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

Community

Connector Improvement: ST Campaigns are not fetched from the Amazon Ads connector

Answered
Becir Isakovic User

Respected,

The ST campaigns are not in the fivetran database and that is a problem because the reports generated on the campaign level are not accurate and they are missing the ST (Sponsored TV) types of campaigns.

Regards

Please sign in to leave a comment.

Comments

5 comments

Date Votes
  • Official comment
    Lucas Alexander Fivetranner

    Hi Becir,

    Thanks for submitting this request. We haven't received a similar request for ST campaigns before. We'll investigate this in Amazon Ads API documentation and get back to you once we've completed our analysis.

    Thanks,
    Luke

  • Becir Isakovic User

    Hi Lucas,

    Any ETA or update on when the ST campaigns will be supported in your system?

    Warm regards,

    Becir Isakovic

  • Lucas Alexander Fivetranner

    Hi Becir,

    We're considering this for a potential project for our next quarter, which will start in January. However, we need to weigh this against other requests and currently, we only have two requests submitted for ST data. 

    We may be able to break up the work of adding ST data to the schema into smaller chunks to move faster. Are there specific ST reports/metadata tables that you need most?

    Thanks,
    Luke

  • Becir Isakovic User

    Hi Lucas,

    The only thing that we need is that the ST campaigns are present in the report as the other campaigns data. In the AWS Ads console under the Sponsored Ads -> Campaign Management there is a report (image is attached to the message) there is a breakdown per campaign. We are able to fetch all data in the tables sd_campaign_report, sd_campaign_report, and campaign_level_report. However, the ST campaign types are not shown in here. Just adding it to any of these tables (or creating a new one) is good for us. It is only a new campaign type, not a new report.

    Please keep us updated as this is extremely important report for us.

    Thank you in advance!

    Warm regards,

    Becir Isakovic


  • Lucas Alexander Fivetranner

    Hi Becir,

    This is still in our backlog, but we complete some initial investigation.

    Amazon has a dedicated API for creating/updating/reading ST entities, which is separate from SD and SB reporting endpoints. The ST Reporting API supports 2 report types:

    • Campaign

    • Targeting

    Based on this, it will be a new service with its own metadata and reporting tables. 

    We agree that adding this to our connector is valuable, and it is in our backlog. We'll prioritize against the other items in our backlog based on customer demand. If anyone else comes across this, please upvote it to show your interest!

    Thanks,
    Luke