Joy data in Shopify Analytics

Use Joy loyalty data — Point Balance and VIP Tier — as filters and columns inside Shopify Analytics reports.

This feature is available for Essential plan and above.

What is this feature?

Shopify Analytics can now recognise Joy data — both loyalty metafields (Point Balance, VIP Tier) and Joy tags (engaged members, assisted orders, referral activity) — as native filter and column options. You can build custom reports that combine store data (orders, revenue, sessions) with loyalty data, all inside Shopify admin. No export, no spreadsheet join, no external tool required.

The same data also powers ShopifyQL for advanced reporting. Joy ships ready-made templates so you don't have to write queries from scratch — see ShopifyQL templates below.

Why you should use this feature

Before this feature, comparing loyalty performance against store performance meant exporting data from Joy, exporting again from Shopify, and joining them in a spreadsheet. Now both data sources live in the same report — you can slice revenue by VIP tier, track retention by point balance, or target campaigns without leaving Shopify admin.

Common use cases:

• Revenue by VIP tier — see how much revenue Gold tier contributes vs. other tiers

• Retention by tier — compare repeat-purchase rate between Bronze, Silver, Gold

• Win-back targeting — filter customers with a high point balance but no recent order

• Top spenders by tier — build a customer list for a VIP-only campaign

• AOV by tier — verify whether higher tiers actually spend more per order

Requirements

• Joy plan: Essential or above

• Show metafields on Shopify admin must be turned on in Joy (see Metafield Settings)

How to set up

1

Turn on "Show metafields on Shopify admin" in Joy

Go to Joy → Settings → General and turn on Show metafields on Shopify admin. Full setup: Metafield Settings.

Once on, Joy fields (Point Balance, VIP Tier) are automatically registered with Shopify Analytics — nothing else to click.

2

If you had this setting on before the Analytics update — re-sync once

Turn Sync metafields from Joy to Shopify off, then on again. This one-time refresh registers Joy fields with Shopify Analytics.

3

That's it — Joy fields are now in Shopify Analytics

Joy fields (Point Balance, VIP Tier) appear as filters and columns inside any Shopify report. The fastest way to start using them is the ShopifyQL templates library described below.

Quickest way: ShopifyQL templates

ShopifyQL is Shopify's query language for custom reports — powerful but with a learning curve. To skip the writing, Joy ships a ShopifyQL templates library you can launch into Shopify Analytics with one click.

Open Joy → Analytics and click ShopifyQL templates in the top-right (chart icon). A modal opens with two tabs: Analytics (ShopifyQL queries) and Customer Segments (Shopify segment queries).

Joy Analytics → ShopifyQL templates button

For each template you can:

• Open in Shopify — launches the query directly in Shopify Analytics (or Shopify Customers → Segments) with everything pre-filled. No copy-paste needed.

• Copy query — copies the ShopifyQL string to your clipboard if you want to tweak it before running.

Templates use your shop's actual tags and prefix — Joy reads your custom Joy-assisted tag, redeemer tag, and discount prefix so the queries work on your store as-is. Recommended templates (most useful starting points) appear with a Recommended badge at the top.

A few of the queries available today:

• Joy-assisted total sales, AOV, order count, sales over time

• Returning customer rate among Joy redeemers

• Year-over-year sales comparison

• New vs. returning customer split

• Top products bought through Joy

• Day-of-week order patterns

• Total Joy discounts given

• Per-VIP-tier sales and AOV

The library keeps growing — open it whenever you want a new angle on loyalty performance. Full ShopifyQL syntax: shopify.dev/docs/api/shopifyql.

The modal shows a warning banner if Show metafields on Shopify admin is off — turn it on first (Metafield Settings) so the queries can read VIP tier and point balance fields.

Test orders won't show up in Analytics. Shopify Analytics only counts real orders. If you're testing Joy + Analytics with draft orders or canceled test purchases, the report will look empty. Create a draft order, save it as a real order, then refresh Analytics after a few minutes.

Joy tags in Shopify Analytics

Beyond metafields, Joy also syncs customer and order tags into Shopify. Tags work as filters and segments inside Shopify Analytics, Customers, Segments, and Shopify Email — useful when you want to slice data without writing a query.

Tag	Applied to	Source feature
Joy loyalty member	Customers who interact with the loyalty program (Join, Sign up, Sign in)	Auto-tag engaged members
Joy-assisted	Orders + customers that used a Joy coupon	Add tags for orders and customers
Joy Referral	Orders placed via a referral link	Referrals — Advanced settings
Joy referral	Customers acquired through a referral	Referrals → Customer tagging
Joy referee	Customers who referred others	Referrals → Customer tagging

Tag names are configurable in each setting — the values above are the defaults.

Common use cases with tags

• Joy-assisted revenue tracking — Filter Sales by Joy-assisted tag to see total revenue from orders that used loyalty coupons. No separate "Export assisted orders" needed.

• Loyalty member behaviour — Compare AOV, repeat-purchase rate, or session conversion between customers tagged Joy loyalty member vs. untagged.

• Referral channel performance — Filter orders by Joy Referral to measure referral revenue, AOV, conversion rate.

• Acquired-through-referral cohort — Filter Customers by Joy referral tag to see lifetime value of referred customers vs. organic.

FAQ

I enabled the setting but Joy fields aren't in Shopify Analytics yet.

Two likely reasons:

1. You enabled Show metafields on Shopify admin before the Shopify Analytics integration shipped. Turn Sync metafields from Joy to Shopify off and on again to re-sync.

2. Shopify caches analytics schema — give it a few minutes, then refresh the Analytics page.

Why is VIP Tier missing but Point Balance is there?

VIP Tier field is only created when your VIP Tier program is active. Go to Membership → VIP Tiers and make sure the program is on, then re-toggle Show metafields on Shopify admin in Joy.

Can I use Joy fields in Shopify segments (not just Analytics)?

Yes. Once metafields are on Shopify, they also show up in Customers → Segments. You can build segments like "VIP Tier is Gold AND last order > 60 days" and use them for Shopify Email or any app that reads segments.

Does this cost extra?

No. This is part of Joy's metafield sync feature — no additional fee, no Shopify add-on required. It's included in the Essential plan and above.

Will this slow down my store?

No. Metafields are synced in the background and stored on Shopify's side. Analytics reads them natively, so there's no extra API call or storefront impact.