This project is a SQL-based marketing campaign analysis database developed to evaluate the performance of digital marketing campaigns across multiple advertising channels.
The dataset contains campaign metrics such as:
- Advertising Spend
- Impressions
- Clicks
- Conversions
- Revenue
- Campaign Dates
This project demonstrates how SQL can be used for:
- Marketing analytics
- Campaign performance tracking
- ROI analysis
- Conversion analysis
- Revenue analysis
- Business intelligence reporting
- Analyze campaign profitability
- Compare marketing channel performance
- Measure customer engagement
- Calculate ROI and conversion rates
- Support data-driven marketing decisions
Synthetic Marketing Campaign Dataset
“This dataset was generated manually for marketing analytics and portfolio demonstration purposes.”
- SQL
- MySQL
- GitHub
- Summer25
- Fall25
- Winter25
- Database creation
- Table creation
- Data insertion
- Aggregate functions
- GROUP BY operations
- ROI calculations
- Conversion rate analysis
- Revenue analysis
- Campaign tracking
This project helps businesses:
- Measure campaign effectiveness
- Optimize marketing budgets
- Identify high-performing channels
- Improve conversion performance
- Increase return on investment (ROI)
Ifunanya Igbonwa
Data Analyst skilled in:
- SQL
- Excel
- Power BI
- Data Visualization
- Marketing Analytics
This project is open-source and available for educational purposes.