Understanding your Google AdWords Schema

This tutorial provides an overview of the Google AdWords schema using Stitch’s Google AdWords integration. A full summary of each schema attribute is provided to enable you to better understand and use Google AdWords effectively for your marketing analytics. A schema is a collection of objects within a database, typically consisting of tables (defined below) and the relationships between those tables.

Note: The primary key in every table is denoted by 🔑. Some of the following tables contain nested data which may or may not be supported by your destination. More information on nested data can be found here. If you are interested in reading about other Stitch integrations, we have tutorials covering HubSpot schema, Salesforce schema, Intercom schema, Zendesk schema, and more.

account_performance_report Table

The account_performance_report table contains all statistics aggregated by default at the account level.

Attribute

Description

🔑_sdc_primary_key

Applicable only if Stitch does not detect a Primary Key in the source table

day

The day the record pertains to

_sdc_customer_id

The ID of the AdWords account that the record belongs to

_sdc_report_datetime

The start time of the Stitch replication job that replicated this record