Expand my Community achievements bar.

Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!
SOLVED

Replicating API v1.4 call

Avatar

Level 2

Hi,

 

So we make an API v1.4 request to obtain data with multiple dimensions(elements) and metrics (including calculated metrics).

{"reportDescription":{
   "reportSuiteID":"myRSID",
   "dateFrom":$Yesterday,
   "dateTo":$Yesterday,
   "dateGranularity":"Day",
   "elements":[
      {"top":100,
      "id":"product",
      "classification":"dimension1"},
     {"top":100,
      "id":"product",
      "classification":"dimension2"},
     {"top":100,
      "id":"product",
      "classification":"dimension3"},
    {"top":100,
      "id":"dimension4"}
   ],
   "metrics":[
      {"decimals":0,
      "id":"event1"},
      {"decimals":0,
      "id":"event2"},
      {"decimals":0,
      "id":"event3"},
      {"decimals":0,
      "id":"calcMetric1"},
      {"decimals":0,
      "id":"event4"}
    ],
    "segments": [
      {"id": "segment1"}]}}

 

This is working with API v1.4, but we have to migrate this in the near future since v1.4 is not going to be supported down the road.

We are thinking of 

1. Data warehouse: which however doesn't support calculated metrics apparently

2. API v2.0: which allows only one dimension at a time

 

Would like to hear some opinions on which tool to use and being pointed to some resources. 

Thanks in advance.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Hi @Roxie423 ,

In my opinion, it would be best advised to use API 2.0 as it would allow breakdown of dimensions. You can use Analysis Workspace to build your desired report and validate the API request. This would help: https://github.com/AdobeDocs/analytics-2.0-apis/blob/master/reporting-tricks.md.

Thanks!

View solution in original post

3 Replies

Avatar

Correct answer by
Employee Advisor

Hi @Roxie423 ,

In my opinion, it would be best advised to use API 2.0 as it would allow breakdown of dimensions. You can use Analysis Workspace to build your desired report and validate the API request. This would help: https://github.com/AdobeDocs/analytics-2.0-apis/blob/master/reporting-tricks.md.

Thanks!

Avatar

Level 6

Hi @Roxie423 ,

You can also try using the Ad Hoc Analysis as it will allow you to breakdown one dimension line item with another & can see 50,000 line items. Though Adobe has already decided to deprecate Ad Hoc. But, before we are going to deprecate this feature we will be giving an option to the users to view up to 50,000 line items in Analysis Workspace.

 

Regards,

Abhinav

Avatar

Level 10
Do any of the answers below answer your initial question? If so, can you select one of them as the correct answer? If none of the answers already provided answer your question, can you provide additional information to better help the community solve your question?