Release Notes

Release Notes

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.

NOTE: This change is in addtion to the changes made in June 2020, so users who already followed these steps for that change will need to do so again.

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.

Getting started is easy! Get all your data in one place in minutes.
Try Free