Jump to a popular page, or start typing.

    CONNECTIONS / Cockroach / Cockroach to TikTok Custom Audience

    From Cockroach tables to TikTok audience targeting.

    Connect Cockroach and point Signals at your Cockroach tables; it delivers first-party segments to TikTok as match-ready custom audiences each time the read runs, hashed and consent-checked for TikTok.

    cockroach -> tiktok-custom-audience :: live

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

    WHAT THIS ENABLES

    Cockroach to TikTok Custom Audience

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

    • Customer segments from your Cockroach tables activated for TikTok, as Signals delivers first-party segments to TikTok as match-ready custom audiences.
    • TikTok custom audiences mirroring the segment your data team publishes, drawn from your Cockroach tables by platform teams running CockroachDB.

    WHAT FLOWS WHERE

    Cockroach to Custom Audience, mapped.

    A scheduled read pulls the customer segments from your Cockroach tables; Signals hashes and consent-screens each record before TikTok's Custom Audience API accepts the match-ready audiences for match quality on TikTok.

    A scheduled read pulls the customer segments from your Cockroach tables; Signals hashes and consent-screens each record before TikTok's Custom Audience API accepts 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 records already in Cockroach tables and secondary indexes.

    Platform teams running CockroachDB activating TikTok audience targeting straight from Cockroach tables.

    HOW DATAHASH SETS IT UP

    From kickoff to verified events.

    1. Connect

      A read-only database user scoped to the Cockroach tables you name to feed TikTok's Custom Audience API, sized for match quality on TikTok.

    2. Map

      A scheduled read pulls your Cockroach 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

      On each run, Signals pulls your Cockroach tables, delivers first-party segments to TikTok as match-ready custom audiences, and reads only the records changed since the last run, with match quality on TikTok 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, as Signals reads your Cockroach tables and reads only the records changed since the last run.

    Targeting that mirrors your live segment from your Cockroach tables, with read load on the database steady because Signals reads only the records changed since the last run.

    A per-run match report from TikTok's Custom Audience API on match quality on TikTok, straight out of your Cockroach tables.

    ON THE WIRE

    What Custom Audience actually receives.

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

    1. ● signals :: audience upload
    2. > POST /dmp/custom_audience source=cockroach.segments
    3. id_schema ["EMAIL_SHA256","PHONE_SHA256"]
    4. action "add" · audience_id "aud_61400"
    5. id_list_size 56,219 · matched 42,164
    6. ✓ accepted match=75%
    FAQ

    Asked on almost every call.

    How often does the Cockroach TikTok Custom Audience sync run?

    The pace follows your Cockroach tables: Signals sends changes from Cockroach 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 platform teams running CockroachDB keep match quality on TikTok in view. Delivery needs no export and no manual upload.

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

    Coverage of hashed identifiers across your Cockroach tables decides it, and platform teams running CockroachDB own that inside Cockroach. A live email or phone matches into TikTok; neither, and it will not. First-run feedback flags match quality on TikTok, which platform teams running CockroachDB then raise inside your Cockroach tables.

    NEXT STEP

    Cockroach to TikTok Custom Audience, in production this week.