Adobe Analytics API Call to pull data with mulitple dimensions | Community
Skip to main content
E
emmak109
Level 3
December 5, 2024
Solved

Adobe Analytics API Call to pull data with mulitple dimensions

  • December 5, 2024
  • 2 replies
  • 882 views

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?

 

 

Best answer by 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

 

 

 

2 replies

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
December 5, 2024

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.

 

E
emmak109Author
Level 3
December 5, 2024

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:

 

DateTarget ExperienceVisits

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
    Community Advisor and Adobe Champion
    Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
    Community Advisor and Adobe Champion
    December 5, 2024

    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
      Community Advisor
      Harveer_SinghGi1Community Advisor
      Community Advisor
      January 7, 2025

      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.

        Terms & ConditionsAccessibility statement

        Loading footer...