This project analyzes nano-influencer campaign performance across global markets by combining campaign activity with cost data. The analysis identifies high-performing markets and cost-efficient reward types to support data-driven campaign and budget decisions.
Using data from 2,500+ campaign posts, the analysis identified France and UAE as the top-performing markets by engagement efficiency.
| Market | Avg Engagement Rate (%) | Cost Per Engagement (CPE) | Total Spend |
|---|---|---|---|
| France | 6.97% | $0.23 | $32,945 |
| UAE | 6.90% | $0.26 | $26,415 |
| UK | 5.09% | $0.29 | $33,645 |
| Germany | 5.01% | $0.34 | $31,595 |
| USA | 5.02% | $0.39 | $33,300 |
The analysis compared advocacy rewards based on engagement generated per dollar spent:
- Sample Products → $0.07 CPE (highest efficiency)
- Full Size Sets → $0.24 CPE
- Exclusive Kits → $0.58 CPE
Based on the analysis, the following actions are recommended for Customer Success and Product teams:
-
Focus on High-Performing Markets Prioritize nano-influencer recruitment in France, which recorded the highest engagement rate (6.97%) and lowest CPE among the markets analyzed.
-
Improve Reward Efficiency Consider allocating more recruitment budget to Sample Product rewards, which recorded the lowest CPE ($0.07) and generated 3.4× more engagement than Full Size Sets for the same budget.
-
Refine Product KPIs For skincare brands, consider prioritizing Saves alongside Likes, as Saves can provide an additional indicator of audience interest and content value.
-
ETL Pipeline Combined campaign events with creator demographic data using Python and Pandas.
-
Feature Engineering Developed campaign performance metrics, including:
- Cost Per Engagement (CPE)
- Market-weighted Engagement Rate
-
Interactive Dashboard Built a Streamlit application for exploring campaign performance, market trends, reward efficiency, and key metrics.
This solution helps marketing teams:
- Identify high-performing global markets
- Compare campaign acquisition costs
- Evaluate reward efficiency
- Support data-driven campaign and budget decisions
**Aklilu Abera ** Data Analyst | Marketing Analytics | ROI Analysis