We first use the information in the data to create a total cost for each campaign in the Total Campaign Cost column. This is simply the number of clicks paid for, multiplied by the cost per click. We can then use Total Campaign Cost to calculate CAC by dividing Total Campaign Cost by the number of new customers acquired.
We can immediately see that Click-ad Campaign 1 was far more cost-effective than Click-ad Campaign 3.