Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Automation solution ideas - report builde r>excel> google sheets?

Avatar

Avatar
Level 1
sonial
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
sonial
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
sonial
Level 1

17-08-2020

Hi there, 

 

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. 

Thank you for your help!

Sonia

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Affirm 25
Level 4
kainth
Level 4

Likes

49 likes

Total Posts

117 posts

Correct Reply

26 solutions
Top badges earned
Affirm 25
Give Back
Boost 5
Boost 3
Boost 25
View profile

Avatar
Affirm 25
Level 4
kainth
Level 4

Likes

49 likes

Total Posts

117 posts

Correct Reply

26 solutions
Top badges earned
Affirm 25
Give Back
Boost 5
Boost 3
Boost 25
View profile
kainth
Level 4

18-08-2020

Hi @sonial,

 

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.

Link: https://docs.adobe.com/content/help/en/analytics/analyze/report-builder/publish-powerbi/power-bi.htm...

Hope this clarifies. Please let me know if you have any further questions.

 

Regards,

Abhinav