Dataford
Top 20
Prep plan
Updated weekly · Last refresh Aug 30

Wise. Energy Marketing Analytics Specialist Interview Questions

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

20questions
~3htotal time
Track your progressSign up free to work through all 20 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 3 drills · ~62 min
Window Functions vs GROUP BYEasy
Recently asked

Explain how window functions differ from GROUP BY and when to use each in Splice product analysis.

Window FunctionsGroup ByAggregationsWise. Energy
Optimize Slow Join QueryHard
Recently asked

Tests query optimization techniques for large-scale clickstream and conversion joins.

Performance TuningJoinssqlWise. Energy
Compare Monthly User Retention CohortsMedium
Practice
Recently asked
Practice drill

Calculate month-1 retention for January vs February signup cohorts using joins, date filtering, and aggregation.

Window FunctionsDate FunctionsAggregationsTrideumZulilyeBay
7-Day Rolling Active UsersMedium
Practice
Practice drill

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsMetaSpotifyMeta IT
Retention Rate SQLHard
Practice
Practice drill

Calculate Wise Energy's 30-day user retention by signup cohort using a CTE, left join, date filtering, and conditional aggregation.

sql queryWise. Energy
More SQL & Data Manipulation questions with a free account
2
Strategy6 questions · ~48 min
Attribution Model Selection StrategyMedium
Recently asked

Explain when to use first-touch, last-touch, or multi-touch attribution based on business goals, funnel structure, and measurement limits.

Business Acumenmarketing analyticsattribution modelsWise. Energy
Marketing Budget Allocation StrategyEasy
Recently asked

Approach for allocating a constrained marketing budget across channels and objectives using ROI, trade-offs, and prioritization.

EstimationGrowth StrategyMarket SizingWise. Energy
Scale Acquisition Without More BudgetHard
Recently asked

Tests strategic analytics for finding growth levers under strict budget constraints.

Growth Strategyefficiencybudget constraintsWise. Energy
More Strategy questions with a free account
3
Behavioral & Leadership7 questions · ~56 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~24 min
Measure Campaign Lift with ControlEasy
Recently asked

Design a control-treatment experiment to estimate campaign lift and determine whether the campaign caused a meaningful improvement.

ExperimentationCausal InferenceA/B TestingWise. Energy
LTV: Organic vs Paid SearchMedium
Recently asked

Tests ability to define and compute LTV with channel-based segmentation and long-term windows.

acquisitionLTVCohort AnalysisWise. Energy
Investigate CPA Spike Root CauseMedium
Recently asked

Tests diagnostic thinking across tracking, attribution, funnel metrics, and channel performance.

campaign performanceDiagnosisWise. Energy

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 20 questions plus 3 hands-on drills to finish this plan.