Campaign Analytics Portfolio · 2025

Data that Tells
the Right Story

A curated showcase of data-driven campaign reports across DSP, PR, paid social, and lead generation — analysed and authored by Ekiomoado (Eki) Akhigbe.

AnalystEki Akhigbe
RoleHead of Digital Marketing Intelligence
ToolsLooker Studio · Tableau · SQL · Python
01BottleKingDSP Awareness · Dec 2025 02GCA YouthAdaptPR Media · 2025 03Pepsi: Decade of DancePaid Social · Nov 2025 04Pepsi: DisembaVideo Views · Nov–Dec 2025 05BuyLetLiveLead Generation · Dec 2025

01 · BottleKing Awareness Campaign

DSP Awareness Campaign · Nigeria
BottleKing Awareness Campaign
7 Dec – 26 Dec 2025  ·  All Devices  ·  673 Inventory Sources
December 2025
Impressions
8.1m
Total served
Reach
2.5m
Unique users
Clicks
149k
Total clicks
Avg CTR
2%
Overall rate
Avg CPM
$0.08
Cost per 1k impr.
Device Breakdown
Android
Impressions6.8m
Clicks141k
CTR 2.07%
iOS
Impressions1.3m
Clicks~2k
CTR 0.16%
Impressions by Device
Android
6.8m
iOS
1.3m
Clicks by Device
Android
141k
iOS
Top Inventory — CTR
CallApp
3%
Block Blast
2%
Truecaller
1%
Vita Mahjong
1%
Word Solitaire
Bounce Rate — Top Sources
Vita Mahjong
~73%
CallApp
~68%
Truecaller
~66%
Taskilo
~66%
Block Blast
~64%
Geographic Performance — Nigeria (100% delivery)
#CityImpressionsEngagementsBounce Rate
01Lagos4,205,4889,08866.47%
02Abuja1,396,6422,99768.96%
03Port Harcourt1,326,9903,64267.70%
04Benin City323,43367564.59%
05Ibadan208,09540466.83%
06Kano120,18429768.80%
07Jos42,80510067.85%
💡

Analyst Insight: Strong awareness delivery — 8.1m impressions at $0.08 CPM — confirms efficient reach. However, elevated bounce rates (64–73%) across top placements limited post-click progression. Android dominated with 94% of all clicks at CTR 2.07% vs iOS 0.16%, signalling a clear opportunity to prioritise Android-first creative optimisation and refine inventory selection toward lower-bounce placements in future flights.

02 · GCA PR Performance — YouthAdapt 2025

PR Campaign · Pan-African
GCA YouthAdapt 2025 Campaign
12 Media Platforms  ·  Multi-country Africa  ·  BBC Africa · ARISE TV · CNBC Africa + more
2025
Total Impressions
94.1m
Across all platforms
Total Reach
37.0m
Unique audience
Total Engagement
2.3m
Total interactions
Avg Engagement Rate
2.17%
Benchmark: ~1.5%
Media Type Mix — Impressions
Publication
58.3%
Publication / Awareness
33.3%
Coverage
8.3%
Share of Engagements
Publication / Awareness
67.4%
Publication
31.5%
Coverage
1.1%
Estimated Reach by Platform
BBC Africa
8.0m
Opera News
5.0m
Instagram
4.0m
Graphic Online
3.5m
Facebook
3.0m
ARISE TV
3.0m
Twitter/X
2.5m
CNBC Africa
2.5m
WhatsApp
1.8m
AYO TV
1.5m
Platform Performance Overview
#PlatformEst. ReachEst. ImpressionsEst. EngagementsEng. Rate
1BBC Africa (Business Insider)8,000,00020,000,000300,0000.02
2Opera News Online5,000,00012,500,000187,5000.02
3Instagram4,000,00012,000,000540,0000.05
4Graphic Online (Pulse Ghana)3,500,0008,750,000131,2500.02
5Facebook3,000,0009,000,000405,0000.05
6ARISE TV3,000,0006,000,00030,0000.01
7Twitter/X2,500,0007,500,000337,5000.05
8CNBC Africa (Climate Sector)2,500,0005,000,00025,0000.01
9WhatsApp Community1,800,0005,400,000243,0000.05
10AYO TV (MPASHO.CO.KE)1,500,0003,000,00015,0000.01
Social Media KPIs
Social Reach
11.3m
Engagements
1.5m
Social Reach Distribution
Instagram
35.4% · 4.0m
Facebook
26.5% · 3.0m
Twitter/X
22.1% · 2.5m
WhatsApp
15.9% · 1.8m
💡

Analyst Insight: The YouthAdapt campaign delivered exceptional pan-African scale — 94.1m impressions, 37m reach across 12 platforms. BBC Africa and Opera News led on reach while social platforms drove 5× higher engagement rates than traditional media. Top 5 platforms delivered 75% of total reach. Recommended next steps: integrate UTM tracking for PR attribution and expand localised storytelling via WhatsApp communities to unlock higher engagement depth.

03 · Pepsi — A Decade of Dance

