Paid social CAC

Let's calculate paid social CAC. We previously looked at Follower Rate and Cost per Account Follow to measure performance in this channel. CAC gives us another tool to analyze how paid social marketing is performing. Examining the follower metrics and customer acquisition metrics let's us see how the channel performs at both tasks.

In this series of exercises, the data set contains a union, which stacks two data sets on top of each other - in this case, data sets for paid social and paid search. This enables fields from both datasets to be used at the same time in the same sheet.