The first time I calculated my ad spend, the shop was busy but sales weren’t
At 10 p.m. last Wednesday, I shut down my advertising dashboard in Hangzhou. Another 800 yuan had left my credit card. The ads had produced 120 clicks, but only two inquiries. My first thought was: maybe the copy wasn’t good enough? Then I put a number on every step and realized I wasn’t even close to breaking even. I panicked for a moment because tomorrow’s budget was still sitting in the account. I’ve been stuck here too: staring at clicks while forgetting the metric that actually determines the spend—the cost per qualified inquiry.
This isn’t new software; it’s an “ad return ledger”
Simply put, you calculate how much you spend per qualified customer, then compare the revenue those customers generate with your ad spend and other costs. The idea isn’t new, but plenty of small teams still haven’t used it properly. Lao Zhou runs corporate training in Chengdu. In November 2024, he paused two paid-promotion groups and kept only the one with faster replies and a higher conversion rate. Three months later, his cost per inquiry had fallen from 480 yuan to 210 yuan. The software didn’t make money for him; it helped him move money toward the more effective path. There’s no urgency to try it today—exporting the most recent campaign record is enough to start.
Replicate it today: 0 yuan, 30 minutes, no technical barrier
Replicating this today costs 0 yuan and takes about 30 minutes, with no coding required. First, open the platform where you bought ads and find the “spend” and “qualified inquiries or orders” fields. Record the last seven days of data. If you’re unsure what counts as a qualified inquiry, temporarily use “people who left contact details and genuinely discussed a purchase.” Don’t rush to include likes. Next, divide total spend by the number of qualified inquiries to get the cost per qualified inquiry. Multiply that by the conversion rate to estimate your customer acquisition cost, then compare it with the average profit from one customer. If your profit data is incomplete, hold off on increasing the budget so you don’t spend more while feeling increasingly anxious.
Decide whether to continue based on your current stage
If you’re just starting and spend less than 100 yuan per day, I’d test one small channel for seven days and track only one target: keeping the average cost per qualified inquiry below the ceiling I can accept, without getting distracted by impressions or clicks. If you already have one or two customers, I’d also record inquiry quality and pause the keywords or audiences that only bring spectators with no follow-up. If you’re scaling, I’d calculate results separately by product, channel, and audience, then set spending limits so the ads look lively without leaving cash flow tight at month-end. Not everyone needs this tool. If referrals already give you a steady flow, calculating the numbers is still enough; there’s no need to buy another software package immediately.