Hi Team, We use Adobe Analytics (Omniture) to track the traffic hundreds of our websites. There is a need to extract the following parameters to 250 Report Sites in excel format. This excel will be used to derive further insights for a given business unit. Im a non technical resource and cannot write programs to get the data using APIs. Is there any easier way to download bulk data in excel format.
City Visits Source of Visit Most Used Devices Crrent vs Previous month visits New Vs Repeat users Most viewed pages and count Bounce rate
Hi kanikas19907318, Thanks for quick reply. I will explore Report builder excel add-in. However will you be able to give me some guidance/inputs on API approach as it will enable me defend the technical team's effort quote of 4 to 5 weeks.
Inputs from you may incldue
1) API method to use - Exact URL(s) of the adobe analytics API will be useful
2) Is there any Adobe playground to check API output ?
3) Any preferred programming language or easier Open source option
4)Any other inputs to take to the techncial team and defend 5 weeks of effort for such a small/medium activity
You probably wouldn't be able to pull all that data in a single request per report suite, since most of them are ranked reports. In fact, I'm pretty sure all of them include dimensions except for bounce rate. This means you'll likely be pulling 7 reports per report suite.
Kanika is spot on regarding the tools you should use - Report Builder or the API is definitely going to be your best bet.
How do you want the data organized? You have report suite, 6 dimensions, and 1 metric (bounce rate). With bounce rate, it wouldn't be too hard to list all 250 report suites, then display site-wide bounce rate next to it. But with the other 6 dimensions, how do you want that to look? How many line items per dimension do you want displayed?