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 |