[source-amazon-ads] Support configuration of dynamic v3 reports

[matthewbelair]

Topic

No response

Relevant information

Connector Name
source-amazon-ads

Current State

• The connector primarily relies on deprecated v2 reports (except for Brand product type)
• The sponsored_brands_v3_report_stream is currently limited to a single report type
• Users face long waiting times due to inability to specify targeted report parameters

Proposed Enhancement
Add support for dynamic report generation, similar to LinkedIn Ads and Google Ads connectors. This would enable users to:

1. Specify custom report parameters including:
   • Ad Product
   • Group By fields
   • Column selections
   • Report Type ID
   • Time Unit

Related Documentation

• Amazon Ads API Documentation - Report Types

[natikgadzhi]

@artem1205 are those part of the rewrite, or not yet?

[artem1205]

@natikgadzhi ,yes, it is in progress

https://github.com/airbytehq/airbyte-internal-issues/issues/10423#issue-2609698586

[natikgadzhi]

Great! When you get to a PR, reference this issue so it gets autoclosed