top of page

Marketing Campaign Performance Analysis

Understanding how countries, campaigns, and platforms convert impressions into purchases

SQL  • Tableau

Overview

This project analyzes marketing performance across multiple dimensions to understand how efficiently impressions are converted into purchases. Instead of focusing only on raw volume metrics such as impressions or total purchases, the analysis emphasizes conversion efficiency, using purchase per impression as the central performance indicator.

By examining performance across countries, campaigns, and advertising platforms, the project aims to identify where marketing efforts are most effective and where optimization opportunities exist. The analysis could support data driven decisions related to budget allocation, campaign prioritization, and geographic or platform focus.

The project combines structured data analysis with an interactive dashboard to allow both high level insights and deeper exploration of performance patterns.

Business Question

Marketing teams often invest heavily in campaigns without a clear understanding of how efficiently those investments translate into actual customer purchases. High impression volume does not necessarily indicate strong performance if conversion efficiency remains low.

This project addresses the following business questions:

  • Which countries generate the highest conversion efficiency from impressions to purchases?

  • Which campaigns perform best in terms of purchase efficiency rather than volume alone?

  • How does performance vary across advertising platforms?

  • Where should marketing efforts be reinforced or reconsidered to improve overall return?

Key Metrics (KPIs)

  • Purchases per Impression (primary KPI): ratio between purchases and impressions, used as the main efficiency indicator to compare campaign performance across countries, platforms, and campaigns

  • Total Purchases: total number of purchases generated, used to contextualize volume differences across segments

  • Impressions: total number of ad impressions, used to represent exposure and scale of campaign delivery

  • Campaign Level Performance: purchases per impression aggregated by campaign, used to identify relative performance differences

  • Platform Level Performance: purchases per impression segmented by platform, used to compare efficiency across marketing channels

Analytical Approach

  • Aggregated marketing data across countries, campaigns, and platforms

  • Calculated Purchase per Impression as the primary performance metric

  • Compared performance across dimensions to identify relative efficiency rather than absolute volume

  • Validated metric consistency to ensure meaningful comparisons

  • Structured results to support both static analysis and interactive exploration through a dashboard

Performance Analysis

The analysis reveals clear differences in marketing efficiency depending on geography, campaign design, and platform choice. Some countries achieve strong purchase conversion with comparatively fewer impressions, indicating more effective targeting or audience alignment.

Campaign level analysis shows that not all campaigns benefit equally from high impression counts. Several campaigns with moderate reach outperform larger campaigns in terms of purchase efficiency, suggesting that messaging, timing, or audience selection plays a critical role in conversion outcomes.

Platform comparison highlights differences in how users respond to ads depending on the channel. Certain platforms consistently show higher Purchase per Impression rates, reinforcing the importance of platform specific strategies rather than uniform campaign distribution.

Overall, the analysis demonstrates that marketing effectiveness is driven more by efficiency and alignment than by scale alone.

Interactive Dashboard
dashboard preview marketing.png

The interactive dashboard consolidates all key performance dimensions into a single exploratory view. It allows users to:

  • Compare Purchase per Impression across countries

  • Rank campaigns based on conversion efficiency

  • Analyze platform performance side by side

  • Quickly identify top and underperforming segments

The dashboard complements the analytical findings by enabling dynamic filtering and deeper investigation of patterns that may not be immediately visible in static analysis.

Key Findings

  • Purchase efficiency varies significantly across countries, even when impression volumes are similar

  • High impression volume does not guarantee strong conversion performance

  • Several campaigns achieve high efficiency with moderate reach, indicating better targeting or creative alignment

  • Platform choice has a measurable impact on conversion outcomes

  • Performance differences suggest that marketing optimization should prioritize efficiency metrics rather than scale alone

Tools & Technologies

• SQL
• Data Visualization: Tableau

Full Project Repository

The complete analysis, including data preparation, metric calculations, and reproducible workflows, is available in the full project repository on GitHub.

bottom of page