Field change Ready in Improvado
Shopify GraphQL: split ShopifyQL sales by new or returning customer
- Updated
- October 21, 2026
- Affected
- ShopifyQL Sales ShopifyQL
- What to do
- No action required. Add New Or Returning Customer to a ShopifyQL or Sales ShopifyQL extraction to start collecting it; existing extractions are unaffected until you add the field.
Improvado's Shopify GraphQL connector now ingests the ShopifyQL
new_or_returning_customer dimension, so a new
New Or Returning Customer property is available on the
ShopifyQL and Sales ShopifyQL reports. Use it to split sales
between first-time and repeat customers.
What's new
- New Or Returning Customer: whether a sale came from a new or a returning customer. Values are New, when the sale is part of the customer's first order with your store, and Returning, when the customer had ordered from your store before.
Good to know
- Adding the property splits each period into one row per customer type, so an extraction returns more rows. Additive metrics such as Gross Sales, Net Sales and Orders add up to the same totals as before.
- Rates, averages and customer counts, such as Average Order Value, Returning Customer Rate and Customers, are calculated within each row. Do not sum them across the New and Returning rows.
- Shopify provides this property for sales data, so pair it with sales metrics in a ShopifyQL extraction.
Nothing else changed
This is purely additive. No existing field was renamed, removed or recalculated, and existing ShopifyQL and Sales ShopifyQL extractions keep working unchanged.