Expand my Community achievements bar.

SOLVED

How to pull revenue by DMA by day?

Avatar

Level 1

Hi- 

 

I was wondering if there was an easy way to pull revenue by day by DMA over a span of time? I am having a trouble getting to this view even in the Data Warehouse when I select "daily" breakdown.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor and Adobe Champion

Since I am not sure what kind of view you are looking for, have you tried the API?

 

https://adobedocs.github.io/analytics-2.0-apis/

 

If you can get the view you want in Workspaces, you can get the APIs that build that out, and still manipulate them if its close but not exact.. but it's a little easier sometimes to get the API call that is close to what you need and tweak it then to start from scratch.

 

To get the API calls made by Workspace, you have to first turn on Debugging:

Jennifer_Dungan_0-1692332364167.png

 

This will add a new icon to your Tables:

Jennifer_Dungan_1-1692332382268.png

 

 

Clicking on that new icon will give you an option for the Table or the Sparkline (choose the Table):

Jennifer_Dungan_2-1692332416423.png

 

Now you will be presented with Timestamps for each API call made:

Jennifer_Dungan_3-1692332441815.png

 

 

When you choose this, you will be taken to a page showing the API call in multiple formats such as JSON and CURL.

 

If your Table is complex, you may need to run multiple API calls, as the system works on this structure of calling each breakdown in a separate call.

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor and Adobe Champion

Since I am not sure what kind of view you are looking for, have you tried the API?

 

https://adobedocs.github.io/analytics-2.0-apis/

 

If you can get the view you want in Workspaces, you can get the APIs that build that out, and still manipulate them if its close but not exact.. but it's a little easier sometimes to get the API call that is close to what you need and tweak it then to start from scratch.

 

To get the API calls made by Workspace, you have to first turn on Debugging:

Jennifer_Dungan_0-1692332364167.png

 

This will add a new icon to your Tables:

Jennifer_Dungan_1-1692332382268.png

 

 

Clicking on that new icon will give you an option for the Table or the Sparkline (choose the Table):

Jennifer_Dungan_2-1692332416423.png

 

Now you will be presented with Timestamps for each API call made:

Jennifer_Dungan_3-1692332441815.png

 

 

When you choose this, you will be taken to a page showing the API call in multiple formats such as JSON and CURL.

 

If your Table is complex, you may need to run multiple API calls, as the system works on this structure of calling each breakdown in a separate call.