GitHub Marketing Analytics Specialist Interview Questions

The questions to prepare for a GitHub Marketing Analytics Specialist interview. Questions from real interview reports rank first. Updated daily.

17questions

~3htotal time

Track your progressSign up free to work through all 17 questions and resume where you left off.

Start practicing free →

SQL & Data ManipulationStart here. 4 questions + 1 drill · ~48 min

Handling Nulls in Dashboard MetricsEasy

Explain how to handle NULLs in SQL-backed visualizations without misrepresenting counts, averages, or trends.

Data WranglingCase WhenAggregations

GitHub

Monthly Active Users by CampaignMedium

Practice

Use PostgreSQL joins and monthly aggregation to count distinct active users from a specific signup campaign.

Date FunctionsJoinscampaign performance

GitHub

SQL Retention by ChannelMedium

Practice

Calculate 30-day retention rates for users acquired through paid search and organic search.

RetentionJoinsCase When

GitHub

PR Merge Time After First ReviewMedium

Practice

Practice drill

Calculate the average elapsed time between each pull request's first review and merge event.

Window FunctionsDate FunctionsJoins

GitHub

More SQL & Data Manipulation questions with a free account

Metrics4 questions · ~38 min

Compare CAC Against LTVMedium

Calculate CAC and compare it with LTV to decide whether an acquisition campaign is economically viable.

CACcampaign viabilityLTV

GitHub

Diagnose Pipeline Velocity BottlenecksMedium

Tests metrics thinking to isolate where funnel or sales execution is slowing down.

Funnel AnalysisDiagnosis

GitHub

Multi-Touch Attribution for GitHub EnterpriseHard

Tests advanced attribution modeling choices, data requirements, and measurement design.

attributioncampaign performance

GitHub

More Metrics questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan

Behavioral & Leadership8 questions · ~75 min

Cross-Functional Teamwork in DesignEasy

Tests how you collaborate across functions in a design context, communicate clearly, and take ownership for team outcomes.

Stakeholder ManagementCommunicationLeadership

GitHub

More Behavioral & Leadership questions with a free account