Platform
ActiveCampaign
Adalyser
Adform
Adjust
AdRoll
AdsWizz
Adtraction Advertising
Airbnb Review
Airtable
Amazon Ads
Amazon DSP
Amazon Seller
Amazon Vendor Central
Amplitude
Apple Search Ads
AppsFlyer
App Store Connect
App Store Review
Awin
Bigcommerce
Bing Webmaster Tool
Bluesky
Booking Review
Branch
Braze
Brevo (ex SendInBlue)
CallRail
Capterra Review
ChartMogul
ChatGPT Ads
GEO
Comment Sold
Criteo
Facebook Ads (Meta Ads)
Facebook (Meta) Pages
Facebook Public Data
Facebook Review
Firebase Realtime Database
G2 Review
Glassdoor Review
Google Ad Manager
Google Ads
Google Analytics
Google Display & Video 360
Google Merchant Center
Google My Business
Google Page Speed
Google Play Review
Google Play Store
Google Search Console
Google Sheets
Hawk DSP
HubSpot
Impact
Indeed Review
Instagram
Instagram Public Data
JSON / CSV / XML
Klaviyo
Line Ads
LinkedIn Ads
LinkedIn Page
Magento
Mailchimp
MailerLite
Matomo
Microsoft (Bing) Ads
Mixpanel
Outbrain DSP
Outbrain
Pardot
Piano Analytics
Pinterest Ads
Pinterest Organic
Pipedrive
Piwik
PostHog
Prestashop
Profitwell
QuickBooks
Reddit Ads
RevenueCat
Shopify
Snapchat Ads
Spotify Ads
StackAdapt
Stripe
Taboola
Teads
The Trade Desk
TikTok Ads
TikTok GMV
TikTok Organic
TikTok Shop
Tripadvisor Review
Trustpilot Review
X / Twitter Ads
Vistar Media
WooCommerce
Xandr
Get Started

Introduction

Datasources and destinations

Fields listing for TikTok Shop

EXPLORE YOUR DATA

Metrics & dimensions

Find the fields you need for your next report.

19 metrics90 dimensions

109 fields

All fields
FieldDetails
Auto Combine Group ID
Identifier to combine orders from the same customer during LIVE.
Field IDorder/auto_combine_group_id
DimensionTEXT
Buyer Email
Anonymized buyer email.
Field IDorder/buyer_email
DimensionTEXT
Buyer Message
The note from the buyer.
Field IDorder/buyer_message
DimensionTEXT
Buyer Requested Cancel
Whether the buyer has a pending cancellation request.
Field IDorder/is_buyer_request_cancel
DimensionBOOLEAN
Buyer User ID
Buyer user ID.
Field IDorder/user_id
DimensionTEXT
Cancel Order SLA Time
Automatic cancellation time set by the platform. Unix timestamp.
Field IDorder/cancel_order_sla_time
DimensionYEAR_MONTH_DAY
Cancel Reason
Cancellation reason.
Field IDorder/cancel_reason
DimensionTEXT
Cancel Time
Time status updated to CANCELLED. Unix timestamp.
Field IDorder/cancel_time
DimensionYEAR_MONTH_DAY
Cancellation Initiator
Cancellation request initiator. Available values: SELLER, BUYER, SYSTEM.
Field IDorder/cancellation_initiator
DimensionTEXT
Collection Due Time
Auto-cancel if not IN_TRANSIT by this time. Unix timestamp.
Field IDorder/collection_due_time
DimensionYEAR_MONTH_DAY
Collection Time
Time status updated to IN_TRANSIT. Unix timestamp.
Field IDorder/collection_time
DimensionYEAR_MONTH_DAY
Commerce Platform
Platform where the order was placed (e.g., TIKTOK_SHOP, TOKOPEDIA).
Field IDorder/commerce_platform
DimensionTEXT
Consultation ID
ID for corresponding ePharmacy consultation, if initiated.
Field IDorder/consultation_id
DimensionTEXT
CPF
Invoice number used to issue an invoice (BR only).
Field IDorder/cpf
DimensionTEXT
CPF Name
Name belonging to the CPF number (BR market).
Field IDorder/cpf_name
DimensionTEXT
Create Time
The date and time that the order was created. Unix timestamp.
Field IDorder/create_time
DimensionYEAR_MONTH_DAY
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
DimensionYEAR_MONTH_DAY
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
DimensionDAY
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
DimensionDAY_OF_WEEK
Delivery Due Time
Auto-cancel if not DELIVERED by this time. Unix timestamp.
Field IDorder/delivery_due_time
DimensionYEAR_MONTH_DAY
Delivery Option ID
Mapped to seller logistics template ID.
Field IDorder/delivery_option_id
DimensionTEXT
Delivery Option Name
Delivery option name for display.
Field IDorder/delivery_option_name
DimensionTEXT
Delivery Prefs Drop-off Location
Drop-off location selected by the recipient (US only).
Field IDorder/recipient_address_delivery_preferences_drop_off_location
DimensionTEXT
Delivery SLA Time
Order should arrive by this date to be on-time. Unix timestamp.
Field IDorder/delivery_sla_time
DimensionYEAR_MONTH_DAY
Delivery Time
Time status changed to DELIVERED. Unix timestamp.
Field IDorder/delivery_time
DimensionYEAR_MONTH_DAY
Delivery Type
Indicates PUDO vs home delivery.
Field IDorder/delivery_type
DimensionTEXT
Exchange Source Order ID
Original order ID for the exchange order (US/UK).
Field IDorder/exchange_source_order_id
DimensionTEXT
Fast Delivery Program
Badge indicating fast delivery program (e.g., 3_DAY_DELIVERY). US only.
Field IDorder/fast_delivery_program
DimensionTEXT
Fast Dispatch SLA Time
Latest collection time to gain NDD incentives (TH, PH). Unix timestamp.
Field IDorder/fast_dispatch_sla_time
DimensionYEAR_MONTH_DAY
Fulfillment Priority Level
Priority value to prioritize shipping (SEA).
Field IDorder/fulfillment_priority_level
DimensionNUMBER
Fulfillment Type
Fulfillment type for the order.
Field IDorder/fulfillment_type
DimensionTEXT
Handling Duration Days
Number of days for handling (MADE_TO_ORDER/BACK_ORDER).
Field IDorder/handling_duration_days
DimensionTEXT
Handling Duration Type
CALENDAR_DAY or BUSINESS_DAY. Default BUSINESS_DAY.
Field IDorder/handling_duration_type
DimensionTEXT
Has Updated Recipient Address
Whether the recipient address has been updated.
Field IDorder/has_updated_recipient_address
DimensionBOOLEAN
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
DimensionHOUR
Is COD
Whether the order is Cash on Delivery.
Field IDorder/is_cod
DimensionBOOLEAN
Is Exchange Order
TRUE if this is an exchange order (US/UK).
Field IDorder/is_exchange_order
DimensionBOOLEAN
Is On-Hold Order
Whether the order is or will be ON_HOLD.
Field IDorder/is_on_hold_order
DimensionBOOLEAN
Is Replacement Order
Whether this is a replacement order.
Field IDorder/is_replacement_order
DimensionBOOLEAN
Is Sample Order
Whether the order is a sample order.
Field IDorder/is_sample_order
DimensionBOOLEAN
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
DimensionMONTH_DAY
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
DimensionMONTH
Need Upload Invoice
Whether an invoice needs to be uploaded and status (BR only).
Field IDorder/need_upload_invoice
DimensionTEXT
Order ID
TikTok Shop order ID.
Field IDorder/id
DimensionTEXT
Order Type
Order type (e.g., ZERO_LOTTERY, PRE_ORDER, MADE_TO_ORDER, BACK_ORDER).
Field IDorder/order_type
DimensionTEXT
Paid Time
The date and time that the order was paid. Unix timestamp.
Field IDorder/paid_time
DimensionYEAR_MONTH_DAY
Payment Buyer Service Fee
Service fee applied from the fifth order onwards. Indonesia only.
Field IDorder/payment_buyer_service_fee
MetricNUMBER
Payment Currency
Currency for payment.
Field IDorder/payment_currency
DimensionTEXT
Payment Handling Fee
Fee to cover additional processing/handling costs. Indonesia only.
Field IDorder/payment_handling_fee
MetricNUMBER
Payment Item Insurance Fee
Post-purchase product insurance cost. US and Indonesia.
Field IDorder/payment_item_insurance_fee
MetricNUMBER
Payment Method Name
Payment method name for display.
Field IDorder/payment_method_name
DimensionTEXT
Payment Original Shipping Fee
Shipping fee before discount.
Field IDorder/payment_original_shipping_fee
MetricNUMBER
Payment Original Total Product Price
Total original price of the products (VAT included for cross-border shops). US: pre-tax.
Field IDorder/payment_original_total_product_price
MetricNUMBER
Payment Platform Discount
Product discount by platform.
Field IDorder/payment_platform_discount
MetricNUMBER
Payment Product Tax
The tax on the total item price.
Field IDorder/payment_product_tax
MetricNUMBER
Payment Retail Delivery Fee
Retail delivery fee (RDF). US only.
Field IDorder/payment_retail_delivery_fee
MetricNUMBER
Payment Seller Discount
Product discount by seller.
Field IDorder/payment_seller_discount
MetricNUMBER
Payment Shipping Fee
Buyer paid shipping fee. For the US market, pre-tax total amount.
Field IDorder/payment_shipping_fee
MetricNUMBER
Payment Shipping Fee Cofunded Discount
Seller shipping fee discount eligible for co-funded reimbursement.
Field IDorder/payment_shipping_fee_cofunded_discount
MetricNUMBER
Payment Shipping Fee Platform Discount
Shipping fee discount provided by platform.
Field IDorder/payment_shipping_fee_platform_discount
MetricNUMBER
Payment Shipping Fee Seller Discount
Shipping fee discount provided by seller not co-funded.
Field IDorder/payment_shipping_fee_seller_discount
MetricNUMBER
Payment Shipping Fee Tax
The tax on the shipping price.
Field IDorder/payment_shipping_fee_tax
MetricNUMBER
Payment Shipping Insurance Fee
Insurance cost against loss or damage during transit. Indonesia only.
Field IDorder/payment_shipping_insurance_fee
MetricNUMBER
Payment Small Order Fee
Small order fee (TH market only).
Field IDorder/payment_small_order_fee
MetricNUMBER
Payment Sub Total
Buyer paid sub-total of all the SKUs in the order. For the US market, pre-tax total amount.
Field IDorder/payment_sub_total
MetricNUMBER
Payment Tax
Buyer paid total taxes for the order.
Field IDorder/payment_tax
MetricNUMBER
Payment Total Amount
Buyer paid total payment.
Field IDorder/payment_total_amount
MetricNUMBER
Pick-up Cut-off Time
Latest pick-up time to avoid LDR (SEA regions). Unix timestamp.
Field IDorder/pick_up_cut_off_time
DimensionYEAR_MONTH_DAY
Post Town
Post town of the address (UK only).
Field IDorder/recipient_address_post_town
DimensionTEXT
Postal Code
Postal/ZIP code for shipping.
Field IDorder/recipient_address_postal_code
DimensionTEXT
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
DimensionQUARTER
Recipient Address Detail
Full recipient detailed address.
Field IDorder/recipient_address_address_detail
DimensionTEXT
Recipient Address Line 1
The first line of the street address.
Field IDorder/recipient_address_address_line1
DimensionTEXT
Recipient Address Line 2
The second line of the street address.
Field IDorder/recipient_address_address_line2
DimensionTEXT
Recipient Address Line 3
The third line of the street address (usually BR).
Field IDorder/recipient_address_address_line3
DimensionTEXT
Recipient Address Line 4
The fourth line of the street address (usually BR).
Field IDorder/recipient_address_address_line4
DimensionTEXT
Recipient First Name
Recipient first name (US, UK, JP only).
Field IDorder/recipient_address_first_name
DimensionTEXT
Recipient First Name (Local Script)
Recipient first name in katakana (JP only).
Field IDorder/recipient_address_first_name_local_script
DimensionTEXT
Recipient Full Address
Complete recipient address information.
Field IDorder/recipient_address_full_address
DimensionTEXT
Recipient Last Name
Recipient last name (US, UK, JP only).
Field IDorder/recipient_address_last_name
DimensionTEXT
Recipient Last Name (Local Script)
Recipient last name in katakana (JP only).
Field IDorder/recipient_address_last_name_local_script
DimensionTEXT
Recipient Name
Recipient name (may be desensitized with platform logistics).
Field IDorder/recipient_address_name
DimensionTEXT
Recipient Phone Number
Recipient telephone number (may be desensitized with platform logistics).
Field IDorder/recipient_address_phone_number
DimensionTEXT
Recommended Shipping Time
Recommended time to ship based on LSP service type (SEA). Unix timestamp.
Field IDorder/recommended_shipping_time
DimensionYEAR_MONTH_DAY
Region Code
Region code.
Field IDorder/recipient_address_region_code
DimensionTEXT
Release Date
Date handling starts (PRE_ORDER). Unix timestamp.
Field IDorder/release_date
DimensionYEAR_MONTH_DAY
Replaced Order ID
Order ID that is being replaced (if applicable).
Field IDorder/replaced_order_id
DimensionTEXT
Request Cancel Time
Buyer request cancellation time. Unix timestamp.
Field IDorder/request_cancel_time
DimensionYEAR_MONTH_DAY
Required Delivery Time
Order should be delivered before this time. Unix timestamp.
Field IDorder/delivery_option_required_delivery_time
DimensionYEAR_MONTH_DAY
RTS SLA Time
Latest shipping time specified by the platform. Unix timestamp.
Field IDorder/rts_sla_time
DimensionYEAR_MONTH_DAY
RTS Time
Time seller shipped the order. Unix timestamp.
Field IDorder/rts_time
DimensionYEAR_MONTH_DAY
Seller Note
Seller note from Seller Center.
Field IDorder/seller_note
DimensionTEXT
Shipping Due Time
Auto-cancel if not AWAITING_COLLECTION by this time. Unix timestamp.
Field IDorder/shipping_due_time
DimensionYEAR_MONTH_DAY
Shipping Provider
The name of the current shipping provider.
Field IDorder/shipping_provider
DimensionTEXT
Shipping Provider ID
The ID of the current shipping provider.
Field IDorder/shipping_provider_id
DimensionTEXT
Shipping Type
Delivery method: TIKTOK or SELLER.
Field IDorder/shipping_type
DimensionTEXT
Split/Combine Tag
Indicates whether the order is combined or split.
Field IDorder/split_or_combine_tag
DimensionTEXT
Status
Specific order status.
Field IDorder/status
DimensionTEXT
Tracking Number
Tracking number. Available after shipment.
Field IDorder/tracking_number
DimensionTEXT
TTS SLA Time
Latest collection time specified by the platform. Unix timestamp.
Field IDorder/tts_sla_time
DimensionYEAR_MONTH_DAY
Update Time
Time of order status change. Unix timestamp.
Field IDorder/update_time
DimensionYEAR_MONTH_DAY
Warehouse ID
Seller warehouse ID.
Field IDorder/warehouse_id
DimensionTEXT
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
DimensionWEEK
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
DimensionWEEK
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
DimensionYEAR
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
DimensionYEAR_MONTH
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
DimensionYEAR_MONTH_DAY_HOUR
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
DimensionYEAR_QUARTER
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
DimensionYEAR_WEEK

