Guides
Shape Help Center

TikTok Fields

Suggest Edits

Dimensions (75)

Account

NinjaCat System ID: tik_tok:DIM_ACCOUNT
Data Type: text
Aggregates To: DIM_ACCOUNT

Action / behavior category

API Name: action_category
NinjaCat System ID: tik_tok:DIM_action_category
Data Type: text

Action scene

API Name: action_scene
NinjaCat System ID: tik_tok:DIM_action_scene
Data Type: text

Ad Format

API Name: ad_format
NinjaCat System ID: tik_tok:DIM_ad_format
Data Type: text

Ad group Budget

API Name: adgroup_budget
NinjaCat System ID: tik_tok:DIM_adgroup_budget
Data Type: decimal
Display As: currency

Ad group Budget Mode

API Name: adgroup_budget_mode
NinjaCat System ID: tik_tok:DIM_adgroup_budget_mode
Data Type: text

Ad group ID

API Name: adgroup_id
NinjaCat System ID: tik_tok:DIM_adgroup_id
Data Type: text

Ad group name

API Name: adgroup_name
NinjaCat System ID: tik_tok:DIM_adgroup_name
Data Type: text
Aggregates To: DIM_AD_GROUP_NAME

Ad group Scheduled Budget

API Name: adgroup_scheduled_budget
NinjaCat System ID: tik_tok:DIM_adgroup_scheduled_budget
Data Type: decimal
Display As: currency

Ad Id

API Name: ad_id
NinjaCat System ID: tik_tok:DIM_ad_id
Data Type: text

Ad Image Preview URL

API Name: nc_image_preview_url
NinjaCat System ID: tik_tok:DIM_image_preview_url
Data Type: text
Display As: url

Ad name

API Name: ad_name
NinjaCat System ID: tik_tok:DIM_ad_name
Data Type: text
Aggregates To: DIM_AD_NAME

Ad Preview URL JSON

API Name: nc_ad_preview_url
NinjaCat System ID: tik_tok:DIM_ad_preview_url
Data Type: text
Display As: url

Ad Size

API Name: ad_size
NinjaCat System ID: tik_tok:DIM_ad_size
Data Type: text

Ad text

API Name: ad_text
NinjaCat System ID: tik_tok:DIM_ad_text
Data Type: text

Advertising objective

API Name: objective_type
NinjaCat System ID: tik_tok:DIM_objective_type
Data Type: text

Age

API Name: age
NinjaCat System ID: tik_tok:DIM_age
Data Type: text

App Name

API Name: app_name
NinjaCat System ID: tik_tok:DIM_app_name
Data Type: text

Audience Network

API Name: ac
NinjaCat System ID: tik_tok:DIM_ac
Data Type: text

Behavior name

API Name: behavior_name
NinjaCat System ID: tik_tok:DIM_behavior_name
Data Type: text

Call to Action

API Name: call_to_action
NinjaCat System ID: tik_tok:DIM_call_to_action
Data Type: text

Campaign Budget

API Name: campaign_budget
NinjaCat System ID: tik_tok:DIM_campaign_budget
Data Type: decimal
Display As: currency

Campaign Budget Mode

API Name: campaign_budget_mode
NinjaCat System ID: tik_tok:DIM_campaign_budget_mode
Data Type: text

Campaign ID

API Name: campaign_id
NinjaCat System ID: tik_tok:DIM_campaign_id
Data Type: text
Aggregates To: DIM_CAMPAIGN_ID

Campaign name

API Name: campaign_name
NinjaCat System ID: tik_tok:DIM_campaign_name
Data Type: text
Aggregates To: DIM_CAMPAIGN_NAME

Campaign Status

API Name: campaign_status
NinjaCat System ID: tik_tok:DIM_campaign_status
Data Type: text

Campaign Type

API Name: campaign_type
NinjaCat System ID: tik_tok:DIM_campaign_type
Data Type: text

Conversion Id

API Name: nc_conversion_id
NinjaCat System ID: tik_tok:DIM_conversion_id
Data Type: text

Conversion Name

