RE: GAM API - Issue of getting Total Revenue

Skip to first unread message
Message has been deleted

Ad Manager API Forum Advisor

Jan 20, 2022, 12:47:56 AMJan 20

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)




Google Logo
Yasmin Gabrielle Padua
Ad Manager API Team

Reply all
Reply to author
0 new messages