Paid Social · Nigeria
Pepsi — A Decade of Dance
November 2025  ·  2 Campaign Variants  ·  Reach + Engagement Objectives
Nov 2025
Total Reach
517k
Impressions
530.8k
Video Views
267.9k
Total Results
478.1k
Post Engagement
76.6k
Avg Frequency
1.1×
No fatigue
Campaign 1 vs 2 — Reach & Views
C1 Reach
425k
C2 Reach
92k
C1 Views
165k
C2 Views
103k
Engagement Rate Comparison
Campaign 1
Reach425k
Eng.23.7k
Rate 0.06
Campaign 2
Reach92k
Eng.52.9k
Rate 0.58
Note: Campaign 2 achieved 9.7× higher engagement rate despite smaller reach — English-language variant resonated far more deeply.
Result Type Distribution
Reach
88.9%
Post Engagements
11.1%
Post Engagement by Campaign
Campaign 1
23.7k
Campaign 2
52.9k
💡

Analyst Insight: Campaign 1 dominated reach (425k) while Campaign 2 delivered a standout engagement rate of 0.58 — 9.7× higher than Campaign 1. Frequency was optimal at ~1× across both, ensuring no audience fatigue. Recommendation: replicate Campaign 2's content format and targeting as the engagement template, while scaling Campaign 1's reach mechanics for future brand visibility flights.

04 · Pepsi Nigeria — Disemba 2025

Video Views Campaign · Lagos, Nigeria
Pepsi Nigeria — Disemba 2025
November–December 2025  ·  Meta + X  ·  Adults 18–35  ·  KOL-led Execution
Dec 2025
Video Views
872.5k
Total Reach
439.3k
Total Impressions
1.3m
Engagement (3s+)
392.8k
Views by Asset
X — Decade of Dance
374.9k
Meta — Block Party
324.9k
IG — Disemba
107k
FB — Disemba
65.7k
Instagram vs Facebook — Disemba
Instagram
Views107k
Engagement92.4k
Avg Watch 13s
Facebook
Views65.7k
Engagement53.2k
Avg Watch 13s
Mainland Block Party — Meta
IG Views
183.8k
FB Views
141.1k
IG ThruPlays
117.5k
FB ThruPlays
69.0k
X — Top Posts by Impressions
Obi's House
312k
KOL — Tobi
120k
KOL — Gbemi
109k
KOL — Joey
103k
Chunesday
96k
X Eng. Rate: 9.1% Clicks: 5.9k
Viewing Quality — Joey Akan Disemba Execution
PlatformViewsUnique Views2s Continuous3s PlaysThruPlaysAvg Watch
Instagram107,01284,65595,46192,42482,70513s
Facebook65,72550,23954,79253,18046,64013s
💡

Analyst Insight: Disemba 2025 achieved its video views objective with 872.5k views across platforms. Instagram consistently delivered superior engagement quality with higher ThruPlay rates and deeper viewer progression, while Facebook drove scale. X functioned as a strong amplification layer with a 9.1% engagement rate. Key recommendation: prioritise early visual hooks within the first 2–3 seconds to reduce autoplay drop-off and continue KOL-led executions for cultural resonance on X.

05 · BuyLetLive — Lead Generation Campaign

Full-Funnel Lead Generation · Multi-Market
BuyLetLive Lead Generation Campaign
December 2025  ·  Nigeria · UK · Canada · US  ·  Awareness + Lead Conversion
Dec 2025
Leads Generated
112
Quality leads
Registrations
141
Completed sign-ups
Lead Gen Reach
111.6k
Across markets
Link CTR
19.1%
Across campaigns
Awareness Campaign Layer
Spend
₦5.1m
Reach
2.1m
Impressions
2.9m
ThruPlays
10.5k
Views
1.3m
Leads by Market
UK
72 leads
Canada
39 leads
US
CPL by Market
UK
₦36k
Canada
₦65k
US
₦253k
UK most efficient: ₦36k CPL at 72 leads. US requires budget reallocation.
Full Campaign Breakdown
#CampaignSpend (₦)ImpressionsClicksCTRLeadsCPL (₦)
1UK — Lead Gen2,600,67975,1712,6821.88%7236,121
2Canada — Lead Gen2,541,04275,1752,0631.57%3965,155
3US — Lead Gen253,0402,4731052.30%1253,040
4UK — Awareness10,268320274.69%
5Nigeria — Awareness35,14216,4461,5538.62%
Awareness → Conversion Funnel
Impressions
2.9m
Reach
2.1m
Views
1.3m
Leads
112
Awareness Views by Sub-campaign
Nigeria
936.7k
UK
160k
Canada
138k
US
53k
💡

Analyst Insight: BuyLetLive delivered strong full-funnel performance — 112 qualified leads and 141 registrations. UK was the clear efficiency winner: highest volume (72 leads) at the lowest CPL (₦36k). The US market yielded 1 lead at ₦253k CPL, signalling poor audience-product fit. Recommended action: reallocate US budget to UK/Canada and implement landing page A/B testing to improve conversion from the already strong 2.1m awareness reach base.