API Name: nc_conversion_name
NinjaCat System ID: tik_tok:DIM_conversion_name
Data Type: text

Country Code

API Name: country_code
NinjaCat System ID: tik_tok:DIM_country_code
Data Type: text
Display As: country
Aggregates To: DIM_COUNTRIES

Creative Type

API Name: creative_type
NinjaCat System ID: tik_tok:DIM_creative_type
Data Type: text

Currency

NinjaCat System ID: tik_tok:DIM_CURRENCY
Data Type: text
Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: tik_tok:DIM_DATA_SOURCE
Data Type: text
Aggregates To: DIM_DATA_SOURCE

Date

API Name: stat_time_day
NinjaCat System ID: tik_tok:DIM_date
Data Type: date
Aggregates To: DIM_DATE

Day Of Month

NinjaCat System ID: tik_tok:DIM_DAY_OF_MONTH
Data Type: integer
Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: tik_tok:DIM_DAY_OF_WEEK
Data Type: text
Display As: day_of_week
Aggregates To: DIM_DAY_OF_WEEK

Delivery country or location

API Name: country
NinjaCat System ID: tik_tok:DIM_country
Data Type: text

Device Brand ID

API Name: device_brand_id
NinjaCat System ID: tik_tok:DIM_device_brand_id
Data Type: text

Device brand name

API Name: device_brand_name
NinjaCat System ID: tik_tok:DIM_device_brand_name
Data Type: text

Display Name

API Name: display_name
NinjaCat System ID: tik_tok:DIM_display_name
Data Type: text

Display orientation

API Name: orientation
NinjaCat System ID: tik_tok:DIM_orientation
Data Type: text

External Id

NinjaCat System ID: tik_tok:DIM_EXTERNAL_ID
Data Type: text
Aggregates To: DIM_EXTERNAL_ID

Gender

API Name: gender
NinjaCat System ID: tik_tok:DIM_gender
Data Type: text
Aggregates To: DIM_GENDER

Interest Category

API Name: interest_category
NinjaCat System ID: tik_tok:DIM_interest_category
Data Type: text

Landing Page URL

API Name: landing_page_url
NinjaCat System ID: tik_tok:DIM_landing_page_url
Data Type: text

Language

API Name: language
NinjaCat System ID: tik_tok:DIM_language
Data Type: text

Mobile App ID

API Name: mobile_app_id
NinjaCat System ID: tik_tok:DIM_mobile_app_id
Data Type: text

Month Of Year

NinjaCat System ID: tik_tok:DIM_MONTH_OF_YEAR
Data Type: text
Display As: date_month_of_year
Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: tik_tok:DIM_NETWORK
Data Type: text
Display As: title_case
Aggregates To: DIM_NETWORK

Placement

API Name: placement
NinjaCat System ID: tik_tok:DIM_placement
Data Type: text

Placement type

API Name: placement_type
NinjaCat System ID: tik_tok:DIM_placement_type
Data Type: text

Platform

API Name: platform
NinjaCat System ID: tik_tok:DIM_platform
Data Type: text

Playable ID

API Name: playable_id
NinjaCat System ID: tik_tok:DIM_playable_id
Data Type: text

Playable Name

API Name: playable_name
NinjaCat System ID: tik_tok:DIM_playable_name
Data Type: text

Playable URL

API Name: playable_url
NinjaCat System ID: tik_tok:DIM_playable_url
Data Type: text

Promotion type

API Name: promotion_type
NinjaCat System ID: tik_tok:DIM_promotion_type
Data Type: text

Quarter

NinjaCat System ID: tik_tok:DIM_QUARTER
Data Type: text
Display As: quarter
Aggregates To: DIM_QUARTER

Row

NinjaCat System ID: tik_tok:DIM_ROW
Data Type: text
Aggregates To: DIM_ROW

Status

API Name: playable_status
NinjaCat System ID: tik_tok:DIM_playable_status
Data Type: text
Aggregates To: DIM_STATUS

System Account ID

NinjaCat System ID: tik_tok:DIM_ACCOUNT_ID
Data Type: text
Aggregates To: DIM_ACCOUNT_ID

