We’ve made it We’ve learned everything we need to calculate ROI! We know how to work with subqueries, we know how to join tables together, how to group and count records or calculate sums.
These are ingredients of pretty much any metric and you should be feeling like finishing a marathon right now! All right, all right – there are a couple of kilometers left! See you at the finish line
Total revenue per campaign
Let’s start with the first ROI part – earnings. We’ll calculate it per campaign, to make sure it’s actionable – we can use it to...