Replicating API v1.4 call

Roxie423

20-07-2020

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

kainth

20-07-2020

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

ishans52004352

Employee

20-07-2020

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!