Top 18
Prep plan
Updated weekly · Last refresh Aug 30

Prosper Marketplace Marketing Analytics Specialist Interview Questions

The questions to prepare for a Prosper Marketplace Marketing Analytics Specialist interview. Questions from real interview reports rank first. Updated weekly.

18questions
~2htotal time
Track your progressSign up free to work through all 18 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 3 questions · ~24 min
Diagnose Rising Customer Acquisition CostsMedium

Diagnose why CAC doubled over three quarters by separating channel efficiency, funnel changes, customer mix, and measurement effects.

CACLeading IndicatorsDiagnosisProsper Marketplace
Metrics for Lifecycle Campaign SuccessMedium

Tests ability to define measurement frameworks and KPIs for lifecycle marketing effectiveness.

KPIConversion RateEngagement MetricsProsper Marketplace
More Metrics questions with a free account
2
SQL & Data Manipulation4 questions + 3 drills · ~62 min
Deduplicate Customers Without IDsMedium

Tests data quality and SQL-based record linkage approaches for deduplicating customer data.

null handlingData WranglingReconciliationProsper Marketplace
Optimize Slow Clickstream AggregationHard

Tests performance tuning skills for large-scale analytics queries over clickstream data.

financial dataperformanceAggregationsProsper Marketplace
LEFT vs INNER Join for CampaignsEasy

Tests understanding of join semantics for correctly combining campaign and outcome datasets.

Joinsmany-to-onedata integrityProsper Marketplace
Weekly Service KPI by TeamMedium
Practice
Practice drill

Analyze weekly service delivery performance by team using joins, a CTE, date aggregation, and KPI calculations.

KPIJoinssqlDeloitteReputation
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
Monthly Campaign Performance SummaryEasy
Practice
Practice drill

Aggregate January 2024 campaign data by channel using GROUP BY, filtering, and ordering by total clicks.

JoinsData WranglingAggregationsDNVEversanaDiscord
More SQL & Data Manipulation questions with a free account
3
Behavioral & Leadership8 questions · ~64 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~24 min
A/B Test for Email CampaignMedium

Design and analyze an A/B test for a new email campaign, including metrics, power, guardrails, and common experiment risks.

email campaignAnalysisA/B TestingProsper Marketplace
Multi-Touch Attribution ApproachHard

Tests attribution strategy thinking and how you handle complex journeys across channels.

Business Modelcustomer journeyattributionProsper Marketplace
A/B Testing ExperienceMedium

Evaluates your experimentation thinking, metric selection, and result interpretation for marketing.

experienceA/B TestingProsper Marketplace

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 18 questions plus 3 hands-on drills to finish this plan.