Google Ads Release Notes

April 2022 (v 2.0.0)

Switch from the old Adwords API to the new Google Ads API. This switch include the following changes:

• 149 total resources to select from
• Flexibility on the selection of returned fields, segments and metrics
• Incremental loads
• Multiple Google Ads' customer IDs selection
• New destination tables

The old Adwords API will be deprecarted on April 27th by Google and will not be available starting that day.

July 2020 (v 1.6.0)

An added field spurred this change to Google Adwords data source, as it alters the ID patterns on two reports: the Adgroup Performance Report and the Search Query Performance Report. For the Adgroup Performance Report, that new pattern is: {campaign_id}*{ad_group_id}*{device}*{network (with search partners)}*{day} and for the Search Query Performance Report, that new pattern is {keyword_id}*{customer_ID}*{match_type}*{search term hashed}*{day}.

Because these changes altered the primary key, the data in the tables prior to the change has an outdated schema that cannot be updated correctly. As a next step, clients using the Adwords data source must:

1. Delete the data source.
2. Drop the tables created by the source.
3. Re-add the data source and run the collection, so that the new primary key is brought in.

June 2020 (v1.51)

Panoply is always working to improve our service and our data sources. This update to the Google Adwords data source brings it current with recent changes in the underlying API, including changes to the Search Query Report which affected the Primary Key of the report and the addition of greater historical data ranges. Some of these changes will require action by those clients using the Adwords API data source.

That action includes the following steps:

1. Delete the table with Search Query Report data. Unless renamed by user it will be called adwords_search_query_performance_report
2. Verify that the Search Query Report is checked in your Adwords data source.
3. Manually collect from the Adwords data source. This will recreate the table and will pull in the data.
4. All data will be historical up to the attribution window

In addition, the changes to this data source affected the primary key. In response we have updated the ID pattern on the Search Query Performance Report by adding a hashed value of the Search term field. The new ID pattern is {campaign_id\}_{ad_group\_id}_{ad\_id}_{keyword ID\}\*\{customer\_id}_{Search term hashed}_{Day}

Lastly, we have added options for longer date ranges greater than the last 30-days. These ranges include 30-days, 90-days, 1-year, and 2-years. We have also added the option to choose the attribution window on succeeding data collects with durations of 30-days or 90-days.