RE: GAM API - Issue of getting Total Revenue
Ad Manager API Forum Advisor
Hi Xuan,
Thanks for contacting the Ad Manager API team, this is Yasmin. Please advise that I had to remove your previous post as it contained sensitive information. That said, kindly refrain from sending out such information as this forum is public, moving forward.
The equivalent of the column TOTAL_CONVERSION_REVENUE from the UI is the metric Total advertiser sales. If you're looking for the Total CPM, CPC, CPD, and vCPM revenue, or the Total CPM, CPC and CPD revenue, kindly use the column TOTAL_LINE_ITEM_LEVEL_ALL_REVENUE. On the other hand, if you're just looking for the Total CPM and CPC revenue, kindly use the column TOTAL_LINE_ITEM_LEVEL_CPM_AND_CPC_REVENUE. You can always create report queries in the Ad Manager UI, and retrieve them with the ReportService.getSavedQueriesByStatement method in order to check for the fields' equivalents in the API or just navigate through our documentation for the available columns to be used for reporting in the API for more information.
If you're seeing a difference between what the UI and API returns, and would like for us to investigate further, kindly provide the following via Reply privately to author option:
- Complete screenshots of the UI report
- Complete SOAP request and response logs of the API report (which should show all the dimensions and columns used, settings and filters set, and date range)
Regards,
|
||||||
ref:_00D1U1174p._5004Q2VNhNy:ref