Adobe Analytics API Call to pull data with mulitple dimensions

[emmak109]

Hi,

I am trying to pull A4T data by following dimensions and metrics - Date, Target Activities, Control & Treate Experiences, Visits, Orders, Some customer segments.  Is there a way to pull this data within one API call?

[Jennifer_Dungan]

My guess on this would be no? I assume those dimensions are all breakdowns... so each breakdown requires it's own API call.

If you build this in Workspace, you can get the APIs used to build the Workspace by turning on the debugger under help.

This will add a new icon to your visualization:

Clicking on it will allow you to choose the table data or sparkline, then it will show up timestamps of all the calls that were made:

Clicking on each timestamp will show you the API call that was used to build the table... note that these all have extra "table" fields, which you wouldn't need, but you can use this to help form your own API calls.

[emmak109]

I thought may be there should be a way to pull data via API similar to the format we get via Data warehouse. Below is what I would want to pull:

Date

Target Experience

Visits

Order

Will it require two API calls because I have two dimensions - Date and Target Experiences? If yes, then how should I go about it with two API calls?

[Jennifer_Dungan]

Don't shoot the messenger on this one...

But my understanding of the 2.0 version of the API, is that for each dimension row that needs a breakdown, you need another call...

So if you were getting 30 days of data:

You would need one call to get the 30 days, then you would need 30 calls (one for each day) to get the Target Experience for that day.... you can return multiple metrics at least...

Each breakdown has to reference its parent row

[Harveer_SinghGi1]

Hi @emmak109 ,

If you are using Adobe Reporting API 2.0 then as @Jennifer_Dungan you'll need to execute multiple API calls to get the breakdown report. For example if you have two dimensions and want to breakdown top 5 items of one dimension by second dimension then you'll have to attempt it as below,

1. Run first API request to fetch top 5 items of dimension one

2. For each of these 5 items returned above, run an API call which return values of dimension two while using the respective value from dimension one as a filter

What this means is that to return a breakdown of top 5 rows of dimension one by dimension two you'll need to run total of 6 API calls.

If you are are using Adobe Reporting API 1.4 then it is pretty easy as you can run multiple breakdowns in a single API call with by creating the payload similar to Report Description JSON.