Contextflo Blog

The e-commerce analytics stack: Shopify + Klaviyo + GA + Stripe

Your data lives in four places. Here's how to query across all of them in one conversation without building a unified data model.

May 12, 20263 min readVivek Sah

Your e-commerce data lives in four places: Shopify for orders, Klaviyo for email, Google Analytics for traffic, and Stripe for payments. To answer “which email campaign drove the most revenue last month?” you need data from all four. Here's how to set that up in an afternoon.

E-commerce analytics stack setup

The stack

1Shopify + Klaviyo → Airbyte → your warehouse (BigQuery or Snowflake)
2Stripe + Google Analytics → Contextflo (direct API connection)
3Warehouse + APIs → all queryable through Claude in one conversation

Contextflo connects to both your warehouse (for Shopify and Klaviyo data synced via Airbyte) and directly to Stripe and GA via API. No need to ETL everything into the warehouse first. You can query across all sources in one conversation.

What you can now ask

“Which Klaviyo campaign drove the most Stripe revenue last month?”

“What's our blended CAC when I combine Google Analytics acquisition data with Stripe revenue?”

“Show me the customer journey: GA source → Shopify first order → Klaviyo email engagement → repeat purchase rate.”

“Which products have the highest refund rate in Stripe but the best reviews in Shopify?”

These are questions that used to require a data team to answer. Now anyone on your team can ask them in plain English and get an answer in under 5 minutes.

Why this stack works

Most e-commerce teams either build dashboards in each tool (fragmented view) or hire someone to build a unified data model (expensive, slow). This setup gives you a unified view without the unified data model. You ask a question that spans sources, and the AI figures out where to pull from.