analytics-reporting

# Analytics Reporting

This skill enables an AI agent to generate detailed marketing analytics reports that go beyond raw numbers to deliver actionable insights. The agent collects data across traffic, engagement, conversion, and revenue metrics, applies attribution models to understand channel contribution, performs funnel and cohort analysis, and produces executive-ready reports with clear recommendations. The output helps marketing teams make data-driven decisions about budget allocation, campaign optimization, and strategy shifts.

## Workflow

1. **Define reporting scope and KPIs.** Clarify the report type (monthly overview, campaign-specific, channel deep-dive) and time period. Establish the primary KPIs to track: traffic metrics (sessions, unique visitors, pageviews), engagement metrics (bounce rate, time on page, pages per session), conversion metrics (conversion rate, leads generated, cost per acquisition), and revenue metrics (customer lifetime value, return on ad spend, marketing-attributed revenue).

2. **Collect data from all sources.** Pull data from web analytics (Google Analytics, Plausible), search console (impressions, clicks, average position), advertising platforms (Google Ads, Meta Ads, LinkedIn Ads), email marketing (Mailchimp, SendGrid), CRM (HubSpot, Salesforce), and social media analytics (native platform insights). Normalize date ranges and metric definitions across sources to ensure comparability.

3. **Analyze trends and identify patterns.** Compare current period metrics against previous period and year-over-year baselines. Calculate growth rates, identify statistically significant changes, and flag anomalies (traffic spikes from viral content, drops from algorithm updates or site outages). Segment data by channel, device, geography, and user cohort to uncover hidden patterns.

4. **Apply attribution modeling.** Move beyond last-click attribution to understand the full customer journey. Apply multi-touch models — linear (equal credit), time-decay (more credit to recent touchpoints), or data-driven (algorithmic) — to evaluate how each channel contributes to conversions. This prevents over-investing in bottom-funnel channels while starving the awareness channels that feed the pipeline.

5. **Perform funnel and cohort analysis.** Map the conversion funnel from first visit to purchase or signup. Calculate drop-off rates at each stage: landing page → lead form → MQL → SQL → customer. Identify the highest-friction stages and recommend tests to improve them. Run cohort analysis to understand retention — do users acquired from organic search retain better than those from paid ads after 30, 60, and 90 days?

6. **Generate the report with visualizations and recommendations.** Structure the report with an executive summary, channel-by-channel breakdown, top-performing content, funnel analysis, and a prioritized recommendation section. Include tables, trend charts, and comparison visualizations. End every section with a "So what?" — the specific action the team should take based on the data.

## Usage

Provide the agent with the reporting period, data sources or raw data exports, and which KPIs matter most to your team. The agent returns a structured analytics report with insights and recommendations.

**Prompt:** `Generate a January 2025 marketing analytics report for our e-commerce site. Data sources: Google Analytics, Google Ads, and Shopify. Focus on traffic trends, conversion rate by channel, and ROAS.`

## Examples

### Example 1: Monthly Marketing Analytics Report

**Request:** Generate the February 2025 monthly report for `acmesaas.com`.

**Executive Summary:**

| Metric | Feb 2025 | Jan 2025 | MoM Change | YoY Change |
|--------|----------|----------|------------|------------|
| Total Sessions | 84,200 | 78,500 | +7.3% | +22.1% |
| Unique Visitors | 61,400 | 57,800 | +6.2% | +18.9% |
| Bounce Rate | 42.1% | 45.3% | -3.2 pts | -5.8 pts |
| Avg Session Duration | 3:42 | 3:18 | +12.1% | +8.4% |
| Lead Form Submissions | 1,240 | 1,080 | +14.8% | +31.2% |
| Trial Signups | 386 | 342 | +12.9% | +28.7% |
| CAC (blended) | $127 | $143 | -11.2% | -19.1% |
| Marketing-Attributed Revenue | $94,200 | $81,600 | +15.4% | +41.3% |

**Channel Breakdown:**

| Channel | Sessions | Conv. Rate | Leads | Cost | CAC |
|---------|----------|------------|-------|------|-----|
| Organic Search | 38,100 | 2.1% | 800 | $0 | $0 |
| Paid Search (Google) | 18,400 | 1.8% | 331 | $24,800 | $74.92 |
| LinkedIn Ads | 8,200 | 1.4% | 115 | $18,600 | $161.74 |
| Email Marketing | 12,600 | 3.2% | 403 | $1,200 | $2.98 |
| Direct / Referral | 6,900 | 0.9% | 62 | $0 | $0 |

**Key Insights:**
1. **Organic search is the efficiency leader.** It delivered 65% of all leads at zero marginal cost. The 22% YoY session growth reflects SEO investments from Q3–Q4 2024 compounding.
2. **Email marketing has the highest conversion rate at 3.2%.** The new onboarding drip sequence launched in January drove a 40% lift in email-sourced trial signups.
3. **LinkedIn Ads CAC is elevated at $161.74.** However, LinkedIn leads convert to paid customers at 2.4x the rate of Google Ads leads. When measured by LTV:CAC ratio, LinkedIn is more efficient.
4. **Bounce rate improved 3.2 points MoM.** This correlates with the homepage redesign deployed February 3rd, which added social proof and clearer CTAs above the fold.

**Recommendations:**
- Increase organic content investment: publish 2 additional SEO-targeted posts per week focused on high-intent commercial keywords identified in the January keyword gap analysis.
- Scale LinkedIn Ads budget by 20% but narrow targeting to Director+ titles at companies with 200–2,000 employees to reduce CAC.
- A/B test the trial signup page — current 12.9% growth is strong but the 1.8% paid search conversion rate suggests friction on the landing page.

### Example 2: Campaign Performance Analysis

**Request:** Analyze the "Q1 Product Launch" paid campaign running Jan 15–Feb 28 across Google Ads a