How to track 7-Eleven sales by store

Short answer: Most brands don't pull data from the retailer themselves; they get it through the distributor, at whatever level of detail they agreed. Ask for at least five fields: store code, area, week, units sold, and whether the product was in stock. Lay it out as a weekly table and remove stores without stock before you read anything. If you don't, zero sales from empty shelves look like shoppers refusing to buy.

Brands new to 7-Eleven often receive a monthly total. That tells you whether this month beat last month, not why. Store-level tracking answers the questions marketing actually needs: which areas responded to content, and which have a stock problem.

Where the data comes from

In-store sales come from the retailer's point-of-sale system and are passed to trading partners under their agreements. In practice, a brand selling through a distributor gets what the distributor receives and is willing to share. Some share weekly store-level data; some share only monthly totals. So raise it before signing, not when sales start to worry you.

Five fields you need

If you can, ask for deliveries into each store too. That shows where stock is piling up and where it runs out faster than it's replaced.

Lay out a weekly table

One row per store per week, plus columns you calculate:

1. In stock all week? From the stock status. If not, leave it out of averages.
2. Units per day: units sold divided by days in stock.
3. Area group: campaign area or non-campaign area.
4. Notes: in-store promotions, long holidays, anything that distorts sales.

An ordinary spreadsheet does the job; no special system needed.

Common misreadings

• Averaging in the zeros. Stores without stock drag the average down even though shoppers in stocked stores buy normally.
• Comparing totals before and after store growth. Totals rise because stores were added, not because marketing worked.
• Judging from one week. Weekly sales in a single store swing a lot; read several weeks, and read by area.
• No pre-campaign baseline. Without it you can't say whether what you see is high or low.

Turning it into decisions

• Areas where per-store sales rose more than in comparison areas after content ran are where to continue.
• Stores out of stock several weeks running go to the distributor for delivery fixes.
• Stores always in stock but with very low sales may have a placement problem; spot-check them.

Limits

• The data level depends on agreements between brand, distributor and retailer; this page doesn't describe the retailer's internal systems
• Reported stock status doesn't always match the shelf, so spot-checks are still needed
• This is a data method, not the result of a particular project

FAQ

Can I always get store-level data from the distributor? Not always; it depends on the agreement. If you can't get every store, ask for area-level data at least for the areas where you'll campaign.

How often should data come in? Weekly after listing and during campaigns; fortnightly once sales are stable.

How does store data help on TikTok? It sets ad targeting to areas with stock, and lets you compare sales before and after videos go out in those areas.

Sources

• Subpayanunt on FMCG distribution strategy (sell-in, sell-out): https://www.subpayanunt.com/post/distribution-strategy-fmcg-thailand
• Targeting TikTok ads where the stock is: https://www.flowupth.com/en/insights/tiktok-ads-where-stock-is
• Measuring with test and control areas: https://www.flowupth.com/en/insights/test-vs-control-stores

Related guide: Listed in 7-Eleven Thailand but Not Selling?

Get Flowup to help: Listed in 7-Eleven Thailand but not selling? Fix it before delisting

What Flowup can do for you: Services · Contact Flowup · Insights