Getting Total Cost and Cost/conv. for Filtered keywords via Adwords API

[Vanja]

Hello!

I'm trying to get Total cost, and Cost/conv. values that are displayed inside Google Adwords Keywords Filter (see attachment; row Total: Filtered Keywords, values marked in red).

First we retreive ACCOUNT_PERFORMANCE_REPORT containing Conversions, Cost and CostPerConversion fields.

From this report we take Cost field as Total Account Cost and CostPerConversion field as Total Account Cost Per Conversion.

Total Account Cost - 196071207730 / 1000000 = 196071.21

Total Account Cost Per Conversion - 3384143 / 1000000 = 3.38

If we compare these results to results from Google AdWords account (marked green in the screenshot) they seem to be correct.

Next, we are requesting KEYWORDS_PERFORMANCE_REPORT containing Conversions, Cost and CostPerConversion fields.

From this report we are filtering only those keywords that meet conversions > 0.00 criteria

After filtering we are summing Cost to get Total Filtered Keywords Cost and summing CostPerConversion field and dividing by number of filtered keywords.

Total Filtered Keywords Cost - 144619700000 / 1000000 = 144619.70

Total Filtered Keywords Cost Per Conversion - 3333911.2398789 / 1000000 = 3.33

Comparing these results to results from Google AdWords account (marked red in the screenshot) we see that those are not correct results.

What we need is the information on which Report Type we need to fetch from the API and how can we get those red marked results from the screenshot.

Thank you in advance!

[Bharani Cherukuri (AdWords API Team)]

Hi Vanja, 

Could you share us the client customer id along with the date range, so I can take a look at the discrepancy you're noticing and assist you further? You can respond back via Reply privately to author option. 

Regards,

Bharani, AdWords API Team

[Bharani Cherukuri (AdWords API Team)]

Hello Vanja, 

The Account Performance Report will return metrics at the account level, hence this is matching with the metrics on the Campaign tab in the UI. On the other hand, Keywords Performance Report is generated at the keyword level with one row per keyword. The Cost in the Keywords Performance report will be the total cost for the keywords equivalent to the Cost in the Keywords tab. Hence Cost in the Account Performance Report is not equivalent to the Cost in the Keywords Performance Report. You may refer to this guide on how total cost are calculated in the account.