I want to create a report that pulls data from a google analytics with the similar look to the following:
Attached is an excel sheet that lays out the rows and columns. Once it is finished I just want to be able to put in my credentials for the Google Analytics account and have it populate the data.
There should only be 3 rows ever on the report. Row 1 will be the data from 2 months previously, row 2 will be from the previous month, and row 3 will be the data for the current month.
Some of the columns also contain formulas that need to calculate based on the data pulled. Those formulas are contained in the excel file.
I need this done very quickly. If you do not have any experience using google api please do not apply.