Summary

We are requesting support for the Weekly Search Terms Report within the Amazon Selling Partner connector. This report is currently available in the Amazon Vendor Central portal under Retail Analytics but is not part of the Fivetran connector's current ERD.

This report is critical to our business needs as it provides an optimal data grain between daily volatility and quarterly trends, offering a balanced and actionable view of organic search performance specific to Vendor Central.

Business Impact

• The absence of the weekly report limits our ability to perform trend analysis that is neither too granular (daily) nor too coarse (quarterly).

• Weekly aggregation is a key cadence used internally for marketing, product, and operational reporting.

• This impacts our ability to make timely adjustments to product listings, merchandising, and demand forecasting based on search performance.

Request Details

• Feature: Add the weekly-grain Search Terms Report as an available table in the Amazon Selling Partner connector.

• Current Behavior: Only daily, monthly, and quarterly variants are available.

• Expected Behavior: The connector should expose the same weekly search terms report that is available in the Amazon Vendor Central UI, pulled via SP-API (if supported).

Supporting Information

• We have verified that this report is present and accessible via the Vendor Central portal UI.

• This request is aligned with other tables (e.g., sales, traffic) that already offer daily, weekly, monthly, and quarterly granularities.

• We are happy to provide screenshots, sample exports, or further information if needed to support scoping this feature.

We appreciate the Fivetran team’s support and responsiveness. Adding this table would significantly improve the completeness and usability of the connector for Vendor Central customers like us.