Google_ads
User facing views for Google Ads derived tables.
campaign_conversions_by_date
Campaign Conversions By Date
google_ads.campaign_conversions_by_date
Number of conversions and installs by campaign & date.
- Owners:
| Column | Description | Type | Nullable |
|---|---|---|---|
| date | Date | Yes | |
| account_name | String | Yes | |
| account_id | Integer | Yes | |
| campaign_name | String | Yes | |
| campaign_id | Integer | Yes | |
| installs | Float | Yes | |
| conversions | Float | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | google_ads_derived | campaign_conversions_by_date_v1 |
Source Directory | View Definition | Metadata File
campaign_names_map
Campaign Names Map
google_ads.campaign_names_map
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| account_name | String | Yes | |
| account_id | Integer | Yes | |
| campaign_id | Integer | Yes | |
| campaign_name | String | Yes | |
| is_most_recent_record | Boolean | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | google_ads_derived | campaign_names_map_v1 |
Source Directory | View Definition | Metadata File
daily_ad_group_stats
Daily Ad Group Stats
google_ads.daily_ad_group_stats
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| date | Date | Yes | |
| account_name | String | Yes | |
| account_id | Integer | Yes | |
| currency_code | String | Yes | |
| campaign_name | String | Yes | |
| campaign_id | Integer | Yes | |
| ad_group_name | String | Yes | |
| ad_group_id | String | Yes | |
| ad_group_status | String | Yes | |
| ad_group_type | String | Yes | |
| spend | Float | Yes | |
| clicks | Integer | Yes | |
| impressions | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | google_ads_derived | daily_ad_group_stats_v1 |
Source Directory | View Definition | Metadata File
daily_campaign_stats
Daily Campaign Stats
google_ads.daily_campaign_stats
Please provide a description for the query
| Column | Description | Type | Nullable |
|---|---|---|---|
| date | Date | Yes | |
| account_name | String | Yes | |
| account_id | Integer | Yes | |
| currency_code | String | Yes | |
| campaign_name | String | Yes | |
| campaign_id | Integer | Yes | |
| advertising_channel_type | String | Yes | |
| advertising_channel_subtype | String | Yes | |
| status | String | Yes | |
| spend | Float | Yes | |
| clicks | Integer | Yes | |
| impressions | Integer | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | google_ads_derived | daily_campaign_stats_v1 |
Source Directory | View Definition | Metadata File