Competitive Intelligence — Workflow Architecture
5 Phases · 10 Dashboard Sections
Skill: /competitive-intel-dashboard

Five-Phase Intelligence
Workflow Architecture

From raw company names to a fully interactive competitive intelligence terminal. Each phase is orchestrated sequentially — automated data collection feeds manual research, which feeds AI synthesis, which feeds dashboard generation.

Pipeline Overview

The pipeline opens with automated data collection against the SimilarWeb API for each target domain. Twelve months of desktop and mobile traffic are ingested, then split into two six-month halves to surface directional trends. A secondary referral analysis script processes the raw JSON to identify new inbound sources, flag any driving ≥5% of traffic, and generate partnership hypotheses.

Steps
  1. 1
    Confirm company domains
    e.g. stripe.com, squareup.com
  2. 2
    Run traffic analysis script
    analyze_traffic_trends.py — 12-month organic vs paid
  3. 3
    Flag organic drops >15%
    Check if paid spend compensated
  4. 4
    Run referral analysis script
    analyze_referral_sources.py — new sources, 5%+ share
  5. 5
    Generate strategic takeaways
    Per-company verdict + channel verdict
Outputs
  • traffic_data_{domain}.json
  • referral_findings.json
  • Per-company traffic verdict
Sources
  • SimilarWeb API (desktop + mobile)
  • Domain confirmation (public WHOIS / company site)
Known Limitations
  • SimilarWeb figures are estimates, not audited measurements
  • Private companies with low web presence have LOW confidence scores
Dashboard Output (10 Sections)
Key Metrics
Executive Summary
Company Positioning
Strategy Matrix
Traffic Trends
Referral Analysis
Paid Ads Intel
Pitch Angles
Playbook
Confidence
Confidence Scoring
HIGHPublic filings, audited data
MEDIUMEstimates, analyst reports
LOWInferences, limited signals
Source Hierarchy
110-K / Annual Reports
2Press Releases / IR Pages
3Credit Ratings (Fitch)
4Analyst Reports (IDC, Datos)
5SimilarWeb Estimates
6Ad Library Observations
7Referral Traffic Inferences

Competitive Intelligence Workflow · /competitive-intel-dashboard skill · Manus