Ad spend tied to Shopify revenue, in numbers that reconcile.
Live in 14 days. We build it, maintain it, and answer your questions.
Plans from $2,500/month. See pricing
Built on the tools your team already uses
- Meta
- Google Ads
- TikTok
- Shopify
- GA4
- Klaviyo
- BigQuery
- Snowflake
- Sigma
- Tableau
The Marketing Data Kit
A trusted foundation in 14 days, not 14 weeks.
Every client starts on the same tested foundation, configured to your business. It runs in your warehouse, and the code lives in your repository.
- Ad platforms
- Commerce
- Site and owned
- Your inputs
Connect
Ad platforms, Shopify, GA4, and Klaviyo in your own warehouse.
Model
Tested models for spend, orders, customers, and margin.
Report
Eight dashboards in Koladr, or in your Sigma or Tableau.
Ask and maintain
A fixed price on new work. Fixes are included.
The foundation every other request builds on.
See what’s in the kitThe problem
Every platform says it drove your sales.
They can’t all be right.
Add up what Meta, Google, and TikTok each claim, and you’ll often “sell” more than Shopify recorded. GA4 misses orders, and the spreadsheet that reconciles it all lives on one person’s laptop.
We give you one set of numbers you can defend, tied out to Shopify every month.
- MER
- Net sales ÷ ad spend. Every channel, one number.
- nCAC
- Ad spend ÷ new customers. What growth actually costs.
- CM3
- Profit after COGS, shipping, payment fees, and ad spend.
Illustrative figures from our demo brand.
Why Koladr
A data team you order like software.
Fixed prices, a request queue, and a senior lead accountable for every number.
- Type
- New dashboard page
- Estimate
- 4 credits
- Service level
- 3 business days
- Reviewer
- Account lead
Fixed prices, approved up front.
Every request gets a credit estimate before work starts. The estimate is the price.
MER · tied out
net_sales / ad_spend
-- net of refunds; excludes wholesale,
-- test, and influencer seeding ordersOne set of numbers you can defend.
Blended efficiency, new-customer cost, and contribution margin, tied out to Shopify every month.
Add TikTok to fct_ad_spend
#58 · wants to merge into main
- dbt build142 tests passed
- Tie-outspend within ±1%
- Review1 approval required
Your code, in your repository.
Every change arrives as a pull request in your GitHub. Nothing merges without review.
Why did MER dip the week of Aug 10?
Ask in Slack or the portal.
Every client gets a shared Slack channel. Each request gets its own thread.
Anomaly alerts and a weekly memo.
Included on Growth and Scale, so surprises reach you before the Monday review.
Every Koladr client gets
- 14 days
- from kickoff to a live foundation, tied out to Shopify and your ad platforms.
- 100%
- of deliveries reviewed by a lead before they reach you.
- 0
- credits used until you accept the delivery. Cancel before we start and they come back.
The Koladr stack
A stack you own, top to bottom.
Everything we build runs in your accounts: your warehouse, your repository, your BI. We bring the models, the tests, and the people who keep them running.
How delivery works
Ask whenever it comes up.
Delivered within your plan’s service level.
Raise a request in the portal or Slack. Your team scopes it, builds it, and tests it, and a lead reviews the work before it reaches you.
- 01You submit a requestAny time, in the portal or your Slack channel, with whatever context you have.
- 02We build itAn engineer on your account picks it up, builds it, and tests it against your data.
- 03A lead signs offYour lead checks the numbers and delivers, with a note on what changed.
Turnaround is your plan’s service level, in US business days from estimate approval: 5 on Launch, 3 on Growth, 2 on Scale.
Dashboards
Are we growing profitably?
Answered from day 14.
See all eight workbooks- Executive overview
- Channel performance
- Budget pacing
- Customer cohorts and LTV
- Contribution margin
- Creative performance
- Site funnel
- Email and SMS
Luxfold · B2B paid media · sample data
Paid media · Executive summary
September 2026 compared with August
- Search pipeline was $483K in September, down 32% from August, on 5% less spend.
- Pipeline ÷ spend fell to 1.53× from 2.13×.
Paid search the only channels with attributed pipeline
Weekly search spend and pipeline
Pipeline by brand type
- Non-Brand$3.8K on $161K · 0.02×
- Brand$403K on $117K · 3.46×
- Competitors$76K on $38K · 2.03×
A smaller version of the Executive summary we host for Luxfold, on the same code as client dashboards: switch the period and hover the charts. The full page adds the search funnel, conversion paths, segment tables, and campaign watchlists. Open the full page
What you can ask for
A menu, not a timesheet.
Common requests have a fixed credit range.
- Launch $2,500/mo · 20 credits
- Growth $5,000/mo · 45 credits
- Scale $9,500/mo · 90 credits
| Request | What you get | Credits |
|---|---|---|
| New dashboard | A new dashboard on your marts, in Koladr or your Sigma or Tableau. | 5–10 |
| New dashboard page | New charts or a page added to an existing workbook. | 3–5 |
| Add a supported source | Connect, backfill, and map a source the kit already supports. | 4–6 |
| Custom API pipeline | A scheduled pipeline for a source nobody supports yet. | 15–25 |
| New data model | A new or changed dbt model, tested and documented. | 3–8 |
| Custom mart + dashboard page | A new business-ready table with a page on top of it. | 8–12 |
| Metric or mapping change | Change a definition, channel mapping, or exclusion rule. | 1–2 |
| Ad-hoc analysis | A written answer to a specific business question. | 3–8 |
The Growth plan includes 45 credits a month. Anything not on the menu, describe it and we’ll scope it. Compare plans
Security
Built so you never have to hand over your data.
We work inside your systems, with access you control and can revoke at any time.
Your data stays in your warehouse
The kit runs in a BigQuery project or Snowflake account you own. We don’t host copies.
Your code, in your repository
Every change arrives as a pull request in your GitHub. Nothing merges without review.
People approve every change
A person on our team reviews every change before it reaches your systems or your team.
Engineers only see the clients they’re assigned to. Every staff sign-in requires multi-factor authentication.
How we handle access- Read-only access
- Revocable any time
- MFA for all staff
- Hashed customer emails
- DPA with every client
- Working toward SOC 2
See Koladr in action.
Walk through the kit on our demo brand. We’ll map your sources, your definitions, and your first dashboard.
We’re onboarding a small group of design partners at a reduced rate in exchange for honest feedback and a case study.