We have a small Google Apps Script that pulls data based on a start and end date.
The data is pulled from Google Analytics but the problem is in the date logic
Within the period from start to end date, the logic runs data pulls covering shorter periods
E.g. between Jan 1 and Dec 31 it may be asked to execute queries by week or by month
1) Bug fix
The logic has 1 or 2 bugs that needs to be fixed so that the full period is pulled and not less and not for dates outside of start and end dates.
2) The structure of the script mixes code for pulling parameters from the sheet with code that pulls the data and code that writes the output to the sheet.
The script needs to be split and properly structured so that parameters can be provided from other sources and the data presented (output) independently of the data pulls.
3) Separate ETL Job
This will either use the updated scripts or another method to extract GA data nightly and insert the data into a SQL Database
That project will have a budget of its own
I've mentioned the 3rd phase in this job to give Freelancers and idea of where this job is going