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

Avatar

Avatar
Validate 1
Level 1
Roxie423
Level 1

Likes

2 likes

Total Posts

30 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
Roxie423
Level 1

Likes

2 likes

Total Posts

30 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
Roxie423
Level 1

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)

Avatar

Avatar
Affirm 25
Level 4
kainth
Level 4

Likes

49 likes

Total Posts

117 posts

Correct Reply

26 solutions
Top badges earned
Affirm 25
Give Back
Boost 5
Boost 3
Boost 25
View profile

Avatar
Affirm 25
Level 4
kainth
Level 4

Likes

49 likes

Total Posts

117 posts

Correct Reply

26 solutions
Top badges earned
Affirm 25
Give Back
Boost 5
Boost 3
Boost 25
View profile
kainth
Level 4

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

Avatar

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

153 likes

Total Posts

314 posts

Correct Reply

102 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

153 likes

Total Posts

314 posts

Correct Reply

102 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
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!