Which Ad Brought the Sale? Tracking Revenue Per Meta Ad on WhatsApp

To track WhatsApp sales from Facebook ads, record which ad each chat came from at the start, tag the contact, log the outcome (booked, quoted, paid) and add the sale amount, then compare chats, bookings and revenue per ad. The ad that sends the most chats is often not the ad that brings the most money.

Why is it hard to know which ad brought the sale on WhatsApp?

It is hard because the ad ends at the tap on the WhatsApp button, and the sale happens later, inside a private chat that your ad dashboard cannot see. The dashboard shows chats started. It does not show who paid.

For the owner, this creates a familiar problem. You run three ads. The dashboard says Ad B brought the most chats. But your staff say the serious customers seem to come from Ad C. Who is right? Without a record that connects each chat to an ad and then to a sale, nobody can say, and the budget moves to whichever ad looks busiest.

This guide shows a simple way to fix it, step by step, using a sheet or your chat platform. For the wider ad-to-appointment path, read our beginner's guide to Click-to-WhatsApp ads, and for a broader take on measurement see WhatsApp ads ROI tracking for Facebook and TikTok. This post focuses on one question: revenue per ad.

What do you need to track revenue per ad?

You need four records for every chat: the source ad, the stage reached, the outcome and the sale amount. If any one is missing, the chain breaks.

That table is the whole system. Everything else is how to fill it in reliably.

Step 1: How do you tell chats apart by ad?

Give every ad a short, unique name and make sure that name is attached to each new chat. Without a label on the chat, you are guessing.

There are two practical ways to do it:

1. Pre-filled opening message. Click-to-WhatsApp ads can start the chat with a ready line. Write a different line for each ad, such as a different product name or code word. The customer sends it, and your system sees which ad they came from.
2. Platform capture. Some chat platforms record ad information automatically when the chat starts. Ask your provider whether yours does, and how it appears on the contact record.

Use the first method if you are unsure about the second, since it works with any setup. Meta describes the format in its guide to creating ads that click to WhatsApp.

Step 2: How should the chat be tagged?

Tag the contact with the ad name and the stage as the chat moves, so the record builds itself. A tag turns a conversation into a row you can count.

In an AI agent office, this is the job of the AI employees. The receptionist records the source, the sales agent notes interest and budget, and the booking agent marks a confirmed appointment. ChatsHero does CRM tagging from the chat context, so the tags are applied while the customer talks rather than by someone remembering later.

Illustrative example. Behind the scenes the contact would be tagged: source RAYA-C, stage: booked.

Step 3: Which outcomes should you log?

Log four outcomes only: booked, quoted, paid and lost with a reason. More categories make the sheet slow to fill and nobody keeps it up.

Lost reasons teach more than wins. In our own sales data, 76 contacts went silent with no clear reason, and 19 stopped when demo times were offered. Knowing why a lead was lost is what turns a tracking sheet into a to-do list, so add a lost reason from day one.

Step 4: How do you record the sale?

Record the sale amount against the same contact, on the day it happens. This is the step most businesses skip, and it is what makes revenue per ad possible.

How it gets recorded depends on how you sell:

• Online payment or transfer in chat: the amount can be captured from the payment proof or order record. ChatsHero supports AI Receipt Scanning and Google Sheets updates as custom workflows, so a payment slip sent in chat can feed the sheet. Confirm your own setup, since workflows are tailored.
• Counter or walk-in sale: staff must enter it. A simple rule helps: no invoice number without the contact's tag.
• Sale closed days later: keep the contact open until paid or lost, so the sale still counts to the original ad.

Be honest about the limit. An AI cannot see a cash payment at your counter. If staff do not record it, that revenue will be missing from the ad that earned it, and the ad will look worse than it is. For payment proof handling, see WhatsApp payment proof and COD in Malaysia.

Step 5: How do you read revenue per ad?

Read it in one table, once a week, from chats to money. The aim is to see the ad that earns, not the ad that looks busy.

Illustrative layout with invented chat counts. Fill in your own figures.

In that layout, Ad B has the most chats and the fewest payments. Ad C has the fewest chats and the most payments. Judged by chats, Ad B wins. Judged by revenue per ringgit of spend, Ad C probably does. The sheet makes the decision visible. For a simple spreadsheet build, our guide to a WhatsApp sales funnel in Google Sheets shows the columns, and Google's help pages on COUNTIF and in-cell dropdown lists explain how to count by ad and keep stage labels consistent.

What mistakes make ad tracking unreliable?

Four mistakes cause most bad numbers: unlabelled chats, inconsistent stages, unrecorded offline sales and judging too early.

1. Unlabelled chats. If half your chats have no source, the totals mean little. Fix the labelling first.
2. Inconsistent stages. One person writes 'hot', another writes 'interested'. Use a dropdown, not free text.
3. Missing offline sales. Make recording the sale part of closing it.
4. Judging too early. If your sales take two weeks to close, a three-day-old ad has not finished producing revenue. Compare ads after a full sales cycle.

Also be careful with personal data. A tracking sheet holds names and phone numbers, so limit who can open it and follow the Personal Data Protection Act. Share summaries, not the full list, with your ad agency.

Who needs revenue-per-ad tracking, and who can keep it simple?

Anyone running more than one ad into WhatsApp, or spending steadily, benefits from it. A business with a single ad and a handful of chats can track by hand with a notebook.

It matters most where sales are high-value and slow, such as property, cars, renovation and B2B supply, because the ad that wins on chats can be a long way from the ad that wins on revenue. In those trades, a sale may take weeks, and a salesperson, not the AI, closes it. The AI's job is to keep the record complete so the right ad gets the credit.

It matters least where an order is a single click and the sale is paid inside the ecommerce platform, since that platform already shows the order source.

How does a ChatsHero AI Agent Office keep the record?

ChatsHero, a Malaysian AI agent platform, runs a reporting agent alongside the receptionist, sales and booking agents, so tags, bookings and outcomes are collected as chats happen and summarised for the boss. Payment slips can feed a Google Sheet through custom workflows such as AI Receipt Scanning.

How the source ad is captured and shown on the contact depends on your setup, so ask to see it during the free 30-minute Zoom demo. Bring your current ads, and we will walk through how each chat would be tagged from first message to sale.

Frequently Asked Questions