A learnerinvited you

SQL for Marketers

8 min4 lessonsNovice

What you’ll learn

Write your first SELECT query to pull campaign names, budgets, and dates from a marketing table, then use WHERE to answer: which campaigns ran in Q4?
Connect campaign data to revenue outcomes using JOIN, so you can answer: which marketing channel drives the highest customer lifetime value?
Use GROUP BY and aggregate functions to build cohort analysis and funnels, answering: how many users converted by signup month and channel?
Combine filtering, joins, and aggregation to model multi-touch attribution, so you can answer: which touchpoint in the funnel matters most for repeat purchases?

Difficulty

NoviceBrand new to this

Teacher

About this study

“SQL for Marketers” is a free, 4-lesson study on sql for marketers at novice level, 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 exam to earn a diploma. Starting is free and needs no account — or generate your own study on any topic.

What you'll learn

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.…

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…

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…

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

How personal income taxes work: brackets, deductions, and filing — 4 lessons on How personal income taxes work: brackets, deductions, and filing (novice).

The Night Manager — 4 lessons on The Night Manager (novice).

NBA playoffs — Intermediate — 4 lessons on NBA playoffs (intermediate).