KPI Tree

Shopify Metric

Revenue

Gift Card Utilization Rate = Total Gift Card Value Redeemed / Total Gift Card Value Issued x 100

Gift Card Utilization Rate measures the proportion of total gift card value issued in your Shopify store that has been redeemed at checkout. It uses the gift card balance and redemption data Shopify records for every card sold or issued, comparing the value spent against the value originally loaded. A high rate means gift cards are converting into orders, while a low rate signals balances sitting idle in customer wallets.

Full guide: definition, formula, and benchmarks
ShopifyRevenue

Gift Card Utilization Rate

Gift Card Utilization Rate measures the proportion of total gift card value issued in your Shopify store that has been redeemed at checkout. It uses the gift card balance and redemption data Shopify records for every card sold or issued, comparing the value spent against the value originally loaded. A high rate means gift cards are converting into orders, while a low rate signals balances sitting idle in customer wallets.

How to calculate gift card utilization rate

Gift Card Utilization Rate = Total Gift Card Value Redeemed / Total Gift Card Value Issued x 100

Why gift card utilization rate matters for Shopify users

Gift cards are deferred revenue. Until a Shopify gift card is redeemed, the cash you collected sits as a liability against future orders, so utilisation tells you how much of that liability is actually turning into sales rather than ageing into unused balances. Tracking it keeps you honest about how productive your gift card programme really is.

A low utilisation rate points to friction worth fixing, whether that is poor reminders, confusing redemption at checkout, or cards bought as gifts that recipients never activate. Lifting the rate pulls forward revenue you have already banked and brings buyers back into the store, often at a higher basket size than their original purchase.

Understand and act on gift card utilization rate with KPI Tree

Sync your Shopify gift card and order data into your warehouse and compute Gift Card Utilization Rate in KPI Tree, dividing redeemed value by issued value across the period. Place it in a metric tree alongside average order value and checkout conversion rate so you can see how redeemed balances flow through to completed orders and overall revenue.

Assign RACI ownership so a named person, usually in retention or ecommerce, is accountable for the rate, and set a monthly review cadence in KPI Tree. Reviewing it regularly lets the team act on rising idle balances with reminder campaigns or checkout changes before the value goes stale.

Get started with your Shopify data

Query using MCP
MCP

Pull metrics from Shopify directly through the Model Context Protocol.

Data Warehouse
SnowflakeBigQueryDatabricksRedshift

Connect your existing warehouse where Shopify data already lands.

Professional Services
FivetranSnowflakedbt

Our professional services team can build you turn-key AI foundations in a matter of weeks. Data warehouse on Snowflake/BigQuery, ELT with Fivetran, all modelled in dbt with a semantic layer.

Explore gift card utilization rate across integrations

Empower your team to understand and act on Shopify data

Map what drives your metrics, measure progress at any grain, prove what works statistically, and deliver personalised action plans to every team member.

Experience That Matters

Built by a team that's been in your shoes

Our team brings deep experience from leading Data, Growth and People teams at some of the fastest growing scaleups in Europe through to IPO and beyond. We've faced the same challenges you're facing now.

Checkout.com
Planet
UK Government
Travelex
BT
Sainsbury's
Goldman Sachs
Dojo
Redpin
Farfetch
Just Eat for Business