Google Ads template

In this guide, you'll find the JSON file for the Google Ads modeling template and a step-by-step guide on how to implement it. Please check out the templates introduction guide to learn how to add a data modeling template in Y42.


This template is tailored towards E-Commerce use cases and will provide you with a Google Ads modeling template that includes purchase conversions and purchase conversion values. In order to use this template, please make sure to add two Google Ads integration. 1 Google Ads integration will include ads data (ad metrics e.g. clicks, impressions per ad ID per day) and the other one will include conversion data (e.g. conversions, conversion value per ad ID per day)

To implement this template, please add one Google Ads integration with following tables & columns selected:

Google Ads integration with ad metrics

 Table name  Column name


  • ad_group_id
  • ad_group_name
  • ad_id
  • ad_name
  • ad_type
  • campaign_id
  • campaign_name
  • clicks
  • cost_micros
  • date
  • impressions
  • resource_name


  • currency_code
  • descriptive_name
  • id
  • resource_name
  • status
  • test_account
  • time_zone


The second Google Ads integration should include this table and columns:

Google Ads integration with conversion metrics

 Table name  Column name


  • ad_id
  • conversion_action
  • conversion_action_category
  • conversions
  • conversions_value
  • date
  • resource_name


Data lineage


Step-by-step guide

  1. Create a new model.
  2. Name it stg_google_ads.
  3. Import the JSON file stg_google_ads.
  4. Replace the INPUT nodes with your actual Google Ads input table from the two Google integrations.
  5. Commit the model.

Please find the template JSON file down below ⬇️

Was this article helpful?
0 out of 0 found this helpful