Target audience type for DPA

API Name: dpa_target_audience_type
NinjaCat System ID: tik_tok:DIM_dpa_target_audience_type
Data Type: text

Thumbnail

API Name: preview_url
NinjaCat System ID: tik_tok:DIM_preview_url
Data Type: text

TikTok App ID

API Name: tt_app_id
NinjaCat System ID: tik_tok:DIM_tt_app_id
Data Type: text

TikTok App Name

API Name: tt_app_name
NinjaCat System ID: tik_tok:DIM_tt_app_name
Data Type: text

TikTok Page Category

API Name: tiktok_page_category
NinjaCat System ID: tik_tok:DIM_tiktok_page_category
Data Type: text

User action

API Name: user_action
NinjaCat System ID: tik_tok:DIM_user_action
Data Type: text

Video Displayable

API Name: video_displayable
NinjaCat System ID: tik_tok:DIM_video_displayable
Data Type: text

Video Duration

API Name: video_duration
NinjaCat System ID: tik_tok:DIM_video_duration
Data Type: text

Video File Name

API Name: video_file_name
NinjaCat System ID: tik_tok:DIM_video_file_name
Data Type: text

Video Format

API Name: video_format
NinjaCat System ID: tik_tok:DIM_video_format
Data Type: text

Video Id

API Name: video_id
NinjaCat System ID: tik_tok:DIM_video_id
Data Type: text

Video Size

API Name: video_size
NinjaCat System ID: tik_tok:DIM_video_size
Data Type: text

Video URL Cover

API Name: video_cover_url
NinjaCat System ID: tik_tok:DIM_video_cover_url
Data Type: text

Week Of Year

NinjaCat System ID: tik_tok:DIM_WEEK_OF_YEAR
Data Type: text
Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: tik_tok:DIM_Year
Data Type: text
Aggregates To: DIM_YEAR

Metrics (88)

Avg Video Length

NinjaCat System ID: tik_tok:MET_avg_video_length
Data Type: integer
Formula: (tik_tok:MET_total_video_length / tik_tok:MET_video_play_actions )

Clicks

API Name: clicks
NinjaCat System ID: tik_tok:MET_clicks
Data Type: integer
Aggregates To: MET_CLICKS

Clicks on music disc

API Name: clicks_on_music_disc
NinjaCat System ID: tik_tok:MET_clicks_on_music_disc
Data Type: integer

Conversions

API Name: conversion
NinjaCat System ID: tik_tok:MET_conversion
Data Type: integer
Aggregates To: MET_CONVERSIONS

Conversions Count

API Name: nc_conversion_count
NinjaCat System ID: tik_tok:MET_conversion_count
Data Type: integer

Conversions Revenue

API Name: nc_conversion_value
NinjaCat System ID: tik_tok:MET_conversion_value
Data Type: decimal
Display As: currency

Cost Charged by Cash

API Name: cash_spend
NinjaCat System ID: tik_tok:MET_cash_spend
Data Type: decimal
Display As: currency

Cost Charged by Voucher

API Name: voucher_spend
NinjaCat System ID: tik_tok:MET_voucher_spend
Data Type: decimal
Display As: currency

Cost / Conv.

NinjaCat System ID: tik_tok:MET_conversion_rate
Data Type: decimal
Display As: currency
Aggregates To: MET_CPA
Formula: (tik_tok:MET_spend / tik_tok:MET_conversion)

Cost Per Result

NinjaCat System ID: tik_tok:MET_cpr
Data Type: decimal
Display As: currency
Formula: (tik_tok:MET_spend / tik_tok:MET_result)

Count (Unique Dimensions)

NinjaCat System ID: tik_tok:MET_COUNT_NC
Data Type: integer
Aggregates To: MET_COUNT_NC

CPC

NinjaCat System ID: tik_tok:MET_CPC
Data Type: decimal
Display As: currency
Aggregates To: MET_CPC
Formula: tik_tok:MET_spend / tik_tok:MET_clicks

CPM

