# April

## <mark style="color:yellow;">Connector Enhancements</mark>

#### <mark style="color:green;">Amazon Sponsored Products</mark> <mark style="color:green;">**Connector**</mark>

Following the release of the new [version 3 reporting endpoints](https://advertising.amazon.com/API/docs/en-us/info/release-notes#announcing-reporting-enhancements-for-sponsored-products-and-sponsored-brands), 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](https://advertising.amazon.com/API/docs/en-us/reporting/v3/migration-guide#new-metrics).&#x20;
* 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.\
  \&#xNAN;*Reach out to* [*Daton support*](mailto:support@sarasanalytics.com) *if you have 5+ integrations to be added to the report metrics.*
* The connector now allows date ranges, eliminating the 429 errors.&#x20;
* 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&#x20;
* Invoice for advertising&#x20;
* 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. \
  \&#xNAN;***Please update your deduplication and downstream queries accordingly, as targeting values are no longer null and instead load the "TARGETING\_EXPRESSION" value.***&#x20;
* 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.

## <mark style="color:orange;">NEW Connectors Added!</mark>

#### <mark style="color:green;">**Inventory Planner Connector**</mark>

<details>

<summary>About <mark style="color:green;"><strong>Inventory Planner Connector</strong></mark></summary>

[Inventory Planner](https://www.inventory-planner.com/) 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.

</details>

**Tables supported:**

* `Variants`

*Click* [*here*](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/saas-integrations/inventory-planner) *to read the documentation of the <mark style="color:green;">Inventory Planner</mark> Connector.*

#### <mark style="color:green;">**Awtomic Connector**</mark>

<details>

<summary>About <mark style="color:green;"><strong>Awtomic Connector</strong></mark></summary>

[Awtomic ](https://www.awtomic.com/)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.&#x20;

</details>

**Tables supported:**

* `Subscriptions_Peel`
* `Subscriptions_Billing_Attempts`

*Click* [*here*](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/saas-integrations/awtomic) *to read the documentation of the <mark style="color:green;">Awtomic</mark> Connector.*