Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Average Cost Per Lead In Interface?

276 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I run a digital marketing company and I'm trying to have an element in an interface that reports the Average Cost Per Lead. For this I need to divide my total amount spend on paid ads with the amount of leads generated. Is there a way to do this?

1 Reply 1

Like you said, the idea is to compute: Generated Leads / Amount Spent. So you first need to associate leads with campaigns, figure out the cost of your campaign spending, etc. 

Here’s a very basic example that I put together

  • Each lead is associated with an ad campaign through a linked record field.
  • In the campaigns table, I count the number of leads and
  • divide the total spent by the count to get the average cost per lead per campaign.

You can consolidate most of this into a single field as well, or compute a rollup. From there, you can access the data in more straightforward manner inside the interface designer. 

Zemanir Airtable Consulting

www.zemanir.com