Google Ads

LookML files for a schema mapping on Snowflake for google Ads compatible with Fivetran's Google Ads ETL. This is designed to work with a ETL agnostic Google Ads block.

To use this block, you will need to:

Include it in your manifest.lkml:

Note: This requires the Project Import feature currently in /admin/labs to be enabled on your Looker instance.

Via local projects:

Fork this repo and create a new project named app-marketing-google-ads-adapter

manifest.lkml

local_dependency: {
  project: "app-marketing-google-ads-adapter"
}


local_dependency: {
  project: "app-marketing-google-ads"
}```

Or remote dependency which don't require a local version.

manifest.lkml
```LookML

remote_dependency: app-marketing-google-ads-adapter {
  url: "git://github.com/looker/app-marketing-google-ads-fivetran-snowflake"
  ref: "b491583a3ac3a1125e535b5c5855bd56e9aa41a5"
}

remote_dependency: app-marketing-google-ads {
  url: "git://github.com/looker/app-marketing-google-ads"
  ref: "557fa52e9fee322d9a601ee5bf009cf929ef0261"
}```

Note that the `ref:` should point to the latest commit in each respective repo [google-ads-fivetran-bigquery](https://github.com/looker/app-marketing-google-ads-fivetran-snowflake/commits/master) and [google-ads](https://github.com/looker/app-marketing-google-ads/commits/master).

2. Create a `google_ads_config` view that is assumed by this project. This configuration requires a  file

For example:

google_ads_config.view.lkml
```LookML
view: google_ads_config {
  extension: required

  dimension: google_ads_schema {
    hidden: yes
    sql:google_ads;;
  }
}

3. Include the view files in your model.

For example:

marketing_analytics.model.lkml

include: "/app-marketing-google-ads-adapter/*.view"
include: "/app-marketing-google-ads/*.view"
include: "/app-marketing-google-ads/*.dashboard"

Interface

Account Structure

ad.view:

• ad_adapter
  • external_customer_id
  • campaign_id
  • ad_group_id
  • creative_id
  • creative
  • status_active

ad_group.view:

• ad_group_adapter
  • external_customer_id
  • campaign_id
  • ad_group_id
  • ad_group_name
  • status_active

campaign.view:

• campaign_adapter
  • external_customer_id
  • campaign_id
  • campaign_name
  • status_active
  • budget_id
  • amount

customer.view:

• customer_adapter
  • external_customer_id

Targeting Criteria

geo.view

• geotargeting
  • state
  • country_code
  • name
  • postal_code

keyword.view

• keyword_adapter
  • external_customer_id
  • campaign_id
  • ad_group_id
  • criterion_id
  • criteria
  • status_active
  • bidding_strategy_type

Reports

ad_impressions.view

• _date
• ad_network_type
• device_type
• cost
• impressions
• interactions
• clicks
• conversions
• conversionvalue
• averageposition

Account Stats

• ad_impressions_adapter
• ad_impressions_hour_adapter
  • hour_of_day

Campaign Stats

• ad_impressions_campaign_adapter
• ad_impressions_campaign_hour_adapter
  • hour_of_day

Ad Group Stats

• ad_impressions_ad_group_adapter
• ad_impressions_ad_group_hour_adapter
  • hour_of_day

Keyword Stats

• ad_impressions_keyword_adapter

Ad Stats

• ad_impressions_ad_adapter

Targeting Reports

• ad_impressions * [age_range, audience, gender, geo, parental_status, video]

Block Info

This Block is modeled on the schema from Fivetrans's Google AdWords ETL.

The schema documentation for AdWords can be found in Google's docs.