May 2023

New Connectors

Amazon Ads (Version 2)

DataChannel now supports an updated version of the Amazon Ads connector.

With this updation, the original version of the Amazon Ads is no longer available. Users are advised that the new version be used for new pipelines. Two pipelines of the older version of the Amazon Ads Connector have been deprecated and are no longer available. These are : Sponsored Products, and Sponsored Brands Video. Details of avaiable pipelines (including new pipelines added) are given below.

The connector can be accessed from the Data Sources page on the DataChannel Dashboard. Please follow the step-by-step Set up Guide for a smooth integration.

This Amazon Ads connector will enable streaming of relevant Amazon Ads performance data into a user determined data warehouse. Users will be able to start accessing their data by setting up a pipeline. Data acquired using such a pipeline enables you scale, optimise, and report on your advertising activities.

Available Pipelines

  1. Asins - Retrieve ASIN performance report.

  2. Sponsored Brands- Retrieve Sponsored Brands performance reports.

  3. Sponsored Brands Purchased Product- Retrieve performance data for products that were purchased as a result of your campaign.

  4. Sponsored Display- Retrieve Sponsored Display performance reports.

  5. Sponsored Products Ad Group- Retrieve performance data for all Sponsored Products campaigns that received impressions on the chosen dates, grouped by ad group.

  6. Sponsored Products Advertised Product- Retrieve performance data for products that are advertised as part of your campaigns.

  7. Sponsored Products Campaigns- Retrieve performance data for all Sponsored Products campaigns that received impressions on the chosen dates.

  8. Sponsored Products Placement- Retrieve performance data for all Sponsored Products campaigns that received impressions on the chosen dates, grouped by placement.

  9. Sponsored Products Purchased Product- Retrieve performance data for products that were purchased, but were not advertised as part of a campaign.

  10. Sponsored Products Search Term- Retrieve search term performance metrics broken down by targeting expressions and keywords.

  11. Sponsored Products Targeting- Retrieve performance metrics broken down by both targeting expressions and keywords.

Possible Destinations

Click here for more details about this connector.

Adjust Raw Data Export (BETA)

DataChannel now supports Adjust Raw Data Export connector. The connector can be accessed from the Data Sources page on the DataChannel Dashboard. Please follow the step-by-step Set up Guide for a smooth integration.

This Adjust Raw Data Export connector will enable you to export your raw user data from Google Cloud Storage into a your chosen data warehouse. You will be able to start accessing this data by setting up a pipeline. Data acquired using such a pipeline will enable you to build your own database and analyze your users the way you want. This will prove useful for user-level analysis and personalized retargeting efforts.

Available Pipelines

  1. Report- Provides reports on events/datapoints selected by you based on your requirement.

Possible Destinations

Click here for more details about this connector.

New Destination

Salesforce Reverse ETL

DataChannel now supports Salesforce Reverse ETL connector. The connector can be accessed from the Destinations page on the DataChannel Dashboard. Please follow the step-by-step setup guide for a smooth integration.

The Salesforce Reverse ETL connector enables streaming relevant data from your data warehouse into the Salesforce platform.

Available Syncs

  1. Salesforce Report- Retrieve objects, fields and records data from a user specified data warehouse and send it to the Salesforce platform.

Supported Reverse ETL Datawarehouses

Click here for more details about this connector.

Feature Updates

Amazon Seller Central

DataChannel’s Amazon Seller Central connector now supports 14 new forward data pipelines. The new and existing pipelines (a total of 34 pipelines) of the Amazon Seller Central connector can be accessed from the Data Sources page on the DataChannel Dashboard.

Please follow the step-by-step Set up Guide for a smooth integration of the pipelines.

New Pipelines that are now available

  1. Active Listings Report- Retrieve tab-delimited flat file detailed active listings report.

  2. All Listings Report- Retrieve tab-delimited flat file detailed all listings report. It provides a snapshot of all your products.

  3. B2B Product Opportunities- Not Yet on Amazon Report- Retrieve a comma-separated report which includes a compiled a list of products that are in demand, but are not yet on Amazon.

  4. B2B Product Opportunities- Recommended For You Report- Retrieve a comma-separated report which includes recommended products that might be a good opportunity for the selling partner’s business on Amazon.

  5. FBA Amazon Fulfilled Shipments Report- Retrieve tab-delimited flat file report containing detailed order/shipment/item information including price, courier, and tracking data.

  6. FBA Fee Preview Report- Retrieve tab-delimited flat file report containing the estimated Amazon Selling and Fulfillment Fees for the seller’s FBA inventory with active offers.

  7. FBA Reimbursements Report- Retrieve tab-delimited flat file report containing itemized details of a seller’s inventory reimbursements, including the reason for the reimbursement.

  8. FBA Storage Fees Report-Retrieve tab-delimited flat file report containing estimated monthly inventory storage fees for each ASIN of a seller’s inventory in Amazon fulfillment centers.

  9. Inactive Listings Report- Retrieve tab-delimited flat file detailed inactive listings report.

  10. Inventory Report- Retrieve tab-delimited flat file open listings report that contains a summary of the seller’s product listings with the price and quantity for each SKU.

  11. Open Listings Report- Retrieve tab-delimited flat file open listings report.

  12. Subscribe and Save Forecast Report- Retrieve tab-delimited flat file report that provides an eight-week forecast of sales based on existing subscriptions and sales history.

  13. Subscribe and Save Performance Report- Retrieve tab-delimited flat file report that provides a trailing four-week view of items shipped, percentage of orders missed due to being out of stock, average post-discount sale price, and average discount for each SKU.

  14. Supressed Listings Report- Retrieve tab-delimited flat file that contains suppressed listings, the reason each listing is suppressed, and instructions for removing each suppression.

Possible Destinations

Click here for more details about this connector.

Reverse ETL Wizard

We have now added a Reverse ETL Wizard which can be accessed by clicking on the Home Tab. You can read more about this functionality available to you by clicking here. Now, you can expect a more streamlined experience that guides you through the process of creating a reverse sync.

Bug Fixes

We have carried out minor bug fixes in the EasyEcom connector to enable you to backfill data older than 7 days.

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.