Wally's Widgets, a fictitious company created for portfolio purposes, sought to determine whether its marketing budget was being allocated effectively across multiple campaign channels. Leadership wanted to understand which marketing activities generated the greatest lead generation potential, which campaigns underperformed, and whether future marketing investments should be adjusted.
A review of campaign performance data revealed significant differences in efficiency between channels. Paid Search generated the highest planned lead volume while maintaining the lowest cost per targeted lead. Event marketing also demonstrated strong efficiency despite a limited sample size. Display Advertising generated moderate results but at substantially higher costs, while Email campaigns delivered the weakest performance relative to spending.
The analysis identified opportunities to improve marketing effectiveness by reallocating resources toward higher-performing channels while optimizing or reevaluating lower-performing initiatives.
Wally's Widgets is a fictitious company created for portfolio and educational purposes. The business scenario, analytical methods, and recommendations are based on real-world business challenges and professional experiences. Company names, proprietary information, and actual business data have been modified to protect confidentiality while preserving the analytical process used by a Business Analyst.
Marketing budgets are finite, and organizations must decide how to allocate resources to maximize business outcomes.
The executive team wanted to answer several key questions:
Which campaign types generate the strongest results?
Which campaign types are underperforming?
Are marketing dollars being spent effectively?
How should future budgets be allocated?
Are there opportunities to improve lead generation without increasing spending?
Without clear performance analysis, future budget decisions risk being based on assumptions rather than data.
CEO - Revenue growth and return on marketing investment
CFO - Budget efficiency and cost control
VP of Sales - Lead generation quality and pipeline growth
Marketing Director - Campaign effectiveness and budget planning
Marketing Team - Channel optimization and performance improvement
Business Analyst - Data analysis and recommendations
The marketing department executed twelve campaigns across four primary channels:
Paid Search
Display Advertising
Email Marketing
Event Marketing
Campaign performance was evaluated using:
Planned lead generation
Campaign budgets
Actual spend
Cost per targeted lead
Budget variance
Overall campaign spending remained disciplined.
Total Budget: $114,382
Actual Spend: $112,146
Budget Utilization: 98%
Number of Campaigns: 12
The marketing team demonstrated strong budget management; however, performance varied considerably across channels.
Several factors contributed to performance differences among campaign types.
Paid Search targets prospects actively seeking solutions, resulting in stronger lead generation efficiency.
Display Advertising primarily supports awareness-building activities rather than immediate lead generation, contributing to higher acquisition costs.
Email campaigns may be affected by list quality, audience engagement, segmentation challenges, or outdated contact databases.
Resources appear to have been distributed across channels without sufficient emphasis on the highest-performing campaign types.
1,000 target leads
$42,902 spend
$42.90 cost per lead
Paid Search generated the highest lead volume while maintaining the lowest cost per lead.
100 target leads
$5,579 spend
$55.79 cost per lead
Although only one campaign was executed, Event Marketing demonstrated strong efficiency.
450 target leads
$36,990 spend
$82.20 cost per lead
Display campaigns generated leads but required significantly more investment than Paid Search.
150 target leads
$26,675 spend
$177.83 cost per lead
Email campaigns exhibited the highest cost per lead and lowest efficiency among evaluated channels.
In the desired future state:
Marketing budgets are allocated based on performance data.
Campaign investments are aligned with ROI expectations.
Leadership can quickly identify high-performing channels.
Marketing and sales share common performance metrics.
Budget planning is supported by historical campaign analytics.
The organization requires the ability to:
Measure campaign effectiveness consistently.
Compare channel performance objectively.
Improve budget allocation decisions.
Increase lead generation efficiency.
Support strategic marketing planning with data.
The solution should:
Track campaign spend by channel.
Track leads generated by campaign.
Calculate cost per lead automatically.
Measure budget variance.
Provide campaign performance dashboards.
Support year-over-year comparisons.
Track campaign-generated opportunities and revenue.
Continue investing across all channels at existing levels.
Minimal disruption
Predictable budgeting
Missed optimization opportunities
Lower overall efficiency
Shift investment from Email and Display campaigns toward Paid Search and Event Marketing.
Improved efficiency
Potential increase in lead volume
Reduced channel diversification
Potential overreliance on fewer channels
Improve lower-performing campaigns while maintaining a balanced portfolio.
Preserves channel diversity
Opportunity to improve underperforming assets
Requires additional effort and testing
Results may take longer
The recommended approach combines Options 2 and 3.
Immediate actions should include:
Increase investment in Paid Search.
Expand Event Marketing testing.
Conduct detailed review of Email performance.
Improve Display Advertising targeting and creative assets.
Develop ongoing campaign performance dashboards.
This strategy balances short-term gains with long-term optimization.
Validate campaign metrics
Review historical trends
Identify top-performing channels
Improve targeting
Refine creative assets
Enhance audience segmentation
Shift investment toward high-performing channels
Reduce funding for consistently underperforming initiatives
Monthly performance reviews
Quarterly budget adjustments
Annual strategic planning updates
Lower cost per lead
Improved marketing ROI
Better budget utilization
Improved decision-making
Greater visibility into campaign performance
Faster identification of optimization opportunities
Data-driven budgeting
Improved alignment between marketing and business goals
Stronger pipeline generation
Although marketing remained within budget, performance varied significantly across channels.
Campaign success should be evaluated using measurable outcomes rather than assumptions or historical preferences.
Simple metrics can quickly reveal significant performance differences between channels.
Event marketing showed strong results, but additional testing is required before making large-scale investment decisions.
By combining financial data with performance metrics, business analysts can help organizations make more informed investment decisions and maximize the impact of limited resources.