getting costs per keyword

[Tim Swetonic]

Hello,

I want to get the costs of a campaign, on a keyword basis. I'm using the KEYWORDS_PERFORMANCE_REPORT, which does this. But when I compare the totals costs for a given day, using the adwords UI, the costs don't add up - they're off by nearly 40%.

Any idea on why this is off?

Thanks

[Anthony Madrigal]

Hello Tim,

Could you please provide me through Reply privately to author

• Your CID
• Your SOAP request for the report
• A screenshot of the cost in the UI

Thanks,

Anthony

AdWords API Team

[Anthony Madrigal]

Hi Tim,

It seems like the screenshot you sent me was from the Campaigns tab. You should be comparing the costs here with the Campaign Performance Report, not the Keywords Performance Report since that will not show impressions that are not based on your keyword criteria such as Shopping Campaigns.

Ideally, you could compare results from the Keywords Performance Report with the Keywords tab in the UI. However, "Total - all account" will not be able to compare it with the report since "Total - all account" includes metrics such as impressions that are not attributable to keywords.

As a workaround:

• Run a Keywords Performance Report where AdNetworkType1 = SEARCH and compare that with Total - Search in the UI
  
• Run a Display Keyword Performance Report where AdNetworkType1 = CONTENT and compare that with Total - Display Network in the UI
  

Cheers,

Anthony

AdWords API Team

[Tim Swetonic]

Thanks for your suggestions!

[Tim Swetonic]

Hi again. I tried your suggestions. Now I get the proper costs (according to the adwords UI) for Total - Search and Total - Shopping. However, Total - Display Network doesn't match. 

I'm using awql like this

SELECT AdGroupId,AdGroupName,CampaignId,CampaignName,Device,Clicks,Cost,Date FROM DISPLAY_KEYWORD_PERFORMANCE_REPORT WHERE AdNetworkType1='CONTENT' DURING 20150601,20150601

The cost I get is $106.54 when the adwords UI says $2,764.24. Clicks are way off too, 208 vs 3969.

Something must be missing in my query - any ideas?

On Wednesday, July 15, 2015 at 1:09:10 PM UTC-7, Anthony Madrigal wrote:

[Anthony Madrigal]

Hi Tim, 

The stats for the Display Keyword Performance Report should be compared to the display keywords'  Total - keywords row found in the Display Network > Display keywords tab. Also, in your report, I think you may have added the value of the Total row in when calculating the total cost. Once you exclude that value, then your Total Cost for both the UI and report should be $53.27.

[Tim Swetonic]

Thanks. Is it possible to get this - on the Campaigns tab, for June 1 2015, Total - Display Network equals $2,764.24. Is it possible to get that total cost from the API somehow? You mentioned impressions earlier, maybe that's the piece I'm missing.

Tim

[Anthony Madrigal]

Hey Tim,

You may be able to get the stats from the Campaign tabs by running a Campaign Performance Report and including WHERE AdNetworkType = 'CONTENT'. This may not include all the cost because some of the impressions came from the Display Network tab I mentioned previously.

Regards,

Anthony

AdWords API Team