How do I install the 13 Data Analysis Global skill?

Run npx skillmds@latest add gabrielmoreira/13-data-analysis-global in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

What does the 13 Data Analysis Global skill do?

Use when raw data exists — Meta, Google, TikTok, GA4, Shopify, a CRM export, or a spreadsheet — and has to become insight and decisions: descriptive, diagnostic, predictive, and prescriptive layers, cuts by channel, campaign, creative, audience, and time, cohorts, and a decision log. Trigger on 'analyze this data', 'read these numbers for me', 'what does this export say', 'pull insight from GA4', 'cohort analysis', 'here is the spreadsheet'. Also use when the user pastes a table and asks what it means. Not for — diagnosing ad root cause, see `03-performance-eval-global`; writing the report a stakeholder reads, see `07-marketing-report-global`; auditing account setup, see `21-ads-audit-global`. It is listed under Product & Planning on SkillMD.

Is 13 Data Analysis Global safe to use?

This skill has not completed SkillMD's automated safety review yet. Capability flags: docs only. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with 13 Data Analysis Global?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is 13 Data Analysis Global free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published 13 Data Analysis Global?

gabrielmoreira (@gabrielmoreira) published this skill. Their other Agent Skills are listed on their SkillMD profile.

13 Data Analysis Global by gabrielmoreira

Name: 13 Data Analysis Global
Rating: 4.5 (4 reviews)
Author: gabrielmoreira

Marketing Data Analysis (Global)

Insight before numbers. Lead with judgment, illustrate with data — never list numbers without interpretation.

Information Gathering

Ask up to 4 questions:

Data source? Meta Ads, TikTok Ads, GA4, Shopify, Triple Whale/Hyros/Northbeam, Google Sheets — single source or combined?
Time window? This week, this month, A vs B (e.g. March vs April)?
Current business goal? Increase leads, lower CPL, raise ROAS, or a specific issue to fix?
Paste data here — drop a table, or describe core metrics (spend, impressions, clicks, leads, revenue).

Analysis Principles

Reading Order

1. DESCRIPTIVE   — What happened? (numbers, trends)
2. DIAGNOSTIC    — Why? (root cause)
3. PREDICTIVE    — What's next? (forecast)
4. PRESCRIPTIVE  — What to do? (concrete actions)

Presentation Rules

Rule	Explanation
Insight first, numbers second	"CPL up 40% due to creative fatigue" — not "CPL went from $5 to $7"
Compare, don't quote absolutes	Always compare with: prior week (WoW), prior month (MoM), or industry benchmark
Flag anomalies	Any metric moving > 20% vs prior period → flag for investigation
Recommendations have deadlines	Each recommendation specifies: action, when, owner, success metric

Analysis Frameworks by Source

Meta Ads

Level	Primary metrics	Secondary metrics
Account	Spend, ROAS, CPA	Frequency, Reach
Campaign	CPM, CPL, Conv rate	Budget utilization
Ad Set	CPC, CTR, CPM	Audience size, overlap
Ad (Creative)	Hook rate (3s view), Hold rate, CTR	Engagement rate, save rate

Reading Meta Ads:

High spend + low impressions → CPM high → audience too narrow or auction-pressured
High impressions + low clicks → CTR low → creative not compelling
High clicks + low leads → LP problem or form too long
High leads + low bookings → poor lead quality or weak nurture

TikTok Ads

Level	Primary metrics	Secondary metrics
Account	Spend, CPA, ROAS	Total impressions
Campaign	CPM, Cost per result	Campaign type performance
Ad Group	CPC, CTR, Conv rate	Audience size, age/gender split
Ad (Video)	2s view rate, 6s view rate, completion rate	Like, comment, share

Reading TikTok Ads:

2s view rate low → weak hook — first 3 seconds aren't strong enough
6s view rate low → losing attention after the hook
Completion rate low + CTR low → video doesn't drive action
CPV high → wrong audience, or video doesn't fit TikTok format

Google Analytics 4

Metric group	Metric	Meaning
Acquisition	Users, Sessions, Source/Medium	Traffic origin
Engagement	Engagement rate, Time on page, Pages/session	Traffic quality
Conversion	Conv rate, Events (form submit, click CTA)	Conversion effectiveness
Retention	Returning users, User retention	Stickiness

Reading GA4:

Traffic up + engagement down → low-quality traffic, filter sources
Traffic up + conversions down → LP problem or wrong-intent traffic
Bounce rate high (>70%) on one page → mismatch with ad copy or slow load

E-commerce Attribution Tools (Dropshipping/DTC)

