Connect your data.
Build anything.
Kapoq Datalink is the pipeline, enrichment layer, and schema underneath every Kapoq application. Connect it directly to your BI tools, your AI assistants, and your custom apps — Amazon, Walmart, and Criteo data, refreshed daily.
Applications
AI Assistant
Kapoq MCP
Application
Kapoq Analytics
Reporting
BI Tools
Your Stack
Custom Apps
▲ ▲ ▲ ▲
THE FOUNDATION
Kapoq Datalink
01 · Pipes
API management
02 · Enrichment
Context & joins
03 · Schema
Normalized tables
▲ ▲ ▲ ▲
Data Sources
Source
Amazon Ads
Source
Amazon SPAPI
Source
Amazon DSP
Source
Walmart
Source
Criteo
Powers reporting, AI assistants, and custom apps
Looker Studio
Power BI
Tableau
BigQuery
Snowflake
MySQL
What is Datalink?
The pipes, logic, and context that power everything Kapoq.
Datalink is the data foundation behind Kapoq's products. It ingests Amazon, Walmart, and Criteo performance data, applies the same business context Kapoq uses internally, and serves it as clean, normalized, joinable tables — ready to plug into your stack.
Connect from Looker, Power BI, Tableau, BigQuery, Snowflake, or any tool that speaks MySQL. We handle the APIs, the error detection, and daily refreshes. You own the reporting.
Built once, used everywhere. Datalink is also the foundation that the
Kapoq MCP
is built on — same data, same logic, same security. Anything you can query with SQL,
you can also ask Claude, ChatGPT, or Gemini.
29+
Live data sources
Daily
Refresh schedule
Decades
Of API expertise
ISO 27001
Security certified
What's in the data?
Every metric that matters — joined together.
Over 29 data sources across advertising, sales, inventory, customer LTV, and operations. All normalized, all joinable, all refreshed daily. Here are the most-used:
Advertising
Campaign, Ad Group & Target
Spend, sales, ACoS, ROAS, NTB — sliced however you need, down to keyword and ASIN.
Advertising
Search Term & Product Ad
Customer queries that triggered ads, plus performance at the individual creative and SKU level.
DSP
DSP Performance
Order, line item, creative-level spend, impressions, clicks, and 14-day attributed sales.
Sales
Total Sales by SKU
Daily revenue and units sold across Seller and Vendor accounts — the foundation for TACoS.
Sales
Seller & Vendor Sales by ASIN
ASIN-level revenue, category rank, returns, and shipped COGS across both selling channels.
Traffic
Seller & Vendor Traffic
Sessions, page views, Buy Box %, and glance views — the inputs to every conversion metric.
Inventory
FBA & Vendor Inventory
On-hand, inbound, reserved, removal, plus P70/P80/P90 vendor forecasts for restock planning.
Inventory
Vendor Purchase Orders
Submitted, accepted, and received quantities at the ASIN-PO level — tracked over time.
Customer
LTV Order & Customer
Raw orders, first/last purchase, repeat rates, and lifetime value at the buyer-email level (Sellers).
Promotions
Coupons, Promos & Subscribe & Save
Lightning Deals, coupon redemptions, subscription revenue, and S&S forecast windows.
Reference
Account, Brand & ASIN Reference
Clean lookup tables for joining everything together without messy manual SKU maps.
Operations
Goals, Returns, Other Sellers
Monthly goal snapshots, return reasons with customer comments, and Buy Box competitor tracking.
That's a sample of what's most-used today — but new sources are added to Datalink continuously, and you can access them as soon as they're available. View the full schema →
More than just data
The context behind every row.
Raw API data is just numbers. Datalink adds the business logic that turns those numbers into something you can actually report on — brand-vs-category classifications, your own goals, your tags, and a unified product view across channels. It's the same context layer Kapoq's own analytics depend on.
Keyword classification
Brand. Non-brand. Category.
Every search term and target classified automatically — so you can analyze brand defense, conquest, and category capture as separate buckets, not one undifferentiated blob of ad spend.
"your brand name"
"category term"
"competitor brand"
"brand + product"
"generic"
Your goals
Your goals, in the data.
The brand and account-level goals you set in Kapoq are available through Datalink, making it easy to benchmark actual performance against target in any report or dashboard.
22%
Cross-channel
One model. Every marketplace.
Walmart metrics map to the same columns as their Amazon counterparts wherever they exist, so cross-marketplace aggregation just works. We also pre-aggregate the heavy datasets — the orders feed rolls up to daily sales, for example — so reporting stays fast without you doing the lift.
Amazon
$48,210 · 1,420 u
Walmart
$12,640 · 380 u
→
Cross-marketplace roll-up
$60,850 · 1,800 u · same columns, no joins required
Tags & taxonomy
Your taxonomy, in the data.
Tags, tag groups, budget groups, event stakes — every internal label you've set up in Kapoq lives in the data, so filters and segments in your reports work the way your team already thinks.
tag_group: "Launch ASINs"
tag: "Hero SKU"
budget_group: "Core Brand · Sponsored"
event_stake: "Prime Day '25"
What you can build
One foundation. Endless applications.
Datalink is built to power anything you'd want to do with your Amazon, Walmart, and Criteo data — from polished agency reports to AI workflows to entirely custom internal tooling. Here's what brands and agencies are doing today:
Reporting · BI
Dashboards your way
Power Looker Studio, Power BI, Tableau, Hex, Mode — any SQL tool — with the same data behind Kapoq's own reports. Start from our templates or build from scratch.
See the Looker demo →AI · Natural language
Ask in plain English
The Kapoq MCP plugs Claude, ChatGPT, Gemini, or your own agent directly into Datalink. Same tables, same security — conversational interface for the rest of your team.
Explore the Kapoq MCP →Custom · Automation
Build your own
Read-only SQL access to drive internal tools, Slack alerts, profitability calculators, forecasting models, or anything else your team has been wishing for. Your stack, your call.
Talk to us about your use case →Save yourself the hassle
Years of API work, packaged.
Brands and agencies who try to build this in-house find the same thing: the data is a moving target. Amazon's APIs change constantly — SPAPI alone shipped six breaking changes last year — and one senior engineer can spend most of their week just keeping the pipes from breaking. Datalink delivers the same pipeline for a fraction of what it would cost to even consider building it in-house.
Build it yourself
Constant maintenance, fragile pipelines.
- A full-time senior dev dedicated to API maintenance
- Amazon ships API changes faster than you can patch
- Silent data errors that surface in reports weeks later
- No context layer — raw rows you have to enrich yourself
- Every new data source means another integration project
Kapoq Datalink
Maintained for you. Enriched on day one.
- Decades of API expertise built into every table
- Daily refresh, so your reports are always current
- Automated error detection catches issues before you do
- US-hosted, IP-allowlisted, ISO 27001
- Brand terms, goals, tags, and cross-channel data on day one
- New sources added continuously — you gain instant access
How it works
From source API to your dashboard.
Datalink runs as a managed pipeline with a read-only MySQL connection at the end. Four stages, all maintained by Kapoq — so you connect once and never think about it again.
01
EXTRACT
From every source
Amazon, Walmart, and Criteo APIs — pulled daily on a managed schedule.
02
NORMALIZE
Into one schema
29+ tables with consistent fields, types, and join keys.
03
ENRICH The Kapoq Edge
With business context
Brand terms, goals, tags, and cross-channel data — on the rows, ready to query.
04
SERVE
Dashboards · MCP · Custom Apps
Read-only MySQL connection feeding your dashboards, the Kapoq MCP, or any custom app you can build.
Built on Datalink
Same data. Plain-English questions.
The Kapoq MCP is the most popular application built on top of Datalink. It plugs Claude, ChatGPT, Gemini — or any agent your team has built — directly into the same enriched data, so anyone can get answers by typing a question.
you ›
Which ASINs are at risk of stocking out in the next 30 days?
queries datalink
asin_fba_inventory
total_sales_by_sku
12 ASINs at risk. Top exposure: B07XYZ123 —
11 days cover, $642/day, no inbound…
Security & Trust
Secure by design.
Datalink runs on US-based, leased infrastructure with strict internal data policies and scoped, IP-allowlisted access. Your data isn't a black box — you can talk to our CISO whenever you want.
ISO
27001
27001
ISO 27001 Certified
Independently certified information security management.
US
Hosted
Hosted
US-Based Servers
Leased from Ionos in the United States — no offshore data residency.
IP
Allowlist
Allowlist
Scoped Access
Whitelisted IPs and read-only credentials. Revoke any time.
CISO
On Call
On Call
Direct Security Contact
Have a security review? We'll connect you to our CISO directly.
Book a demo
Get your data flowing.
Tell us about your stack and we'll show you exactly how Datalink fits in — with a live walkthrough of the data, the enrichment layer, and the integration options for your tools.
