Jump to a popular page, or start typing.
    Talk to our team

    CONNECTIONS / BigQuery / BigQuery to TikTok Custom Audience

    From BigQuery datasets to TikTok audience targeting.

    Point Signals at the dataset behind a read-only service account, and it delivers first-party segments to TikTok as match-ready custom audiences on the cadence your scheduled query already keeps.

    Talk to our team Explore the setup

    bigquery -> tiktok-custom-audience :: live

    1. ● bigquery → tiktok.audience :: live
    2. > read audiences.segment_members rows=12,362
    3. hash sha256(email,phone) consent=filtered
    4. route tiktok deliver
    5. ✓ delivered · 10,384 matched

    WHAT THIS ENABLES

    BigQuery to TikTok Custom Audience

    BigQuery to TikTok Custom Audience: A scheduled query reads the customer segments in your BigQuery tables, and Signals delivers first-party segments to TikTok as match-ready custom audiences, hashed and consent-checked whenever the scheduled query reruns.

    • Signals delivers first-party segments to TikTok as match-ready custom audiences, reading your BigQuery tables whenever the scheduled query reruns.
    • TikTok custom audiences mirroring the segment your data team publishes, fed by analytics engineers running BigQuery scheduled queries.

    WHAT FLOWS WHERE

    BigQuery to Custom Audience, mapped.

    A scheduled query hands the customer segments to Signals, which hashes and consent-filters each row before TikTok's Custom Audience API logs the match-ready audiences for match quality on TikTok.

    A scheduled query hands the customer segments to Signals, which hashes and consent-filters each row before TikTok's Custom Audience API logs the match-ready audiences for match quality on TikTok.

    WHO THIS IS FOR

    Built for the teams that own the number.

    TikTok advertisers seeding lookalikes and suppressing existing customers, with the numbers already modeled in BigQuery tables and GA4 exports.

    Analytics engineers running BigQuery scheduled queries who need TikTok custom audiences mirroring the segment your data team publishes.

    HOW DATAHASH SETS IT UP

    From kickoff to verified events.

    1. Connect

      A read-only service account with dataViewer on the one dataset you nominate to feed TikTok's Custom Audience API, sized for match quality on TikTok.

    2. Map

      A scheduled query reads your BigQuery tables, and its columns map to TikTok's Custom Audience API in the visual mapper, hashed and checked for match quality on TikTok.

    3. Deliver

      Whenever the scheduled query reruns, Signals delivers first-party segments to TikTok as match-ready custom audiences, scans only the rows the query changed, with match quality on TikTok watched in the debugger.

    WHAT YOU GET

    What ships with this use case.

    TikTok custom audiences mirroring the segment your data team publishes on every run, since Signals scans only the rows the query changed.

    Targeting that mirrors your live segment, delivered whenever the scheduled query reruns without BigQuery slot cost climbing.

    Each run returns a match report on match quality on TikTok from TikTok's Custom Audience API, read from your BigQuery tables whenever the scheduled query reruns, at flat BigQuery slot cost.

    ON THE WIRE

    What Custom Audience actually receives.

    signals :: bigquery.tiktok-custom-audience :: wire

    1. ● signals :: audience upload
    2. > POST /dmp/custom_audience source=bigquery.audiences.segment_members
    3. id_schema ["EMAIL_SHA256","PHONE_SHA256"]
    4. action "add" · audience_id "aud_71599"
    5. id_list_size 12,362 · matched 10,384
    6. ✓ accepted match=84%
    RELATED USE CASES

    Adjacent moves on the same stack.

    from BigQuery

    BigQuery to Meta Custom Audience

    BigQuery to Meta Custom Audience: A scheduled query reads the customer segments in your…

    Learn more

    from BigQuery

    BigQuery to Google Customer Match

    BigQuery to Google Customer Match: A scheduled query reads the customer segments in your…

    Learn more

    same use case

    ActiveCampaign to TikTok Custom Audience

    ActiveCampaign to TikTok Custom Audience: Signals reads your ActiveCampaign contacts and…

    Learn more

    generic

    TikTok Custom Audience

    Datahash syncs hashed customer audiences from your CRM, warehouse, or files to TikTok for…

    Learn more
    FAQ

    Asked on almost every call.

    How often does the BigQuery TikTok Custom Audience sync run?

    The scheduled query sets the pace: rebuild the customer segments nightly and delivery to TikTok is nightly, or refresh hourly for an hourly feed. Each run only reads the rows the query changed, so TikTok custom audiences mirroring the segment your data team publishes stays current for match quality on TikTok while BigQuery slot cost barely moves.

    What match rate should a BigQuery-sourced TikTok Custom Audience batch expect?

    Coverage in your BigQuery tables decides the rate, not BigQuery. A row with a current hashed email or phone matches; one missing both cannot, however the query is tuned. The first run's report from TikTok's Custom Audience API sets a baseline, the number TikTok advertisers seeding lookalikes and suppressing existing customers weigh against match quality on TikTok.

    NEXT STEP

    BigQuery to TikTok Custom Audience, in production this week.

    Talk to our team All BigQuery use cases