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