Week 2 Refined Data Visualizations
Submitted By: Muhammad Umar
um0888921@[Link]
This report presents a series of refined data visualizations created from the marketing campaign
dataset provided by Excelerate. The objective of these visualizations is to simplify complex
campaign performance data into clear, polished insights that can support decision-making. By
applying best practices such as simplification, emphasis, and direct labeling, these charts
highlight spending patterns, engagement trends, efficiency metrics, and audience behaviors.
The visualizations are designed not only to analyze campaign effectiveness but also to provide
actionable insights for optimizing future marketing strategies.
CTR Trend by Age
CTR varies across age groups, peaking in some younger segments.
CPC vs CPR by Campaign
Comparison of CPC and CPR across campaigns highlights efficiency differences.
Top 10 Campaigns by Spend
Campaigns with the highest spending are highlighted here.
Frequency vs CTR
CTR tends to flatten or decline at higher ad frequency.
Reach Composition by Audience
This stacked bar chart shows how different audiences contributed to reach.
Spend Distribution by Geography
Budget allocation is shown across geography groups.
Most Efficient Campaigns
Top campaigns in terms of clicks generated per 100 INR spent.