Expand my Community achievements bar.

SOLVED

Adobe Analytics API - Single JSON for top level data, and and second level breakdown data, for all rows

Avatar

Level 3

Hi All,

 

I'm looking into how to report multiple breakdowns using the Adobe Analytics API. Ultimately I would like to make a JSON request that returns top level data,  and second level breakdown data, for all rows of top level data (not just specific rows).

 

Thanks in Advance.

1 Accepted Solution

Avatar

Correct answer by
Employee

Hi @deepakkv Here is one example given how you can create three level breakdown: https://www.adobe.io/apis/experiencecloud/analytics/docs.html#!AdobeDocs/analytics-2.0-apis/master/r...

To make it more simple, you can create your desired report in workspace and capture the JSON request for the same report and use it. Here is a document on this process: https://www.adobe.io/apis/experiencecloud/analytics/docs.html#!AdobeDocs/analytics-2.0-apis/master/r...

Hope this helps!

View solution in original post

4 Replies

Avatar

Correct answer by
Employee

Hi @deepakkv Here is one example given how you can create three level breakdown: https://www.adobe.io/apis/experiencecloud/analytics/docs.html#!AdobeDocs/analytics-2.0-apis/master/r...

To make it more simple, you can create your desired report in workspace and capture the JSON request for the same report and use it. Here is a document on this process: https://www.adobe.io/apis/experiencecloud/analytics/docs.html#!AdobeDocs/analytics-2.0-apis/master/r...

Hope this helps!

Avatar

Level 3

Hi @akt0m3r . it showing a breakdown of a single row.  my question is , Is there one piece of JSON code I can run  that would return both top level data, and the associated second level breakdown data for all top rows?

Avatar

Employee
I expect the second method should have helped you with the desired output. Just to clarify could you please share a Worksapce project snapshot how the result should look like?

Avatar

Level 1

I have the same question, referring to https://developer.adobe.com/analytics-apis/docs/2.0/guides/endpoints/reports/breakdowns/#second-leve... when we send a request for second level breakdown, we are getting the itemId of the top level. Instead we would want to get the value of the itemId in the response of the second level breakdown which will really cut down another API request.

E.g, For Nov 19,2018 in the image the response obtained is 

 

"rows": [
{
"itemId": "364325780",
"value": "videoPage3",
"data": [
22,
22
]
}]
 
We would want the response to be something like below.
 
"rows": [
{
"itemId": "364325780",
"itemValue": "Nov 19,2018",
"value": "videoPage3",
"data": [
22,
22
]
}]