Per Google's instruction, we have updated our query engine to use the latest version of the Google AdWords reporting API (v201506). The old version (v201502) will be sunset shortly and this move was critical to keeping our AdWords integration running.
As part of this update to their API, Google (among other changes) has renamed several report columns. ShufflePoint AdWords users will need to update their references to those columns in your queries. Any queries to the old version of column names will return an error. Here is the list of changed columns...
Old name | New name |
---|---|
PromotionLine | Headline |
PageOnePromotedRaiseBidWhenBudgetConstained | PageOnePromotedRaiseBidWhenBudgetConstrained |
ConversionRate | ClickConversionRate |
ConversionRateSignificance | ClickConversionRateSignificance |
Conversions | ConvertedClicks |
ConversionSignificance | ConvertedClicksSignificance |
CostPerConversion | CostPerConvertedClick |
CostPerConversionSignificance | CostPerConvertedClickSignificance |
ValuePerConversion | ValuePerConvertedClick |
WHAT YOU NEED TO DO: The easiest thing to do with your Excel reports containing queries that use these columns is to do a find & replace operation. For example find ":Conversions" and replace with ":ConvertedClicks" - searching with the : will allow you to ensure you aren't just finding an replacing any static report headers or labels you have input. Also, not including the prepended report type (i.e. aw- or aw-agp, etc) allows you to do a single find & replace across all report types using those columns.
For full details of the changes made in this version of Google's AdWords API you can visit the release notes here: https://developers.google.com/adwords/api/docs/reference/#v201506
NOTE: One column change not pointed out here - in your ShufflePoint reports, replace aw-kp:KeywordText with aw-kp:Criteria to get keyword reports working.
For any other issues or problems with your reporting via ShufflePoint please email us at [email protected] for quickest response.