For dropshipping or DTC stores, native ad-platform metrics often diverge from real revenue. Use one of these:

Tool	Best for	Key feature
Triple Whale	Shopify DTC	Pixel-based attribution, blended ROAS, AI insights
Hyros	Info products + DTC	Server-side tracking, long-window attribution
Northbeam	High-spend DTC ($100K+/mo)	MTA + MMM, incrementality testing
Polar Analytics	Mid-market DTC	All-in-one dashboards, source-of-truth tracking
Wicked Reports	Email-heavy DTC	Multi-touch attribution including email

Cross-checking: when Meta reports 5x ROAS but Shopify reports 2x ROAS, trust the platform-of-record (Shopify). The gap is usually iOS 14+ attribution loss.

Spreadsheet Data (Manual)

When user pastes data from a sheet:

Identify core columns: date, channel, spend, units (impressions/clicks/leads/orders), revenue
Compute derived metrics: CPL, CPA, ROAS, conversion rate
Sort by time to surface trends
Group by channel/campaign for comparison

Trend Detection

Week over Week (WoW)

Metric	Prior week	This week	Change	Status
[Metric]	[Value]	[Value]	[+/- %]	[Normal / Watch / Alert]

Alert thresholds:

10–20% change → monitor, no action yet
20–40% change → investigate, prepare a response
40% change → act now

Month over Month (MoM)

Metric	Prior month	This month	Change	vs Industry benchmark
[Metric]	[Value]	[Value]	[+/- %]	[Above/Below industry avg]

Seasonality (Global)

Period	Impact	Adjustment
Q4 holiday (US: Black Friday → Christmas)	CPM +30–50%, conversion up	Increase budget; book inventory early; lock LPs
Chinese New Year	Asia logistics paused, CPM +20% in APAC	Move launches before/after; warn customers about shipping
Back-to-school (US: Aug; UK: Sep)	CPM +10–15% (education/electronics)	Plan from June
Valentine's, Mother's Day, Father's Day	CPM +15–25% (gifting niches)	Run campaigns 1 week before
Summer (Northern hemisphere: Jun–Aug)	CPM dips 10–15% in many verticals	Test creative, scale new channels
Ramadan / Eid (varies by year)	MENA conversion shifts	Adjust tone, timing — engagement spikes after iftar

Anomaly Detection (Decision Trees)

CPL Spike

CPL up
├── CTR down? → Creative fatigue → Refresh creative
├── CTR normal + Conv rate down? → LP issue
│   ├── Slow load? → Check PageSpeed
│   ├── Form broken? → Test form on mobile
│   └── Wrong intent traffic? → Audit audience targeting
└── CPM up? → Auction pressure or seasonality
    ├── Holiday / sale season? → Increase budget or pause
    └── Competitor spend up? → Switch audience or channel

ROAS Drop

ROAS down
├── Revenue down + spend flat? → Conversion problem
│   ├── Lead quality poor? → Check audience
│   ├── Sales team slow? → Check response time
│   └── Pricing changed? → Audit pricing
├── Revenue flat + spend up? → Over-spending
│   ├── Scaled too fast? → Reduce, max 20%/day increase
│   └── New channel not optimized? → Stop scaling, optimize first
└── Both down? → Systemic issue
    ├── Competitor running big promo? → Competitor scan
    └── Off-season? → Check seasonality

Engagement Drop

Engagement down
├── Reach down? → Algo de-prioritized
│   ├── Too many promo posts? → Increase educational/entertainment ratio
│   └── Posting too often? → Reduce frequency
├── Reach normal + ER down? → Content not compelling
│   ├── Stale format? → Try new formats (carousel, POV, duet)
│   └── Repetitive topics? → Rotate angles per content matrix
└── Reach up + ER down? → Wrong audience reaching

Cohort Analysis

Monthly Cohort Template

Cohort (signup month)	Month 1	Month 2	Month 3	Month 6	Month 12
Jan 2026 (100 customers)	100%	[X%] active	[X%]	[X%]	[X%]
Feb 2026 (120 customers)	100%	[X%]	[X%]	[X%]	—
Mar 2026 (95 customers)	100%	[X%]	[X%]	—	—

Reading:

Steady decline across months → natural churn, build retention program
Sharp drop in month 2 → bad first experience, fix onboarding
Stable from month 3 → retention floor reached, focus on this segment

Cohort by Acquisition Source

Source	Customers	CAC	LTV 90 days	LTV:CAC
Meta Ads	[X]	[X]	[X]	[X:1]
TikTok Ads	[X]	[X]	[X]	[X:1]
Organic	[X]	[X]	[X]	[X:1]
Referral	[X]	[X]	[X]	[X:1]
Email	[X]	[X]	[X]	[X:1]

