Search

reasonautomation.com

Product Release Notes

Product Release Notes

Release Notes

Q2 2026 (April – May 2026)

Amazon SP-API Enhancements Fixes based on Amazon adjusting throttling limits that were causing data accuracy and latency issues.

CommonDB — Multi-Profile Advertising Support Multiple advertising profiles can now be associated with a single brand UUID in the platform, enabling multi-advertising profile reporting.

Data Health — Accuracy Improvements Rolling data health validation is now more accurate — correctly distinguishing between empty tables (expected during initial setup) and data gaps (requiring attention). False alerts on new connections are eliminated.

Portal — Navigation & Display Fixes Brand switching, font sizing, and tab display issues in the portal have been resolved. Navigation behaves consistently across multi-brand and multi-account environments.

Q1 2026 (January – March 2026)

MCP Access for Select Customers We began enabling Model Context Protocol (MCP) access for select enterprise customers, allowing your teams to connect RA data directly to AI workflows and large language model tooling.

Data Health — Expanded Coverage Data health monitoring now covers brand-level, sink-level, and instance-level report status in a single view. Up-to-date validation is now rolling 24-hour (not a static timestamp).

API Authorizations — Connection Clarity When an API connection becomes invalid, the portal now shows you exactly why — not just a red status. The RA team can also pull a full ad profile list for an authorization and select the correct profile on behalf of a client, eliminating back-and-forth during onboarding.

Dashboard Seat Billing — Updated for 2026 Package New brands now receive 5 included dashboard seats by default, with additional seats available at the updated 2026 pricing. Stripe billing is updated to reflect the new package structure automatically.

Q4 2025 (October – December 2025)

AVN Legacy Table Deprecated — Cleaner Data Model The legacy basis_neg_avn table was deprecated and replaced with a modernized derivative structure. Your AVN analyses now run against a cleaner, more maintainable data model — reducing the risk of stale logic influencing negotiation numbers.

Cron Job Timeout Fixed — Report Generation Reliability A recurring cron job responsible for generating system reports was timing out at the 15-minute limit. We fixed the root cause, ensuring scheduled reports complete reliably every cycle.

Automated Pipeline Error Metric Creation When a connection experiences an error, the platform now automatically creates a push metric report flagging the failure. Issues are tracked systematically rather than discovered manually.

Q3 2025 (July – September 2025)

AVN Model — Coop Rebate Logic Fixed We corrected coop rebate calculation logic in the AVN and basis_vendorprofit models. Your negotiation P&L is now accurately inclusive of co-op structures, so you're walking into Amazon meetings with the right numbers.

API Authorization Validation We built validation logic for API connections — catching authorization errors at configuration time rather than after a pipeline failure. You know immediately if a connection has a problem, not after a missed data run.

Q2 2025 (April – June 2025)

AVN "Next" Release — Ongoing Monitoring & Negotiation Prep We shipped the next generation of the AVN model, purpose-built for ongoing monitoring during the negotiation cycle — not just point-in-time analysis. Enterprise customers running AVN prep now have a live view of the metrics that matter in JBP conversations.

AVN Full Derivative Table — Shipped The AVN model is now fully materialized as a derivative table — meaning your negotiation financials load faster, query more efficiently, and update on schedule without manual intervention.

Payments Invoice Matching — Deployed to All AVN Clients A new payments_invoices_matching table was deployed across all AVN customers, giving you a reconciled view of invoices against expected payment terms. Discrepancy analysis that previously required manual work is now structured and queryable.

BASIS Core — Improved Event Graph & Notifications We shipped improved content and logic for event-based notifications in the BASIS data layer. Data events — anomalies, gaps, completions — are now surfaced with richer context so your team understands what happened, not just that something happened.

Notifications Epic — Launched We launched a comprehensive Notifications system covering Amazon Seller and Vendor data events. Branded content changes, offer changes, and listing updates now generate structured, queryable notification records in your data environment.

Inventory Age Report — New Columns Added We added new columns to the inventory_age report, expanding the aging analysis your team can perform at the ASIN level. More complete inventory visibility, particularly useful for fee forecasting and operational planning.

Exchange Rate Support — Global Data Pipelines Exchange rate data is now natively integrated into core data pipelines, including confirmed PO records and KPIS daily/monthly reports. Global brands get accurate multi-currency views without manual conversion steps.

Q1 2025 (January – March 2025)

AVN Model Deployed — Post-Launch Follow-Ups Completed Following the initial AVN model launch, we completed a series of post-launch refinements and stabilization tasks. The AVN P&L framework was hardened for production use across enterprise accounts.

Currency Column Added to COGS Upload (AVN) The COGS upload used in AVN calculations now supports an optional currency column. Global brands can now upload cost-of-goods data in local currency — and the platform handles the conversion at the ASIN level.

Currency Added to Orders Confirmed POs Exchange rate data is now included in confirmed purchase order records, giving global brands an accurate multi-currency view of their committed inventory positions.

Legacy Invoice Tables Deprecated The legacy invoice_summary and invoice_details tables were deprecated in favor of the modernized invoices2 pipeline — a cleaner, more reliable invoice data structure with better historical coverage.

New Advertising Reports Validated We validated the maximum historical availability for all advertising report types and confirmed availability of new Advertising API reports ahead of Amazon's 2025 API migration. You won't experience gaps when Amazon's old endpoints are retired.

Notifications API — Launched The Notifications API was shipped, enabling programmatic access to Amazon data event notifications across the platform.

