MDW TikTok Table Spec: fact_vendor_cost_tiktok_master

fact_vendor_cost_tiktok_master

Why is it important? This is a master table actively in use with the standard as well as number of other custom metrics to choose from.

Term

Definition

Datatype

stat_time_day

date

Date

batch_id

${this.batchID}

String(1000)

account_name1

account_name

String(1000)

campaign_name

campaign_name

String(1000)

campaign_id

campaign_id

String(1000)

adgroup_name

adgroup_name

String(1000)

adgroup_id

adgroup_id

String(1000)

objective

objective

String(1000)

spend

spend

Amount(1000)

impressions

impressions

Amount(1000)

clicks

clicks

Amount(1000)

real_time_conversion

real_time_conversion

Amount(1000)

conversion

conversion

Amount(1000)

purchase

purchase

Amount(1000)

value_per_total_purchase

value_per_total_purchase

Amount(1000)

vta_conversion

vta_conversion

Amount(1000)

vta_purchase

vta_purchase

Amount(1000)

cta_conversion

cta_conversion

Amount(1000)

cta_purchase

cta_purchase

Amount(1000)

total_purchase_value

total_purchase_value

Amount(1000)

complete_payment

complete_payment

Amount(1000)

cost_per_complete_payment

cost_per_complete_payment

Amount(1000)

reach

reach

Amount(1000)

frequency

frequency

Amount(1000)

real_time_result

real_time_result

Amount(1000)

secondary_goal_result

secondary_goal_result

Amount(1000)

app_install

app_install

Amount(1000)

total_registration

total_registration

Amount(1000)

total_app_event_add_to_cart

total_app_event_add_to_cart

Amount(1000)

total_purchase

total_purchase

Amount(1000)

total_checkout

total_checkout

Amount(1000)

total_checkout_value

total_checkout_value

Amount(1000)

total_complete_payment_rate

total_complete_payment_rate

Amount(1000)

user_registration

user_registration

Amount(1000)

web_event_add_to_cart

web_event_add_to_cart

Amount(1000)

initiate_checkout

initiate_checkout

Amount(1000)

total_initiate_checkout_value

total_initiate_checkout_value

Amount(1000)

form

form

Amount(1000)

on_web_subscribe

on_web_subscribe

Amount(1000)

skan_result

skan_result

Amount(1000)

skan_conversion

skan_conversion

Amount(1000)

skan_app_install

skan_app_install

Amount(1000)

skan_registration

skan_registration

Amount(1000)

skan_purchase

skan_purchase

Amount(1000)

skan_add_to_cart

skan_add_to_cart

Amount(1000)

skan_checkout

skan_checkout

Amount(1000)

spend_credits

spend_credits

Amount(1000)

total_spend_credits

total_spend_credits

Amount(1000)

total_spend_credits_value

total_spend_credits_value

Amount(1000)

subscribe

subscribe

Amount(1000)

total_subscribe

total_subscribe

Amount(1000)

total_subscribe_value

total_subscribe_value

Amount(1000)

on_web_order

on_web_order

Amount(1000)

total_on_web_order_value

total_on_web_order_value

Amount(1000)

video_play_actions

video_play_actions

Amount(1000)

video_watched_2s

video_watched_2s

Amount(1000)

video_watched_6s

video_watched_6s

Amount(1000)

average_video_play

average_video_play

Amount(1000)

average_video_play_per_user

average_video_play_per_user

Amount(1000)

video_views_p25

video_views_p25

Amount(1000)

video_views_p50

video_views_p50

Amount(1000)

video_views_p75

video_views_p75

Amount(1000)

video_views_p100

video_views_p100

Amount(1000)

profile_visits

profile_visits

Amount(1000)

profile_visits_rate

profile_visits_rate

Amount(1000)

likes

likes

Amount(1000)

comments

comments

Amount(1000)

shares

shares

Amount(1000)

follows

follows

Amount(1000)

clicks_on_music_disc

clicks_on_music_disc

Amount(1000)


How did we do?


Powered by HelpDocs (opens in a new tab)