Healthy LTV:CAC is generally 3:1 or better.

Attribution Models

Comparing 3 Models

Model	How it credits	When to use
Last Click	100% to final touch	Default, simple, short funnels
First Click	100% to first touch	Evaluating TOFU/awareness channels
Linear	Equal split across all touches	Long funnels, multi-channel, fair credit

Attribution comparison template:

Channel	Last Click	First Click	Linear	Note
Meta Ads	[X orders]	[X orders]	[X orders]	[Role: TOFU/BOFU?]
TikTok Ads	[X orders]	[X orders]	[X orders]	[Role?]
Google Search	[X orders]	[X orders]	[X orders]	[Role?]
Organic	[X orders]	[X orders]	[X orders]	[Role?]
Email	[X orders]	[X orders]	[X orders]	[Role?]

Recommendations:

Short funnel (1–3 days): Last Click works
Medium funnel (7–14 days): use Linear
Long funnel (30+ days): First Click for TOFU, Last Click for BOFU
DTC/dropshipping at scale: switch to a dedicated tool (Triple Whale, Hyros, Northbeam)

Output Template

# Data Analysis Report — [Brand/Campaign]
Period: [Start] — [End]
Data sources: [Meta Ads / TikTok Ads / GA4 / Shopify / ...]
Analysis date: [YYYY-MM-DD]

---

## 1. Executive Summary

**3 most important insights:**
1. [Insight 1 — written as judgment, not raw numbers]
2. [Insight 2]
3. [Insight 3]

**Overall status:** [Green = stable | Yellow = monitor | Red = urgent action]

---

## 2. Descriptive — What happened?

### Top-line metrics

| Metric | This period | Prior period | Change | Industry benchmark | Status |
|--------|-------------|--------------|--------|--------------------|--------|
| Spend | [X] | [X] | [+/- %] | — | [icon] |
| Impressions | [X] | [X] | [+/- %] | — | [icon] |
| Clicks | [X] | [X] | [+/- %] | — | [icon] |
| CTR | [X%] | [X%] | [+/- %] | [X%] | [icon] |
| Leads | [X] | [X] | [+/- %] | — | [icon] |
| CPL | [X] | [X] | [+/- %] | [X] | [icon] |
| ROAS | [Xx] | [Xx] | [+/- %] | [Xx] | [icon] |

### Performance by channel

| Channel | Spend | Leads | CPL | ROAS | % of budget | Note |
|---------|-------|-------|-----|------|-------------|------|
| Meta Ads | [X] | [X] | [X] | [Xx] | [X%] | [1 sentence] |
| TikTok Ads | [X] | [X] | [X] | [Xx] | [X%] | [1 sentence] |
| Google Ads | [X] | [X] | [X] | [Xx] | [X%] | [1 sentence] |

### Top 5 campaigns

| Campaign | Spend | Leads | CPL | ROAS | Note |
|----------|-------|-------|-----|------|------|
| 1. [Name] | [X] | [X] | [X] | [Xx] | [1 sentence] |
| 2. [Name] | [X] | [X] | [X] | [Xx] | [1 sentence] |
| 3. [Name] | [X] | [X] | [X] | [Xx] | [1 sentence] |
| 4. [Name] | [X] | [X] | [X] | [Xx] | [1 sentence] |
| 5. [Name] | [X] | [X] | [X] | [Xx] | [1 sentence] |

### Top 3 creatives

| Creative | Format | Hook rate | CTR | CPL | Days running | Note |
|----------|--------|-----------|-----|-----|--------------|------|
| 1. [Name/desc] | [Video/Image/Carousel] | [X%] | [X%] | [X] | [X days] | [1 sentence] |
| 2. [Name/desc] | [Format] | [X%] | [X%] | [X] | [X days] | [1 sentence] |
| 3. [Name/desc] | [Format] | [X%] | [X%] | [X] | [X days] | [1 sentence] |

---

## 3. Diagnostic — Why?

### What's working — why?
- [Cause 1 + supporting data]
- [Cause 2 + supporting data]

### What's not — why?
- [Cause 1 + supporting data + remedy]
- [Cause 2 + supporting data + remedy]

### Anomalies to investigate
- [Anomaly 1 — description + likely cause + investigation step]
- [Anomaly 2]

---

## 4. Predictive — Forecast

### Next period (3 scenarios)

| Metric | Bear | Base | Bull |
|--------|------|------|------|
| Spend | [X] | [X] | [X] |
| Leads | [X] | [X] | [X] |
| CPL | [X] | [X] | [X] |
| ROAS | [Xx] | [Xx] | [Xx] |
| Revenue | [X] | [X] | [X] |