NinjaCat System ID: tik_tok:MET_CPM
Data Type: decimal
Display As: currency
Aggregates To: MET_CPM
Formula: 1000 * tik_tok:MET_spend / tik_tok:MET_impressions

CTR

NinjaCat System ID: tik_tok:MET_CTR
Data Type: decimal
Display As: percent
Aggregates To: MET_CTR
Formula: (tik_tok:MET_clicks / tik_tok:MET_impressions)

Engaged Views (15 seconds)

API Name: engaged_view_15s
NinjaCat System ID: tik_tok:MET_engaged_view_15s
Data Type: integer

Engaged Views (6 seconds)

API Name: engaged_view
NinjaCat System ID: tik_tok:MET_engaged_view
Data Type: integer

Form Submissions (offline)

API Name: offline_form_events
NinjaCat System ID: tik_tok:MET_offsite_form
Data Type: integer

Form Submissions (onsite)

API Name: onsite_form
NinjaCat System ID: tik_tok:MET_onsite_form
Data Type: integer

Form Submissions Value (offline)

API Name: offline_form_events_value
NinjaCat System ID: tik_tok:MET_total_offsite_form_value
Data Type: decimal
Display As: currency

Form Submissions Value (onsite)

API Name: total_onsite_form_value
NinjaCat System ID: tik_tok:MET_total_onsite_form_value
Data Type: decimal
Display As: currency

Frequency

API Name: frequency
NinjaCat System ID: tik_tok:MET_frequency
Data Type: decimal
Display As: float
Aggregates To: MET_FREQUENCY

Impressions

API Name: impressions
NinjaCat System ID: tik_tok:MET_impressions
Data Type: integer
Aggregates To: MET_IMPRESSIONS

No. of Related Ad Groups

API Name: associated_adgroup_count
NinjaCat System ID: tik_tok:MET_associated_adgroup_count
Data Type: integer

Paid Comments

API Name: comments
NinjaCat System ID: tik_tok:MET_comments
Data Type: integer

Paid Followers

API Name: follows
NinjaCat System ID: tik_tok:MET_follows
Data Type: integer

Paid Likes

API Name: likes
NinjaCat System ID: tik_tok:MET_likes
Data Type: integer
Aggregates To: MET_LIKES

Paid Shares

API Name: shares
NinjaCat System ID: tik_tok:MET_shares
Data Type: integer

Playable CTA button clicks

API Name: playable_cta_click
NinjaCat System ID: tik_tok:MET_playable_cta_click
Data Type: integer

Playable page views

API Name: playable_page_view_count
NinjaCat System ID: tik_tok:MET_playable_page_view_count
Data Type: integer

Playable views: first scene

API Name: playable_first_scene_view_count
NinjaCat System ID: tik_tok:MET_playable_first_scene_view_count
Data Type: integer

Playable views: second scene

API Name: playable_second_scene_view_count
NinjaCat System ID: tik_tok:MET_playable_second_scene_view_count
Data Type: integer

Playable views: third scene

API Name: playable_third_scene_view_count
NinjaCat System ID: tik_tok:MET_playable_third_scene_view_count
Data Type: integer

Profile Visit

API Name: profile_visits
NinjaCat System ID: tik_tok:MET_profile_visits
Data Type: integer

Profile Visit Rate

NinjaCat System ID: tik_tok:MET_profile_visit_rate
Data Type: decimal
Display As: percent
Formula: (tik_tok:MET_profile_visits / tik_tok:MET_impressions)

Reach

API Name: reach
NinjaCat System ID: tik_tok:MET_reach
Data Type: integer
Is Unique: True
Aggregates To: MET_REACH

Real-Time Conversions

API Name: real_time_conversion
NinjaCat System ID: tik_tok:MET_real_time_conversion
Data Type: integer

Real-time Cost Per Result

NinjaCat System ID: tik_tok:MET_real_time_cpr
Data Type: decimal
Display As: currency
Formula: (tik_tok:MET_spend / tik_tok:MET_real_time_result)

Real-time CPA

