Shopify + Klaviyo
Klaviyo shows how each campaign and flow performed, and Shopify records every order, refund and unit cost. Ask what a campaign made after refunds and cost of goods, which flows bring buyers back, or which segments actually reorder, and get one answer that reads both. Querri copies Shopify and Klaviyo into one Library on a schedule and matches subscribers to customers by email address.
Querri only reads from Shopify and Klaviyo. It never changes an order, a product or a customer, and never sends a message or edits a list or flow. You approve Querri on Shopify's own screen and sign in to Klaviyo to approve read access, so no password or API key passes through Querri. SOC 2 Type II, HIPAA and ISO 27001:2022 certified.
Why Shopify and Klaviyo reporting gets hard
Each system does its own job well and reports on it well: Klaviyo on how campaigns and flows did, Shopify on what sold. The questions in between have meant an export from each and a spreadsheet to join them. Querri makes that one question.
Klaviyo credits a campaign with the orders placed after a click or an open. Shopify later records the refunds, returns and discounts on those orders. Say a campaign shows $40,000 in Klaviyo and half of it comes back in Shopify: neither tool shows both at once.
Margin by campaign needs unit cost for each variant, which sits in Shopify or your ERP. A send that sold well at a deep discount can look like the best campaign of the month.
A flow report counts the order the flow drove. Whether that buyer came back for a second and third order is in Shopify's order history, often well after the attribution window has closed.
Klaviyo knows who is in each segment. Shopify knows what those people bought. Reorder rate by segment means joining the two on email address.
Email and SMS sign-ups are in Klaviyo, the ad spend that brought them in is in Meta Ads, Google Ads and Amazon Ads, and the orders that followed are in Shopify.
What you can finally answer
Each one needs Klaviyo's view of the message and Shopify's view of the order: why that has been hard, and what Querri does with it.
Why it's hard
Klaviyo credits revenue to the campaign. Refunds, discounts and unit cost are in Shopify, so margin needs both, order by order.
With Querri
Querri matches each campaign's orders to Shopify, takes out refunds and discounts, and subtracts unit cost per variant. Tell it once in Facts & rules what contribution margin means for you.
Why it's hard
Flow reports count the order a flow drove. Retention is about the second, third and fourth order, months later, in Shopify.
With Querri
Querri reads who received each flow from Klaviyo and follows those customers' Shopify orders over time, so you can compare 90-day and 180-day repeat rates by flow. Keep the comparison on a dashboard that updates with each sync.
Why it's hard
Attributed revenue counts the orders Klaviyo credits to a message. Subscribers also buy without a recent click or open, and those orders appear only in Shopify.
With Querri
Querri matches subscribers to Shopify customers by email and totals their net orders, credited to a message or not. Store revenue per subscriber as a KPI and keep Klaviyo's attributed figure beside it on the same chart.
Why it's hard
Segment membership is in Klaviyo and orders are in Shopify, so reorder rate by segment has meant exporting both and matching them by hand.
With Querri
Querri reads segment and list memberships from Klaviyo, joins them to Shopify orders by email, and ranks segments by reorder rate and net revenue. Ask a follow-up, like the same view for SMS subscribers only, and it reuses the work.
Why it's hard
Sign-ups and consent are in Klaviyo, spend is in each ad console, and the first orders are in Shopify.
With Querri
Connect Meta Ads, Google Ads or Amazon Ads too, and Querri puts new email and SMS subscribers by month next to spend and first orders. Querri shows each platform's numbers as reported; it doesn't reassign credit between them.
Why it's hard
Paste two exports into a chat and each prompt joins them its own way. Two people get two answers.
With Querri
Link Querri to Claude or ChatGPT once. The assistant reads from your Library, uses your saved KPIs and rules, and respects each person's access.
Shopify + Klaviyo plus the rest
Shopify and Klaviyo together answer most retention questions. The ad platforms add what each subscriber cost, Stripe adds subscription renewals, and Google Analytics adds the sessions in between. They all land in the same Library.
Shopify + Klaviyo pair well with
Answers you can stand behind
Revenue per subscriber can fairly mean the revenue Klaviyo attributes to messages, or every order a subscriber placed in Shopify. Both are defensible, and they answer different questions. Save the one you plan on in Facts & rules and every chat, chart and dashboard uses it; when a question could be read either way, Querri says which reading it used. See how answers work.
Wake up to what changed
Each night Querri compares your KPIs with their own history, by flow, segment and product, and does the math rather than guessing. Anything worth a look is in your Inbox by morning. Querri never pauses a flow or edits an order; you decide what to change.
Retention dashboards
Describe the dashboard you want, or hand Querri a screenshot of the one your team uses now, and change it the same way. Campaign and flow results sit beside Shopify net revenue, refunds and margin, and each person can see only the rows that belong to them.
Reports you can stop rebuilding
Each campaign's orders after refunds, discounts and cost of goods.
See Facts & rules90-day and 180-day repeat rates for the customers each flow reached.
See dashboardsKlaviyo-attributed revenue beside every Shopify order from subscribers.
See KPIsEvery segment ranked by reorder rate and net revenue.
See reportsNew email and SMS subscribers each month beside spend by platform.
See advertising analyticsFlows, segments and repeat orders as a formatted Excel file every Monday.
See Excel toolsWhat comes over
Shopify brings its orders, catalog, customers, inventory and payout tables; Klaviyo brings profiles, lists, segments, events, campaigns, flows and their performance. Each lands in your Library and refreshes on its own schedule.
Among the tables from each side
Shopify orders sync by their last update, as often as hourly, and an edited order brings its lines and refunds along. Klaviyo profiles and events sync incrementally, and its other tables reload in full each time.
Querri reads every order a Shopify store has, not only the last 60 days, through bulk operations on Shopify's GraphQL Admin API. Klaviyo profiles and events load in full on the first sync, and campaign and flow performance cover the last 365 days.
Querri asks Shopify and Klaviyo only for read access. It never edits an order or a product, and never sends a message or changes a profile, list or flow.
You approve Querri on Shopify's own screen and sign in to Klaviyo to approve read access. No password or API key passes through the Connector Agent.
How to connect Shopify and Klaviyo
Open Connect and say "connect Shopify and Klaviyo," or pick each from the catalog.
Type the store as acme or acme.myshopify.com, then grant read-only access when Shopify asks. Installing from the Shopify App Store works too.
Klaviyo's own page lists the read access Querri asks for. Approve it there; nobody copies an API key.
Nothing loads until you say yes. Approve the first load and how often each side syncs.
Ask which segments reorder most. Querri tells you how it matched subscribers to customers.
Shopify + Klaviyo FAQ
Ask the Connector Agent to connect Shopify and Klaviyo, or pick each from the catalog. Approve read-only access on Shopify's screen, then sign in to Klaviyo and approve read access there. Approve the first load and a sync schedule for each, and the data arrives.
No. Querri doesn't move data between the two or change either one. It reads both into its own Library so you can ask questions across them. Whatever connects your store to Klaviyo today keeps doing its job.
From Shopify: orders, line items, refunds, returns, discounts, products and variants, customers, inventory and payouts. From Klaviyo, thirteen tables: profiles, lists, segments, list and segment memberships, metrics, events, campaigns, campaign messages, flows, campaign and flow performance, and catalog items.
On the schedule you choose for each side. Shopify incremental syncs can run as often as hourly. Klaviyo profiles and events pick up what changed since the last sync, and the other Klaviyo tables reload in full.
No. Querri only reads. It never edits an order, a product or a customer in Shopify, and never sends a message or changes a profile, list, segment or flow in Klaviyo.
By email address, which both systems store. If your team matches on something else, such as a customer ID you send to Klaviyo, say so once in Facts & rules and Querri uses it.
Querri matches the orders behind a campaign's revenue to Shopify and takes out the refunds and returns recorded there. Ask for it by campaign, flow or month, or keep it on a dashboard.
Klaviyo's campaign and flow performance come over as Klaviyo reports them, with revenue attributed to Placed Order. Revenue after refunds, margin and revenue from every Shopify order are separate figures that Querri works out from both systems, and it says which one an answer uses.
No. Querri doesn't run multi-touch attribution or media-mix models and doesn't reassign credit between channels. It shows Klaviyo's attributed revenue and each ad platform's reported numbers next to the orders and refunds Shopify recorded.
Yes. Connect them too, and spend by platform sits next to Klaviyo sign-ups and Shopify orders in the same Library, so cost per subscriber and spend against margin come out of one question.
Yes. Each Shopify store and each Klaviyo account is its own connection, and they all land in the same Library.
Yes. Link Querri to Claude or ChatGPT once. The assistant reads from your Querri Library, uses your saved KPIs and rules, and sees only what that person can see in Querri.
Querri is SOC 2 Type II, HIPAA and ISO 27001:2022 certified. You approve access on Shopify's and Klaviyo's own screens, so no password or API key passes through Querri, and your data never trains a model. Sharing and row-level access set which rows each person sees.
Keep exploring
It takes a few minutes to connect both, and Querri only reads your data.