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

Community

Connector Improvement: TikTok Ads Connector - Add GMV Max Creative-Level Reporting (Video-Level + Sales Detail)

Answered
Arnau Aumedes User

We’re using the TikTok Ads connector together with the GMV Max campaigns (TikTok Shop Ads).
The current schema already includes GMV Max data at the campaign + country + daily level through the table gmv_campaign_country_report_daily, which is useful but too aggregated.

To build proper performance dashboards and ROI analyses, we urgently need creative-level (video/ad-level) data for GMV Max campaigns, including both spend and attributed sales (GMV / total purchase value).

Problem

  • The existing GMV Max export (gmv_campaign_country_report_daily) only provides metrics at campaign + country granularity.

  • There is no way to analyze which specific creatives (videos) drive sales or spend within each GMV Max campaign.

  • The standard tables ad_report_daily and tiktok_ads__ad_report do not include GMV Max ads, so the video-level breakdown is missing completely.

  • This prevents creative optimization, ROI per video, and full reconciliation of ad spend vs. TikTok Shop GMV.

Request
Please extend the TikTok Ads connector to also pull GMV Max creative-level reports from TikTok’s new GMV Max Reporting API (TikTok Shop Ads API).
Specifically, we’d need a new table similar to:

 
gmv_ad_report_daily

with fields such as:

  • advertiser_id

  • campaign_id

  • adgroup_id

  • ad_id

  • video_id / creative_id

  • date

  • country

  • impressions

  • clicks

  • spend

  • gmv

  • total_purchase_value

  • conversion_count

  • roas

  • currency

Ideally, this could be incorporated into the dbt TikTok Ads package so that the new data joins with existing campaign and creative metadata.

Please sign in to leave a comment.

Comments

5 comments

Date Votes
  • Official comment
    Lucas Alexander Fivetranner

    Hi all, 

    Just a quick update on this. We're working on this improvement now. We're planning to add new prebuilt reports for the campaign-level, product-level, and creative-level Product GMV Max Campaign reports, as well as the campaign-level, livestream-level, and duration-level LIVE Max Campaign reports. 

    We need API access to test these new endpoints. If you're willing to help with this, please let me know, and I'll send an access request. These endpoints also require a new scope from TikTok Ads, so we'll need you to reauthorize your connection during testing.

    Cheers,
    Luke

  • Lucas Alexander Fivetranner
    • Edited

    Hi Arnau,

    Luke from the Product team here. Thanks for submitting this feature request and providing so much detail.

    We use the TT_SHOP report_type in TikTok Ads Reporting API to sync the GMV_CAMPAIGN_COUNTRY_REPORT_DAILY. The docs for the Reporting API are here. The endpoint is /report/integrated/get/. The available dimensions (here) and metrics (here) for the TT_SHOP report_type from this endpoint are limited to the ones that we already provided. It isn't possible to break down this report_type by creative, ad, or adgroup, or add the metrics you requested.

    There is a separate API that TikTok released that they say can be used to "run a report on GMV Max Campaigns". The endpoint is /gmv_max/report/get/. It appears to support many more metrics (see here). But I don't see the following dimensions/metrics you requested:

    • ad_id
    • adgroup_id
    • video_id
    • spend
    • gmv
    • total_purchase_value
    • conversion_count
    • roas
    • currency

    Regardless, we plan to implement this endpoint (/gmv_max/report/get/) too; however, it will take some time because it is a separate endpoint. All the other reports that we support use the main reporting endpoint (/report/integrated/get/).

    If you're aware of another way to the fields I listed above, please let me know. I'll keep you posted on our progress implementing the /gmv_max/report/get/ endpoint. 

    Thanks,
    Luke

  • Arnau Aumedes User

    Hi Lucas Alexander,

    Thanks for your reply. However, we’re not seeing the fields you mentioned in the GMV_CAMPAIGN_COUNTRY_REPORT_DAILY table. The table currently only contains the following 7 fields (and not the ones you mentioned that would be perfect for us..):

    • campaign_id

    • country_code

    • stat_time_day

    • _fivetran_synced

    • spend

    • campaign_name

    • billed_cost

    Could you please provide this table with the fields you mentioned earlier, plus the number of orders?

    The ideal structure for us would include:

    • ad_id

    • adgroup_id

    • video_id

    • spend

    • gmv

    • total_purchase_value

    • conversion_count

    • roas

    • currency

    • number of orders

    Looking forward to your response. We do need it asap please.

    Best,

    Arnau

  • Lucas Alexander Fivetranner

    Hi Arnau,

    I think you misread my first response. From my analysis, TikTok does not provide these fields for GMV Campaigns via their API. Therefore, Fivetran cannot provide them:

    • ad_id
    • adgroup_id
    • video_id
    • spend (only available at campaign level, as we provide now in GMV_CAMPAIGN_COUNTRY_REPORT_DAILY). 
    • gmv
    • total_purchase_value
    • conversion_count
    • roas
    • currency

    This is the documentation I reviewed to come to this conclusion: https://business-api.tiktok.com/portal/docs?id=1824722485971009. 

    Regardless, adding support for this endpoint is in our backlog. We just won't be able to support the fields I listed above until TikTok makes them available.

    Luke

  • Edward Gurton User

    Hi Lucas,

    Has there been any progress on this?

    I would be willing to help test. 

    We have a TikTok Ads connector with an authorisation for an account running GMV Max Campaigns.

    Edward