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

    CONNECTIONS / Clickhouse / ClickHouse to TikTok Custom Audience

    From ClickHouse tables to TikTok audience targeting.

    Signals reads your ClickHouse tables through a read-only database user scoped to the ClickHouse tables you name, then delivers first-party segments to TikTok as match-ready custom audiences so TikTok sees match-ready audiences without an export.

    Talk to our team Explore the setup

    clickhouse -> tiktok-custom-audience :: live

    1. ● clickhouse → tiktok.audience :: live
    2. > read segments rows=56,495
    3. hash sha256(email,phone) consent=filtered
    4. route tiktok deliver
    5. ✓ delivered · 47,456 matched

    WHAT THIS ENABLES

    ClickHouse to TikTok Custom Audience

    TikTok Custom Audience for ClickHouse: Signals delivers first-party segments to TikTok as match-ready custom audiences straight from your ClickHouse tables, hashed and consent-screened each time the read runs.

    • Signals delivers first-party segments to TikTok as match-ready custom audiences, reading your ClickHouse tables each time the read runs.
    • Targeting that mirrors your live segment, with no export step out of your ClickHouse tables.

    WHAT FLOWS WHERE

    Clickhouse to Custom Audience, mapped.

    Each sync hands the customer segments from your ClickHouse tables to Signals, which hashes and filters every record, then TikTok's Custom Audience API logs the match-ready audiences for match quality on TikTok.

    Each sync hands the customer segments from your ClickHouse tables to Signals, which hashes and filters every record, then 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, working out of ClickHouse tables and materialized views.

    Analytics engineers on ClickHouse who need TikTok custom audiences mirroring the segment your data team publishes out of ClickHouse tables.

    HOW DATAHASH SETS IT UP

    From kickoff to verified events.

    1. Connect

      A read-only database user scoped to the ClickHouse tables you name, mapped to TikTok's Custom Audience API and tuned for match quality on TikTok.

    2. Map

      Columns from your ClickHouse tables align to TikTok's Custom Audience API in the visual mapper, hashed as the read runs and checked for match quality on TikTok.

    3. Deliver

      Each time the read runs, Signals reads your ClickHouse tables and delivers first-party segments to TikTok as match-ready custom audiences, reads only the records changed since the last run, 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 from your ClickHouse tables, delivered each time the read runs.

    Targeting that mirrors your live segment out of your ClickHouse tables, delivered each time the read runs without read load on the database climbing.

    Match feedback on match quality on TikTok from TikTok's Custom Audience API each run, tied back to your ClickHouse tables.

    ON THE WIRE

    What Custom Audience actually receives.

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

    1. ● signals :: audience upload
    2. > POST /dmp/custom_audience source=clickhouse.segments
    3. id_schema ["EMAIL_SHA256","PHONE_SHA256"]
    4. action "add" · audience_id "aud_74697"
    5. id_list_size 56,495 · matched 47,456
    6. ✓ accepted match=84%
    RELATED USE CASES

    Adjacent moves on the same stack.

    from Clickhouse

    ClickHouse to Meta Custom Audience

    Meta Custom Audience for ClickHouse: Signals keeps Meta audiences synced as adds and…

    Learn more

    from Clickhouse

    ClickHouse to Google Customer Match

    Google Customer Match for ClickHouse: Signals projects your segments into Google Ads as…

    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 ClickHouse TikTok Custom Audience sync run?

    The pace follows your ClickHouse tables: Signals sends changes from ClickHouse to TikTok each time the read runs. Because it reads only the records changed since the last run, TikTok custom audiences mirroring the segment your data team publishes stays current while analytics engineers on ClickHouse keep match quality on TikTok in view. Delivery needs no export and no manual upload.

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

    In ClickHouse, match rate tracks the email and phone quality your ClickHouse tables carry. Clean identifiers land for TikTok; blank ones never will. The first Custom Audience API report shows analytics engineers on ClickHouse where match quality on TikTok needs work, a data-quality task handled in ClickHouse.

    NEXT STEP

    ClickHouse to TikTok Custom Audience, in production this week.

    Talk to our team All Clickhouse use cases