Data Analyst: Turn Numbers Into Decisions That Drive Growth
Bridge the gap between data collection and business decisions. GA4 analysis, conversion tracking, ROI calculation, and dashboard creation�all translated into clear, prioritized recommendations anyone can understand and act on.
The Problem: Drowning in Data, Starving for Insights
Analytics Overload, Zero Clarity
You have Google Analytics 4 installed. You see numbers: 3,247 sessions, 12,389 page views, 2.3 pages/session, 47% bounce rate. What does it mean? Is that good? What should you do about it? No idea.
Result: Marketing decisions made on gut feel, not data. Budget wasted on channels that don't convert. Opportunities missed because you can't see them in the numbers.
No Idea What's Working (Or What It Costs)
You're running SEO, Google Ads, and social media. Total marketing budget: $4,000/month. Which channel delivers the best ROI? What's your cost per lead? Cost per acquisition? Customer lifetime value? You don't know.
Result: You're spending $2,500/month on Google Ads getting 15 leads at $167 each. Meanwhile, SEO delivers 30 leads at $50 each�but you keep increasing ad spend because "it's working." You're leaving $3,500/month on the table.
Conversion Tracking Is Broken (Or Missing)
Traffic dropped 30% last month. Is it seasonal? Technical issue? Algorithm update? Competitor launched? You can't tell. Your conversion funnel: 1,000 visitors �??? �12 leads. Where are people dropping off? No tracking to answer that question.
Result: You're flying blind. Can't prove ROI to stakeholders. Can't optimize what you can't measure. Every marketing meeting is guesswork, not strategy.
The Fix: Data Analyst transforms raw analytics into actionable insights�GA4 analysis, conversion tracking, ROI calculation, channel comparison, monthly performance reports with clear recommendations. You'll know exactly what's working, what's not, and what to do about it.
Core Capabilities: What This Agent Does
Google Analytics 4 (GA4) Analysis
Deep dive into GA4 data: traffic sources, user behavior, engagement metrics, landing page performance, device breakdown, geographic data. Identifies trends, anomalies, and opportunities. Benchmarks against industry standards. Provides context for every metric.
Conversion Funnel Analysis
Maps complete customer journey from traffic to conversion. Identifies drop-off points in funnel (awareness �interest �consideration �intent �action). Calculates conversion rate at each stage. Prioritizes fixes based on volume and impact. A/B test recommendations.
ROI Calculation & Unit Economics
Calculates CAC (Customer Acquisition Cost), LTV (Lifetime Value), and ROI by channel. Tracks unit economics: cost per lead, cost per acquisition, profit per job. Compares channel performance. Recommends budget allocation based on hard ROI data.
Dashboard Creation & Visualization
Creates executive dashboards (monthly KPIs, trends, wins/opportunities), channel-specific dashboards (SEO, social, content performance), and custom reports. Visual data representation for complex metrics. Mobile-friendly, actionable insights.
Campaign Performance Measurement
Tracks SEO performance (organic traffic, rankings, conversions), social media ROI, content marketing effectiveness, email campaign results, paid advertising ROAS. Cross-channel attribution analysis. Campaign-to-revenue tracking.
Multi-Channel Analytics & Comparison
Compares all marketing channels side-by-side: traffic, leads, conversion rate, CAC, ROI. Identifies highest-performing channels. Reveals underperforming channels. Recommends optimization or reallocation. Tracks multi-touch attribution.
Traffic Drop Investigation
Investigates sudden traffic changes. Verifies data accuracy (tracking issues, date ranges). Identifies affected channels. Checks for technical problems, algorithm updates, competitor changes. Quantifies impact (lost leads, revenue). Recommends corrective actions.
Opportunity Identification
Proactively identifies optimization opportunities: low-hanging fruit (high traffic, low conversion pages), content gaps (high bounce pages), channel opportunities (underutilized platforms). Quantifies potential impact. Prioritizes by effort vs. reward.
Data Compilation for Orchestrated Workflows
Compiles data across orchestrated workflows: competitive intelligence (aggregate 5 competitor analyses), SEO strategy (compile 4 analysis reports), marketing mix intelligence (compile 5 channel reports). Creates comparison matrices and structured JSON outputs.
Audience Insights & Segmentation
Analyzes audience demographics (age, gender, location), device breakdown (mobile/desktop/tablet), user behavior patterns, new vs. returning users. Identifies highest-value segments. Recommends targeting strategies.
Insights Translation
Translates technical metrics to business outcomes. Speaks in plain language (no jargon). Focuses on what matters (not every metric). Tells a story with data. Provides honest assessment of uncertainty or limitations.
Data Accuracy & Quality Assurance
Verifies data before analysis. Checks for tracking errors or gaps. Accounts for data processing delays (GA4 24-48 hour lag). Cross-references multiple sources. Uses statistical significance. Separates correlation from causation.
When to Use Data Analyst
Monthly Performance Reporting
Need comprehensive monthly analytics report with traffic trends, conversion analysis, ROI by channel, top wins, opportunities, and clear action plan for next month.
Traffic or Conversion Drop Investigation
Traffic dropped suddenly or conversion rate declining. Need root cause analysis, impact quantification, and specific recommendations to recover performance.
ROI Calculation & Channel Comparison
Running multiple marketing channels but don't know which delivers best ROI. Need CAC, LTV, and ROI calculation to optimize budget allocation.
Conversion Funnel Optimization
Getting traffic but not enough conversions. Need funnel analysis to identify drop-off points, prioritize fixes, and test improvements.
Executive Dashboard Creation
Need high-level dashboard for stakeholders showing KPIs, trends, wins, opportunities�simple, visual, actionable insights without overwhelming detail.
Data Compilation for Workflows
During orchestrated workflows (competitive intelligence, SEO strategy, marketing mix analysis), compiles multiple agent outputs into structured comparison matrices and reports.
How Data Analyst Works
Raw data �pattern identification �insights �prioritized recommendations
1. Data Collection & Validation
Gathers data from all relevant sources: GA4, Google Search Console, social media analytics, CRM data, financial data. Verifies data accuracy. Checks for tracking errors, anomalies, or gaps. Establishes baseline metrics. Accounts for processing delays (GA4 24-48 hours).
2. Pattern Identification & Analysis
Looks for trends over time (week-over-week, month-over-month, year-over-year). Identifies correlations between metrics. Spots outliers and anomalies. Compares performance across segments (channels, pages, devices, locations). Considers seasonality and external factors.
3. Root Cause Analysis
Goes beyond "what" to determine "why." Tests hypotheses with data. Considers external factors (seasonality, market changes, algorithm updates). Validates findings with multiple data sources. Separates correlation from causation. Documents uncertainty when data is inconclusive.
4. Opportunity Quantification
Calculates potential impact for each opportunity (additional traffic, leads, revenue). Estimates effort required (hours, cost, timeline). Assesses risk level (low/medium/high). Creates ROI projections for recommended actions. Prioritizes opportunities by impact vs. effort.
5. Prioritized Recommendations
Uses 2�2 matrix: Impact (high/low) �Effort (high/low). High impact, low effort = do immediately. High impact, high effort = plan carefully. Low impact, low effort = do if time permits. Low impact, high effort = avoid. Recommendations include specific actions, responsible parties, timeline, expected outcomes.
6. Clear Action Plan & Reporting
Creates comprehensive monthly report with executive summary, key insights (top 3 wins, top 3 opportunities, areas of concern), detailed analysis (traffic, conversions, ROI, audience), and action plan (immediate actions, this month, next 90 days). Plain language, visual data, actionable recommendations.
Real Results: HVAC Company Channel Performance Analysis
Before Data Analysis
Client running SEO ($1,500/month), Google Ads ($2,500/month + $3,000 ad spend), and social media ($500/month). Total marketing budget: $7,500/month. No tracking of which channel delivers best ROI.
| Channel | Monthly Cost | Perceived Value |
|---|---|---|
| Google Ads | $5,500 ($2,500 mgmt + $3,000 ad spend) | "Best performer�lots of calls" |
| SEO | $1,500 | "Takes too long�not sure if working" |
| Social Media | $500 | "Need it for brand awareness" |
| Google Business Profile | $0 (DIY) | "Post when we remember" |
Decision-Making: Gut feel. Owner wanted to increase Google Ads spend to $5,000/month because "it's working."
After ROI Analysis (Data Analyst Report)
| Channel | Leads | CAC | Close Rate | LTV | ROI |
|---|---|---|---|---|---|
| Google Business Profile | 45 | $50 | 35% | $1,200 | 1,400% |
| Organic SEO | 30 | $150 | 40% | $1,200 | 400% |
| Social Media | 20 | $200 | 25% | $1,200 | 288% |
| Google Ads | 15 | $367 | 50% | $1,200 | 114% |
The Shocking Truth
Google Business Profile: $0 investment generating 45 leads/month at $50 CAC with 1,400% ROI (highest volume, lowest cost, best ROI)
SEO: $1,500/month generating 30 leads at $150 CAC with 400% ROI (second-best performer, 40% close rate)
Google Ads: $5,500/month generating only 15 leads at $367 CAC with 114% ROI (highest cost, lowest ROI, barely profitable)
Recommended Budget Reallocation
1. Increase GBP focus: $500/month (professional management, daily posting, review generation, Q&A optimization)
2. Double SEO investment: $3,000/month (content creation, technical optimization, link building)
3. Maintain social media: $500/month (organic posting, engagement)
4. Reduce Google Ads to break-even: $2,000/month ($1,000 mgmt + $1,000 ad spend for branded terms only)
New total budget: $6,000/month (saved $1,500/month)
Projected Impact (Based on Data Analysis)
GBP optimization: 45 �75 leads/month (+30 leads at $67 CAC)
SEO doubling: 30 �60 leads/month (+30 leads at $150 CAC)
Google Ads reduction: 15 �8 leads/month (-7 leads, but saves $3,500/month)
Net result: 110 �143 leads/month (+33 leads, -$1,500 budget)
Additional revenue/month: $13,200 (33 leads �40% close �$1,000 avg job)
ROI of data analysis: Client paid $800 for comprehensive analytics report. Gained $13,200/month in revenue + saved $1,500/month in wasted ad spend. First month ROI: 17:1
Technical Implementation Details
Model & Performance
- Primary Model: Claude Opus (for complex analysis, insights generation, recommendations)
- Compilation Tasks: Claude Haiku (for mechanical data aggregation in orchestrated workflows�saves ~50% cost)
- Analysis Speed: Monthly performance report delivered in 2-4 hours
- Data Processing: Handles GA4 24-48 hour lag, verifies data accuracy before analysis
- Output Format: Markdown reports, JSON data structures, visual dashboards, comparison matrices
Data Sources & Integrations
- Primary Analytics: Google Analytics 4 (via google-analytics-4-manager skill)
- SEO Data: Google Search Console (via gsc-data-extractor skill)
- Social Analytics: Platform-specific skills (YouTube, Facebook, Instagram)
- Conversion Data: CRM integrations, form tracking, phone tracking
- Financial Data: Revenue attribution, cost tracking, profit margins
- Data Processing: Google Sheets (via Google Workspace MCP) for custom calculations
Key Metrics Tracked
- Traffic Metrics: Users, sessions, pageviews, traffic sources, landing pages, exit pages
- Engagement: Engagement rate, average engagement time, pages/session, scroll depth, events
- Conversions: Conversion rate by channel, goal completions, form submissions, phone clicks
- Audience: Demographics, device breakdown, locations, new vs. returning users
- Unit Economics: CAC (Customer Acquisition Cost), LTV (Lifetime Value), ROI by channel
- Attribution: First-touch, last-touch, linear, time-decay, position-based models
Analysis Standards
- Data Accuracy: Always verify data before analysis, check for tracking errors, account for processing delays
- Statistical Rigor: Use statistical significance, don't over-interpret small sample sizes
- Context: Consider seasonality, external factors, algorithm updates
- Causation vs. Correlation: Test hypotheses, validate with multiple sources
- Reporting: Lead with insight (not data), use plain language, visualize complex data
- Honesty: Transparent about uncertainty, admit when data is inconclusive
Related Agents & Workflows
Works Closely With:
Marketing Analytics Specialist
Orchestrates comprehensive marketing intelligence analysis.
Comprehensive SEO Strategist
Provides SEO data for organic traffic analysis.
Business Development Consultant
Uses data insights for competitive intelligence reporting.
Content Copywriter
Leverages content performance data for optimization.
Orchestrated Workflows (Participant Role):
Pattern 1: Competitive Intelligence
Your Role: Data compilation (Haiku) - aggregate 5 competitor analyses into master comparison matrices and structured JSON
Timeline: 15-20 minutes (mechanical aggregation)
Orchestrated by: business-development-consultant
Pattern 2: SEO Strategy Development
Your Role: Data compilation (Haiku) - compile 4 analysis reports into master SEO audit JSON with comparison matrices
Timeline: 15 minutes (mechanical aggregation)
Orchestrated by: comprehensive-seo-strategist
Pattern 4: Marketing Mix Intelligence
Your Role: Data compilation (Haiku) - compile 5 channel reports into master marketing dashboard, calculate cross-channel metrics
Timeline: 20 minutes (quarterly compilation)
Orchestrated by: marketing-analytics-specialist
Pattern 3: Architecture Design
Your Role: Documentation compilation support when needed for technical documentation
Timeline: Variable (as needed)
Orchestrated by: software-architect
When Data Analyst Is Right For You
Perfect If You:
- Have analytics installed but don't know what the numbers mean
- Running multiple marketing channels but can't tell which works best
- Need to prove ROI to stakeholders or justify marketing budget
- Traffic or conversion rate changed and you don't know why
- Want monthly performance reports with clear action plans
- Making marketing decisions on gut feel instead of data
- Need conversion funnel analysis to optimize lead generation
- Launching new campaigns and want baseline + ongoing tracking
- Local service business tracking CAC, LTV, profit per job
Not Needed If:
- You have zero traffic or conversions yet (nothing to analyze)
- No analytics tracking installed (need tracking setup first)
- Brand new website with <30 days of data (wait for baseline)
- You have in-house data analyst who provides monthly reports
- You only run one marketing channel with clear tracking
Turn Your Data Into Decisions That Drive Growth
Let's analyze your GA4 data, calculate ROI by channel, identify optimization opportunities, and create clear action plan. Data-driven growth starts here.
Comprehensive analytics report delivered in 3-5 business days. Monthly reporting packages available.
Data Analytics: Relevant Agents & Services
Transform raw data into actionable business insights
Related Industries
Marketing Analytics Specialist
Orchestrates comprehensive marketing intelligence analysis.
Learn moreBusiness Development Consultant
Uses data insights for competitive intelligence reporting.
Learn more