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.
Source of Visit
Most Used Devices
Crrent vs Previous month visits
New Vs Repeat users
Most viewed pages and count
|City Visits||Source of Visit||Most Used Devices||Vurrent vs Previous month visits||New Vs Repeat users||Most view pages (top three) and count||Bounce rate|
API makes it easy where in you can use a dynamic variable for report suite. If you don't want to go for API approach, you can try using Report builder excel add-in.
- Create a request with required dimensions/metrics
- Copy the request and edit the report suite for it.
Here are some helpful articles:
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
Here are our API docs so you can pull data: GitHub - AdobeDocs/analytics-2.0-apis: Documentation for the Adobe Analytics 2.0 APIs
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?