CPC Fell but Sales Did Not? Six Metrics from Click to Qualified Lead + Free Advertising Funnel Data Template (Word)
A lower CPC only means each click costs less. It says nothing about intent, landing-page fit, qualification or sales follow-up. Reporting must move from platform efficiency to business outcomes; otherwise the cheapest campaign can become the most expensive waste.
Six stages so CPC does not dominate the report
Stage | Formula | Question answered | Warning |
|---|---|---|---|
1 Click | Media cost ÷ clicks = CPC | How expensive is traffic? | Cheap but wrong intent |
2 Visit | Engaged visits ÷ clicks | Did the page load and engage? | Speed or tracking loss |
3 Enquiry | Enquiries ÷ visits | Does the page drive action? | Spam or duplicates |
4 Qualified | Qualified ÷ enquiries | Are these the right people? | Inconsistent sales coding |
5 Quote | Quotes ÷ qualified | Can demand become opportunity? | Slow response or poor fit |
6 Sale | Won revenue or margin ÷ media cost | Is there a business return? | Incomplete attribution or payment |
Join the data within one reporting window
Ad platforms, GA4, CRM and finance often use different dates, time zones and attribution. Choose one reporting window and record media cost, click ID or UTM, enquiry time, qualification, quote and sale. Label platform-attributed revenue separately from CRM actuals. Apply one de-duplication rule to phone, WhatsApp and repeated submissions.
Worked example: cheap clicks can create expensive customers
Campaign A spends HK$10,000 for 1,000 clicks, a HK$10 CPC, 20 enquiries, four qualified leads and one sale: HK$2,500 per qualified lead. Campaign B spends the same for 500 clicks at HK$20 CPC, but produces 30 enquiries, 12 qualified leads and three sales: about HK$833 per qualified lead. This is an illustrative calculation, not an Allua client case.
Write down the qualification rule
Qualification should not depend on each salesperson's instinct. Define target geography, need, budget range, timing, decision role and valid contact. Keep an unable-to-assess status rather than forcing a classification. Audit a sample monthly so team members apply the same rule.
When to send offline outcomes back
If the platform sees only form submissions, it may find more people who submit easily rather than people who buy. Google Ads supports offline conversions and enhanced conversions for leads to connect later qualification or won outcomes. Clean CRM statuses, consent, first-party data and match keys first; faster imports amplify bad data if the foundation is weak.
Hong Kong planning budget and timeline
Plan roughly HK$8,000–20,000 for a one-off media, GA4 and CRM diagnosis. A dashboard, UTM or click-ID design, qualification fields, offline imports and training may start around HK$25,000–80,000+. Ongoing analysis may start around HK$12,000–40,000 per month, excluding media and software. Allow 1–2 weeks for diagnosis and 3–8 weeks for integration and validation. These are Allua planning ranges, not fixed quotes.
Free resource: Advertising Funnel Data Template
Reconcile clicks, enquiries and qualified leads using consistent definitions. Get an editable Word version to adapt and reuse for your team.
Select “Advertising Funnel Data Template｜12項廣告漏斗數據核對表” in the form, enter your email, choose how you’ll use the resource and confirm your consent to receive both Word versions by email.
Update it on the same day each month and record numerator, denominator, source and anomaly explanation for every stage. Example: if enquiry rate is steady but qualified rate falls from 40% to 15%, inspect search terms, location, form choices and qualification coding before changing a button colour.
01 | Fix report dates, timezone and window
02 | Include all campaign media cost
03 | Align click and visit definitions
04 | Remove test and duplicate enquiries
05 | Include phone and WhatsApp sources
06 | Document qualification criteria
07 | Keep an unable-to-assess status
08 | Use CRM dates for quotes and wins
09 | Separate attributed and actual revenue
10 | Calculate cost per qualified lead
11 | Log anomalies and data gaps
12 | Choose one main monthly correction
Frequently asked questions
Is ROAS the only final metric? It is common in ecommerce, while B2B and long cycles also need qualification, quote, win rate, margin and time to cash.
How much data is enough? It depends on cycle length and decision risk. Mark tiny samples as directional instead of letting one large order overturn everything.
Is a difference between platform and CRM reports automatically an error? No. Attribution windows, time zones, cross-device journeys and duplicates all create gaps; document the rule.
Make advertising reports drive business decisions
Share media cost, campaigns, GA4, enquiries, qualification, quotes and sales fields. Allua can build a six-stage scorecard, anomaly rules and monthly decision process. Contact Allua to build an advertising business-outcome scorecard.
Creator partnership invitation
Creators interested in future Allua features or brand partnerships may use the creator partnership form. Submission does not guarantee selection or collaboration.
Sources and disclaimer
Sources: Google Ads offline conversions and enhanced conversions for leads; GA4 traffic-source dimensions. Attribution and policies can change, so verify before implementation. Example numbers only demonstrate calculations; actual costs and outcomes depend on industry, account and quotation.
Comments