The Kapoq Data Connector offers the seamless extraction and transfer of Amazon and Walmart data to your preferred destinations, including data warehouses and BI tools like PowerBI, Tableau, or Google Looker Studio.
Here are the data sources currently available (with more to be added):
Advertising Target Data
Advertising Ad Group Data
Advertising Campaign Data
Amazon DSP Data
Amazon Product Level Sales Data
Regarding the frequency in which the data updates, Kapoq Data Connector tables refresh nightly, typically completing between 1:00 and 2:00 AM Central Time.
Data Schemas:
AdvertisingTargetData
TargetId
Date
Impressions
Clicks
Cost
Orders
AdSales
CampaignId
Campaign
StartDate
EndDate
CampaignType
TargetingType
CampaignStatus
CampaignServingStatus
CurrentBudgetMarketplaceCurrency
CostType
AdFormat
DynamicBiddingStrategy
TopPlacementModifier
ProductPagePlacementModifier
PlacementRestOfSearchModifier
TopOfPageClickShare
ProductPageClickShare
AdGroupId
AdGroup
AdGroupStatus
Target
TargetStatus
BidMarketplaceCurrency
KapoqBid
MatchType
ExpressionType
KeywordType
ProductTargetType
MaxAcos
Currency
Strategy
BudgetGroup
SalesChannel
Account
Brand
IsAccountActive
IsBrandActive
LastUpdated
AdvertisingAdGroupData
Date
Impressions
Clicks
Cost
Orders
AdSales
CampaignId
Campaign
StartDate
EndDate
CampaignType
TargetingType
CampaignStatus
CampaignServingStatus
CurrentBudgetMarketplaceCurrency
CostType
AdFormat
DynamicBiddingStrategy
TopPlacementModifier
ProductPagePlacementModifier
PlacementRestOfSearchModifier
TopOfPageClickShare
ProductPageClickShare
AdGroupId
AdGroup
AdGroupStatus
Currency
Strategy
BudgetGroup
SalesChannel
Account
Brand
IsAccountActive
IsBrandActive
LastUpdated
AdvertisingCampaignData
Date
Impressions
Clicks
Cost
Orders
AdSales
CampaignId
Campaign
StartDate
EndDate
CampaignType
TargetingType
CampaignStatus
CampaignServingStatus
CurrentBudgetMarketplaceCurrency
CostType
AdFormat
DynamicBiddingStrategy
TopPlacementModifier
ProductPagePlacementModifier
PlacementRestOfSearchModifier
TopOfPageClickShare
ProductPageClickShare
Currency
Strategy
BudgetGroup
SalesChannel
Account
Brand
IsAccountActive
IsBrandActive
LastUpdated
AdvertisingDspStatisticsByReportDateAndLineItem
Advertiser
Account
Brand
Date
Order
LineItem
Creative
CreativeSize
CreativeType
TotalCost
Impressions
TotalDetailPageViews14d
TotalAddToCart14d
TotalSales14d
Clicks
UnitsSold14d
Purchases14d
DetailPageViews14d
AddToCart14d
NewToBrandPurchases14d
TotalNewToBrandUnitsSold14d
NewSubscribeAndSave14d
TotalUnitsSold14d
TotalPurchases14d
TotalSubscibeAndSaveSubscriptions14d
Sales14d
TotalSales (Vendor & Seller)
Date
Account
Brand
SKU
ASIN
ParentASIN
TotalQuantity
TotalSales
Data Sources - Coming Soon (TBD):
Traffic - Account, Brand, ASIN > Buy Box %, Total Sessions, Unit Conversion Rate, Order Conversion Rate, Page Views
Accounting - Account, Brand, ASIN > SKU Net Profit, SKU Margin %
Inventory - SKU Level > Account, Brand, Fulfillable, Reserved buckets, Inbound buckets, and higher level stats (OOS days, lost sales $, avg. fulfillable qty, avg. DOC)
Any questions for us? Please feel free to reach out to learn more!