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 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

About Inventory Planner Connector

Inventory Planner is a cloud-based inventory management software solution that helps businesses manage their inventory levels more effectively and efficiently. The software is designed to simplify the inventory management process by automating many of the tasks involved in inventory planning.

Tables supported:

  • Variants

Click here to read the documentation of the Inventory Planner Connector.

Awtomic Connector

About Awtomic Connector

Awtomic is a subscription-based service for automating and optimizing various tasks related to digital marketing, social media management, and web development. The platform provides a range of tools and features that allow users to streamline their workflows and improve their productivity.

Tables supported:

  • Subscriptions_Peel

  • Subscriptions_Billing_Attempts

Click here to read the documentation of the Awtomic Connector.

Last updated