What is it about
The TikTok connector extracts data directly from the TikTok Marketing API and makes it available for use in your BigQuery environment.
To start working with a connector, follow these steps:
Go to Home → Data and reporting → Connectors.
Click the button 'Create new connector'.
Give your connector a name.
Step 1: Choose a data source type and account
Select the data source type 'TikTok'.
Choose an account for TikTok. If no TikTok account is yet connected to Alvie, you will be prompted to connect this data source to Alvie first. To do so, simply follow this guide.
Step 2. Choose a report type
You can select one of the pre-defined reports or create your own report by choosing the user-defined report option.
There are some specifics based on the report type you choose:
There are some advanced settings available for the chosen report.
Select Days to refresh to determine how many days should be refreshed on each run.
Step 3: Select a date range
Select the date range to be applied to the connector. For more details, check the guide here.
Step 4: Set up data targets
Set up data targets to ensure your data is placed correctly. Follow the guide here on how to do this properly.
Step 5: Check advanced settings and activate your connector
Once you are ready, you can activate the connector and start it immediately. It is also possible to save the connector without activating it and return to it later.
The available pre-defined reports:
campaign_performance
campaign_performance
Description
Report for general campaign performance metrics and dimensions.
Dimensions
date
campaign_id
stat_time_day
campaign_name
Metrics
spend
reach
cpm
cost_per_1000_reached
impressions
video_watched_6s
clicks
ctr
page_browse_view
time_series
time_series
Description
Tiktok time series report
Dimensions
date
campaign_id
stat_time_day
campaign_name
Metrics
impressions
campaign_performance_attribution
campaign_performance_attribution
Description
Report for general campaign performance metrics and dimensions. Consumed by the Attribution pipeline.
Dimensions
date
account_id
campaign_id
stat_time_day
campaign_name
currency
Metrics
spend
impressions
clicks
conversion
total_onsite_shopping_value
campaign_performance_base
campaign_performance_base
Description
Report for general campaign performance metrics and dimensions.
Dimensions
date
stat_time_day
currency
account_id
advertiser_name
advertiser_id
campaign_name
campaign_id
objective_type
campaign_dedicate_type
Metrics
impressions
gross_impressions
video_watched_6s
clicks
spend
conversion
result
secondary_goal_result
complete_payment
value_per_complete_payment
total_landing_page_view
total_pageview
total_value_per_pageview
button_click
total_button_click_value
online_consult
total_online_consult_value
user_registration
total_user_registration_value
page_content_view_events
total_page_view_content_events_value
product_details_page_browse
total_product_details_page_browse_value
web_event_add_to_cart
total_web_event_add_to_cart_value
on_web_order
total_on_web_order_value
initiate_checkout
total_initiate_checkout_value
add_billing
total_add_billing_value
page_event_search
total_page_event_search_value
form
total_form_value
download_start
total_download_start_value
on_web_add_to_wishlist
total_on_web_add_to_wishlist_value
on_web_subscribe
total_on_web_subscribe_value
custom_page_events
custom_page_events_value
onsite_shopping
total_onsite_shopping_value
onsite_initiate_checkout_count
total_onsite_initiate_checkout_count_value
onsite_on_web_detail
total_onsite_on_web_detail_value
onsite_add_to_wishlist
total_onsite_add_to_wishlist_value
onsite_add_billing
total_onsite_add_billing_value
onsite_on_web_cart
total_onsite_on_web_cart_value
onsite_form
total_onsite_form_value
onsite_download_start
onsite_destination_visits
ix_page_view_count
ix_button_click_count
ix_product_click_count
offline_shopping_events
offline_shopping_events_value
offline_contact_events
offline_contact_events_value
offline_subscribe_events
offline_subscribe_events_value
offline_form_events
offline_form_events_value
offline_add_payment_info_events
offline_add_payment_info_events_value
offline_add_to_cart_events
offline_add_to_cart_events_value
offline_add_to_wishlist_events
offline_add_to_wishlist_events_value
offline_click_button_events
offline_click_button_events_value
offline_complete_registration_events
offline_complete_registration_events_value
offline_download_events
offline_download_events_value
offline_initiate_checkout_events
offline_initiate_checkout_events_value
offline_place_order_events
offline_place_order_events_value
offline_search_events
offline_search_events_value
offline_view_content_events
offline_view_content_events_value
campaign_performance_custom_conversions
campaign_performance_custom_conversions
Description
Report for conversion metrics for campaign performance.
Dimensions
date
stat_time_day
currency
account_id
advertiser_name
advertiser_id
campaign_name
campaign_id
objective_type
campaign_dedicate_type
custom_event_type
Metrics
custom_app_events
custom_app_events_value
custom_page_events
custom_page_events_value
Ad Performance Custom Conversions
Ad Performance Custom Conversions
Report for conversion metrics for ad performance.
Dimensions
date
stat_time_day
currency
account_id
advertiser_name
advertiser_id
campaign_name
adgroup_name
ad_name
ad_id
objective_type
campaign_dedicate_type
custom_event_type
Metrics
custom_app_events
custom_app_events_value
custom_page_events
custom_page_events_value
Ad Performance Base
Ad Performance Base
Dimensions
date
stat_time_day
currency
account_id
advertiser_name
advertiser_id
campaign_name
adgroup_name
ad_name
ad_id
objective_type
campaign_dedicate_type
Metrics
impressions
gross_impressions
video_watched_6s
clicks
spend
conversion
result
secondary_goal_result
complete_payment
value_per_complete_payment
total_landing_page_view
total_pageview
total_value_per_pageview
button_click
total_button_click_value
online_consult
total_online_consult_value
user_registration
total_user_registration_value
page_content_view_events
total_page_view_content_events_value
product_details_page_browse
total_product_details_page_browse_value
web_event_add_to_cart
total_web_event_add_to_cart_value
on_web_order
total_on_web_order_value
initiate_checkout
total_initiate_checkout_value
add_billing
total_add_billing_value
page_event_search
total_page_event_search_value
form
total_form_value
download_start
total_download_start_value
on_web_add_to_wishlist
total_on_web_add_to_wishlist_value
on_web_subscribe
total_on_web_subscribe_value
custom_page_events
custom_page_events_value
onsite_shopping
total_onsite_shopping_value
onsite_initiate_checkout_count
total_onsite_initiate_checkout_count_value
onsite_on_web_detail
total_onsite_on_web_detail_value
onsite_add_to_wishlist
total_onsite_add_to_wishlist_value
onsite_add_billing
total_onsite_add_billing_value
onsite_on_web_cart
total_onsite_on_web_cart_value
onsite_form
total_onsite_form_value
onsite_download_start
onsite_destination_visits
ix_page_view_count
ix_button_click_count
ix_product_click_count
offline_shopping_events
offline_shopping_events_value
offline_contact_events
offline_contact_events_value
offline_subscribe_events
offline_subscribe_events_value
offline_form_events
offline_form_events_value
offline_add_payment_info_events
offline_add_payment_info_events_value
offline_add_to_cart_events
offline_add_to_cart_events_value
offline_add_to_wishlist_events
offline_add_to_wishlist_events_value
offline_click_button_events
offline_click_button_events_value
offline_complete_registration_events
offline_complete_registration_events_value
offline_download_events
offline_download_events_value
offline_initiate_checkout_events
offline_initiate_checkout_events_value
offline_place_order_events
offline_place_order_events_value
offline_search_events
offline_search_events_value
offline_view_content_events
offline_view_content_events_value
User defined reports for TikTok connectors
You can view a complete guide and overview of how to setup user defined connectors here: