Something went wrong!
Hang in there while we get back on track
Marketing Campaign Correlation Analysis
Analyzing marketing funnel metrics (ad spend, impressions, clicks, conversions, revenue) to identify relationships and multicollinearity issues. Demonstrates full correlation matrix generation with strong correlation identification and variable selection recommendations for regression modeling.
Input
What you provide to the skill
Analyze correlations in my marketing CSV with columns: ad_spend, impressions, clicks, conversions, revenue (250 rows)
Output
What the skill generates for you
============================================================
CORRELATION ANALYSIS RESULTS
Dataset: 233 rows x 5 columns
Numeric variables analyzed: 5
Variables: ad_spend, impressions, clicks, conversions, revenue
Strong Correlations Found: 10 (|r| > 0.7)
ad_spend <-> impressions r = 1.000 (positive)
ad_spend <-> clicks r = 1.000 (positive)
ad_spend <-> conversions r = 1.000 (positive)
ad_spend <-> revenue r = 1.000 (positive)
impressions <-> clicks r = 1.000 (positive)
impressions <-> conversions r = 1.000 (positive)
impressions <-> revenue r = 1.000 (positive)
clicks <-> conversions r = 1.000 (positive)
clicks <-> revenue r = 1.000 (positive)
conversions <-> revenue r = 1.000 (positive)
Multicollinearity Issues: 10 (|r| > 0.8)
WARNING: High correlations detected between predictors!
Consider removing or combining these variables for regression modeling:
- ad_spend <-> impressions (r = 1.000)
- ad_spend <-> clicks (r = 1.000)
- ad_spend <-> conversions (r = 1.000)
- ad_spend <-> revenue (r = 1.000)
- impressions <-> clicks (r = 1.000)
- impressions <-> conversions (r = 1.000)
- impressions <-> revenue (r = 1.000)
- clicks <-> conversions (r = 1.000)
- clicks <-> revenue (r = 1.000)
- conversions <-> revenue (r = 1.000)
Output Files Generated:
Correlation Matrix: marketing_matrix.csv
Heatmap Visualization: marketing_heatmap.png
============================================================
About This Skill
Generate correlation matrices and annotated heatmaps from CSV datasets. Identifies strong correlations, flags multicollinearity issues, and produces professional visualizations for regression preparation.
View Skill DetailsMore Examples
Customer Satisfaction Survey Heatmap
Correlation heatmap for customer survey data with Likert scale ratings (1-10). Analyzes relationships between product quality, service, shipping, price value, and overall satisfaction. Demonstrates handling of ordinal survey data with smaller sample sizes.
Real Estate Property Correlation Matrix
Generating correlation matrix for housing dataset with property features (sqft, bedrooms, bathrooms, lot_size, year_built) and sale price. Shows realistic correlations between size metrics and price, with multicollinearity warnings for regression preparation.