We now support all Google Ads Account metadata tables. You can select or deselect the metadata tables on the Schema tab of your dashboard or select or deselect them during the Schema configuration using our REST API.
Now only Custom reports are configured in the connector setup form, and existing Prebuilt reports are configured on the Schema tab of your dashboard.
Also, we have changed the configuration format. The Prebuilt configuration type is deprecated. It is supported now only for backward compatibility and will be removed soon. The Prebuilt report type is replaced with the Custom report type that has a predefined set of selected fields. Tables in all existing Prebuilt reports can be selected or deselected during the Schema configuration.
These changes only affect new Google Ads connectors created after January 18, 2021. We will migrate existing Google Ads and Google Ads Account connectors to Google Ads connectors in the new format in the future.
We now sync metadata tables that were previously available in Google Ads Account:
Also, we now sync tables related to Prebuilt reports, which were previously configured during the connector setup:
For more information, see the Google Ads ERD.
Now we perform a table re-sync whenever a field is added to or removed from a custom table. Previously, we only used incremental and rollback syncs, which may have caused incorrect metrics values being displayed in the table and unwanted report segmentation inconsistencies when the field set was changed.
We improved the way we sync Placement Performance report data. Previously, the only AdNetworkTypes that the report contained were Display Network. Now, it receives placement data for all network types: Display Network, Search Network, YouTube Search, YouTube Videos, and Cross-network.
You can now configure multiple reports in one connector. For example, you can configure several Google Ads reports for the same Customer ID without re-entering the credentials for each report.
Important: All existing Google Ads connectors are now considered legacy, but they continue to function just as they did before this change. You can change their setup in the same way as you did previously.
All new connectors created after August 12, 2020 are multi-report. You can no longer direct multiple connectors to the same schema in the destination because the schema name must be unique. If you need to use different credentials (for example, another Customer ID) for the same kind of reports, you have to create a separate connector and choose a different schema name for it.
We have added report schema configuration in the Schema tab. You can enable or disable the sync for any report you set up. The Schema tab shows the table name you chose when you set up the report, rather than the report name.
Read more about the new setup process in our Google Ads Setup Guide.
We now sync the
BaseCampaignId columns from the
KEYWORD_PERFORMANCE_REPORT report again. These columns were previously deprecated.
When you sync the
KEYWORD_STATS pre-built report or a custom report based on the
KEYWORD_PERFORMANCE_REPORT, you may notice the following warnings in your logs:
ADWORDS_DEPRECATED_FIELD : Deleting BaseAdGroupId from the set of fields of the report KEYWORDS_PERFORMANCE_REPORT. Please remove the field by editing the setup form.
ADWORDS_DEPRECATED_FIELD : Deleting BaseCampaignId from the set of fields of the report KEYWORDS_PERFORMANCE_REPORT. Please remove the field by editing the setup form.
These warnings appear because we previously did not sync the
BaseCampaignId columns. You do not need to take any action to resolve these warnings - these columns will be automatically added to your destination table.
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.
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.
We now add a fivetran_synced column while syncing empty tables and columns from the source.
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.
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 as
NULLvalues to keep column types consistent.
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
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.
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.
We have removed support for the
CAMPAIGN_CRITERIA_REPORT because it does not contain a
date field, which we require for incremental updates.
- We upgraded our connector from AdWords API v201806 to v201809 and handled deprecation.
- Renamed the report
- Read more about the deprecations and changes in [Google's AdWords API
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.
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.
Customer IDs will now be included in the Specific Accounts section of the Fivetran setup form.
We have upgraded the Adwords API from v201710 to v201806 and handled deprecated fields.
bidtypefield has been deprecated.
shopping_universal_adsfield has been renamed
For additional details, see Adwords' API deprecation schedule.
We no longer support the
LABEL_REPORT report because it does not support date fields.
CLICK_PERFORMANCE_REPORT table is now limited to fetching 90 days of data, which is AdWords' maximum retention.