Google Ads

Google Ads is an online advertising platform by Google that enables businesses to display their ads on Google's search results pages and across the Google Display Network. Advertisers can target specific keywords and audiences, pay for clicks or interactions, and track the performance of their campaigns through detailed analytics.

The Google Ads connector uses v15 of the googleads.googleapis.com API.

Feature nameSupported
Column HashingTrueField level
BlockingTrueField level
IncrementalTrue
Custom dataFalse
HistoryFalse
ReSyncTrueTable level
TemplatesTrue

Data Schema

Google Ads applies global rate limits across your account

  • This means that Google Ads imposes certain restrictions on how often you can make requests or perform certain actions on their platform for a specific account. This is usually done to prevent misuse or overuse of their services.
  • If you're using the Google Ads API for multiple purposes, you might encounter problems when trying to sync data with Weld as the global rate limits might have been reached.
  • When you reach 80% of your rate limit Weld will slow down all Google Ads syncs to avoid maxing out rate limits.

🔧 Setup Guide - ELT

To connect your Weld account to Google Ads, you need:

  • The account needs editor permissions for activate, and viewer permissions for gather. These will be granted when adding the user to the Google Ads workspace.
  • Browser extensions such as ad blockers may prohibit the Google Ads connection. If you encounter this issue please pause the ad blocker and try again.

Step 1 - Begin Configuration

  1. In the connector setup form, enter the destination schema name of your choice.
  2. Click Authorize to allow Weld to access your Google account using OAuth. You will be redirected to your Google account.

Step 2 - Grant access to Weld

  1. Click Grant Access to allow Weld to connect to your Google app. When authorization is complete, you will be redirected back to the Weld connections overview. The configuration is complete.

Step 3 - Connection Settings

  1. Select all the Ad accounts that you would to sync data from.
  2. Limit historical data to only sync data after the selected date if you want to only include that data in the initial sync.

Step 4 - Data To Sync

  1. Select the pre-built reports you wish to include in the sync.
    You can view the schema, remove columns or hash sensitive information.

Step 5 - Configure Sync

  1. Select how often you would like the data to sync.
  2. Provide a unique destination table name.

Weld will take over from here and commence syncing data from your Google Ads account.

📈 Data Modelling

  1. Access Data Post-Sync: Once the initial synchronization is complete, your Google Ads data is available for querying in the SQL editor by clicking Transform.
  2. Find Google Ad Tables: In Transform, expand the Google Ad folder under Data Sources to see available tables.
  3. Explore Table Schema: Click on a table to view its schema and understand the structure and type of data.
  4. Create SQL Queries: Begin a new page in Transform to start crafting your SQL queries.
  5. Utilize AI Assistance: For help with queries, click the icon to talk to Ed Logo Ed, our AI Assistant, and input details about your querying needs.
  6. Save and Organize Queries: Save your refined queries in a specific folder for future reference.

📂 Table Summary

Weld supports data replication of both object and report Google Ads data.

  • Objects

    • Description: Objects represent the structural and operational setup of an advertising entity. This includes configurations, targeting settings, and relationships with other entities in the advertising ecosystem.
    • Example: ad_group

  • Reports

    • Description: Reports focus on the performance metrics and results of the entity. They provide detailed data about how well the entity is performing on a daily basis.
    • Example: ad_group_stats

Objects Overview

  • Core Entities: Essential to Google Ads, representing foundational data. Provides information on what the entity is and how it is set up
    • Advertisers
    • Campaign
    • Ad Group
    • Ad

Reports Overview

  • Performance Metrics: Includes detailed metrics and statistics for reporting on Ads, Ad Groups, and Campaigns. Indicate how well the entity is performing, based on various performance metrics.
  • Granularity: Data availability is detailed, offered on a daily and hourly basis.
  • Additional Reporting Dimensions: Reports can also be created based on Country, Language, Age, Gender, and Platform.

📊 SQL Templates

Get started with Google Ads SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Google Ads.

📈 Marketing Core Metrics

You can integrate the following connectors with your Google Ads data to create a comprehensive marketing dashboard using Weld and our Marketing Core Metrics:

To use these prebuilt models, simply click on any of these connectors in the Data Sources section of your account, and select Marketing Metrics.

𝌭 Staging Models

google_ads_ad_report
google_ads_account_report
google_ads_ad_group_report
google_ads_campaign_report

🔧 Setup Guide - Reverse ETL

Google Ads reverse ETL allows you to sync data on a schedule from your Weld App automatically into a custom audience user list in Google Ads.

Prerequisites

  • An active Google Ads account with permission to access data from accounts you would like to sync.

Step 1 - Authenticate

  1. Click on the Reverse ETL button in the side bar and click + New on the top right.
  2. Select the Google Ads connector from the drop down menu or else click + Add new connection to authorize the connector:
    1. In the connector setup form, enter the destination schema name of your choice.
    2. Click Authorize to allow Weld to access your Google Ads account using OAuth. You will be redirected to your Google Ads account.
    3. Approve Weld to access your Google Ads account.
    4. When authorization is complete, you will be redirected back to the Weld connections overview. The configuration is complete.

Step 2 - Begin Configuration

  1. Select your object:
    • User_list
  2. Select Ad Account
  3. Select or create User List

Step 3 - Model

  1. Choose the SQL model that contains the data that you would like to send to Google Ads

Step 4 - Sync Operation

Choose how you would like to sync your data:

  • Update: Updates existing records.

Step 5 - Schedule

Choose how often you would like the sync to run. You can choose to have the sync running on an independent schedule or as part of an orchestration workflow.

Step 6 - Mapping

Primary key: Select the unique identifier fields to match your record between your source and destination (this is usually the email or ID).

Map the column from your data model to the property in Google Ads.

Google Ads Conversion API can be accessed by pushing data into a Google Sheet.

Follow the Google Sheets setup guide:

Was this page helpful?