MDW Tableau Table Spec: tbl_fb_tableau_reporting_custom_taxonomy
tbl_fb_tableau_reporting_custom_taxonomy
Term | Definition | Datatype |
id | Internal ID | Varchar(100) |
id_breaker | Definition | Varchar(100) |
dimension_type | Facebook objects- to identify the category such as campaign, adset, audience etc... | Varchar(450) |
dimension_value | Value of the category | Varchar(65535) |
cuts | Time level slicing such as Weekly, Monthly | Integer |
interval_start_date | Week or month start date | Date |
interval_end_date | Week or month end date | Date |
int_pulse_start_date | Experiment start or resume date | Date |
int_pulse_end_date | Experiment end or pause date | Date |
control_reach | Control reach at time slice level | Integer |
ctrl_amount_spent_usd | Control spend at time slice level | Double Precision |
ctrl_conv | Control conversion at time slice level | Double Precision |
ctrl_revenue | Control revenue at time slice level | Double Precision |
test_reach | Test reach at time slice level | Integer |
test_amount_spent_usd | Test Spend at time slice level | Double Precision |
test_conv | Test conversion at time slice level | Double Precision |
test_revenue | Test revenue at time slice level | Double Precision |
orders(lt) | Last touch orders | Double Precision |
revenue(lt) | Last touch orders | Double Precision |
conversion_type | Conversion type | Varchar(100) |
audience_type | Audience type | Varchar(256) |
age_max | Maximum age of audience targeted | Varchar(10) |
age_min | Minimum age of audience targeted | Varchar(65535) |
genders | Gender of audience targeted | Varchar(65535) |
geo_countries | Countries | Varchar(65535) |
geo_location_types | Location types | Varchar(65535) |
publisher_platforms | Publisher platforms | Varchar(65535) |
instagram_platforms | Instagram platforms | Varchar(65535) |
messenger_platforms | Messenger platforms | Varchar(65535) |
custom_audiences_name | Included custom audiences | Varchar(65535) |
excluded_custom_audiences_name | Excluded custom audiences | Varchar(65535) |
excluded_geo_markets_name | Excluded markets | Varchar(65535) |
excluded_geo_country | Excluded country | Varchar(65535) |
excluded_location_types | Excluded location types | Varchar(65535) |
interests_name | Interest targeting | Varchar(65535) |
income_name | Income targeting | Varchar(65535) |
behaviors_name | Behaviour targeting | Varchar(65535) |
base_dim1 | Adset name | Varchar(65535) |
base_dim2 | Campaign name | Varchar(65535) |
base_dim3 | Addl placeholder | Varchar(65535) |
base_dim4 | Addl placeholder | Varchar(65535) |
custom_dim1 | Platforms | Varchar(65535) |
custom_dim2 | Included custom audiences | Varchar(65535) |
custom_dim3 | Addl placeholder | Varchar(65535) |
custom_dim4 | Addl placeholder | Varchar(65535) |
custom_dim5 | Addl placeholder | Varchar(65535) |
test_add_metrics1 | Test impressions | Double Precision |
test_add_metrics2 | Addl placeholder | Double Precision |
ctrl_add_metrics1 | Test impressions | Double Precision |
ctrl_add_metrics2 | Addl placeholder | Double Precision |
test_ad_account_id | Ad Account | Varchar(1000) |
control_ad_account_id | Ad Account | Varchar(1000) |
dimension_id | ID of the category / dimension | Varchar(100) |
expt_type | Scale test or incrementality test | Varchar(256) |
audience_size | Audience size | Varchar(50000) |
segment | Segment - taxonomy | Varchar(5000) |
tactic | Tactic - taxonomy | Varchar(5000) |
channel | Channel - taxonomy | Varchar(5000) |
derived_dimen_1 | Addl placeholder | Varchar(25000) |
derived_dimen_2 | Addl placeholder | Varchar(25000) |
derived_dimen_3 | Addl placeholder | Varchar(25000) |
derived_dimen_4 | Addl placeholder | Varchar(25000) |
derived_dimen_5 | Addl placeholder | Varchar(25000) |
test_add_metrics3 | Addl placeholder | Double Precision |
test_add_addl_conversion | Addl placeholder | Double Precision |
test_add_addl_revenue | Addl placeholder | Double Precision |
ctrl_add_metrics3 | Addl placeholder | Double Precision |
ctrl_add_addl_conversion | Addl placeholder | Double Precision |
ctrl_add_addl_revenue | Addl placeholder | Double Precision |
ui_final_conv_inc | Conversion incrementality from cross channel | Double Precision |
ui_final_conv_inc_lower | Addl placeholder | Double Precision |
ui_final_conv_inc_upper | Addl placeholder | Double Precision |
ui_final_revenue_inc | Revenue incrementality from the cross channel | Double Precision |
ui_final_revenue_inc_lower | Addl placeholder | Double Precision |
ui_final_revenue_inc_upper | Addl placeholder | Double Precision |
adset_status | Current status of adset | Varchar(1000) |
adset_rpmu_control | Control revenue per 1000 users reached | Double Precision |
adset_optimization_event | Adset optimization event | Varchar(1000) |
adset_attribution_spec_0_event_type | Click or view | Varchar(1000) |
adset_attribution_spec_0_windows_days | Attribution window | Integer |
adset_attribution_spec_1_event_type | Click or view | Varchar(1000) |
adset_attribution_spec_1_window_day | Attribution window | Integer |
adset_bid_strategy | Adset bid strategy | Varchar(1000) |
adset_bid_amount | Bid cap or target cost | Double Precision |
adset_bid_type | Bid type | Varchar(1000) |
campaign_status | Campaign status | Varchar(1000) |
campaign_objective | Campaign's objective | Varchar(1000) |
campaign_bid_strategy | Campaign bid strategy | Varchar(1000) |
campaign_daily_budget | Daily budget of the campaign | Varchar(1000) |
campaign_attribution_spec | Campaign attribution spec | Varchar(1000) |
campaign_id | Campaign ID | Integer |
min_audience_size | Minimum size of audience targeted | Integer |
max_audience_size | Maximum size of audience targeted | Integer |
adset_budget_latest | Adset current budget | Double Precision |
adset_budget_remaining | Adset budget remaining (lifetime - budget spend) | Double Precision |
campaign_budget_latest | Campaign current budget | Double Precision |
campaign_budget_remaining | Campaign budget remaining (lifetime - budget spend) | Double Precision |
campaign_lifetime_budget | Campaign lifetime budget set | Double Precision |
