Marketing Analytics Path · Mission 1 of 25Starter

Quick question about that spring campaign

SELECT all customers and understand their basic attributes

Back to Marketing Analytics

The Brief

Alex ChenMarketing Managerslack-dm

Hey — can you pull the total number of customers we sent the spring email campaign to? Also what was the open rate? Marketing standup is in 30 min, just need a quick number.

You'll practice

SELECTLIMITData quality

Tables available

dim_customers

Hints (3)

Each hint you reveal reduces the XP you can earn. Try the query first.

Hint 1

The customer data lives in `dim_customers`. Use `SELECT *` with `LIMIT 10` to preview the first 10 rows without loading all 500

Hint 2

You need all 9 columns: customer_id, first_name, last_name, email, signup_date, city, state, age, gender

Hint 3

Make sure you're using `LIMIT 10` — without it you'll load all 500 rows. The query is just `SELECT * FROM dim_customers LIMIT 10`