If you are a client of PPC agency, it can be hard to follow, what is going on with your PPC campaigns. In most cases PPC clients don´t have even time for this. For all busy PPC clients I prepared simple table to protect your PPC interests.
PPC profitability table to download:
PPC PROFITABILITY TABLE, Google Sheet format.
You can easily copy table to your drive and share with your PPC agency.
Or you can download the table in excel format.
The table is easy to use and will not take time even to most busy PPC clients.
It contains most significant data - PPC profitability indicators.
Simply enter PPC costs and PPC revenues. All PPC profitability indicators will generate automatically.
How to use PPC profit table:
The table focus on 2 important areas of PPC results:
Comparison in time:
At first, we will enter data for previous year and previous periods. This is important.
For example: The profit in January 2018 is 2500 USD. This can be a fine number. But did the PPC results improved? If in January 2017 we made PPC profit 3500 USD, it can indicate a problem.
Comparing the results in time, we can say if PPC results are improving or not.
PPC profitability indicators:
We use few PPC indicators. This will help the PPC clients and PPC agency to have a better picture.
PPC costs - advertising cost of Google AdWords or Facebook ads. In table this is without PPC agency fee, but you can simply add it.
PPC revenues - revenues of Google AdWords or Facebook ads.
Generated PPC indicators:
ROI - return on investments. Formula is: (PPC revenues - PPC costs)/PPC costs.
ROA - return on advertising. Formula is: PPC revenues/PPC costs.
Gross profit - formula is: PPC revenues - PPC costs. Fot the most PPC clients, gross profit is the most significant indicator.
1. This PPC table is a simple solution to a busy PPC clients.
2. You can use this table for Google AdWords, Facebook ads, Bing ads and any other PPC tool.
3. Why gross profit? PPC gross profit is used rarely in PPC advertising. Mostly CPA, ROA, ROI indicators are used. But in PPC advertising you can have great ROA, ROI or CPA, but the gross profit will decline.
Long term growth of gross profit is ideal PPC goal, but also the most difficult goal in PPC management.