Amazon Ads sponsored_product_ad_group upgraded to v3
We’ve migrated the Amazon Ads sponsored_product_ad_group endpoint to a new v3 version in Weld, aligned with Amazon Ads’ sponsored_product_ad_group API v3.
The new endpoint is now the source of truth for all new and updated sponsored_product_ad_group data going forward.
The existing table remains available with historical data only, but it will not receive new records.
👉 To keep your models working on new data, you’ll need to switch your queries to the new sponsored_product_ad_group_v3 table.
Full announcement: Amazon Advertising release notes
What happens to the old table?
- The old
sponsored_product_ad_grouptable remains available - It contains historical data only
- No new updates will be written to it
- It can be used for backfills or comparisons, but active models must move to v3
Why this change?
Amazon Ads has deprecated the legacy sponsored_product_ad_group API and introduced v3 as the supported API.
Weld’s new sponsored_product_ad_group_v3 tables reflects this structure directly.
🔄 Schema changes (old → v3)
The v3 schema is not a drop-in replacement for the legacy table.
While many core identifiers remain, some fields and tables were renamed, reorganised, or removed.
Table changes
| Legacy Table | v3 Table |
|---|---|
sponsored_product_ad_group | sponsored_product_ad_group_v3 |
sponsored_product_ad_group_suggested_keyword | sponsored_product_ad_group_v3_suggested_keyword |
sponsored_product_ad_group_bid_recommendation | removed |
Field changes
Legacy (sponsored_product_ad_group_suggested_keyword) | v3 (sponsored_product_ad_group_v3_suggested_keyword) |
|---|---|
keyword_text | keyword |
state | removed |
rank | new |
suggested_bid_range_start | new |
suggested_bid_range_median | new |
suggested_bid_range_end | new |
What you need to do
-
Update your models to read from
{{raw.hubspot.sponsored_product_ad_group_v3(_*)}} -
Review any models that depend on removed or renamed fields such as:
keyword_text→keywordstate(removed)
-
Update field references to their new equivalents where relevant.
Final note
These changes originate from Amazon Ads' API design, not Weld-specific decisions.
Weld’s goal with sponsored_product_ad_group_v3 is to mirror Amazon Ads’ supported API as closely as possible while providing a stable, explicit schema for analytics.
