Skip to main content
TikTok Connector
Jonas Østergård Bæk avatar
Written by Jonas Østergård Bæk
Updated over a week ago

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:

  1. Go to HomeData and reportingConnectors.

  2. Click the button 'Create new connector'.

  3. Give your connector a name.

Step 1: Choose a data source type and account

  1. Select the data source type 'TikTok'.

  2. 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:

  • If you select one of the pre-defined reports, please refer to the details here.

  • If you select a user-defined report, please refer to the information here.

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

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

Description
Tiktok time series report

Dimensions

  • date

  • campaign_id

  • stat_time_day

  • campaign_name

Metrics

  • impressions

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

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

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

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

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:

Did this answer your question?