Back to library
Perplexity AIPerplexity AI

SQL Test for Marketing Roles

Growth & Marketing

What it tests

Analytical depth — can this marketer actually query data?

Format

  1. 1Provide a sample database schema (users, events, campaigns, revenue)
  2. 2Ask 3-5 questions of increasing difficulty (basic SELECT, JOINs + date logic, subqueries + calculations)
  3. 3Candidates can use any SQL client; open-book, open-internet

What to look for

  • Can they get to the answer at all? (many marketers can't)
  • Do they understand what the numbers mean, not just how to query them?
  • Do they ask clarifying questions about the schema?

Adaptation guide

Use your actual data schema (anonymized). The questions should reflect real analyses your growth team runs weekly.

Full description

Format:

  • Provide a sample database schema (users, events, campaigns, revenue)
  • Ask 3-5 questions of increasing difficulty:
    1. "How many users signed up in the last 30 days from organic search?" (basic SELECT)
    2. "What's the 7-day retention rate by acquisition channel?" (JOINs + date logic)
    3. "Which campaign had the highest LTV:CAC ratio? Show your work." (subqueries + calculations)
  • Candidates can use any SQL client; open-book, open-internet

Time: 45-60 minutes

What to look for:

  • Can they get to the answer at all? (many marketers can't)
  • Do they understand what the numbers mean, not just how to query them?
  • Do they ask clarifying questions about the schema?

Adaptation: Use your actual data schema (anonymized). The questions should reflect real analyses your growth team runs weekly.