Google Enhanced Conversions for Leads

⌘K
  2. Home
  4. Docs
  6. Google Enhanced Conversio...
  8. Step 1: Set up events Sou...
  10. Option 12: Set up Snowflake source for Google Enhanced Conversion for Leads

Option 12: Set up Snowflake source for Google Enhanced Conversion for Leads

Video Walkthrough

Description  :

Snowflake is a fully managed cloud data warehouse service. It requires no hardware or software installation, configuration, or management. All ongoing maintenance, upgrades, and tuning are handled by Snowflake, making it a scalable and low-maintenance solution for data integration and analytics.


Prerequisites:  

  • Active Snowflake account credentials.
  • Access to the Snowflake Warehouse, Database, and Schema containing the data.

Getting Started:  

Select Data Type  

  • Choose the type of data integration you want to set up.
  • Currently supported options include: Offline Events, Google Leads, Meta CLO, Snapchat Leads, TikTok Leads, and LinkedIn Leads.
  • For this integration, select Google Leads.
  • Provide a Source Name for your connection and click Next.

Choose Integration Method  

You can integrate Snowflake data into Google Leads using two methods:

Option 1: Table Path  

  • Select Table Path if you want to provide data in a structured table format specified by Datahash.
  • Table Name: Provide the table name from which the data needs to be extracted (must exist within your selected dataset).
  • Download the File Format from Datahash to understand the expected data schema for setup.

Credentials Required:

  • User Account → Your Snowflake account ID (found at the beginning of your Snowflake URL).
  • Warehouse Name → The compute warehouse to be used.
  • Database Name → The target database in your Snowflake account.
  • Schema Name → The schema inside your database.
  • Username → The username for Snowflake access.
  • Password → The password for Snowflake access.
  • Table Name → The table to fetch data from.
  • Once provided, click Validate Credentials. If successful, click Finish to complete the setup.

Option 2: Query Path  

  • Select Query Path if you want to define a custom SQL Query for Datahash to extract data.
  • In this method, Table Name is not required since the query itself defines the source.

Credentials Required:

  • User Account → Your Snowflake account ID.
  • Warehouse Name → The compute warehouse.
  • Database Name → The database name.
  • Schema Name → The schema name.
  • Username → Snowflake username.
  • Password → Snowflake password.
  • Click Validate Credentials
  • Click Next

After credentials are validated:

  • Enter your SQL Query on the Configure screen.
  • Use Preview Results to verify your query output.
  • If everything looks correct, click Finish to complete the setup.

Completion  

  • Once setup is successful, the source connector will be marked Completed in the dashboard.
  • If you exit before finishing, the setup remains in Pending status and can be resumed later by selecting the connection name.

How can we help?