### Forecast drivers
- [Driver 1: seasonality, competitor, algo change, ...]
- [Driver 2]

---

## 5. Prescriptive — Actions

### Act now (next 48h)
| # | Action | Owner | Deadline | Measure by |
|---|--------|-------|----------|------------|
| 1 | [Specific action] | [Role] | [Date] | [Metric] |
| 2 | [Specific action] | [Role] | [Date] | [Metric] |

### This week
| # | Action | Owner | Deadline | Measure by |
|---|--------|-------|----------|------------|
| 1 | [Specific action] | [Role] | [Date] | [Metric] |
| 2 | [Specific action] | [Role] | [Date] | [Metric] |

### This month
| # | Action | Owner | Deadline | Measure by |
|---|--------|-------|----------|------------|
| 1 | [Specific action] | [Role] | [Date] | [Metric] |
| 2 | [Specific action] | [Role] | [Date] | [Metric] |

Auto-Diagnostics

When analyzing, automatically check these conditions:

Condition	Check	Action
CPL up > 30% WoW	Creative running > 14 days? Frequency > 3?	Refresh creative, rotate audience
CTR < 0.8%	Strong 3s hook? Eye-catching imagery?	A/B test hooks, change opening frame
ROAS < 2x for 7 days	Right audience? LP conv rate?	Narrow audience, audit LP
LP conv rate < 3%	Load time? Form length? CTA clarity?	Trigger skill 12-landing-page-brief-global
Frequency > 4	Audience saturated	Expand audience or switch channel
Spend < 70% of budget	Audience too narrow or bid too low	Expand audience, raise bid
One channel > 60% spend	Single-channel dependency risk	Reallocate, test new channel

Skill Cross-references

03-performance-review-global — broader marketing performance review
07-marketing-report-global — turn analysis into stakeholder-ready monthly/quarterly report
10-reverse-kpi-calc-global — recompute KPIs and budget from real data
12-landing-page-brief-global — when LP conversion is the bottleneck
05-ad-copy-global — when creative is the bottleneck
15-social-listening-global — add qualitative data (sentiment, trends) alongside quantitative

Quality Checklist

Before delivering the report

Every insight has supporting data
Every number is compared (WoW, MoM, or vs benchmark)
Anomalies (> 20% change) flagged and explained
Recommendations specify: owner, deadline, success metric
Forecast includes 3 scenarios (bear, base, bull)
No raw numbers without interpretation
Source and time window are clearly stated
Cross-checked: ad-platform spend matches actual spend
For dropshipping/DTC: revenue cross-checked between Shopify and ad platform

13 Data Analysis Global

File contents

Marketing Data Analysis (Global)

Information Gathering

Analysis Principles

Reading Order

Presentation Rules

Analysis Frameworks by Source

Meta Ads

TikTok Ads

Google Analytics 4

E-commerce Attribution Tools (Dropshipping/DTC)

Spreadsheet Data (Manual)

Trend Detection

Week over Week (WoW)

Month over Month (MoM)

Seasonality (Global)

Anomaly Detection (Decision Trees)

CPL Spike

ROAS Drop

Engagement Drop

Cohort Analysis

Monthly Cohort Template

Cohort by Acquisition Source

Attribution Models

Comparing 3 Models

Output Template

Auto-Diagnostics

Skill Cross-references

Quality Checklist

Before delivering the report

Frequently asked questions

13 Data Analysis Global

File contents

Marketing Data Analysis (Global)

Information Gathering

Analysis Principles

Reading Order

Presentation Rules

Analysis Frameworks by Source

Meta Ads

TikTok Ads

Google Analytics 4

E-commerce Attribution Tools (Dropshipping/DTC)

Spreadsheet Data (Manual)

Trend Detection

Week over Week (WoW)

Month over Month (MoM)

Seasonality (Global)

Anomaly Detection (Decision Trees)

CPL Spike

ROAS Drop

Engagement Drop

Cohort Analysis

Monthly Cohort Template

Cohort by Acquisition Source

Attribution Models

Comparing 3 Models

Output Template

Auto-Diagnostics

Skill Cross-references

Quality Checklist

Before delivering the report

Related skills

Frequently asked questions

How do I install the 13 Data Analysis Global skill?

What does the 13 Data Analysis Global skill do?

Is 13 Data Analysis Global safe to use?

Which AI agents work with 13 Data Analysis Global?

Is 13 Data Analysis Global free to use?

Who published 13 Data Analysis Global?