Expand my Community achievements bar.

Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.
SOLVED

Automate Email Dashboard Reports in Excel Format

Avatar

Level 1

Is it possible to automate the emailing of a monthly dashboard containing the data in Excel format?

1 Accepted Solution

Avatar

Correct answer by
Employee

Hi Julie,

You can certainly do so if you use the Adobe Report Builder Excel Add-In. In Adobe Reports & Analytics (formerly SiteCatalyst) custom dashboards can only be exported as PDF or HTML due to the format.

Best,

Brian

View solution in original post

4 Replies

Avatar

Correct answer by
Employee

Hi Julie,

You can certainly do so if you use the Adobe Report Builder Excel Add-In. In Adobe Reports & Analytics (formerly SiteCatalyst) custom dashboards can only be exported as PDF or HTML due to the format.

Best,

Brian

Avatar

Level 1

Okay. I think you are saying that I have to rebuild the dashboard in Report Builder and schedule the automation there? Is that right? Where do I schedule that in Report Builder? 

Also, I've encountered a number of issues when importing different bookmarked reports from AR&R.  What are the guidelines for the types of bookmarks that can successfully be imported into Report Builder? The error is attached.  

Avatar

Employee

Hi Julie,

As Report Builder is the only option to schedule a custom dashboard via Excel I recommend doing your work and scheduling in that solution. I do not know the cause of that specific error, but it may be best to start from scratch in Report Builder so you can get the data blocks exactly how you want them and create an organized clean template.

You can schedule in Report Builder per the instructions below:

http://microsite.omniture.com/t2/help/en_US/arb/schedule_report_requests.html

Full Adobe Report Builder Help site:

http://microsite.omniture.com/t2/help/en_US/arb/

Best,

Brian

Avatar

Level 5

Hi

Yes , only solution is report builder but to avoid prospect errors you need to be careful while preparing data block e.g range of every data block should not overlap , you cant delete data you have delete data block , etc

 

Regards

Devinder