# PPC Profit Calculator – Is Not Using an Agency Costing You Time and Money? Plug in the Numbers and See!

One legitimate concern that potential PPC clients have when choosing a search firm to manage their PPC, is the agency’s fees. These prospects may be considering managing campaigns themselves and while they may not achieve the same results as an Agency, removing a layer of fees might seem to trump the gains of a seasoned SEM professional.

My colleague Joanne, recently wrote a blog on helping e-commerce clients determine if they are profitable when they include SEER’s fees. She uses her calculator and the method she describes in her blog for the e-commerce clients (Page currently not available) she manages and in doing so she helps our client sleep better at night because they know even with SEER’s fees and their variable costs she is able to achieve increasing profitability.

The SEER team has recently enhanced this calculator to help both lead generation clients and e commerce clients determine profitability when all cost and fees are taken into consideration. The excel file is linked here, but will eventually be made into a widget on the SEER site.

The goal of this calculator is to help clients and potential clients determine with all fees included whether or not their paid search campaign is returning a profit.

To use this calculator you need the following information:

1. Monthly Budget
2. Set Up Fee (if applicable)
3. Commission or Flat Fee paid to the Agency
4. The average CPC for the account
6. Sales to Lead Ratio — for e commerce clients this will be 100%. For lead generation clients knowing this ratio is essential for evaluating the profitability of the account
7. Average Order Value
8. Variable Cost or Profit Margin

All other fields can be calculated with this given information.

1. Profit/Sale = Average Order Value — Average Variable Cost
2. Clicks = Total Budget/ CPC
5. Revenue = Sales * Profit per Sale
6. Monthly Fees to Agency = Flat Fee or Commission + “Setup Fee/12”
7. Total Cost = Monthly Budget + Cost to Agency + Variable Cost
8. Profit = Revenue(E) — Total Cost(G)

Let’s look at how this calculator can be used, with the following assumptions held constant.

1. Sales to Lead ratio = 25%,
2. Average order value = \$3,500
3. Profit margin = 25% or \$2625

Scenario 1: No Agency

Monthly Budget = 5K,
Set Up Fee = 0
Agency Fee = 0
Avg. CPC = \$5

Plugging in these assumptions into the calculator, as seen below the client is doing ok and able to generate \$1,562 in profit a month on his own without an agency.

Scenario 2 No Change in Performance with Agency

Monthly Budget = 5K,
Set Up Fee = \$6,000
Agency Fee = \$2,000 Flat fee
Avg. CPC = \$5

In the example below you can see that total profit for the month fell from \$1,562 to \$63 by adding agency fees with no improvement in performance. The conclusion from this example is that an agency better increase performance to justify their fees.

But as the following examples will demonstrate, if you were to choose a strong agency that can increase performance metrics, the results will improve your profitability.

Scenario 3: Agency with Improvement in Conversion Rate

Monthly Budget = 5K,
Avg. CPC = \$5
Lead Conv. Rate from 3% to 5%
Agency Fees = 1k Flat fee
Set Up Fee = 6K

This example illustrates how improving the lead to conversion ratio from 3% to 5% can change the profitability.

How can an agency increase conversion rate? At the onset, they will help you re-organize the account and will do extensive keyword research to identify keywords that have the potential to convert. They will then make sure that they organize these keywords into tightly themed groups, with ad copy that speaks to the keywords that you are targeting. They will also work with you to find the best pages to land these clicks on or recommend that landing pages be developed to target these keywords directly and ensure their ad copy includes any offers or benefits emphasized on the landing page.

Also, a strong agency will watch your account like a hawk and identify any keywords that have very low conversion rates using Google tracking or high bounce rates using Google Analytics. They may lower bids on these terms, or suggest a new landing page, or even eliminate these terms so more of your budget is available for the higher converting terms. Additionally, they will use Search Query reports to eliminate irrelevant terms you are being matched to by adding negatives to your account. Combined, this continual tweaking should influence your conversion rate in a positive way. They may also suggest landing page improvements and test these changes using the website optimizer to help develop the page that has the highest overall conversion rate.

These steps will not only impact your conversion rate, but may also increase your Quality Score, which in turn will influence the CPC you will have to pay for any given position. In other words, with a better quality score you may be paying less than your competitor for a better position. The impacts of quality score are not factored into the calculator example below, but is just another reason why not using an agency may be costing you money.

Plugging in the increase in conversion rate into the PPC calculator, illustrates how increasing your conversion rate, which results in more leads, which results in more PROFITABLE sales, may take your monthly profitability from \$1,563 in our original non agency scenario to \$4,438 with fees included

Scenario 4: Agency w/ Improvement in Conversion Rate and Account Expansion

Monthly Budget from 5k to10K,
Avg. CPC = \$5
Agency Fees = 1k Flat Fee
Set Up Fee = 6K