Platform Enhancements

Resolved an intermittent issue

We have identified and resolved an intermittent issue with some jobs getting stuck in the pipeline leading to data delays. Our analysis showed that the issue had an impact on <1% of our jobs and with the recent change, we expect to see an improvement in the timeliness of replication.

Upcoming Platform Enhancements

dbt Packages

We have started publishing dbt Packages for some of our connectors starting with Amazon Seller Central. Over the course of the next few weeks, we will be adding dbt packages for over fifteen connectors. 
You can follow the updates here. 
Please try the packages and share your feedback with us.

Platform Upgrades

Major infrastructure changes will be made over the next couple of weeks to support our product objectives for 2023. These changes will not only enable us to speed up the pace of development and feature rollout but will also ensure higher platform availability. 

Stay Tuned!

Connector Enhancements

Amazon Ads Connector

Fixed a bug with the profiles table across SP/SB/SD- previously used to load selected profileIDs on Daton with all the other profile names as well now it will push all the available profile data to your warehouses.

Amazon Attribution Connector

Added brb_bonus_amount column for Campaign Performance Report & AdGroup Performance Report. With this, you can track the estimated ad-attributed Brand Referral Bonus credit amount.

Amazon Sponsored Products Connector

• Sponsored Brands Unified Campaigns report & Unified Search term keyword report: Multi-ad accounts were not supported in the current Campaigns report table but Amazon has added support for multi-ad accounts which should properly load data for the respective tables.
• Amazon Sponsored Products revamp is coming to support the new V3 functionality, stay tuned for the next month!

Amazon Selling Partner Connector

• Five new columns have been added to the FBARestockInventoryReport:
  1. Working
  2. Shipped
  3. Receiving
  4. Total_Days_of_Supply__including_units_from_open_shipments_
  5. Days_of_Supply_at_Amazon_Fulfillment_Network
• Impossible dates like '2023-05-01' were being populated in VATTransactionsReport. Corrected the faulty date parsing.
• API calls now start at 00:00 in reportStartTime for PromotionsPerformanceReport. 
  Many promotions that started at 12:00 AM were missed out due to the fact that our promotionStartTime used to start at 12:01.xxx AM instead of 12:00.000 AM. We will be backfilling data to correct this.
• Corrected faulty parsing of nulls values in some mobile traffic columns in SalesAndTrafficReportByChildASIN, SalesAndTrafficReportByDate, and SalesAndTrafficReportyBySKU.

Amazon Vendor Central Connector

• API calls now start at 00:00 in reportStartTime for PromotionsPerformanceReport. 
  Many promotions that started at 12:00 AM were missed out due to the fact that our promotionStartTime used to start at 12:01.xxx AM instead of 12:00.000 AM. We will be backfilling data to correct this.

Gladly Connector

The following reports have been added to the Gladly Connector:

• Conversation Timestamps Report
• Conversation Export Report
• Contact Export Report
• Agent Duration Report
• Agent Summary Report

NEW Connectors Added!

SugarCRM Connector

Tables Added:

• Calendar
• Contacts
• Emails
• Cases
• Currencies
• Tasks
• Notes
• Calculated_fields_updater_queue
• Product_catalog
• Purchases
• Tags
• Purchased_line_items
• Calls
• Meetings
• Accounts

Click here to read the documentation of the SugarCRM Connector.

Impact Connector

Tables Added:

• Ads
• Campaigns
• Deals
• Invoices
• Partners
• Phonenumbers

Click here to read the documentation of the Impact Connector.

Loopreturns Connector

Tables Added:

• Return list
• Return Detail

Click here to read the documentation of the Loopreturns Connector.

Byrd Connector

Tables Added:

• Deliveries
• Products
• Shipments

Click here to read the documentation of the Byrd Connector.

Please contact our support team if you are interested in having new connectors built.