Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: TikTok Ads - Add a fact table with ttclid

Not planned
It Service Account User

It would be really useful for marketing attribution and audience analysis purposes to have a table in the TikTok Ads connector with all the TikTok Click IDs (ttclid) with information about the ad clicked, location of the user, device, etc. (similar to the table "click_view" in the Google Ads connector).

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Lucas Alexander Fivetranner

    Hi there,

    Thank you for your feature request regarding a click-level fact table with TikTok Click IDs (ttclid) for the TikTok Ads connector.

    After thorough investigation, we've found that the TikTok Marketing API does not currently expose click-level data as a queryable reporting dimension. The TikTok Reporting endpoint (report/integrated/get) only supports aggregate-level reporting at the advertiser, campaign, ad group, or ad data levels. There is no click-level data level and no ttclid dimension available in the API response.

    The ttclid is designed as a first-party tracking parameter that TikTok appends to landing page URLs when a user clicks an ad. It is intended to be captured by the advertiser's website and then sent back to TikTok via the Events API or Pixel for conversion attribution. In other words, ttclid is an input parameter for event tracking, not a queryable output from the Reporting API. You can see more about how ttclid works in TikTok's documentation: https://ads.tiktok.com/help/article/tiktok-click-id?lang=en

    Because Fivetran relies on the TikTok Marketing API to access data, we're unable to sync data that isn't available through the API.

    However, there is a workaround if you have Google Analytics 4 tracking on your landing pages. When a user clicks a TikTok ad, the ttclid is appended to the landing page URL as a query parameter. GA4 captures this in the page URL. Using our GA4 connector's Custom Reports feature, you can select the landingPage or pageLocation dimension, which preserves the full URL, including query parameters like ttclid. You could then parse the ttclid from those URLs in your warehouse and join it with the aggregate TikTok Ads performance data synced by Fivetran.

    Note: the GA4 connector's prebuilt reports use pagePath, which strips query parameters, so you'll need to set up a Custom Report to capture the full URL.

    We actively monitor source API updates and will revisit this if TikTok adds a click-level reporting endpoint in the future.

    We appreciate you sharing this feedback; it helps us prioritize our work.

    Cheers,
    Luke