13-phan-tich-du-lieu
# ClaudeWave: 13-phan-tich-du-lieu This Claude Code skill analyzes marketing data across channels (Meta Ads, TikTok Ads, GA4) and dimensions (campaigns, creatives, audiences, time periods) to extract actionable insights. Use it when you need to move beyond raw metrics to understand why performance changed and what specific actions to take, following a framework that prioritizes insights before numbers and always compares results to previous periods rather than reporting absolutes.
git clone --depth 1 https://github.com/minhnv0807/ai-business-skills /tmp/13-phan-tich-du-lieu && cp -r /tmp/13-phan-tich-du-lieu/skills/vi/13-phan-tich-du-lieu ~/.claude/skills/13-phan-tich-du-lieuSKILL.md
# Phan Tich Du Lieu Marketing
> Insight truoc so lieu. Nhan dinh truoc, so lieu de minh hoa — khong liet ke so lieu roi.
---
## Thu thap thong tin
Hoi user toi da 4 cau:
1. **Du lieu tu nguon nao?** Meta Ads, TikTok Ads, GA4, Google Sheets, hay ket hop nhieu nguon?
2. **Khung thoi gian?** Tuan nay, thang nay, so sanh 2 giai doan (VD: thang 3 vs thang 4)?
3. **Muc tieu kinh doanh hien tai?** Tang lead, giam CPL, tang ROAS, hay co van de cu the can xu ly?
4. **Dan data vao day** — paste bang so lieu, hoac mo ta cac chi so chinh (spend, impression, click, lead, revenue).
---
## Nguyen tac phan tich
### Thu tu doc data
```
1. DESCRIPTIVE — Da xay ra gi? (so lieu, xu huong)
2. DIAGNOSTIC — Tai sao? (nguyen nhan goc)
3. PREDICTIVE — Se xay ra gi tiep? (du bao)
4. PRESCRIPTIVE — Can lam gi? (hanh dong cu the)
```
### Quy tac trinh bay
| Quy tac | Giai thich |
|---------|-----------|
| Insight dau, so lieu sau | "CPL tang 40% do creative exhaustion" — khong phai "CPL tu 50K len 70K" |
| So sanh, khong doc tuyet doi | Luon so sanh voi: tuan truoc (WoW), thang truoc (MoM), hoac benchmark nganh |
| Flag bat thuong | Bat ky chi so nao thay doi > 20% so voi ky truoc → danh dau de dieu tra |
| De xuat co thoi han | Moi de xuat phai co: lam gi, khi nao, ai lam, do bang gi |
---
## Framework phan tich theo nguon du lieu
### Meta Ads
| Cap do | Chi so chinh | Chi so bo tro |
|--------|-------------|--------------|
| Account | Spend, ROAS, CPA | Frequency, Reach |
| Campaign | CPMess, 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 |
**Cach doc Meta Ads:**
```
Spend cao + Impression thap → CPM cao → doi tuong qua hep hoac dang canh tranh cao
Impression cao + Click thap → CTR thap → creative khong hap dan
Click cao + Lead thap → Landing page co van de hoac form qua dai
Lead cao + Booking thap → Chat luong lead kem hoac quy trinh cham soc yeu
```
### TikTok Ads
| Cap do | Chi so chinh | Chi so bo tro |
|--------|-------------|--------------|
| Account | Spend, CPA, ROAS | Total impression |
| Campaign | CPMess, 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 |
**Cach doc TikTok Ads:**
```
2s view rate thap → Hook yeu — 3 giay dau khong du manh
6s view rate thap → Noi dung mat hap dan sau hook
Completion rate thap + CTR thap → Video khong dua den hanh dong
CPV cao → Audience sai hoac video khong phu hop format TikTok
```
### Google Analytics 4
| Nhom chi so | Chi so | Y nghia |
|-------------|--------|---------|
| Acquisition | Users, Sessions, Source/Medium | Nguon traffic |
| Engagement | Engagement rate, Time on page, Pages/session | Chat luong traffic |
| Conversion | Conv rate, Events (form submit, click CTA) | Hieu qua chuyen doi |
| Retention | Returning users, User retention | Kha nang giu chan |
**Cach doc GA4:**
```
Traffic tang + Engagement giam → Traffic rac, can loc nguon
Traffic tang + Conv giam → Landing page co van de hoac traffic sai intent
Bounce rate cao (>70%) o 1 trang → Content khong khop voi quang cao hoac load cham
```
### Google Sheets (Data thu cong)
Khi user dan data tu Google Sheets:
1. Xac dinh cac cot chinh: ngay, kenh, chi phi, so luong (impression/click/lead/don), doanh thu
2. Tinh cac chi so phat sinh: CPL, CPA, ROAS, conversion rate
3. Sap xep theo thoi gian de phat hien xu huong
4. Nhom theo kenh/chien dich de so sanh
---
## Phat hien xu huong
### Week over Week (WoW)
| Chi so | Tuan truoc | Tuan nay | Thay doi | Trang thai |
|--------|-----------|---------|----------|-----------|
| [Chi so] | [Gia tri] | [Gia tri] | [+/- %] | [Binh thuong / Canh bao / Nguy hiem] |
**Nguong canh bao:**
- Thay doi 10–20% → Theo doi, chua can hanh dong
- Thay doi 20–40% → Dieu tra nguyen nhan, chuan bi phuong an
- Thay doi > 40% → Hanh dong ngay
### Month over Month (MoM)
| Chi so | Thang truoc | Thang nay | Thay doi | vs Benchmark nganh |
|--------|------------|---------|----------|-------------------|
| [Chi so] | [Gia tri] | [Gia tri] | [+/- %] | [Tren/Duoi TB nganh] |
### Yeu to mua vu (Seasonality) — Vietnam
| Thoi diem | Tac dong | Dieu chinh |
|-----------|---------|-----------|
| Tet Nguyen Dan (T1–T2) | CPM +30–50%, traffic giam | Tang ngan sach 30%, chay truoc Tet 2 tuan |
| 8/3, 20/10 | CPM +15–25% (beauty, qua tang) | Chay chien dich truoc 1 tuan |
| Back to school (T8–T9) | CPM +10–15% (giao duc) | Len ke hoach tu T7 |
| Black Friday (T11) | CPM +20–30% | Chay remarketing la chinh |
| He (T6–T7) | CPM giam 10–15% (nhieu nganh) | Co hoi test creative moi, scale kenh moi |
---
## Phat hien bat thuong (Anomaly Detection)
Khi 1 chi so bat thuong, dieu tra theo cay nguyen nhan:
### CPL tang dot bien
```
CPL tang
├── CTR giam? → Creative exhaustion → Thay creative moi
├── CTR binh thuong + Conv rate giam? → Landing page co van de
│ ├── Load cham? → Kiem tra PageSpeed
│ ├── Form loi? → Test form tren mobile
│ └── Traffic sai intent? → Kiem tra audience targeting
└── CPM tang? → Canh tranh cao hoac mua vu
├── Mua Tet/sale? → Tang ngan sach hoac tam dung
└── Doi thu tang spend? → Doi audience hoac kenh
```
### ROAS giam dot bien
```
ROAS giam
├── Revenue giam + Spend giu nguyen? → Van de chuyen doi
│ ├── Lead chat luong kem? → Kiem tra audience
│ ├── Sales team cham? → Kiem tra response time
│ └── Gia ban thay doi? → Kiem tra pricing
├── Revenue giu + Spend tang? → Over-spending
│ ├── Scale qua nhanh? → Giam lai, tang 20%/ngay max
│ └── Kenh moi chua toi uu? → Dung scale, toi uu truoc
└── Ca hai giam? → Van de toan dien
├── Doi thu co khuyen mai lon? → Phan tich doi thu
└── Mua thap diem? → Kiem tra seasonality
```
### Engagement giam dot bien
```
Engagement giam
├── Reach giam? → Thuat toan de-prioritize
│ ├── Content nhieu quangKe hoach Fullstack Marketing — master skill tong hop chien luoc, noi dung, trien khai, hieu suat, va timeline. Goi cac skill con de hoan thien output.
Use when the user needs an overall marketing plan for a period — objectives, segments, positioning, channel mix, content direction, budget, timeline, KPIs, and a risk matrix, adapted to US, EU, SEA, or LATAM. Trigger on 'marketing plan', 'marketing strategy for next year', 'go-to-market roadmap', 'plan for Q3', 'we have no marketing plan', 'where should we spend next quarter'. Also use when a founder only says the business needs to grow and has no idea which channel to start with. Not for — one specific campaign, see `02-campaign-brief-global`; working backward from a revenue goal to spend, see `10-reverse-kpi-global`; splitting a budget across channels and months, see `61-budget-planning-global`; taking a brand new product to market, see `59-go-to-market-global`.
Use when the user needs a monthly or weekly content calendar — posting schedule per channel, funnel ratio, content pillars, repurposing matrix, and an owner per slot. Trigger on 'content calendar', 'posting schedule', 'what should we post this month', 'editorial calendar', 'social media plan', 'we post randomly with no plan'. Also use when the user only says the team keeps running out of things to post. Not for — the brief for one specific post, see `36-content-brief-global`; the caption text itself, see `37-social-caption-global`; deciding next period content from last period data, see `40-next-content-plan-global`; a paid campaign timeline, see `02-campaign-brief-global`.
Lich noi dung thang — len lich dang bai da kenh voi ti le pheu, content pillar, repurposing matrix, va scoring tieu chi.
Brief chien dich marketing — 9 phan day du tu Context den Risk, bao gom creative direction, RACI, budget allocation theo phase, va auto-trigger cac skill lien quan.
Use when a specific campaign needs a brief the whole team can execute from — context, objective, audience, core message, creative direction, channels, deliverables, week-by-week timeline, approval gates, and risks. Trigger on 'campaign brief', 'creative brief', 'launch brief', 'brief the team on this campaign', 'we are running a promo next month', 'what is the plan for this campaign'. Also use when the user describes a promotion out loud and asks for something the team can actually run. Not for — the whole period plan, see `00-marketing-plan-global`; the list of design files needed, see `41-campaign-asset-list-global`; assigning work to one person, see `64-team-brief-global`; a new product launch sequence, see `59-go-to-market-global`.
Danh gia hieu suat marketing — audit performance ads va organic, chan doan root cause, de xuat toi uu voi action plan 48h va checklist hang tuan.
Use when marketing numbers look bad and the user needs to know WHY — layered root-cause diagnosis across tracking, delivery, creative, landing page, offer, and audience quality, 5-Whys, regional benchmarks for US, EU, SEA, and LATAM, and a 48-hour action plan. Covers dropshipping ROAS and BE-ROAS. Trigger on 'why is CPA so high', 'my ads are not converting', 'ROAS dropped', 'we are burning budget', 'performance is bad this month', 'diagnose the funnel'. Also use when the user pastes a screenshot of numbers with no question attached. Not for — auditing account configuration and scoring health, see `21-ads-audit-global`; writing a report someone else reads, see `07-marketing-report-global`; turning a raw export into insight, see `13-data-analysis-global`.