MDW TikTok Table Spec: fact_vendor_cost_tiktok
fact_vendor_cost_tiktok
Why is it important? Legacy table which was previously used to standard tiktok metrics such as cost, impressions, conversions, total purchases, complete payment etc.
Term | Definition (maps to which Tiktok API parameters) | Datatype |
date | stat_datetime | Date |
campaign_name | Specifies campaign name | String(1000) |
campaign_id | Specifies campaign_id | String(1000) |
ad_group_name | adgroup_name | String(1000) |
ad_group_id | adgroup_id | String(1000) |
objective | objective | String(1000) |
spend | spend | Amount(1000) |
impression | show_cnt | Number(1000) |
click | click_cnt | Number(1000) |
conversions | convert_cnt | Number(1000) |
conversion | time_attr_convert_cnt | Number(1000) |
purchase | active_pay | Amount(1000) |
value_per_purchase | active_pay_avg_amount | Amount(1000) |
vta_conversions | active_show | Number(1000) |
vta_purchase | active_pay_show | Number(1000) |
cta_conversions | active_click | Number(1000) |
cta_purchase | active_pay_click | Number(1000) |
total_purchase_value | active_pay_amount | Amount(1000) |
batch_id | internal processing batch ID | String(1000) |