NinjaCat System ID: tik_tok:MET_real_time_cpa
Data Type: decimal
Display As: currency
Formula: (tik_tok:MET_spend / tik_tok:MET_real_time_conversion)

Real-Time CVR

NinjaCat System ID: tik_tok:MET_real_time_cpc
Data Type: decimal
Display As: percent
Formula: (tik_tok:MET_clicks / tik_tok:MET_real_time_conversion)

Real-Time Result

API Name: real_time_result
NinjaCat System ID: tik_tok:MET_real_time_result
Data Type: integer

Result

API Name: result
NinjaCat System ID: tik_tok:MET_result
Data Type: integer

Result rate

NinjaCat System ID: tik_tok:MET_result_rate
Data Type: decimal
Display As: percent
Formula: (tik_tok:MET_result / tik_tok:MET_impressions)

Secondary Goal Result

API Name: secondary_goal_result
NinjaCat System ID: tik_tok:MET_secondary_goal_result
Data Type: integer

Total Add Billing

API Name: add_billing
NinjaCat System ID: tik_tok:MET_add_billing
Data Type: integer

Total Add Billing Value

API Name: total_add_billing_value
NinjaCat System ID: tik_tok:MET_total_add_billing_value
Data Type: decimal
Display As: currency

Total Add-To-Cart

API Name: web_event_add_to_cart
NinjaCat System ID: tik_tok:MET_web_event_add_to_cart
Data Type: integer

Total Add-To-Cart Value

API Name: total_web_event_add_to_cart_value
NinjaCat System ID: tik_tok:MET_total_web_event_add_to_cart_value
Data Type: decimal
Display As: currency

Total Add to Wishlist

API Name: on_web_add_to_wishlist
NinjaCat System ID: tik_tok:MET_on_web_add_to_wishlist
Data Type: integer

Total Add To Wishlist Value

API Name: total_on_web_add_to_wishlist_value
NinjaCat System ID: tik_tok:MET_total_on_web_add_to_wishlist_value
Data Type: decimal
Display As: currency

Total Button Click

API Name: button_click
NinjaCat System ID: tik_tok:MET_button_click
Data Type: integer

Total Button Click Value

API Name: total_button_click_value
NinjaCat System ID: tik_tok:MET_total_button_click_value
Data Type: decimal
Display As: currency

Total Complete Payment

API Name: complete_payment
NinjaCat System ID: tik_tok:MET_complete_payment
Data Type: integer

Total Complete Payment Value

API Name: total_complete_payment_rate
NinjaCat System ID: tik_tok:MET_total_complete_payment_rate
Data Type: decimal
Display As: currency

Total Complete Registration

API Name: user_registration
NinjaCat System ID: tik_tok:MET_user_registration
Data Type: integer

Total Complete Registration Value

API Name: total_user_registration_value
NinjaCat System ID: tik_tok:MET_total_user_registration_value
Data Type: decimal
Display As: currency

Total Contact

API Name: online_consult
NinjaCat System ID: tik_tok:MET_online_consult
Data Type: integer

Total Contact Value

API Name: total_online_consult_value
NinjaCat System ID: tik_tok:MET_total_online_consult_value
Data Type: decimal
Display As: currency

Total Cost

API Name: spend
NinjaCat System ID: tik_tok:MET_spend
Data Type: decimal
Display As: currency
Aggregates To: MET_COST

Total Custom Page Event

API Name: custom_page_events
NinjaCat System ID: tik_tok:MET_custom_page_events
Data Type: integer

Total Download

API Name: download_start
NinjaCat System ID: tik_tok:MET_download_start
Data Type: integer

Total Download Value

API Name: total_download_start_value
NinjaCat System ID: tik_tok:MET_total_download_start_value
Data Type: decimal
Display As: currency

Total Initiate Checkout

API Name: initiate_checkout
NinjaCat System ID: tik_tok:MET_initiate_checkout
Data Type: integer

Total Initiate Checkout Value

API Name: total_initiate_checkout_value
NinjaCat System ID: tik_tok:MET_total_initiate_checkout_value
Data Type: decimal
Display As: currency

