Name: ama_adwords_bqdts_adapter
Owner: looker
Description: null
Created: 2018-05-01 23:45:03.0
Updated: 2018-05-14 23:43:54.0
Pushed: 2018-05-15 16:19:20.0
Homepage: null
Size: 49
Language: LookML
GitHub Committers
| User | Most Recent Commit | # Commits |
|---|
Other Committers
| User | Most Recent Commit | # Commits |
|---|
This adapter relies on a project app_marketing_analytics_config as specified in the manifest.lkml file. This project needs to include an adwords_config.view.lkml file.
For example:
: adwords_config {
tension: required
mension: adwords_schema {
hidden: yes
sql:adwords;;
mension: adwords_customer_id {
hidden: yes
sql:1234567890;;
ad.view:
ad_group.view:
campaign.view:
customer.view:
age_range.view
audience.view
gender.view
geo.view
keyword.view
parental_status.view
video.view
ad_impressions.view
Account Stats
Campaign Stats
Ad Group Stats
Keyword Stats
Ad Stats
Targeting Reports
This Block is modeled on the schema from Google's BigQuery Transfer Service.
The schema documentation for AdWords can be found in Google's docs.
Entity Tables and Stats Tables - There are several primary entities included in the AdWords data set, such as ad, ad group, campaign, customer, keyword, etc.. Each of these tables has a corresponding “Stats” table, which includes all the various metrics for that entity. For example, the “campaign” entity table contains attributes for each campaign, such as the campaign name and campaign status. The corresponding stats table - “Campaign Basic Stats” contains metrics such as impressions, clicks, and conversions. These stats tables are mapped to an ad_impression explore as an interface to the Looker Marketing Analytics application.
Snapshots - AdWords tables keep records over time by snapshotting all data at the end of each day. The following day, a new snapshot is taken, and appended to the table. There are two columns on each table: _DATA_DATE and _LATEST_DATE. _DATA_DATE tells you the day the data was recorded, while _LATEST_DATE is an immutable field that tells you the most recent date a snapshot was taken. Querying the table using _DATA_DATE = _LATEST_DATE in the WHERE clause would give you only the data for the latest day.
