Kapoq DataLink Overview
Kapoq DataLink offers automated, nightly extraction (1:00–2:00 AM CT) of Amazon and Walmart performance data and was developed to offer brands and agencies direct access to a secure, constantly maintained, and API-optimized data pipeline. The DataLink handles the complexity, cost, and resourcing burden of building and maintaining custom integrations. By leveraging years of Kapoq's deep Amazon API expertise, automated error detection, customizable dashboarding templates via Looker Studio, and flexible integration paths (via MySQL and more), the Kapoq Data Link empowers users to own their reporting with scalable, streamlined insights.
Here are the Data Sources currently available:
Advertising Target Data
Advertising Ad Group Data
Advertising Campaign Data
Amazon DSP Data
Amazon Product Level Sales Data
Amazon Seller Traffic
Amazon Vendor Traffic
Vendor POs
FBA Inventory
Vendor Inventory
📊 Data Sources & Summaries with Metric Definitions
1. Advertising Target Data
Detailed metrics at the keyword or product targeting level within campaigns.
TargetId: Unique identifier for the advertising target.
Date: Date of the data snapshot.
Impressions: Number of times the target ad was displayed.
Clicks: Number of user clicks on the target ad.
Cost: Total ad spend for the target.
Orders: Number of purchases attributed to the ad.
AdSales: Revenue generated from ad-attributed orders.
CampaignId: ID of the associated campaign.
Campaign: Name of the campaign.
StartDate: Campaign start date.
EndDate: Campaign end date.
CampaignType: Type of campaign (e.g., Sponsored Products).
TargetingType: Targeting method used (e.g., manual, automatic).
CampaignStatus: Current campaign status (e.g., enabled, paused).
CampaignServingStatus: Delivery status of the campaign.
CurrentBudgetMarketplaceCurrency: Current budget in marketplace currency.
CostType: Type of cost model used.
AdFormat: Format of the advertisement.
DynamicBiddingStrategy: Bidding strategy applied by Amazon.
TopPlacementModifier: Bid adjustment for top of search.
ProductPagePlacementModifier: Bid adjustment for product pages.
PlacementRestOfSearchModifier: Bid adjustment for rest-of-search placement.
TopOfPageClickShare: % of clicks from top-of-search placement.
ProductPageClickShare: % of clicks from product detail pages.
AdGroupId: ID of the associated ad group.
AdGroup: Name of the ad group.
AdGroupStatus: Current status of the ad group.
Target: Keyword or ASIN being targeted.
TargetStatus: Active or paused status of the target.
BidMarketplaceCurrency: Bid amount in marketplace currency.
KapoqBid: System-recommended bid value.
MatchType: Keyword match type (e.g., broad, exact).
ExpressionType: Expression method used in targeting.
KeywordType: Type of keyword (e.g., branded, generic).
ProductTargetType: Product targeting classification.
MaxAcos: Maximum acceptable advertising cost of sale.
Currency: Currency code of the marketplace.
Strategy: Campaign strategy or optimization approach.
BudgetGroup: Budget grouping label.
SalesChannel: Amazon marketplace (e.g., .com, .ca).
Account: Seller or vendor account identifier.
Brand: Brand associated with the ad.
IsAccountActive: Indicates if the account is active.
IsBrandActive: Indicates if the brand is active.
LastUpdated: Timestamp of the last data refresh.
2. Advertising Ad Group Data
Aggregated performance at the ad group level.
Same metrics as above (excluding
Target,TargetStatus, etc.), excluding targeting-specific fields.
3. Advertising Campaign Data
Top-level campaign performance summary.
Same campaign-level fields as above, excluding group- or target-level details.
4. Amazon DSP Data
Display advertising performance both on and off Amazon.
Advertiser: Name of the advertiser or DSP account.
Account: Linked Amazon account.
Brand: Brand running the DSP ad.
Date: Date of the report.
Order: DSP order identifier.
LineItem: Line item within the order.
Creative: Creative asset name.
CreativeSize: Size of the creative ad.
CreativeType: Type of creative (e.g., display, video).
TotalCost: Total DSP spend.
Impressions: Number of ad views.
Clicks: Number of user clicks on the ad.
TotalDetailPageViews14d: Product page views in 14-day attribution window.
TotalAddToCart14d: Adds to cart over 14-day attribution.
TotalSales14d: Revenue within 14-day attribution.
UnitsSold14d: Number of units sold in the 14-day window.
Purchases14d: Number of purchases within 14 days.
DetailPageViews14d: ASIN-level detail page views.
AddToCart14d: Adds to cart per ASIN.
NewToBrandPurchases14d: Purchases from new customers.
TotalNewToBrandUnitsSold14d: Units sold to new customers.
NewSubscribeAndSave14d: New subscriptions started.
TotalUnitsSold14d: Total units sold across all ASINs.
TotalPurchases14d: Total purchases across all ASINs.
TotalSubscibeAndSaveSubscriptions14d: Total subscriptions started.
Sales14d: Total attributed sales in 14 days.
5. Amazon Product Level Sales Data
Daily product sales at the ASIN or SKU level.
Date: Sales record date.
Account: Account identifier.
Brand: Associated brand.
SKU: Seller's stock-keeping unit.
ASIN: Amazon Standard Identification Number.
ParentASIN: Grouped parent ASIN if applicable.
TotalQuantity: Number of units sold.
TotalSales: Total revenue generated.
6. Amazon Seller Traffic
Customer interaction with Seller Central ASINs.
Date: Record date.
Account: Seller account name.
ASIN: Amazon product identifier.
ParentASIN: Associated parent ASIN.
BuyBoxPercentage: % of time seller had the Buy Box.
PageViews: Total page views including repeats.
Sessions: Unique visitor sessions.
7. Amazon Vendor Traffic
Traffic metrics for Vendor Central products.
Date: Record date.
Account: Vendor account name.
ASIN: Product identifier.
ParentASIN: Associated parent ASIN.
GlanceViews: Product detail page views on Vendor Central.
8. VendorPoAsin
Tracks vendor purchase orders at the ASIN level.
ASIN: Amazon product identifier.
OrderDate: Date the PO was created.
ItemName: Name of the ordered item.
Account: Vendor account name.
ReplenishmentCategoryTypeId: ID of replenishment category.
ReplenishmentCategoryTypeName: Replenishment category label.
AmazonVendorPOId: Internal Amazon PO identifier.
VendorPONumber: PO number issued to vendor.
AmazonVendorPOStatusTypeId: Internal status type ID.
AmazonVendorPOStatusTypeName: Status label (e.g., Submitted).
SubmittedQuantity: Quantity submitted in PO.
AcceptedQuantity: Quantity Amazon accepted.
ReceivedQuantity: Quantity received by Amazon.
UnitCost: Cost per unit.
UnitCostMP: Unit cost in marketplace currency.
PoCost: Total purchase order value.
PoCostMP: Total PO value in marketplace currency.
MarketplaceCurrencyTypeId: Currency ID used in marketplace.
MarketplaceCurrencyTypeName: Currency name (e.g., USD).
9. AsinFbaInventory
Tracks inventory held in Amazon FBA per ASIN; uses the most recent snapshot data available.
ASIN: Amazon product identifier.
MarketplaceProductId: Internal marketplace ID.
Account: Seller account name.
AfnFulfillableQuantity: FBA inventory available for sale.
ReservedFCTransfers: Stock reserved for transfer between fulfillment centers.
ReservedFCProcessing: Units in fulfillment center processing.
AfnInboundWorkingQuantity: Inbound items in working status.
AfnInboundShippedQuantity: Inbound items already shipped.
AfnInboundReceivingQuantity: Inbound items being received.
ReservedCustomerOrders: Inventory reserved for orders.
FCRemovalQty: Units marked for fulfillment center removal.
10. VendorInventory
Tracks vendor-managed inventory and forecast data per ASIN, including on-hand units (sellable and unsellable), purchase orders, cost metrics, and demand forecasts (P70–P90) within Amazon’s supply chain.
ReportingDate – Snapshot date of the inventory data.
Name – Product name.
Account – Vendor account name.
ASIN – Amazon Standard Identification Number for the product.
AmazonVendorDistributionTypeId – ID indicating Amazon's distribution type for the vendor.
OpenPurchaseOrderUnits – Units on open purchase orders not yet received by Amazon.
AverageVendorLeadTimeDays – Average days between PO creation and inventory receipt.
SellThroughRate – Rate of inventory sold relative to available stock.
NetReceivedInventoryCost – Total cost of inventory received by Amazon.
NetReceivedInventoryCostMP – Marketplace-adjusted cost of received inventory.
NetReceivedInventoryUnits – Total units received by Amazon from the vendor.
SellableOnHandInventoryCost – Cost of inventory currently sellable in FBA.
SellableOnHandInventoryCostMP – Marketplace-adjusted cost of sellable inventory.
SellableOnHandInventoryUnits – Units available and sellable in FBA.
UnsellableOnHandInventoryCost – Cost of damaged or unsellable inventory.
UnsellableOnHandInventoryCostMP – Marketplace-adjusted cost of unsellable inventory.
UnsellableOnHandInventoryUnits – Units on hand that are unsellable.
MeanForecastUnits – Average forecasted demand in units.
P70ForecastUnits – 70th percentile forecast: moderately conservative demand estimate.
P80ForecastUnits – 80th percentile forecast: more conservative demand estimate.
P90ForecastUnits – 90th percentile forecast: most conservative/high-confidence forecast.
CurrencyTypeId – Internal ID for the currency used.
CurrencyTypeName – Name of the currency (e.g., USD, EUR).
Data Sources Coming Soon:
1. Product Level Advertising Data
2. Accounting Data
Any questions or additional sources needed? Please feel free to reach out!