Schema: Data Warehouse - Platform Performance - Facebook
| 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 name of the ad campaign. Your campaign contains ad sets and ads | str |
| 15 | campaign_id | The unique ID of the ad campaign. Your campaign contains ad sets and ads | str |
| 16 | adset_name | The name of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization and targeting | str |
| 17 | adset_id | The unique ID of the ad set. An ad set is a group of ads that share the same budget, schedule, delivery optimization and targeting | str |
| 18 | ad_name | The name of the ad | str |
| 19 | ad_id | The unique ID of the 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 the ad | int |
| 24 | impressions | The number of times your ads were on screen | int |
| 25 | inline_link_clicks | The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window | int |
| 26 | outbound_clicks | The number of clicks on links that take people off Facebook-owned properties | int |
| 27 | view_1d | The total number of view through conversions within a 1 day lookback. | dict |
| 28 | click_1d | The total number of click through conversions within a 1 day lookback window. | dict |
| 29 | click_7d | The total number of click through conversions within a 7 day lookback window. | dict |
| 30 | view_1d_value | The total value of view through conversions (in the local currency tracked in the FB pixel) within a 1 day lookback. | dict |
| 31 | click_1d_value | The total value of click through conversions (in the local currency tracked in the FB pixel) within a 1 day lookback window. | dict |
| 32 | click_7d_value | The total value of click through conversions (in the local currency tracked in the FB pixel) within a 7 day lookback window. | dict |
| 33 | view_1d_value_usd | The total value of view through conversions converted to USD within a 1 day lookback. | dict |
| 34 | click_1d_value_usd | The total value of click through conversions converted to USD within a 1 day lookback window. | dict |
| 35 | click_7d_value_usd | The total value of click through conversions converted to USD within a 7 day lookback window. | dict |
| 36 | rb_sync_id | Identifier used by Rockerbox to sync dataset to your warehouse | str |
| 37 | updated_at | timestamp |
Updated about 2 years ago