Explore destinations for your data

AI

Claude

Ask Claude about your Marketing data.
View connector
AI

ChatGPT

Ask ChatGPT about your Marketing data.
View connector
Spreadsheet

Excel

Easily track, report, and analyze your marketing KPIs in Excel.‍
View connector
Data lake

Azure Blob Storage

Quickly export your marketing data to Azure Blob Storage for secure storage and analysis, streamlining workflows and enhancing insights.
View connector
Data lake

Google Cloud Storage

Effortlessly export marketing data to Google Cloud Storage for secure, scalable storage and streamlined insights.
View connector
Data lake

Amazon S3

Unlock effortless data storage and management for your marketing team with seamless transfers to Amazon S3, simplifying workflows and accelerating insights.
View connector
Data warehousing

Snowflake

Effortlessly integrates your data in Snowflake, providing a seamless solution for storage, analysis, and real-time insights.
View connector
Data warehousing

Amazon Redshift

Access advanced analytics and insights by effortlessly connecting your marketing data to Amazon Redshift.
View connector
Data warehousing

Azure SQL

Effortlessly connect your marketing data to Azure SQL for immediate access to valuable insights.
View connector
Data warehousing

PostgreSQL

Effortlessly send data from multiple Marketing platforms to your PostgreSQL database with Catchr for seamless integration, storage, and management.
View connector
Data warehousing

MySQL

Seamlessly integrate your marketing data with MySQL to access valuable analytics and insights.
View connector
Visualization

Tableau

Empower your marketing teams with seamless data transfer to Tableau.
View connector
Visualization

Power BI

Whether it's social media analytics, email marketing results, or PPC campaign data, Catchr bridges the gap. Export your data to Power BI.
View connector
Data warehousing

Big Query

Unlock advanced analytics and insights by easily connecting your marketing data to BigQuery.
View connector
Visualization

Data Studio (formerly Looker Studio)

Catchr makes it super easy to visualize your marketing data into Data Studio (formerly Looker Studio).
View connector
Spreadsheet

Google Sheets

Effortlessly report, monitor, and analyze your marketing KPIs in Google Sheets.
View connector
Introduction
Fields list
Destinations