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 and costPerClick, 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 and placement 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.