How to measure WhatsApp deals group results (weekly spreadsheet)

Posting deals every day without measuring is like driving without a dashboard: you'll get somewhere, but you won't know if you're burning more fuel than you need to. This guide shows which numbers to track in your WhatsApp deals group, how to track clicks and sales, and a simple weekly spreadsheet to decide what to keep, cut and test.

The short answer: track members (joins and exits), clicks per deal, sales or commissions and replies from the group. For clicks, use links that count visits (your affiliate program's dashboard, UTM parameters or a link shortener with stats, where allowed). Pull everything together once a week in a spreadsheet and make one decision a week based on it.

The metrics that matter in a deals group

You could measure dozens of things. If you're starting out, these six already answer the questions that count: is the group growing, are people paying attention, and are the deals selling?

The deals group funnel

Every deal goes through a funnel. Seeing where people drop off tells you where to act:

From these stages come three simple calculations you'll use every week:

• Clicks per member = clicks this week ÷ members. Tells you whether the group is paying attention;
• Conversion rate = sales ÷ clicks. Tells you whether the deals that grab attention also sell;
• Revenue per deal = commission (or revenue) ÷ deals sent. Tells you whether sending more deals pays off.

How to track clicks and sales

If you don't know how many people opened each link, all you have is a hunch. There are three ways to track, and you can combine them:

Affiliates: use the dashboard and split by group

If you're an affiliate, your program's dashboard is the source of truth for sales and commissions. Commissions usually go through a validation period before they're paid out, so record estimated and confirmed commission separately. How and when you get paid varies by program, so check the current terms on the official site.

If you run more than one group, try to create different links for each one, if your program offers a way to label the source (some call it a tracking ID or sub-ID). That way you find out which group earns more.

Your own store: UTM on every link

If you sell through your own store, UTM parameters on the link show in Google Analytics where each visit and sale came from. A simple pattern for groups:

https://yourstore.com/product-x?utm_source=whatsapp&utm_medium=group&utm_campaign={GROUP-NAME}&utm_content={PRODUCT}-{DATE}

Example:
https://yourstore.com/air-fryer-4qt?utm_source=whatsapp&utm_medium=group&utm_campaign=home-deals&utm_content=airfryer-1003

Always use lowercase, no spaces, and keep the same pattern on every link. The full walkthrough, including how to read the reports, is in UTM tracking links for WhatsApp.

Resellers: when orders come in through private chats

If your deals end with "message me to order", there's no link to count clicks. In that case, your private chats are your funnel. Three simple habits fix it:

• Ask for a keyword: "reply WANT IT" or the product code. Each of those messages counts as a "click";
• Ask where they saw it: if you have more than one group or also post on your status, ask quickly "did you see this in the group or on my status?";
• Log it right away: one line per order (date, product, group, closed or not). If you use WhatsApp Business, labels help you separate who ordered, who paid and who only asked.

At the end of the week, "messages received" takes the place of clicks and "orders closed" takes the place of sales. The spreadsheet calculations still work.

The weekly deals group spreadsheet

You don't need expensive tools. A spreadsheet with one row per week (and one tab per group, if you have several) does the job. Here's a template filled in with example numbers:

Reading the example: in week 2 the volume went from 28 to 42 deals, clicks barely moved, sales dropped and exits went up. In week 3, with 21 more carefully chosen deals, exits fell and conversion rose. The takeaway for this example group: more deals didn't bring more sales. That's the kind of insight the spreadsheet gives you.

Week | Group | Members (end of week) | Joins | Exits | Deals sent | Clicks | Sales | Estimated commission | Confirmed commission | Clicks per member | Conversion | Best deal | Worst deal | Decision for the week

One tab per deal (optional, but valuable)

If you have the time, also log each deal: date, time, category, price, clicks and sales. Within a few weeks, patterns appear: which category sells best, which price range converts, which time gets the most clicks. It's the foundation for testing what works in the best times to post deals on WhatsApp and how to write a deal message that sells.

The 20-minute weekly routine

1. 1
   Collect the numbers

   Members in the group, joins and exits, deals sent, and clicks and sales from your dashboard or Analytics.

2. 2
   Fill in the spreadsheet

   One row per group. Calculate clicks per member and conversion.

3. 3
   Find the best and worst deal

   Which one got the most clicks and sales? Which got none? Write both down.

4. 4
   Compare with last week

   Up, down or flat? Always look at the trend, not a single number.

5. 5
   Make one decision

   Just one: cut a category, change a time, reduce volume, test a format. Write it in the "Decision" column.

If you use a tool to send your deals, use its send history to fill in the "deals sent" column instead of counting by hand.

What to do with the numbers

Measuring only pays off when it turns into a decision. Here are some common situations and what usually helps:

If the group has been sliding for weeks, follow the full plan in how to revive a dead WhatsApp group.

Common mistakes when measuring results