ReferenceSource Models
Google Ads Models
Copy-paste SQL models for turning raw Google Ads data into business-ready campaign reporting.
Copy and Paste these Google Ads Models into your Data Layer to quickly go from raw data sources to business ready Google Ads Reporting. Please note:
- Models must be added chronological order from top to bottom (so that they can reference each other).
- When adding your own models you must update the reference to include your source names.
google_campaign_performance_base
select
md5(id:: varchar ||'-'|| date) as id --PK
, date :: date as report_date
, id :: varchar as campaign_id
, name :: varchar as campaign_name
, conversions :: float as n_conversions
, conversions_value :: float as conversions_in_dollars
, impressions :: float as n_impressions
, clicks :: float as n_clicks
, cost_micros :: float / 1000000 as spend
from {{sources.google_ads.campaign}}