MDW Facebook Table Spec: fact_vendor_cost_facebook
fact_vendor_cost_facebook
Term | Definition | Datatype |
start_date | date_start | Date |
end_date | date_stop | Date |
impressions | impressions | Number |
reach | reach | Number |
amount_spent_usd | spend | Amount |
purchases_1d_view | actions_offsite_conversion.fb_pixel_purchase_1d_view | Amount |
purchases_1d_click | actions_offsite_conversion.fb_pixel_purchase_1d_click | Amount |
purchase_7d_view | actions_offsite_conversion.fb_pixel_purchase_7d_view | Amount |
purchase_7d_click | actions_offsite_conversion.fb_pixel_purchase_7d_click | Amount |
purchase_28d_view | actions_offsite_conversion.fb_pixel_purchase_28d_view | Amount |
purchase_28d_click | actions_offsite_conversion.fb_pixel_purchase_28d_click | Amount |
pur_conversion_1d_view | action_values_offsite_conversion.fb_pixel_purchase_1d_view | Amount |
pur_conversion_1d_click | action_values_offsite_conversion.fb_pixel_purchase_1d_click | Amount |
pur_conversion_7d_view | action_values_offsite_conversion.fb_pixel_purchase_7d_view | Amount |
pur_conversion_7d_click | action_values_offsite_conversion.fb_pixel_purchase_7d_click | Amount |
pur_conversion_28d_view | action_values_offsite_conversion.fb_pixel_purchase_28d_view | Amount |
pur_conversion_28d_click | action_values_offsite_conversion.fb_pixel_purchase_28d_click | Amount |
campaign_name | campaign_name | String(1000) |
batch_id | ${this.batchId} | String(1000) |
campaign_id | campaign_id | Number |
adset_id | adset_id | Number |
offline_conversion_1d_view | actions_offline_conversion.purchase_1d_view | Amount |
offline_conversion_1d_click | actions_offline_conversion.purchase_1d_click | Amount |
offline_conversion_7d_view | actions_offline_conversion.purchase_7d_view | Amount |
offline_conversion_7d_click | actions_offline_conversion.purchase_7d_click | Amount |
offline_conversion_28d_view | actions_offline_conversion.purchase_28d_view | Amount |
offline_conversion_28d_click | actions_offline_conversion.purchase_28d_click | Amount |
offline_conversion_value_1d_view | action_values_offline_conversion.purchase_1d_view | Amount |
offline_conversion_value_1d_click | action_values_offline_conversion.purchase_1d_click | Amount |
offline_conversion_value_7d_view | action_values_offline_conversion.purchase_7d_view | Amount |
offline_conversion_value_7d_click | action_values_offline_conversion.purchase_7d_click | Amount |
offline_conversion_value_28d_view | action_values_offline_conversion.purchase_28d_view | Amount |
offline_conversion_value_28d_click | action_values_offline_conversion.purchase_28d_click | Amount |
ad_account_id | account_id | String(1000) |
ad_account_name | account_name | String(1000) |
adset_name | adset_name | String(1000) |
clicks | clicks | Number |
action3_1d_view | action3_1d_view | Amount |
action3_1d_click | action3_1d_click | Amount |
action3_7d_view | action3_7d_view | Amount |
action3_7d_click | action3_7d_click | Amount |
action3_28d_view | action3_28d_view | Amount |
action3_28d_click | action3_28d_click | Amount |
action_value3_1d_view | action_value3_1d_view | Amount |
action_value3_1d_click | action_value3_1d_click | Amount |
action_value3_7d_view | action_value3_7d_view | Amount |
action_value3_7d_click | action_value3_7d_click | Amount |
action_value3_28d_view | action_value3_28d_view | Amount |
action_value3_28d_click | action_value3_28d_click | Amount |
action4_1d_view | action4_1d_view | Amount |
action4_1d_click | action4_1d_click | Amount |
action4_7d_view | action4_7d_view | Amount |
action4_7d_click | action4_7d_click | Amount |
action4_28d_view | action4_28d_view | Amount |
action4_28d_click | action4_28d_click | Amount |
action_value4_1d_view | action_value4_1d_view | Amount |
action_value4_1d_click | action_value4_1d_click | Amount |
action_value4_7d_view | action_value4_7d_view | Amount |
action_value4_7d_click | action_value4_7d_click | Amount |
action_value4_28d_view | action_value4_28d_view | Amount |
action_value4_28d_click | action_value4_28d_click | Amount |
action5_1d_view | action5_1d_view | Amount |
action5_1d_click | action5_1d_click | Amount |
action5_7d_view | action5_7d_view | Amount |
action5_7d_click | action5_7d_click | Amount |
action5_28d_view | action5_28d_view | Amount |
action5_28d_click | action5_28d_click | Amount |
action_value5_1d_view | action_value5_1d_view | Amount |
action_value5_1d_click | action_value5_1d_click | Amount |
action_value5_7d_view | action_value5_7d_view | Amount |
action_value5_7d_click | action_value5_7d_click | Amount |
action_value5_28d_view | action_value5_28d_view | Amount |
action_value5_28d_click | action_value5_28d_click | Amount |
action6_1d_view | action6_1d_view | Amount |
action6_1d_click | action6_1d_click | Amount |
action6_7d_view | action6_7d_view | Amount |
action6_7d_click | action6_7d_click | Amount |
action6_28d_view | action6_28d_view | Amount |
action6_28d_click | action6_28d_click | Amount |
action_value6_1d_view | action_value6_1d_view | Amount |
action_value6_1d_click | action_value6_1d_click | Amount |
action_value6_7d_view | action_value6_7d_view | Amount |
action_value6_7d_click | action_value6_7d_click | Amount |
action_value6_28d_view | action_value6_28d_view | Amount |
action_value6_28d_click | action_value6_28d_click | Amount |
action7_1d_view | action7_1d_view | Amount |
action7_1d_click | action7_1d_click | Amount |
action7_7d_view | action7_7d_view | Amount |
action7_7d_click | action7_7d_click | Amount |
action7_28d_view | action7_28d_view | Amount |
action7_28d_click | action7_28d_click | Amount |
action_value7_1d_view | action_value7_1d_view | Amount |
action_value7_1d_click | action_value7_1d_click | Amount |
action_value7_7d_view | action_value7_7d_view | Amount |
action_value7_7d_click | action_value7_7d_click | Amount |
action_value7_28d_view | action_value7_28d_view | Amount |
action_value7_28d_click | action_value7_28d_click | Amount |
action8_1d_view | action8_1d_view | Amount |
action8_1d_click | action8_1d_click | Amount |
action8_7d_view | action8_7d_view | Amount |
action8_7d_click | action8_7d_click | Amount |
action8_28d_view | action8_28d_view | Amount |
action8_28d_click | action8_28d_click | Amount |
action_value8_1d_view | action_value8_1d_view | Amount |
action_value8_1d_click | action_value8_1d_click | Amount |
action_value8_7d_view | action_value8_7d_view | Amount |
action_value8_7d_click | action_value8_7d_click | Amount |
action_value8_28d_view | action_value8_28d_view | Amount |
action_value8_28d_click | action_value8_28d_click | Amount |
action9_1d_view | action9_1d_view | Amount |
action9_1d_click | action9_1d_click | Amount |
action9_7d_view | action9_7d_view | Amount |
action9_7d_click | action9_7d_click | Amount |
action9_28d_view | action9_28d_view | Amount |
action9_28d_click | action9_28d_click | Amount |
action_value9_1d_view | action_value9_1d_view | Amount |
action_value9_1d_click | action_value9_1d_click | Amount |
action_value9_7d_view | action_value9_7d_view | Amount |
action_value9_7d_click | action_value9_7d_click | Amount |
action_value9_28d_view | action_value9_28d_view | Amount |
action_value9_28d_click | action_value9_28d_click | Amount |
action10_1d_view | action10_1d_view | Amount |
action10_1d_click | action10_1d_click | Amount |
action_value10_7d_view | action10_7d_view | Amount |
action_value10_7d_click | action10_7d_click | Amount |
action10_28d_view | action10_28d_view | Amount |
action10_28d_click | action10_28d_click | Amount |
action_value10_1d_view | action_value10_1d_view | Amount |
action_value10_1d_click | action_value10_1d_click | Amount |
action_value10_7d_view | action_value10_7d_view | Amount |
action_value10_7d_click | action_value10_7d_click | Amount |
action_value10_28d_view | action_value10_28d_view | Amount |
action_value10_28d_click | action_value10_28d_click | Amount |
country | country | Amount |
purchases_count | actions_offsite_conversion.fb_pixel_purchase_value | Amount |
offline_conversion_count | actions_offline_conversion.purchase_value | Amount |
action3_count | action3_count | Amount |
action4_count | action4_count | Amount |
action5_count | action5_count | Amount |
action6_count | action6_count | Amount |
action7_count | action7_count | Amount |
action8_count | action8_count | Amount |
action9_count | action9_count | Amount |
action10_count | action10_count | Amount |
attribution_setting | attribution_setting | Amount |
purchases_value | purchases_value | Amount |
offline_conversion_value | offline_conversion_value | Amount |
action3_value | action3_value | Amount |
action4_value | action4_value | Amount |
action5_value | action5_value | Amount |
action6_value | action6_value | Amount |
action7_value | action7_value | Amount |
action8_value | action8_value | Amount |
action9_value | action9_value | Amount |
action10_value | action10_value | Amount |
