Article date

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.

Prerequisites

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_ad_report
  • ad_group_id
  • ad_group_name
  • ad_id
  • ad_name
  • ad_type
  • campaign_id
  • campaign_name
  • clicks
  • cost_micros
  • date
  • impressions
  • resource_name

customer_client
  • 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_group_ad_report
  • ad_id
  • conversion_action
  • conversion_action_category
  • conversions
  • conversions_value
  • date
  • resource_name

 

Data lineage

Bildschirmfoto_2022-04-27_um_01.48.29.png

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 ⬇️

Articles in this section

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