How to Get Order All Revenues (CPC, CPM & CPD)

[John]

Hi All,

I tried to test a multiple of columns and dimensions to get the the total revenues (CPC, CPD & CPM all together) per order for yesterday reports, but i couldn't.

Tried "AD_SERVER_CPM_AND_CPC_REVENUE", "CONTRACTED_REVENUE_CONTRACTED_NET_REVENUE" and all what's related, and not working.

What i need to generate is a report to get all orders by advertiser by ad unit by ad size that shows impressions, clicks & ctr per each order line.

And of course the all revenues for that order line including (CPC, CPM & CPD)

Thank you so much and appreciate your prompt support.

[Lakshmi P]

Hi,

Did you try to create the report in UI? If not, I would suggest create the report in UI and then recreate it in API. This way you will know the available Dimensions and columns combination in your network.

You can use either TOTAL_INVENTORY_LEVEL_ALL_REVENUE/TOTAL_LINE_ITEM_LEVEL_ALL_REVENUE depending on which dynamic allocation enabled on your network.

Columns with line item level can be used only if line item level dynamic allocation is enabled on your network.

You might find the columns document below helpful.

https://developers.google.com/doubleclick-publishers/docs/reference/v201511/ReportService.Column

Thanks,

Lakshmi, DFP API Team.

[John]

Hi Lakshmi,

The "dynamic allocation" is not allowed in my network.

We tried it on UI, however there is no way to do the same with DFP API, it's huge and so specific and doesn't help me at all for just a simple and important thing, line item revenues.

We just need to use this "AD_SERVER_ALL_REVENUE" and make it work, everytime we use this column, it get's all revenues on the server since we started, and it's diffidently something wrong.

Can you please give us a hint, what we need is, a report to get the below:

• By Ad Unit by line item, and each line item should show some columns like, ctr,cpc, cpd & revenues per this specific line item according to the date rang we specified when we started to generate the report

What we need to do is, getting the revenues for a specific website per day per line item per ad unit

Kindly advice

[Lakshmi P]

Hi John,

Please check the dimensions and columns for the requirement you have given. 

new Dimension[] {Dimension.AD_UNIT_ID, Dimension.AD_UNIT_NAME,Dimension.LINE_ITEM_ID});

    reportQuery.setColumns(new Column[] {Column.AD_SERVER_CTR,Column.AD_SERVER_CPD_REVENUE,Column.AD_SERVER_CPM_AND_CPC_REVENUE,

    

        });

If you are not getting the expected report with the above combinations, please send the screenshot with the selection of UI fields and your network id. I could give you the equivalent API dimensions and columns specific to your network.

I am adding the dimensions,columns and dimensionattributes link which has the descriptions for each field.

• DIMENSIONS
  
• COLUMNS 
  
• DIMENSIONATTRIBUTES
  

Thanks,

Lakshmi, DFP API Team.

[John]

Thank you Lakshmi.

Pleas find attached 2 images showing the report builder and a report example.

Appreciate your help.

[Lakshmi P]

Hi,

Thank you for sending the screenshots. Please check the dimensions and Columns below:

Dimensions:

Dimension.AD_UNIT_NAME,

Dimension.ADVERTISER_NAME,

Dimension.CREATIVE_SIZE,

Dimension.AD_UNIT_ID,

Dimension.ADVERTISER_ID

 

Columns:

Column.TOTAL_INVENTORY_LEVEL_IMPRESSIONS,

Column.TOTAL_INVENTORY_LEVEL_CLICKS,

Column.TOTAL_INVENTORY_LEVEL_ALL_REVENUE,

Column.TOTAL_INVENTORY_LEVEL_CTR,

Column.TOTAL_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS_RATE

     

Thanks,

Lakshmi, DFP API Team.

[John]

Hi Lakshmi,

Thanks for that, but it still getting big numbers like xxxx while it suppose to be xx per line, i mean something wrong is happening in the revenues columns, i tried everything now including the solutions we have done here in this thread but nothing is working correctly in regards of getting me the correct revenues and total per ad unit per advertiser per ad size.

Kindly advice, What should i do?

[Lakshmi P]

Hi John,

Are you using the CSV_DUMP format to download the report? If so the money amounts are returned in macros. Please check the document below:

https://developers.google.com/doubleclick-publishers/docs/reference/v201511/ReportService.ReportDownloadOptions

If you use CSV_EXCEL you would get the same values as in UI. If the issue still exists after changing to CSV_EXCEL send me the SOAP logs. To generate the SOAP logs, please check for 'How do I enable logging'. 

Hope this helps,

Lakshmi, DFP API Team.

[John]

Awesome!!

I Got it the numbers in $$ finally :)

Thanks a million, Lakshmi.