What does my customer base look like right now, split by active, lapsing, inactive and churned? How has that mix shifted against this time last year?
Grow revenueCustomer base healthWhat would you ask your customer data?
Executive
The state of the customer base, where growth is really coming from, and whether the top line is being bought with margin.
How much of this year's revenue came from customers I already had, against customers I acquired?
Grow revenueCustomer base healthAm I becoming more dependent on discounting to hold revenue? Show me discount penetration and depth over the last three years.
Grow marginDiscount strategyWhich of my top 20 revenue lines are actually losing money once discount and returns come off the cost price?
Grow marginProfitability analysisCompare customers who shop both online and in store against single channel customers. How many of each, and what is the annual spend difference?
Grow revenueChannel behaviourRank my categories by margin contribution rather than revenue. Where am I busy but not profitable?
Grow marginProfitability analysisWhich states and catchments are growing in customers and revenue, and which are quietly declining?
Grow revenueStore network & catchmentHow many people in my paid acquisition audiences are already my customers?
Reduce costAcquisition economicsHow much working capital is tied up in stock that has not sold in six months, and who would buy it?
Reduce costStock productivityAre we tracking to budget this quarter? If not, where is the gap coming from?
Grow revenueForecasting & planningWe are ahead of plan. Is that real demand, or is discount pulling sales forward?
Grow marginForecasting & planningIf churn continues at the current rate, what does my active customer base look like in 12 months?
Grow revenueForecasting & planningWhich acquisition source produces customers who come back, not just customers who convert?
Reduce costAcquisition economicsFinance
Margin by category, discount depth, returns cost and the value sitting in stock that is not moving.
Estimate gross margin by category using product cost against the price customers actually paid.
Grow marginProfitability analysisWhat share of units in each category sold at full price over the last 12 months?
Grow marginDiscount strategyWhich categories are growing in revenue but shrinking in margin?
Grow marginProfitability analysisShow me revenue by financial quarter for the last two financial years, on our financial year, not calendar.
Grow revenueTrading performanceWhat is the value of stock sitting in lines that have not sold in six months, and which customers would buy them?
Reduce costStock productivityWhat was the average discount depth by department during Boxing Day compared with the rest of the quarter?
Grow marginDiscount strategyWhat is my average order value by channel over the last 12 months, and which way is it moving?
Grow revenueTrading performanceWhat is net revenue per customer segment after discount and returns, not gross?
Grow marginProfitability analysisWhich stores are holding the most stock in my lowest margin lines?
Reduce costStock productivityWhich lines have a return rate above 20% and a margin below 30%? Every one of those sales costs me twice.
Grow marginReturns & cost to serveWhat does a new customer spend in their first 12 months, by the channel they first bought through?
Grow revenueAcquisition economicsBased on how last year's cohort behaved, what will the customers I acquired this quarter spend over the next 12 months?
Grow revenueForecasting & planningWhat is my realised price against list price by category, and where is the biggest leak?
Grow marginPricingWhat happens to revenue and margin if I hold the promotional calendar flat next year?
Grow marginForecasting & planningMarketing & CRM
Build the audience, send the campaign, and see what it did to revenue and to margin.
Which of my VIPs are going quiet before they churn, and what are they worth over the next 12 months?
Grow revenueRetention & churnBuild a winback audience: lapsing loyalty members who opened an email in the last six months, excluding anyone I have already sent a winback to this quarter. How many people is that?
Grow revenueAudience buildingHow big is my discount seeking segment, what share of revenue do they represent, and what is their margin against everyone else?
Grow marginSegmentation & personasOf the customers I acquired in the first half of last year, what share came back for a second purchase within six months?
Grow revenueRetention & churnWhich existing customers are sitting in my paid acquisition audiences? Build me a suppression list.
Reduce costAcquisition economicsWhich campaigns in the last 90 days drove the most attributed revenue, and which attribution method did you use?
Grow revenueCampaign measurementWhich campaigns drove revenue but destroyed margin once the discount was applied?
Grow marginCampaign measurementIf I cut one sale period from the calendar, which one contributes the least new customer activity?
Reduce costDiscount strategyHow many people on my named email list are not actually subscribed?
Reduce costGovernance & trustPlan my end of season sale: who to target, in what order, on which channels, and at what discount.
Grow marginDiscount strategyPush my Champions segment to Klaviyo, Meta and Google Ads.
Move fasterAudience buildingWhich of the customers I acquired this quarter are least likely to come back, and what did they buy first?
Grow revenuePredictive & next best actionRank my lapsing customers by how likely they are to respond, ahead of how much they used to spend.
Move fasterPredictive & next best actionWhich one-time buyers are most likely to buy again if I reach them now?
Grow revenueRetention & churnBuild a lookalike seed from my highest value customers, seeded on value rather than recency.
Grow revenueAudience buildingWhich customers will buy at full price, and which will wait for the sale?
Grow marginPredictive & next best actionWhich discount level acquires customers who go on to buy at full price?
Grow marginPricingEcommerce
The full customer picture, online and offline, including what returns and discounting are doing to online profitability.
Which first-purchase category predicts the highest lifetime value?
Grow revenueAcquisition economicsWhich categories over-index online against in store, and where is the biggest channel skew?
Grow revenueChannel behaviourOf customers whose first purchase was online, what share have since bought in a store?
Grow revenueChannel behaviourThe customers I acquired through my highest volume campaigns are not coming back. What did they buy first, and did they buy on discount?
Grow marginAcquisition economicsWhat is my online return rate against store return rate by category, and where is returns cost eating the margin?
Grow marginReturns & cost to serveOf the people who clicked an email in the last 90 days, what share bought within seven days and what did they buy?
Grow revenueCampaign measurementWhich products have high stock on hand and low online sell-through? Who would buy them at full price?
Reduce costStock productivityWhat is the average order value difference between orders placed during sale periods and outside them?
Grow marginDiscount strategyWhich products are my high value customers likely to buy next season?
Grow revenuePredictive & next best actionDo customers in high density postcodes buy differently to low density ones?
Grow revenueSegmentation & personasWhat is this customer likely to buy next, and when?
Grow revenuePredictive & next best actionWhich categories do my customers never cross into, and what is that worth?
Grow revenueCross-sell & basketWhich acquisition channel produces the highest repeat purchase rate in the first six months?
Grow revenueAcquisition economicsWhich of my single category customers look most like my multi-category customers?
Grow revenueCross-sell & basketMerchandising & Buying
Range decisions grounded in demand, cost, stock cover and what discounting each line really needs.
What are the most common product categories that are purchased together in a single order?
Grow revenueCross-sell & basketRank my top 15 brands by margin per unit against average discount depth. Which brands am I subsidising?
Grow marginProfitability analysisI need to clear a set dollar value of aged stock. Which customer segment should I target, and what is the smallest discount that will move it?
Grow marginStock productivityWhat do customers buy next after a first purchase in my biggest category, and how long after?
Grow revenueCross-sell & basketWhich products have the highest return rate, and does it correlate with buying unseen online?
Grow marginReturns & cost to serveWhich subcategories rely on sale periods for more than half their annual volume?
Grow marginDiscount strategyWhich lines are overstocked in one region and selling out in another?
Reduce costStock productivityWhat depth should I buy this category at next season, based on demand and sell-through?
Reduce costForecasting & planningWhere are the gaps in my price ladder, and where is demand actually concentrated?
Grow revenuePricingWhich products could I hold at full price without losing volume?
Grow marginPricingWhich categories are trending down early enough for me to act before the season lands?
Move fasterForecasting & planningWhich products should I stop selling, and what would I lose in customers and margin if I did?
Grow marginRange rationalisationWhich of my low volume products are worth keeping because of who buys them or what they buy alongside?
Grow revenueRange rationalisationWhich products acquire customers who go on to become high value, even though the product itself barely makes money?
Grow revenueRange rationalisationIf I cut the bottom 20% of my range, what happens to revenue, margin and working capital?
Reduce costRange rationalisationWhich products am I carrying only because they have always been there?
Reduce costRange rationalisationRetail Operations
Store performance, catchment coverage, team productivity, and where stock is sitting in the wrong place.
Rank stores in my state by revenue over the last 12 months, and separately by new customer acquisition.
Grow revenueStore network & catchmentWe closed a store. What happened to its customers? Did they shift to the nearest store, move online, or stop buying?
Grow revenueStore network & catchmentWhich stores are discounting hardest, and what is that costing me in margin per transaction?
Grow marginDiscount strategyWhich stores are holding stock that is not selling in their catchment but is selling elsewhere?
Reduce costStock productivityGive me a sales assistant leaderboard for my store: revenue, average order value and units per transaction this quarter.
Grow revenueFrontline performanceWhich catchments have the lowest customer penetration relative to purchase activity? Where am I underweight?
Grow revenueStore network & catchmentHow many customers in my catchment have not shopped in 12 months but are still opening our emails?
Grow revenueRetention & churnWhich of my sales assistants convert the most single item baskets into multi item baskets?
Grow revenueFrontline performanceCompare the new store against the network average for its first six months: revenue ramp, average order value and repeat rate.
Grow revenueStore network & catchmentWhich stores have the most customers at risk of lapsing next quarter?
Grow revenuePredictive & next best actionWhat is my average units per transaction by store, and where is the upside?
Grow revenueCross-sell & basketGive me a demand forecast by state for next quarter.
Move fasterForecasting & planningWhich add-on has the highest attach rate, and which stores are missing it?
Grow revenueCross-sell & basketLoyalty
Whether the programme is buying loyalty or buying discount, and what it costs in margin to run.
Members against non-members: average order value, purchase frequency and 12 month retention. What is the actual value gap?
Grow revenueLoyalty economicsWhat is the overlap between my members and my discount seekers? Am I rewarding loyalty or subsidising discount?
Grow marginLoyalty economicsWhat is the margin cost of my member discount, and which tier earns it back?
Grow marginLoyalty economicsHow many members joined in the last six months, and through which store or channel?
Grow revenueLoyalty economicsHow many members have joined but never made a qualifying purchase?
Grow revenueLoyalty economicsDo members buy across more categories than non-members?
Grow revenueCross-sell & basketOf members whose email engagement has gone dormant, how many are still actively buying?
Grow revenueRetention & churnWhich member segment is most likely to buy full price stock I need to move?
Reduce costStock productivityWhich members are most likely to lapse before they next earn a reward?
Grow revenuePredictive & next best actionWhat is a new member worth over time, and how long until they earn back the cost of the joining offer?
Grow marginLoyalty economicsFor members who only ever buy one category, which second category should I lead with?
Grow revenueCross-sell & basketCustomer Service
Where fulfilment and returns are costing money, and which customers to reach before they walk.
How many orders are sitting unfulfilled right now, and what is the age distribution?
Move fasterFulfilment operationsWhich customers have had multiple delayed or unfulfilled orders in the last six months? Build the outreach list.
Grow revenueFulfilment operationsWho are my serial returners, returning more than 30% of what they buy, and what is their net revenue after returns?
Grow marginReturns & cost to serveWhat is my return rate by fulfilment type? Is delivery driving more returns than click and collect?
Reduce costReturns & cost to serveAre customers who hit a fulfilment problem less likely to buy again in the following six months?
Grow revenueRetention & churnWhich product lines have the highest return rate, and what is the cost of goods tied up in returned stock?
Reduce costReturns & cost to serveWhich orders are most likely to be returned, based on what is in the basket?
Reduce costPredictive & next best actionWhich of my at-risk customers had a service problem, and what is saving them worth?
Grow revenuePredictive & next best actionData, Analytics & IT
Give the business self-serve access with the rules applied, and get your own time back.
Marketing has asked me for a customer list segmented by purchase frequency and average spend. Can they just do this themselves?
Move fasterSelf-serve accessShow me the definition and the calculation behind our active customer count so I can check it.
Move fasterGovernance & trustWhich of my recurring reports can be replaced by a standing question?
Reduce costSelf-serve accessWhat is our average order value this financial year, excluding staff purchases and test transactions?
Move fasterGovernance & trustSplit my customers into intent segments and show me where they overlap.
Move fasterGovernance & trustWhat did last week's email actually drive in sales, and which attribution method did you use?
Move fasterCampaign measurementWhat is our net promoter score by store, and does it show up in repeat purchase rate?
Grow revenueCustomer base healthHow was the demand forecast produced, and what assumptions does it rest on?
Move fasterGovernance & trust.png)