Search Term Impression Rank — Ads Ingestion Error Fixed An ingestion error affecting the ads_sponsored_products_search_term_impression_rank_vc report was identified and resolved. Your search term competitive data is complete and current.

Subscribe & Save — Backfill Selector Fixed A bug in the RAP portal prevented users from selecting the Subscribe & Save report during backfill requests. Fixed — you can now request Subscribe & Save backfills self-service.

Q4 2024 (October – December 2024)

Stripe Billing & Seat Management — Shipped to Production We shipped self-serve billing through Stripe, integrated directly into the customer portal. You can now manage your subscription, purchase additional seats, and view billing history without involving our team.

User Management in Customer Portal — Launched Enterprise accounts can now add, remove, and manage user access directly in the customer portal. Admin controls — including role assignment and permission management — are available without filing a support request.

Infrastructure — Private Network Architecture All platform infrastructure now operates behind private access controls and a Web Application Firewall across our GraphQL and public-facing APIs. Your data environment has no public internet exposure.

PBI Dashboard — PDF Export Fixed Power BI dashboard PDF exports were producing rendering errors for some customers. Fixed — your reports export cleanly for presentation and distribution.

Connection Name Updates — Self-Service You can now update and rename your Amazon API connection names directly in the portal. Accurate, human-readable connection labels make it easier to manage multi-marketplace and multi-account environments.

Remove Erroneous Connections — Self-Service Customers can now delete incomplete or incorrectly configured connections directly from the portal, without requiring RA team intervention.

Enterprise Security Controls — Implemented We deployed comprehensive access governance, audit infrastructure, and security controls that meet the standards required by enterprise procurement and security review teams.

Q3 2024 (July – September 2024)

Infrastructure — Private Network Architecture All AWS resources are now restricted behind a VPN with private access controls. Our infrastructure can no longer be accessed from the public internet — reducing your attack surface and ours.

Amazon Data Pipeline — Enterprise-Grade Security Our Amazon SP-API data ingestion meets enterprise requirements for credential handling, access scoping, and pipeline integrity. Passes enterprise security review without additional attestation.

Q2 2024 (April – June 2024)

SP-API Scheduler Split — Dedicated Pipeline We split SP-API (Seller Partner API) reports into their own dedicated scheduler. This ensures that high-volume Seller Central reports don't compete for resources with Vendor Central data pipelines — improving reliability for both.

API Authorization Tab — Renamed for Clarity The "Public Partners" tab in RA Portal was renamed to "API Authorizations" — reflecting what it actually controls. Better naming means less confusion when managing multi-account environments.

Q1 2024 (January – March 2024)

Invoice Data Pipeline — Modernized We shipped a new invoice report pipeline for Vendor Central with improved deduplication, support for combined summary and detail tables, and full historical coverage.

Confirmed Purchase Orders — Reporting & UI Support Confirmed purchase order data is now available as a structured report type with a new portal UI surface and backfill support.

New Report Types: Coupons & Promotions Coupons and Promotions data is now available as structured report types in both PostgreSQL and Snowflake-connected environments.

New Report Type: Brand Search Terms Brand search term data is now ingested and available as a structured report — giving enterprise accounts visibility into how their brand is being discovered in Amazon search.

Enterprise Security Controls — Phase 1 Deployed Deployed the foundational layer of access governance, audit infrastructure, and security controls required by enterprise procurement and security review teams.

Q4 2023 (October – December 2023)

Snowflake Sink — Multi-Sink & Custom Views Support We shipped multi-sink architecture for Snowflake, allowing a single data pipeline to write to multiple downstream destinations simultaneously. Custom views support was also added.

Snowflake — New Report Types: Returns (Seller & Vendor Central) Returns data from both Seller Central and Vendor Central report types is now available in Snowflake-connected environments.

Settlement API Reports — Fixed An issue affecting Settlement API report ingestion into Snowflake was identified and resolved. Your settlement reconciliation data is complete and accurate.

Q3 2023 (July – September 2023)

Snowflake Sink — Production Launch The Snowflake data sink shipped to production — enabling direct delivery of Amazon data into customer Snowflake environments.

Snowflake — New Report Types: Vendor SP-API Reports Vendor-side SP-API report types were added to the Snowflake sink, expanding coverage beyond Seller Central to Vendor Central data pipelines.

Q2 2023 (April – June 2023)

PostgreSQL Sink — Production Launch The PostgreSQL data sink shipped to production, giving customers a direct delivery path for Amazon data into their own Postgres database environments. Partner UUID partitioning, health monitoring, and graceful error handling were included from the start.

Snowflake — New Report Types: Repeat Purchase & Return Customer Behavior Repeat Purchase Behavior and Return Customer Purchase Behavior reports are now available in Snowflake-connected environments.

Snowflake — New Report Types: Seller Central SP-API Reports Seller Central SP-API report types were added to the Snowflake sink, completing initial coverage across both Seller and Vendor Central data pipelines.

Q1 2023 (January – March 2023)

Retail Analytics API — Stability Fixes A series of Retail Analytics API issues were identified and resolved — including missing data in weekly and monthly global reports, inventory sourcing failures, and a bug in the S3 API producing inaccurate consolidated files.

Brand Analytics Reports — Enabled We enabled and backfilled Brand Search Query Performance and Search Catalog Performance reports for additional accounts.

Maximum Lookback Window — Expanded We extended the maximum lookback window available for Retail Analytics reports, giving you access to a longer historical data record for trend analysis and year-over-year comparisons.

Client Instance Migration — Infrastructure Hardening We migrated select client environments to dedicated database instances — improving data isolation, query performance, and our ability to scale each account independently.