[source-amazon-ads] Add Sponsored Products Search Terms Report stream

[sultar44]

The Amazon Ads connector currently supports Sponsored Products keyword-level daily reports (sponsored_products_keywords_report_stream_daily) but does NOT include the Search Terms Report.

These are fundamentally different data:

• Keywords report = performance of keywords you're bidding on
• Search terms report = actual customer search queries that triggered your ads

The Search Terms Report is critical for:

• Negative keyword optimization (finding irrelevant queries eating budget)
• New keyword discovery (finding high-converting queries to add as keywords)
• Understanding actual customer intent vs. broad/phrase match expansion

Amazon Ads API endpoint: The data is available via the Sponsored Products v3 Reporting API with reportType: spSearchTerm. It follows the same async report pattern as the existing keyword reports.

Suggested stream name: sponsored_products_search_terms_report_stream_daily

This would be a huge addition for anyone running Sponsored Products campaigns. Currently I have to maintain a custom script to pull this and push it to BigQuery alongside Airbyte.

[Aaron ("AJ") Steers (aaronsteers)]

Hi sultar44, thank you for opening this discussion!

This is a well-articulated feature request. The Search Terms Report (spSearchTerm via the Sponsored Products v3 Reporting API) is indeed a distinct and valuable dataset compared to the existing keywords report, and the use cases you described — negative keyword optimization, new keyword discovery, and understanding customer intent — are compelling.

Since the Amazon Ads API already supports this report type via the same async report pattern used by the existing keyword report streams, this looks like a natural addition to the connector.

I'm escalating this to the internal team for review and prioritization. I'll follow up with a tracking link shortly.

---

Need more help? Join Airbyte Community Slack for peer support, or if you're a Cloud customer, open a support ticket referencing this URL.

This message is generated from Devin.ai (internal session link).

[Aaron ("AJ") Steers (aaronsteers)]

This feature request has been escalated to the internal team for review and prioritization: https://github.com/airbytehq/oncall/issues/11556

This message is generated from Devin.ai (internal session link).