Top 40
Prep plan
Updated weekly · Last refresh Oct 8

Publicis Groupe Business Analyst Interview Questions

The questions to prepare for a Publicis Groupe Business Analyst interview. Questions from real interview reports rank first. Updated daily.

40questions
~6htotal time
Track your progressSign up free to work through all 40 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 7 questions · ~58 min
Diagnose Cross Campaign CTR DropMedium

Investigate a 15% CTR drop across multiple campaigns by decomposing performance and separating measurement issues from real demand changes.

Funnel AnalysisKPIDiagnosisPublicis Groupe
Measure Brand Awareness Campaign SuccessMedium

Define a KPI stack for a brand awareness campaign, from reach and recall to downstream pipeline and ROI.

KPILeading IndicatorsEngagement MetricsPublicis Groupe
Build a Marketing KPI DashboardMedium

Design a dashboard that connects campaign activity, funnel conversion, and acquisition efficiency to business outcomes.

North Star MetricKPIsLeading IndicatorsPublicis Groupe
More Metrics questions with a free account
2
Strategy5 questions · ~42 min
Tell Me About YourselfEasy

Craft a concise self-introduction that highlights fit, communication style, and relevance for an Account Executive role.

brand cultureBusiness AcumenCompetitive AnalysisPublicis Groupe
Financial Model for New ServiceHard

Tests your ability to model unit economics, costs, and revenue drivers for a new Publicis Groupe offering.

Business ModelFinancial ModelingassumptionsPublicis Groupe
More Strategy 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
3
SQL & Data Manipulation3 questions + 2 drills · ~45 min
SQL, VLOOKUP, and Power BI ChangesMedium

Assesses practical analytics workflow across SQL, Excel, and Power BI for reporting.

sqlpower biPublicis Groupe
SQL: Explain After SELECTMedium

Tests your understanding of SQL query structure and data retrieval logic.

sqlPublicis Groupe
Rolling 30-Day Active Users SQLHard
Practice
Practice drill

Calculate trailing 30-day active users and rank regional engagement tiers with PostgreSQL aggregation and window functions.

Window FunctionssqlPublicis GroupeFactoredAvepoint
Consecutive Activity Using Lead LagMedium
Practice
Practice drill

Use LAG and LEAD to identify users with activity on consecutive days in a Publicis Groupe platform.

sqlPublicis Groupe
More SQL & Data Manipulation questions with a free account
4
Behavioral & Leadership24 questions · ~199 min
More Behavioral & Leadership questions with a free account
5
More topics1 question · ~8 min
Testing Processes and AutomationMedium

Assesses your approach to quality assurance and repeatable testing practices.

TestingAutomationPublicis Groupe
The finish line: interview-readyComplete all 40 questions plus 2 hands-on drills to finish this plan.