Ecommerce KPIs: the definition each team needs to agree on
Nine ecommerce KPIs, each with its formula and the choice that moves the number: gross or net, shipping, tax, cancellations and attribution window.
8 min read
#ecommerce
20 articles
Fivetran pricing in 2026: how MAR billing works and what drives the bill
Fivetran bills each connection by monthly active rows. On Standard, the first million MAR costs $500 a month at list price, and the rate falls per connection.
8 min read
Windsor.ai alternatives for ecommerce data teams in 2026
Windsor.ai starts at $19 a month but caches data for about three weeks. Nine alternatives scored on seven criteria, with when to stay put.
9 min read
15 best AI tools for data analysis for ecommerce in 2026
A ranking of 15 AI tools for data analysis on criteria C1 to C7. Ten of the 14 competitors need a data warehouse you have already built.
9 min read
14 best CDPs and alternatives for ecommerce in 2026
13 CDPs and Precisian scored on seven data criteria. None of the 13 documents versioned, customer-approved metrics. Activation is where CDPs win.
9 min read
10 best ETL tools for marketing data in 2026
Nine ETL tools and Precisian scored on seven criteria. None of the nine documents versioned, customer-approved metrics; most leave modeling to you.
8 min read
Triple Whale alternatives: when Precisian fits, and when it doesn't
For a US Shopify brand, Triple Whale is usually the right call. Precisian serves e-commerce in Brazil, so it's the alternative only if you operate there.
8 min read
Triple Whale alternatives: 15 marketing attribution and analytics tools for 2026
15 Triple Whale alternatives ranked on seven criteria: data isolation, versioned metrics, MCP access, sources, who runs the data, and data ownership.
9 min read
Data governance for ecommerce teams: the minimum that actually works
Data governance records who decides what about each dataset. For ecommerce, the useful minimum is five records: owner, definition, access, retention, change.
6 min read
What counts as first-party data for an ecommerce brand, and where should it live?
First-party data is what you record in a direct relationship with your customer. Modeled conversions and platform audiences look like it and aren't.
7 min read
Meta Conversions API: what it recovers and what it doesn't fix
The Conversions API sends Meta the events your server recorded. Without a Pixel-matching event_id inside 48 hours, one purchase counts twice.
9 min read
Composable CDP vs data lake: which one an ecommerce brand needs first
A composable CDP activates customer profiles that live in your warehouse. A data lake keeps every source for analysis. One sends, the other explains.
7 min read
Data lake vs data warehouse vs lakehouse for ecommerce and marketing data
A lake keeps raw data, a warehouse keeps modeled data, a lakehouse puts transactions on open files. None of them defines net revenue.
8 min read
Fivetran alternatives for ecommerce data: what the pricing page leaves out
Fivetran bills per monthly active row and Airbyte by credit, but in Airbyte Cloud only 67 of 573 source connectors are maintained by Airbyte itself.
7 min read
The official Google Ads MCP server: what it answers and what it can't see
Google's Ads MCP server reads your account through GAQL, read-only. It reports what Google logged as a conversion, not shipped orders, Amazon sales or returns.
7 min read
Google Analytics MCP: why the numbers it returns are already modeled
The Google Analytics MCP server reads GA4 through the Data API, which follows your reporting identity. On Blended, the numbers arrive already modeled.
8 min read
Why text-to-SQL fails on marketing data, even when the query runs
The query that runs is the worst case of text-to-SQL: the wrong revenue column, the wrong window or a fan-out join returns a clean number and no error.
9 min read
LTV:CAC for ecommerce brands that also sell on Amazon
LTV:CAC divides the margin a customer returns by what it cost to win them. Selling on Amazon hides repeat buyers and platform data shrinks CAC.
7 min read
MER vs ROAS: measuring ad efficiency on revenue you actually booked
MER divides total booked revenue by total marketing spend; ROAS divides platform-attributed revenue by one platform's spend. Formulas and limits.
6 min read
Shopify's MCP servers are built for shopping, not for revenue questions
Shopify's official MCP servers act for buyers, customers and developers. None answers a merchant's margin-by-channel question; community servers fill that gap.
8 min read