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.
Last updated
Was this helpful?
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.
Last updated
Was this helpful?
Here are the sections included in the release notes:
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 .
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
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
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
The future fetch date loading issues in some Amazon Ads tables have been fixed.
Walmart connector stability has been improved through minor fixes.
ShipBob
Google My Business
Tiktok Business
Upscribe
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 .
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 .
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 .
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 .