Top of the Funnel
Kindled is a small direct-to-consumer brand, and its growth lead is building the first funnel report the company has ever had. A funnel is just the sequence of steps a shopper passes through — arriving, looking, carting, buying — and every percentage in the report is measured against the number of people who entered at the top. So before anything else can be worked out, that top-of-funnel figure has to be nailed down.
users — one row per person who has created an account. source records how they arrived: organic means they found Kindled themselves, paid_search means they clicked a bought advert, and referral means an existing customer invited them. signup_date is the day they registered.
| id | name | source | signup_date |
|---|---|---|---|
| 1 | Aiden Cole | organic | 2023-05-01 |
| 2 | Bianca Reyes | paid_search | 2023-05-02 |
| 3 | Carlos Mora | organic | 2023-05-03 |
| 4 | Delia Frank | referral | 2023-05-04 |
| 5 | Ewan Blake | paid_search | 2023-05-05 |
| 6 | Fiona Grey | organic | 2023-05-06 |
| 7 | Gus Herrera | referral | 2023-05-07 |
| 8 | Hana Ito | paid_search | 2023-05-08 |
The table already exists in the database — there is nothing to create or load.
Task: Write a query that returns one row and one column, total_users, holding how many people have created an account.
Example output — the shape, on an invented figure. A product with thirty-four accounts on file would come back as:
| total_users |
|---|
| 34 |
Sign in to solve this problem
Reading problems is free for everyone — solving them (Run, Submit, and tracking what you've solved) needs an account.
Sign in