Total Landing Page View

API Name: total_landing_page_view
NinjaCat System ID: tik_tok:MET_total_landing_page_view
Data Type: integer

Total Page Browse

Deprecated: 2024-11-07T01:28:37.866Z
API Name: page_browse_view
NinjaCat System ID: tik_tok:MET_page_browse_view
Data Type: integer

Total Page Browse Value

Deprecated: 2024-11-07T01:28:37.866Z
API Name: value_per_page_browse_view
NinjaCat System ID: tik_tok:MET_value_per_page_browse_view
Data Type: decimal
Display As: currency

Total Page View

API Name: total_pageview
NinjaCat System ID: tik_tok:MET_total_pageview
Data Type: decimal
Display As: currency

Total Page View Value

API Name: total_value_per_pageview
NinjaCat System ID: tik_tok:MET_total_value_per_pageview
Data Type: decimal
Display As: currency

Total Place an Order

API Name: on_web_order
NinjaCat System ID: tik_tok:MET_on_web_order
Data Type: integer

Total Place an Order Value

API Name: total_on_web_order_value
NinjaCat System ID: tik_tok:MET_total_on_web_order_value
Data Type: decimal
Display As: currency

Total Product Details Page Browse

API Name: product_details_page_browse
NinjaCat System ID: tik_tok:MET_product_details_page_browse
Data Type: integer

Total Product Details Page Browse Value

API Name: total_product_details_page_browse_value
NinjaCat System ID: tik_tok:MET_total_product_details_page_browse_value
Data Type: decimal
Display As: currency

Total Search

API Name: page_event_search
NinjaCat System ID: tik_tok:MET_page_event_search
Data Type: integer

Total Search Value

API Name: total_page_event_search_value
NinjaCat System ID: tik_tok:MET_total_page_event_search_value
Data Type: decimal
Display As: currency

Total Submit Form

API Name: form
NinjaCat System ID: tik_tok:MET_form
Data Type: integer

Total Submit Form Value

API Name: total_form_value
NinjaCat System ID: tik_tok:MET_total_form_value
Data Type: decimal
Display As: currency

Total Subscribe

API Name: on_web_subscribe
NinjaCat System ID: tik_tok:MET_on_web_subscribe
Data Type: integer

Total Subscribe Value

API Name: total_on_web_subscribe_value
NinjaCat System ID: tik_tok:MET_total_on_web_subscribe_value
Data Type: decimal
Display As: currency

Total Video Length

NinjaCat System ID: tik_tok:MET_total_video_length
Data Type: integer
Formula: (tik_tok:MET_video_play_actions * tik_tok:MET_average_video_play)

Total View Content

API Name: page_content_view_events
NinjaCat System ID: tik_tok:MET_page_content_view_events
Data Type: integer

Total View Content Value

API Name: total_page_view_content_events_value
NinjaCat System ID: tik_tok:MET_total_page_view_content_events_value
Data Type: decimal
Display As: currency

Video Views

API Name: video_play_actions
NinjaCat System ID: tik_tok:MET_video_play_actions
Data Type: integer
Aggregates To: MET_VIEWS,MET_VIDEO_VIEWS

Video Views - 2 Seconds

API Name: video_watched_2s
NinjaCat System ID: tik_tok:MET_video_watched_2s
Data Type: integer

Video Views - 6 Seconds

API Name: video_watched_6s
NinjaCat System ID: tik_tok:MET_video_watched_6s
Data Type: integer

Video Views at 100%

API Name: video_views_p100
NinjaCat System ID: tik_tok:MET_video_views_p100
Data Type: integer

Video Views at 25%

API Name: video_views_p25
NinjaCat System ID: tik_tok:MET_video_views_p25
Data Type: integer

Video Views at 50%

API Name: video_views_p50
NinjaCat System ID: tik_tok:MET_video_views_p50
Data Type: integer

Video Views at 75%

API Name: video_views_p75
NinjaCat System ID: tik_tok:MET_video_views_p75
Data Type: integer

Updated 4 months ago