Automate pulling data from Adobe Analytics to Google Sheet for reporting

[prabhdeep1292]

Can we automate pulling data from Adobe Analytics to Google Sheet for reporting purpose. Also is there any option on adobe analytics like we have on Google Adwords to use script to automate reporting?

[Pablo_Childe]

Hi its not Google sheets but Adobe has Excel report builder to do what you want.

Also for adwords you may be able to connect it to Adobe:

https://experienceleague.adobe.com/docs/analytics/integration/advertising-analytics/overview.html

GLTU

[Kishore_Reddy · Accepted solution]

Hey @prabhdeep1292 

1. Please try https://workspace.google.com/marketplace/app/data_connector_for_adobe_analytics/847523755862 for exporting data into Google Sheets. More details here
2. I do not think there's a feature to automate reporting. However, if you can share your use case, I can help with workarounds. Adobe Analytics comes with powerful reporting features and reporting APIs are very efficient as well. So, please feel free to elaborate about the stuff you are trying to achieve, we can work it out

Hope this helps!

Best,

Kishore

[luekl]

Hi,

the Adobe Analytics Component Manager for Google Sheets has recently added a "Report Builder" which lets you pull any Adobe Analytics report data into a Google Sheet. The free version has certain limits, but there is also a free 14-day trial.

You can also schedule reports to be updated daily with e.g. the start and end date rolling via GoogleSheets formulas (e.g. End Date "=TODAY()-1" will always get the data until yesterday:

1. Build the report you want to get in GoogleSheets in Analysis Workspaces.

2. If you haven't already, enable the Workspace Debug mode (Help -> Enable Debug Mode). Then reload. You now see the little bug icons in all tables.

3. Copy the JSON of the Request from Workspace:

4. In the Component Manager Google Sheet, click on AA Component Manager -> Reports -> Create new Report.

5. In the new report tab, paste the request JSON from Workspace into the "Query Payload" Field in the Component Manager

6. Add any other settings, like the date range or if you would like daily granularity data.

7. Click AA Component Manager -> Reports -> Run Report and wait a bit.

To schedule the report to run daily, you can do that via "Activate Schedule".