Facebook Ads Performance & Revenue Optimization 

Project Type

Marketing Analytics | Digital Advertising | Performance Analysis | Power BI Dashboard

Executive Summary 

This Facebook Ads campaign generated 4 paying customers and delivered approximately 4.3x return on ad spend (ROI) from a total advertising investment focused on lead generation for a digital product/service.

A total of ₦150,500 (~$109.03) revenue was generated directly from tracked conversions.

The analysis revealed that revenue performance was primarily driven by targeting precision rather than overall ad reach or engagement volume, highlighting the importance of optimizing for conversion efficiency instead of vanity metrics.

Business Context

The campaign was designed to generate qualified leads and convert them into paying customers.

The primary objective was to evaluate how effectively Facebook advertising spend translated into actual revenue, not just engagement or traffic.

Key focus areas included:

• Identifying which ads generated real revenue

• Understanding which audience segments converted best

• Evaluating full funnel efficiency from impression → purchase

Key Business Outcomes 

• Generated 4 paying customers directly attributed to Facebook Ads

• Achieved approximately 4.3x return on ad spend (ROAS)

• Identified high-performing audience segments responsible for the majority of conversions

• Measured full funnel performance from impressions → clicks → leads → revenue

• Found that a significant portion of high-engagement ads did not contribute to revenue

Strategic Insights 

• Revenue was concentrated within a small number of high-intent audience segments, indicating that targeting quality had a greater impact than ad volume

• Engagement metrics (likes, clicks, impressions) were weak predictors of actual revenue performance

• Certain creatives consistently produced lower cost per acquisition, making them stronger candidates for scaling

• The most profitable ads were not the most popular ones, reinforcing the importance of conversion-focused optimization

Business Recommendations

• Scale high-converting audience segments by reallocating budget away from low-performing groups

• Optimize creatives based on conversion efficiency, not engagement metrics

• Strengthen retargeting strategy to capture users who clicked but did not convert

• Improve funnel tracking accuracy to better attribute revenue across touchpoints

• Test new ad variations focused on conversion intent rather than engagement appeal

Tools & Skills

Tools:
Power BI | Power Query | Microsoft Excel

Skills:
Marketing Analytics | Funnel Analysis | KPI Development | DAX Calculations | Data Cleaning | Dashboard Design | Business Intelligence Reporting | Data Storytelling | Performance Optimization

Project Link

• https://github.com/tosin19-tech/Upskill-Campaign-Performance-Dashboard

Project Outcome 

• 4 qualified customers acquired

• ₦150,500 (~$109.03) revenue generated

• 4.3x ROAS achieved

• Clear identification of high-converting audience segments

• Full funnel visibility from impressions to revenue conversion

• Improved understanding of conversion-driven campaign optimization

Contribution

As the Marketing Analytics and Business Intelligence Analyst, I:

• Supported performance analysis of a Facebook Ads campaign focused on lead generation and customer acquisition 

• Defined campaign KPIs aligned with business objectives

• Collected and cleaned campaign performance data

• Built analytical models using Power BI and DAX

• Designed funnel-based performance tracking system

• Analyzed creative and audience performance

• Extracted insights on revenue-driving segments

• Translated data findings into actionable marketing recommendations

• Built interactive dashboards for decision-making support