ABCDEFGHIJKLMNOPQRSTUVW
1
SOLENTE / CRITEO HIRING CASE
2
This is a synthetic case dataset modeled on the structure of official Criteo Marketing Solutions documentation:
- Statistics / reporting: https://developers.criteo.com/marketing-solutions/docs/campaign-statistics
- Campaign objects: https://developers.criteo.com/marketing-solutions/docs/campaign
- Ad set objects: https://developers.criteo.com/marketing-solutions/docs/ad-set
- Analytics guide: https://developers.criteo.com/marketing-solutions/docs/analytics
- Product sets: https://developers.criteo.com/marketing-solutions/docs/product-sets
3
What is inside
---------------
- 120 days of data from 2025-11-01 to 2026-02-28
- 14 CSV files + 1 manifest + 1 workbook
- ~5,179 total data rows across all CSVs (excluding workbook)
4
Files
-----
- advertiser_daily.csv: 120 rows
- campaign_daily.csv: 360 rows
- adset_daily.csv: 960 rows
- placement_daily.csv: 1080 rows
- creative_daily.csv: 682 rows
- audience_segment_daily.csv: 960 rows
- product_mix_daily.csv: 720 rows
- campaign_config_snapshot.csv: 3 rows
- adset_config_snapshot.csv: 8 rows
- change_log.csv: 10 rows
- case_metadata.csv: 1 rows
- case_questions.csv: 8 rows
- scoring_rubric.csv: 6 rows
- data_dictionary.csv: 161 rows
- manifest.csv: file inventory and row counts
- solente_criteo_hiring_case_pack.xlsx: workbook containing all tables
5
Embedded analysis signals
-------------------------
1) Prospecting campaign budget scale starting 2025-12-16
2) Broad prospecting bid increase on 2025-12-20
3) Frequency cap relax on 2026-01-05 for broad/contextual prospecting ad sets
4) Creative fatigue pressure from 2026-01-28 onward
5) Product / catalog mix shift toward lower-margin outlet inventory from 2026-02-03
6) Short app measurement anomaly from 2026-02-10 to 2026-02-13, then fix on 2026-02-14
7) New prospecting creative launched on 2026-02-21
8) Partial bid rollback on 2026-02-24
6
7
Questions;
8
1. Performance Diagnosis

How would you analyze the change in performance?
What could be the possible reasons behind the decline in ROAS?
What factors might explain the increase in CPC?
What could be causing the drop in conversion rate?
Please explain your reasoning and the approach you would take to diagnose the root causes.
9
2. Campaign Strategy

After reviewing the campaign structure:
Which campaign would you invest more budget in, and why?
Which campaign would you focus on optimizing, and why?
Which campaign would you consider pausing or limiting, and why?
What audience strategies would you recommend?
What optimization actions would you implement over the next two weeks to improve performance?
10
3.Data Analysis

Candidates should combine the daily fact tables with config snapshots and the change log. A strong answer should separate results / effects of different changelog events
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100