September

The September 2023 release enhances the performance of existing connectors, adds new connector support, and continues helping businesses optimize analytics and make data-driven decisions.

Here are the sections included in the release notes:

• Connector Enhancements

• New Connectors

Connector Enhancements

1. Amazon Sponsored Products

On September 7, 2023, we upgraded all Amazon Sponsored Products raw tables to the latest v3 version.

• Key Changes and Enhancements:

  • Columns' syntax modified: The syntax of a few columns has been changed from lowercase to uppercase. To ensure seamless integration, update any downstream queries affected by these column name changes. For more information, see Enum casing.

  • SponsoredProducts_KeywordBidRecommendations table: This table was phased out on September 30, 2023. SponsoredProducts_ThemeBasedBidRecommendations is the replacement table. Migrate to the replacement table and make any necessary changes to your downstream procedures.

  • Store Insights table: This new table provides detailed information about the store's performance, including metrics for traffic, orders, views, and sales.

  • Keyword Bid Recommendation table: The data in this table is now organized by each group ID.

• Enhancements in Sponsored Products Raw Tables: To increase data richness, the following columns have been added:

  • The ProductMetadata table now includes bestSellerRank and category data.

  • The Campaign and CampaignEx tables now provide dynamicBidding data.

  • The following data is now loaded into extended tables (CampaignEx, AdGroupEx, BiddableKeywordsEx, NegativeKeywordEx, CampaignNegativeKeywordEx, ProductAdEx, TargetingClauseEx):

    • servingStatus

    • servingStatusDetails

    • creationDateTime

    • lastUpdateDateTime

2. Amazon Sponsored Brands Connector (v4)

On September 18, 2023, we upgraded the Amazon Sponsored Brands campaign and ad group raw tables to the v4 version.

• Key Changes and Enhancements:

  • All enums are now in uppercase to ensure data consistency. For example, the "state" column, which was previously displayed as "paused," will now be displayed as "PAUSED." To avoid any disruptions or excessive data loading, update your downstream queries.

  • The v4 now supports multi-ad group campaigns previously unavailable in the v3 endpoint.

  • The addition of new columns to the raw tables of campaigns and ad groups provides more comprehensive insights into your advertising efforts.

    • Campaigns:

      • bidding.bidAdjustmentsByPlacement (percentage & placement)

      • bidding.bidAdjustmentsByShopperSegment (percentage & placement)

      • costType

      • extendedData.creationDate

      • extendedData.lastUpdateDate

      • extendedData.servingStatus

      • extendedData.servingStatusDetails

      • goal

      • isMultiAdGroupsEnabled

      • productLocation

      • ruleBasedBudget

      • ruleBasedBudget.applicableRuleId

      • ruleBasedBudget.applicableRuleName

      • ruleBasedBudget.isProcessing

      • ruleBasedBudget.value

      • smartDefault

      • tags

      • bidding.bidOptimizationStrategy

      • Ad Group:

        • state

        • servingStatus

        • servingStatusDetails

        • lastUpdateDate

        • creationDate

    • The Sponsored Brands Campaigns raw table has had multiple columns removed. Null values for these columns will be loaded to ensure the seamless operation of existing integrations. The columns that have been removed are as follows:

      • bidAdjustments (replaced by bidding.bidAdjustmentsByPlacement & bidding.bidAdjustmentsByShopperSegment).

      • bidAdjustments.bidAdjustmentPercent

      • bidAdjustments.bidAdjustmentPredicate

      • adFormat

      • creative

      • creative.asins

      • creative.brandLogoAssetID

      • creative.brandLogoUrl

      • creative.brandName

      • creative.headline

      • creative.shouldOptimizeAsins

      • landingPage

      • landingPage.pageType

      • landingPage.url

      • bidMultiplier

3. Shiphero

The following updates have been added to this connector:

• Line_Items and location columns in Purchase-Orders table

• Order_holds in the columns Orders table

• New tables: Tote_History and Packs_Per_day

4. Bug Fixes and Enhancements:

• The future fetch date loading issues in some Amazon Ads tables have been fixed.

• Walmart connector stability has been improved through minor fixes.

New Connectors

New Connector	Description	Related Documentument
ShipBob	ShipBob provides e-commerce businesses with the infrastructure and technology needed to store inventory, process orders, and ship products to customers. It integrates with various e-commerce platforms and marketplaces, allowing businesses to manage orders from multiple sources effortlessly. For more information, see https://www.shipbob.com/.	ShipBob
Google My Business	Google Business Profile (GBP), formerly Google My Business (GMB), is a free and easy-to-use tool that helps businesses manage their online presence and improve visibility, credibility, and customer engagement. However, its data can be even more valuable when integrated with Daton. For more information, see https://www.google.com/business/.	Google My Business
Tiktok Business	Brands can creatively express themselves and measure campaign success through analytics tools using TikTok Business. It empowers businesses to reach a diverse global audience and tell their stories in innovative ways, making it a valuable tool for modern strategies. For more information, see https://business.tiktok.com .	Tiktok Business
Upscribe	Upscribe is a versatile platform designed to streamline and enhance subscription experiences, fostering brand loyalty and uncovering hidden value. With Upscribe, users can effortlessly build and deploy customized subscription models, focusing on subscriber satisfaction and crucial business metrics. For more information, see https://www.upscribe.io/.	Upscribe