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 |