In the previous exercise about calculating CPA per marketing campaign you might have noticed that not all campaigns have users. There’s no surprise – some campaigns are just experiments and not always bring us users.
That’s what we’re trying to do here – learn everything about data and SQL so we can easily identify such campaigns and shut them down. It’s important not to miss those campaigns in our reports.
How can we lose a campaign in report
Let’s look at the possible query that calculates CPA per campaign:
WITH spend_per_campaign AS ( SELECT...