data-analysislisted

# Data Analysis ## When This Skill Applies - Processing and cleaning marketing datasets - Calculating marketing KPIs and metrics - Performing trend, cohort, and funnel analysis - Building attribution models for channel performance - Generating forecasts and projections ## Core Guidance ### 1. Data Analysis Process ``` Define Question -> Collect Data -> Clean & Validate -> Explore -> Analyze -> Interpret -> Visualize -> Recommend ``` ### 2. Data Cleaning Checklist | Check | Action | Tool | |-------|--------|------| | Missing values | Impute, flag, or exclude | pandas/Excel | | Duplicates | Identify and deduplicate | Sort + compare | | Outliers | Z-score or IQR method | Statistical test | | Data types | Validate dates, numbers, categories | Type casting | | Consistency | Standardize formats, naming | Mapping tables | | Completeness | Ensure required fields present | Validation rules | ### 3. Marketing KPI Formulas #### Acquisition Metrics | KPI | Formula | Good Benchmark | |-----|---------|---------------| | CAC | Total acquisition cost / New customers | Varies by industry | | CPC | Total ad spend / Total clicks | $1-$5 (search) | | CPL | Total spend / Total leads generated | $20-$200 (B2B) | | CPA | Total spend / Total conversions | $50-$500 (B2B) | | ROAS | Revenue from ads / Ad spend | 3x-5x | #### Engagement Metrics | KPI | Formula | Good Benchmark | |-----|---------|---------------| | CTR | Clicks / Impressions * 100 | 2-5% (search) | | Open Rate | Opens / Delivere