Google Ads – Snowflake Quickstart integration template

The Google Ads - Snowflake quickstart integration template (NA | EU) lets you integrate Google Ads with Snowflake for integrated data. The integration template comprises a set of pre-built integration flows. These flows help you sync Google campaigns to Snowflake tables. 

Supported integration flows

The Celigo quickstart bundle contains workflows you can easily configure and deploy without coding or IT support. The following built-in flows sync from the specified source data to the corresponding destination.

Google Ads to Snowflake

Google Ads campaigns to Snowflake tables.

Gather your credentials

Keep your Google Ads and Snowflake account credentials ready:

• Google Ads – verify APIs and Authorization
  • Before you set up a Google Ads connection below, ensure that you have the API and authentication details for your Google Ads app.
  • Refer to the Google Ads help documentation to learn more about APIs and Authorization.
• Snowflake – verify APIs and Authorization
  • Before you set up a Snowflake connection below, ensure that you have the API and authentication details for your Snowflake app.
  • Refer to the Snowflake help documentation to learn more about APIs and Authorization.

Install the Google Ads – Snowflake template

1. From the Snowflake Marketplace options, select the Google Ads template and click Install.
2. Review the template’s contents and ReadMe and click Install now to begin.
3. Install the template.

Configure the Google Ads – Snowflake flows

Additional record mapping is required to integrate the template’s exports and imports with your Google Ads and Snowflake apps.

Note that all of your flows are disabled when first installed. After configuring the flows, you may enable them in your Flows dashboard or in Flow Builder with the Off/On toggle button. Then, run or schedule each flow.

Google Ads campaigns to Snowflake table

This integration flow adds campaigns from Google Ads to a Snowflake table.

Before you begin

1. A table with the required columns should exist in Snowflake before the flow run.

Setup instructions

1. Configure the query in the HTTP request body of the Get Google Ads campaigns export to get certain campaign fields in the response as required.

   Tip: Use the Google Ads Query builder to build the query.

    

2. Configure the mappings in the Import Snowflake tables import as required. The destination field name should be exactly the name of the column in the snowflake table.
3. Configure the “type” hardcoded mappings in the Import Snowflake tables import as required.

Handlebars template

{"pageSize":1000, "pageToken":"{{export.http.paging.token}}","query":"SELECT \n\campaign.id, campaign.name, campaign.status, campaign.campaign_budget, campaign.start_date, campaign.end_date, \n\nmetrics.clicks, metrics.impressions, metrics.conversions, campaign_budget.amount_micros, segments.date\n\n\nFROM campaign WHERE segments.date BETWEEN '{{{dateFormat "YYYY-MM-DD" lastExportDateTime "YYYY-MM-DDTHH:mm:ss.SSSZ"}}}' AND '{{{dateFormat "YYYY-MM-DD" currentExportDateTime "YYYY-MM-DDTHH:mm:ss.SSSZ"}}}'"}