I'm looking for a way to automate our adobe analytics reporting, and hoping someone might have a solution. Is there a google sheets version of the adobe analytics report builder? Or, alternatively, do you know of a way to sync excel and google sheets? That way, i would use report builder to put into excel, and then push onto google sheets.
I want the info in google sheets so I can use Data Studio for visualisation.
Report Builder is an add-in that is available in Microsoft Excel. To be able to pull the Analytics data in the Excel worksheet you will need to create requests using the Report Builder. based on my understanding, currently we have ways to export the data in different formats by scheduling the reports from the Report Builder user interface but we don't have any automated way to push the data from Excel to Google Sheet. So, if you want the Excel data in Google Sheet then the only possible way is to copy the data from the Excel Worksheet to Google Sheet manually.
However, in Analytics we do have an automated way to push the data to Power BI & you can refer to the below documentation link to get more information.