Popular Posts 
News & Events 
Why spend money on marketing? To achieve a positive return on investment. If I put $1 in, how much do I get out? Does the return justify the risk? This is why Google Advertising or PPC is so powerful. You can estimate your return or ROI before you get involved in a campaign. And you can track and tweak as you go.
![]()
Even though search engine marketing is results oriented and completely measurable, many sites and tools given an inaccurate analysis of profit and ROI. I have seen tools that consider new revenue to be profit, many of which do not even consider the cost of the cost of goods. If you are not going to offer an appropriate measurement mechanism, then you should not have one at all. It is deceptive.
Let me walk you through how I run the numbers step by step…
First, download the spreadsheet that I use for this.
Know your revenue per customer (Rev). This is easy if you are a mortgage broker, a consumer software firm or anyone that has a product or service with a 1 time fee. This is a bit more work if you bring in a certain stream of revenues per customer. Then you need to know churn, average time of a customer, what typically a customer buys. The best is if you understand the notion of Lifetime Value of a Customer (LTV).
Know your average gross margins (GM%). GM% = Rev – COGS.
Estimate your cost per click (CPC). CPC = Average bid price over all clicks.
Estimate your conversion rate (CR%). CR% = Lead/Clicks
Estimate your quality lead rate (QLR%). QLR% = Quality Leads/Leads
Estimate your close rate (CloseR%). Close R% = Sales/Quality Leads
Estimate your search engine budget (Ad Spend) and your campaign management fees (Fee).
Now it is time to make some calculations:
Clicks per Month (ClickMonth) = Ad Spend/CPC
Leads per Month (LPM) = ClickMonth * Conversion Rate (CR%)
Quality Leads per Month (QLM) = LPM * Quality Lead Rate (QLR%)
Closed Sales per Month (CSM) = QLM * Close Rate (CloseR%)
Gross Margin per Customer (GMC) = Revenue per Customer (Rev) * Gross Margin (GM%)
Monthly Lead Cost (MLC) = Ad Spend + Fees
Cost per Lead (CPL) = MLC/LPM
Cost per Quality Lead (CPQL) = MLC/QLM
Now for what really matters:
New Sales per Month (RevM) = Rev * CSM
Cost per Sale or Action (CPA) = MLC/CSM
New Profit per Sale (PS) = GMC – CPA
New Profit per Month (PM) = PS * RevM
ROI% = PS/CPA * 100
Now this is something a businessperson can work with because it includes real cost per sale including your cost of good and your cost of sales. With search engine marketing these types of metrics are completely understandable and trackable. It’s why I got into this business.
Having this data in detail is very helpful to you and your search engine marketing agency, because they can control for certain steps in the process to help you arrive at your projections. Soumya (from our firm) has done a nice job defining the terms you should know about PPC or Search Advertising.
Different businesses will have to make some adjustments to fit their situation. If you need some help, please let me know.
Check out the spreadsheet I use with clients.
This is a work in progress, so comments are appreciated.
Could you recommend any specific resources, books, or other blogs on this specific marketing topic?