Stitch has released a new version of its Google Ads integration. With this release comes an update to Google Ads V2, which utilizes the latest Google Ads API (version 20).
The previously used Google Ads API version 18 will be sunset by Google on August 20th, 2025. Once the API is sunset, integrations that interact with it will stop working.
What do I need to do?
Create a new integration to stay ahead of Google sunsetting version 18. We've put together a general guide to assist you.
Using a new schema name
If you are creating a new integration and don't plan on reusing the previous schema name, you can go ahead and make a new Google Ads integration. Selecting Google Ads from the integration options will default to the latest version, in this case, V2. The new integration will also benefit from the 7-day free historic sync.
Re-using the schema name
If you need to use the same schema name for the new integration, you must do the following:
Pause the existing integration(s) in your Stitch account.
Wait for any records that are being prepared to finish loading (such as waiting for Preparing to reflect 0 rows in the integration summary page).
Take note of the tables and fields tracked for replication, as well as the replication methods defined for these tables.
Delete the existing integration from your Stitch account.
Drop or rename the existing schema from your destination data warehouse. We recommend renaming the schema to preserve the data and maintain flexibility to adjust downstream workflows.
Contact Qlik Support to coordinate a manual row-usage exemption for this integration.
Configure a new integration with the same name, and Stitch will create this schema in your destination during the loading process.
Frequently Asked Questions
Q: Can I copy over my bookmarks to the new integration? A: Bookmarks cannot be covered over. When you create a new integration, every table will perform a full table replication from the start date set in the settings. Once the historic sync is complete, it will move to the selected replication method. There is no mechanism to manually set bookmarks, and individual integrations have no interaction with each other, even in upgrades.
Q: What if I need more than 7 days to complete the historic sync? A: Reach out to Qlik Support for a manual exemption. Please explain why you need more time, and we will accommodate accordingly.
Q: Will the data structure be the same in the new integration? A: We cannot guarantee the data structure is the same as it is determined by Google Ads API. If you are looking for field or table changes, please reference the Google Ads API comparison guides (Upgrade from v18 to v19 and Upgrade from v19 to v20). If you are missing data, reference Google's documentation to confirm it hasn't moved or been removed. In the event Google says data should exist, but it is not replicated, raise a ticket to Qlik Support to review and investigate.
If you have any questions, we're happy to assist. Contact Support, reply to this blog post, or take similar queries to the Stitch forum. And if you want to stay up to date for Stitch-specific Support Updates, don't forget to subscribe!
