Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Replicating API v1.4 call

Roxie423
Level 2
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.

3 Replies
ishans52004352
Employee
Employee

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!

kainth
Level 5
Level 5

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

jantzen_belliston-Adobe
Community Manager
Community Manager
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?