September
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.
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_KeywordBidRecommendationstable: This table was phased out on September 30, 2023.SponsoredProducts_ThemeBasedBidRecommendationsis the replacement table. Migrate to the replacement table and make any necessary changes to your downstream procedures. -
Store Insightstable: This new table provides detailed information about the store's performance, including metrics for traffic, orders, views, and sales. -
Keyword Bid Recommendationtable: 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
ProductMetadatatable now includesbestSellerRankandcategorydata. - The
CampaignandCampaignExtables now providedynamicBiddingdata. - The following data is now loaded into extended tables (
CampaignEx,AdGroupEx,BiddableKeywordsEx,NegativeKeywordEx,CampaignNegativeKeywordEx,ProductAdEx,TargetingClauseEx):servingStatusservingStatusDetailscreationDateTimelastUpdateDateTim
- The
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) costTypeextendedData.creationDateextendedData.lastUpdateDateextendedData.servingStatusextendedData.servingStatusDetailsgoalisMultiAdGroupsEnabledproductLocationruleBasedBudgetruleBasedBudget.applicableRuleIdruleBasedBudget.applicableRuleNameruleBasedBudget.isProcessingruleBasedBudget.valuesmartDefaulttagsbidding.bidOptimizationStrategy-
Ad Group:stateservingStatusservingStatusDetailslastUpdateDatecreationDate
-
- The
Sponsored Brands Campaignsraw 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.bidAdjustmentPercentbidAdjustments.bidAdjustmentPredicateadFormatcreativecreative.asinscreative.brandLogoAssetIDcreative.brandLogoUrlcreative.brandNamecreative.headlinecreative.shouldOptimizeAsinslandingPagelandingPage.pageTypelandingPage.urlbidMultiplier
-
-
3. Shiphero
The following updates have been added to this connector:
-
Line_Itemsandlocationcolumns inPurchase-Orderstable -
Order_holdsin the columnsOrderstable - New tables:
Tote_HistoryandPacks_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/. |
|
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/. |
|
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 . |
|
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/. |
