Lucen syncs your TikTok Ads data (Advertising) to your warehouse and models it into the tables below. You connect TikTok Ads with one OAuth sign-in. By default your data refreshes every day at 07:00 Buenos Aires time (UTC-3). Your plan sets how many times a day it can sync, and you can choose the times, see pricing .
Your plan sets how much history the first sync loads, see pricing .
# Send TikTok Ads data to# Tables
Grain none. Native daily reach / frequency
Grain campaign + ad group + ad
Grain ad + event type. No spend # ColumnsColumn names match your warehouse exactly. Descriptions come from dbt.
17 23 42 ID Name Type Description account_id Account id STRING TikTok advertiser ID. Use with client_id to scope joins and reporting. client_id Client id STRING Lucen organization slug. Include in every join to preserve tenant isolation. currency Currency STRING Advertiser currency code; monetary metrics are not currency-converted. timezone_name Timezone name STRING Advertiser timezone used to define report dates and snapshot dates. date Date DATE Reporting day in the advertiser timezone, using standard TikTok attribution reporting. age Age STRING Native audience-report age category; independent of gender and other breakdowns. spend Spend FLOAT64 Ad spend in advertiser currency. Sum within one fact and currency. impressions Impressions FLOAT64 Number of ad impressions; repeat exposure is included. destination_clicks Destination clicks FLOAT64 Clicks to the ad destination (TikTok clicks); excludes other engagement clicks. account_name Account name STRING Advertiser name from the retrieved account metadata. data_updated_at Data updated at TIMESTAMP UTC extraction timestamp of the underlying performance row, not the table build time. destination_ctr Destination ctr FLOAT64 Destination clicks / impressions as a decimal fraction; NULL for zero impressions. Recompute from summed components. destination_cpc Destination cpc FLOAT64 Spend / destination clicks in advertiser currency; NULL for zero clicks. Recompute from summed components. cpm Cpm FLOAT64 1,000 * spend / impressions in advertiser currency; NULL for zero impressions. Recompute from summed components.
22 21 ID Name Type Description account_id Account id STRING TikTok advertiser ID. Use with client_id to scope joins and reporting. client_id Client id STRING Lucen organization slug. Include in every join to preserve tenant isolation. currency Currency STRING Advertiser currency code; monetary metrics are not currency-converted. timezone_name Timezone name STRING Advertiser timezone used to define report dates and snapshot dates. date Date DATE Reporting day in the advertiser timezone, using standard TikTok attribution reporting. platform Platform STRING Native audience-report device platform category; not a device model or device_type field. spend Spend FLOAT64 Ad spend in advertiser currency. Sum within one fact and currency. impressions Impressions FLOAT64 Number of ad impressions; repeat exposure is included. destination_clicks Destination clicks FLOAT64 Clicks to the ad destination (TikTok clicks); excludes other engagement clicks. account_name Account name STRING Advertiser name from the retrieved account metadata. data_updated_at Data updated at TIMESTAMP UTC extraction timestamp of the underlying performance row, not the table build time. destination_ctr Destination ctr FLOAT64 Destination clicks / impressions as a decimal fraction; NULL for zero impressions. Recompute from summed components. destination_cpc Destination cpc FLOAT64 Spend / destination clicks in advertiser currency; NULL for zero clicks. Recompute from summed components. cpm Cpm FLOAT64 1,000 * spend / impressions in advertiser currency; NULL for zero impressions. Recompute from summed components.
ID Name Type Description account_id Account id STRING TikTok advertiser ID. Use with client_id to scope joins and reporting. client_id Client id STRING Lucen organization slug. Include in every join to preserve tenant isolation. currency Currency STRING Advertiser currency code; monetary metrics are not currency-converted. timezone_name Timezone name STRING Advertiser timezone used to define report dates and snapshot dates. date Date DATE Reporting day in the advertiser timezone, using standard TikTok attribution reporting. gender Gender STRING Native audience-report gender category; independent of age and other breakdowns. spend Spend FLOAT64 Ad spend in advertiser currency. Sum within one fact and currency. impressions Impressions FLOAT64 Number of ad impressions; repeat exposure is included. destination_clicks Destination clicks FLOAT64 Clicks to the ad destination (TikTok clicks); excludes other engagement clicks. account_name Account name STRING Advertiser name from the retrieved account metadata. data_updated_at Data updated at TIMESTAMP UTC extraction timestamp of the underlying performance row, not the table build time. destination_ctr Destination ctr FLOAT64 Destination clicks / impressions as a decimal fraction; NULL for zero impressions. Recompute from summed components. destination_cpc Destination cpc FLOAT64 Spend / destination clicks in advertiser currency; NULL for zero clicks. Recompute from summed components. cpm Cpm FLOAT64 1,000 * spend / impressions in advertiser currency; NULL for zero impressions. Recompute from summed components.
ID Name Type Description account_id Account id STRING TikTok advertiser ID. Use with client_id to scope joins and reporting. client_id Client id STRING Lucen organization slug. Include in every join to preserve tenant isolation. currency Currency STRING Advertiser currency code; monetary metrics are not currency-converted. timezone_name Timezone name STRING Advertiser timezone used to define report dates and snapshot dates. date Date DATE Reporting day in the advertiser timezone, using standard TikTok attribution reporting. country_code Country code STRING Native audience-report country code. Coverage may differ from account totals. spend Spend FLOAT64 Ad spend in advertiser currency. Sum within one fact and currency. impressions Impressions FLOAT64 Number of ad impressions; repeat exposure is included. destination_clicks Destination clicks FLOAT64 Clicks to the ad destination (TikTok clicks); excludes other engagement clicks. account_name Account name STRING Advertiser name from the retrieved account metadata. data_updated_at Data updated at TIMESTAMP UTC extraction timestamp of the underlying performance row, not the table build time. destination_ctr Destination ctr FLOAT64 Destination clicks / impressions as a decimal fraction; NULL for zero impressions. Recompute from summed components. destination_cpc Destination cpc FLOAT64 Spend / destination clicks in advertiser currency; NULL for zero clicks. Recompute from summed components. cpm Cpm FLOAT64 1,000 * spend / impressions in advertiser currency; NULL for zero impressions. Recompute from summed components.
ID Name Type Description account_id Account id STRING TikTok advertiser ID. Use with client_id to scope joins and reporting. client_id Client id STRING Lucen organization slug. Include in every join to preserve tenant isolation. currency Currency STRING Advertiser currency code; monetary metrics are not currency-converted. timezone_name Timezone name STRING Advertiser timezone used to define report dates and snapshot dates. date Date DATE Reporting day in the advertiser timezone, using standard TikTok attribution reporting. placement Placement STRING Native audience-report placement category; no campaign or ad attribution is published at this grain. spend Spend FLOAT64 Ad spend in advertiser currency. Sum within one fact and currency. impressions Impressions FLOAT64 Number of ad impressions; repeat exposure is included. destination_clicks Destination clicks FLOAT64 Clicks to the ad destination (TikTok clicks); excludes other engagement clicks. account_name Account name STRING Advertiser name from the retrieved account metadata. data_updated_at Data updated at TIMESTAMP UTC extraction timestamp of the underlying performance row, not the table build time. destination_ctr Destination ctr FLOAT64 Destination clicks / impressions as a decimal fraction; NULL for zero impressions. Recompute from summed components. destination_cpc Destination cpc FLOAT64 Spend / destination clicks in advertiser currency; NULL for zero clicks. Recompute from summed components. cpm Cpm FLOAT64 1,000 * spend / impressions in advertiser currency; NULL for zero impressions. Recompute from summed components.
# Typical questionsAccount spend / reach gold_tiktok_ads_account_performance
Campaign ranking gold_tiktok_ads_campaign_performance
Website purchases gold_tiktok_ads_conversion_event_performancefiltered to website_purchase
Starter queries
SELECT date, account_id, currency, timezone_name, spend
FROM `your-project.your_org_gold.gold_tiktok_ads_account_performance`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;SELECT date, account_id, currency, timezone_name, campaign_id
FROM `your-project.your_org_gold.gold_tiktok_ads_campaign_performance`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;SELECT date, account_id, currency, timezone_name, campaign_id
FROM `your-project.your_org_gold.gold_tiktok_ads_ad_group_performance`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;SELECT date, account_id, currency, timezone_name, campaign_id
FROM `your-project.your_org_gold.gold_tiktok_ads_ad_performance`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;Integration page