Marketing Campaign Analysis
Project: Analyze Marketing Campaign Performance (SQL)
Project Overview
In this SQL project from InterviewMaster.ai, I practiced creating a database and a table using pgAdmin 4 and imported a csv file. I then viewed the data using SQL and cleaned and standardized the data fields. After the data was ready to work with, I then began writing SQL queries to analyze the marketing campaign performance data to uncover trends and insights. I worked with real-world marketing data to evaluate campaign effectiveness and audience engagement.
Data Source: Kaggle Dataset, found here
Learning Objectives
- Write SQL queries to explore marketing campaign datasets
- Clean and standardize data fields
- Aggregate data to find trends in campaign performance metrics
- Practice filtering and summarizing marketing data
Practice Questions
- How many customer records are in the dataset?
- How many customers accepted each of the five marketing campaigns?
- What is the overall acceptance rate across all marketing campaigns?
- How many customers belong to each education level?
- What is the average income of customers who accepted the most recent campaign?
- Which purchase channel had the highest number of purchases?
- How many customers visited the website more than five times in the last month?
- What is the average number of days since the last purchase across all customers?
- How many customers made at least one purchase using a discount?
Please see full project on my GitHub.