Schema: Data Warehouse - Platform Performance - Bing
| Order | Name | Description | Type |
|---|---|---|---|
| 1 | advertiser | Rockerbox Account ID | 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 | campaign_name | The campaign name | str |
| 15 | campaign_id | The Microsoft Advertising assigned unique identifier of a campaign | str |
| 16 | ad_group_name | The ad group name | str |
| 17 | ad_group_id | The Microsoft Advertising assigned unique identifier of an ad group | str |
| 18 | ad_title | The ad title | str |
| 19 | ad_id | The Microsoft Advertising assigned unique identifier of an ad | str |
| 20 | 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 |
| 21 | currency_code | The local currency of your account in the ad platform (e.g., EUR, USD) | str |
| 22 | spend_usd | The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule in USD. | float |
| 23 | clicks | The number of clicks on an ad | int |
| 24 | impressions | The number of times an ad has been displayed on search results pages | int |
| 25 | conversions | The number of conversions. ConversionsQualified is the count of conversions across all conversion goals with the ExcludeFromBiddingProperty set to false. AllConversionsQualified is the count of conversions across all conversion goals regardless of the ExcludeFromBidding setting. ViewThroughConversionsQualified is the count of view-through conversions across all conversion goals. | dict |
| 26 | rb_sync_id | Identifier used by Rockerbox to sync dataset to your warehouse | str |
| 27 | updated_at | timestamp |
Updated about 2 years ago