Revenue analytics and unit economics Calculating revenue or other metric for the last day/week/month

121. Calculating revenue or other metric for the last day/week/month

One of the most frequent words I say when talking about data is monitoring.

We monitor CPC, CPA, ARPU etc for each marketing campaign every day to make sure we make the best value from our marketing investment. When our business is growing and we have many channels, hundreds campaigns in each it’s quite hard to monitor all these time lines. It can totally drive one crazy.

The high level metric to monitor that our business is doing good is to look at marketing spend, revenues or any other metric in the last hour, 24 hours, week or month.

In the...

“well worth the money”
Sign up and check out 37 free lessons and exercises.

Anatoli Makarevich, author of SQL Habit About SQL Habit

Hi, it’s Anatoli, the author of SQL Habit. 👋

SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst 📊 and solve real-life challenges from Business, Marketing, and Product Management.

SQL Habit course is made of bite-sized lessons (you’re looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work. 🚀

“well worth the money”

Fluent in SQL in a month

Master Data Analysis with SQL with real life examples from Product Management, Marketing, Finance and more.
-- Type your query here, for example this one -- lists all records from users table: SELECT * FROM users
Loading chart... ⏳
Previous lesson: Other types of JOINs
Next lesson: Revenue analytics recap