SQL for Marketers

A learner invited you

4 lessons · Novice

Lesson 1 of 4

Select & Filter Campaign Data

Lesson 2 of 4

Join Channels to Revenue

About this study

“SQL for Marketers” is a free, 4-lesson study at novice, created with soclever, a personal AI teacher. Each lesson takes a few minutes and ends with a check-in question; finish the curriculum and you can take a certificate test to earn a diploma. Starting is free once you sign in — or generate your own study on any topic.

What you'll learn

  1. Select & Filter Campaign Data. Your marketing team has a table called campaigns with columns: campaignname, budget, startdate, and status. You need to pull Q4 data—October through December—for a board review.…
  2. Join Channels to Revenue. A JOIN in SQL combines rows from two tables when they share a matching value—it's how you connect "which ad channel brought in this customer" to "how much revenue did that…
  3. Segment Cohorts & Aggregate. You have a users table with signupmonth, channel, and converted (1 or 0). Your boss wants to know: which signup month and channel combo had the most conversions? One row per user…
  4. Build Attribution Windows. You have a touches table with customerid, touchpoint (email, ad, referral), and touchdate. You have an orders table with customerid, orderdate, and isrepeat. The question: which…

Questions this study answers

  • Write the WHERE clause that would filter the campaigns table to show only rows where budget is greater than 5000.
  • If your marketing table has the channel each customer came from and your revenue table has the total purchase amount per customer, what does the JOIN do?
  • If you GROUP BY signup_month and channel, then use SUM(converted), what does each row in your result represent?
  • If a customer had an email, then an ad, then a repeat purchase, how many times does that customer contribute to the counts in your aggregation—once, twice, or once per touchpoint type?

More studies to explore

Or browse all public studies.