Zero data for specific Amazon Ads API streams in Airbyte

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

The user is experiencing issues with specific streams (SPONSORED_BRANDS_REPORT_STREAM_METRIC and SPONSORED_BRANDS_REPORT_STREAM) from the Amazon Ads API not populating data in Airbyte, despite re-syncing with different approaches. Other tables in Snowflake are getting populated, but these specific tables remain empty. User suspects either an issue with Airbyte or the Amazon Ads API.


Question

I’m using Airbyte to query Amazon Ads API, and there’s 0 data for SPONSORED_BRANDS_REPORT_STREAM_METRIC and SPONSORED_BRANDS_REPORT_STREAM. I’ve re-synced it twice, both with trying incremental dedupe approach and then full refresh overwrite, but there’s still 0 data in the end tables (the other Snowflake tables get populated with data).

I can see non-video brand ad campaigns in sponsored_brands_campaigns table but the 2 above tables are empty which means I don’t get any click or impressions data for those campaigns.

Does anyone know if this is likely an Airbyte problem with those 2 streams, or this is an Amazon Ads API problem?


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["amazon-ads-api", "airbyte", "snowflake", "zero-data", "specific-streams", "sponsored-brands-report-stream-metric", "sponsored-brands-report-stream", "click-data", "impressions-data"]
2

Hi Albert, could you confirm if you have the required permissions for Amazon Ads reports? They can be tricky. One strategy, though not the simplest, is to manually request them. You might receive error responses from the API call which I hope can be added in the connector in the future.