Schema: Data Warehouse - Platform Performance - Google
| Order | Name | Description | Type |
|---|---|---|---|
| 1 | advertiser | The name of the Rockerbox account. | str |
| 2 | type | The dataset type (e.g., platform_data) | str |
| 3 | platform | The name of the ad platform (e.g., Adwords) | str |
| 4 | report | The name of the dataset (e.g., platform_performance_adwords) | str |
| 5 | identifier | The unique identifier of the account in the advertising platform | str |
| 6 | date | The date that the action occured | date |
| 7 | utc_hour | The UTC hour that the action occured | int |
| 8 | tier_1 | Marketing channel categorization level 1 | str |
| 9 | tier_2 | Marketing channel categorization level 2 | str |
| 10 | tier_3 | Marketing channel categorization level 3 | str |
| 11 | tier_4 | Marketing channel categorization level 4 | str |
| 12 | tier_5 | Marketing channel categorization level 5 | str |
| 13 | mta_tiers_join_key | The unique identifier used to pull spend from an advertisting platform. This is typically the ad_id, but may differ based on your account setup | str |
| 14 | ad_network_type | The ad network that your ads are being displayed on (e.g., SEARCH, SEARCH_PARTNERS, MIXED, YOUTUBE_WATCH) | str |
| 15 | advertising_channel_type | The primary serving target for ads within the campaign (e.g., SEARCH, DISPLAY, SHOPPING) | str |
| 16 | campaign_name | The name of the ad campaign. Each campaign contains one or more ad groups. | str |
| 17 | campaign_id | The unique identifier of the ad campaign. | str |
| 18 | ad_group_type | The type of the ad group (e.g., SEARCH_STANDARD, DISPLAY_STANDARD) | str |
| 19 | ad_group_name | The name of the ad group. Each ad group contains one or more ad group ads. | str |
| 20 | ad_group_id | The unique identifier of the ad group. | str |
| 21 | spend | The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule in the ad platform account's local currency | float |
| 22 | currency_code | The local currency of your account in the ad platform (e.g., EUR, USD) | str |
| 23 | spend_usd | The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule in USD. | float |
| 24 | clicks | The number of clicks on the ad. | int |
| 25 | impressions | The number of times your ad is shown on a search result page or other site on the Google Network. | int |
| 26 | cost_micros | Ad spend in micro currency units (micros). For example, $1.23 will come back as 1230000 (1.23 x 1,000,000). Micro amounts always refer to the account's local currency. | int |
| 27 | all_conversions_by_conversion_date | The count of conversions based on the time of conversion. | dict |
| 28 | all_conversions | The count of conversions based on the time of the attributed advertising event (impression or click). | dict |
| 29 | view_through_conversions | The count of view through conversions based on the time of the attributed impression. | dict |
| 30 | all_conversions_value_by_conversion_date | The value of conversions based on the time of conversion. | dict |
| 31 | all_conversions_value | The value of conversions based on the time of the attributed advertising event (impression or click). | dict |
| 32 | view_through_lookback_window_days | The maximum number of days which may elapse between an impression and a conversion without an interaction. | dict |
| 33 | click_through_lookback_window_days | The maximum number of days that may elapse between an interaction (e.g., a click) and a conversion event. | dict |
| 34 | rb_sync_id | Identifier used by Rockerbox to sync dataset to your warehouse | str |
| 35 | updated_at | timestamp |
Updated about 2 years ago