In this tutorial, you will learn how to calculate the CPV or cost-per-visit of an ad campaign in Google Sheets.
How To Calculate CPV (Cost Per Visit) in Google Sheets
If you are running a digital marketing campaign, you may be wondering how much it might cost you to acquire a customer through online advertising. One of the key metrics you should measure is the cost-per-visit (CPV) of your campaign.
CPV measures the amount of money you spend for each visitor to your website. It is calculated by dividing the cost of the entire advertising campaign by the number of visits earned during that campaign.
For example, you may spend a total of $500 on online ads for a week and gain a total of 1000 new visits to your landing page. Our campaign’s CPV is equivalent to $500 / 1000 or $0.50.
Finding the CPV of your campaign can be a helpful metric for both short-term and long-term campaigns. Understanding the CPV can help you make adjustments to your advertising budget and determine whether you need to modify your marketing strategy to gain more traffic to your website or product.
In this guide, we will show you how to calculate your CPV in Google Sheets.
How To Find the Cost Per Visit in Google Sheets
Here’s how to find the Cost Per Visit of an ad campaign in Google Sheets.
Step 1
First, we must determine the total ad spend for the whole campaign.
In our example above, we’ve used both the Google Ads and Facebook Ads for our campaign. In total, we spent $400 across both platforms.
Step 2
Next, we must find the total number of visits your page has received in a specified time frame.
In our example, our analytics shows that our page gained 425 visits in the past week.
Step 3
We can calculate the CPV (cost per visit) by dividing the total ad spend by the total number of visits.
If we spent $400 on a week-long campaign and received 425 visits, we can say that the CPV of our campaign is around $0.94.
Summary
This guide should be everything you need to calculate CPV (cost-per-visit) in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.