April
Connector Enhancements
Amazon Sponsored Products Connector
Following the release of the new version 3 reporting endpoints, we are announcing the deprecation of the version 2 Sponsored Products. In effect to the same, Daton has implemented the following changes on your Amazon Ads Connector.
All the reports have been migrated to v3, and some new metrics are now available, including
purchaseClickRate7d
andcostPerClick
, click here to access the entire list.Daton will support all the new report metrics, and we can add them in bulk for your integrations if needed. Please select load in the pop-up that appears after selecting the new columns. Note: This might affect your downstream queries. Reach out to Daton support if you have 5+ integrations to be added to the report metrics.
The connector now allows date ranges, eliminating the 429 errors.
You may expect a decrease to 10-20% of the row count before 4th May for Sponsored Products because the v3 APIs don't return the rows which have all the metrics as 0 or nulls.
Tables Added:
Budget recommendations and missed opportunities
Invoice for advertising
Theme-based bid suggestions
Changes in the Tables:
Bid plus columns are removed from
campaign report
tables andplacement campaign
reports. To maintain existing integrations, null values will be loaded.The
Search Term Keyword
report now includes all match types (BROAD, PHASE, EXACT, TARGETING_EXPRESSION, TARGETING_EXPRESSION_PREDEFINED) previously used to load nulls for Targeting data. Please update your deduplication and downstream queries accordingly, as targeting values are no longer null and instead load the "TARGETING_EXPRESSION" value.The
Search Term Targeting
report contains only TARGETING_EXPRESSION and TARGETING_EXPRESSION_PREDEFINED.Some column data has changed; users are advised to adjust their downstream accordingly. For example,
campaignBudgetType
previously showed "daily" but now it is changed to "DAILY_BUDGET".The search term impression share metric has been added to the
Sponsored Products Keyword Recommendations
table.New column names have been mapped to match the old ones for better compatibility.
Raw tables have been updated to the v3 version.
NEW Connectors Added!
Inventory Planner Connector
Tables supported:
Variants
Click here to read the documentation of the Inventory Planner Connector.
Awtomic Connector
Tables supported:
Subscriptions_Peel
Subscriptions_Billing_Attempts
Click here to read the documentation of the Awtomic Connector.
Last updated