Release Notes
June 2020
When creating a connector, now you can select specific manager accounts (former sub-MCC accounts) to sync. Fivetran will automatically find and sync clients of these manager accounts. Read more about sync modes in our Google Ads Setup Guide.
May 2020
You can now set the conversion window size for your Google Ads connector from your Fivetran dashboard and via the REST API. You can either set it manually or let Fivetran detect it automatically. Read more about setting your conversion window size from the dashboard and via the API.
April 2020
We now add a fivetran_synced column while syncing empty tables and columns from the source.
March 2020
You can now configure your Google Ads connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
November 2019
-
We now force the creation of schemas even if they contain no data. This is especially helpful for Looker users, since Looker's pre-built SQL queries fail if all tables and columns in a schema are not present. Previously, we did not create schemas when they contained no data.
-
We now sync default empty
--values to your destination asNULLvalues to keep column types consistent.
October 2019
You can now select how many months of reporting data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months
- 12 months (default)
- 24 months
- All time
September 2019
We are removing the AveragePosition field from all of our predefined reports, because Google will sunset the average position metric on September 30, 2019. See Ads Developer Blog: Sunset of the Average Position Metric.
Your own reports will remain intact, but starting on September 29, 2019, we will ignore the AveragePosition field and log a warning. We recommend that you remove the AveragePosition field from any of your custom reports and use top and absolute top metrics instead. See Ads Developer Blog: Top and Absolute Top metrics.
Any old data will remain as is and the average_position column will stay in your tables. If you want to remove it completely, you'll have to drop the corresponding tables and run a historical re-sync.
August 2019
We have updated the Google Ads connector setup form. You can only add report fields that are compatible with each other. You no longer need to refer to Google Ads’ documentation to identify conflicting fields.
April 2019
We have removed support for the CAMPAIGN_CRITERIA_REPORT because it does not contain a date field, which we require for incremental updates.
March 2019
- We upgraded our connector from AdWords API v201806 to v201809 and handled deprecation.
- Renamed the report
DESTINATION_URL_REPORTtoFINAL_URL_REPORT. - Read more about the deprecations and changes in Google's AdWords API documentation.
In all the report tables, the primary key _fivetran_id now contains hash id instead of row index to ensure each row has a unique ID.
January 2019
Since acquiring DoubleClick, Google has re-branded all DoubleClick sources. We have renamed the DoubleClick connectors as follows:
- DoubleClick Campaign Manager is now named Campaign Manager.
- DoubleClick for Publishers is now named Google Ad Manager.
- Adwords is now named Google Ads.
September 2018
Customer IDs will now be included in the Specific Accounts section of the Fivetran setup form.
July 2018
We have upgraded the Adwords API from v201710 to v201806 and handled deprecated fields.
- The
bidtypefield has been deprecated. - The
shopping_universal_adsfield has been renamedshopping_goal_optimized_ads.
For additional details, see Adwords' API deprecation schedule.
June 2018
We no longer support the LABEL_REPORT report because it does not support date fields.
April 2018
The CLICK_PERFORMANCE_REPORT table is now limited to fetching 90 days of data, which is AdWords' maximum retention.