Social Media Account Audit
When to Use
- User shares analytics screenshots (LIVE stats, dashboard data, engagement metrics)
- User asks "why is my account/LIVE performing badly?"
- User shares a TikTok/Instagram profile link for review
- User wants to compare past vs current performance
- User asks for growth strategy based on data
Workflow Overview
1. Scrape profile data (if link provided)
2. Extract metrics from screenshots (if provided)
3. Calculate health ratios
4. Diagnose root causes
5. Deliver actionable recommendations
Step 1: Scrape TikTok Profile Data
Fetch HTML
curl -s -L -A "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36" \
"https://www.tiktok.com/@USERNAME" -o /tmp/tiktok_profile.html
Extract Basic Stats (grep approach — fast)
grep -oP '"uniqueId":"[^"]*"|"nickname":"[^"]*"|"signature":"[^"]*"|"followerCount":\d+|"followingCount":\d+|"heartCount":\d+|"videoCount":\d+|"verified":[a-z]+' /tmp/tiktok_profile.html
Extract Full Profile (Python — comprehensive)
import json, re
from datetime import datetime
with open('/tmp/tiktok_profile.html') as f:
html = f.read()
match = re.search(
r'<script id="__UNIVERSAL_DATA_FOR_REHYDRATION__"[^>]*>(.*?)</script>',
html, re.DOTALL
)
data = json.loads(match.group(1))
scope = data['__DEFAULT_SCOPE__']
user_info = scope['webapp.user-detail']['userInfo']
user = user_info['user']
stats = user_info['stats']
# Key fields
print(f"Username: @{user['uniqueId']}")
print(f"Bio: {user['signature']}")
print(f"Created: {datetime.fromtimestamp(int(user['createTime']))}")
print(f"Category: {user.get('commerceUserInfo', {}).get('category', 'N/A')}")
print(f"Commerce User: {user.get('commerceUserInfo', {}).get('commerceUser', False)}")
print(f"TT Seller: {user.get('ttSeller', False)}")
print(f"Verified: {user['verified']}")
print(f"Followers: {stats['followerCount']:,}")
print(f"Following: {stats['followingCount']:,}")
print(f"Likes: {stats['heartCount']:,}")
print(f"Videos: {stats['videoCount']}")
Additional Metadata to Extract
# Commerce info, seller status, room ID, account settings
grep -oP '"commerceUserInfo":\{[^}]*\}|"category":"[^"]*"|"ttSeller":[a-z]+|"roomId":"[^"]*"|"privateAccount":[a-z]+|"nickNameModifyTime":\d+|"openFavorite":[a-z]+' /tmp/tiktok_profile.html
Get secUid (needed for API calls)
grep -oP '"secUid":"[^"]*"' /tmp/tiktok_profile.html | head -1
Step 2: Calculate Health Metrics
| Metric |
Formula |
Healthy Range |
Warning |
| Engagement Rate |
(avg_likes / followers) × 100 |
4-8% |
<3% is low |
| Likes-to-Follower Ratio |
total_likes / followers |
10-20+ |
<5 = ghost followers |
| Follower:Following Ratio |
followers / following |
50:1+ for brands |
<10:1 = follow-for-follow |
| Video Output |
videos / account_age_months |
30-90/month (1-3/day) |
<10/month is too low |
| LIVE Retention Rate |
avg_viewers / total_viewers × 100 |
5-15% |
<1% = bounce problem |
| LIVE PCU Ratio |
PCU / avg_viewers |
2-4x |
>10x = spike then crash |
Step 3: Interpret LIVE Analytics Screenshots
Key Metrics to Look For (TikTok LIVE)
- Rata-Rata Penonton = Average concurrent viewers
- PCU = Peak Concurrent Users
- Penonton = Total unique viewers
- GMV = Gross Merchandise Value (sales)
- CTR LIVE = Click-through rate on products
- Barang terjual = Items sold
Trend Graph Interpretation
- Menonton (red) = Currently watching — should stay stable or rise
- Masuk (blue) = Entering — inflow rate
- Keluar (green) = Leaving — outflow rate
- Healthy pattern: Masuk > Keluar, Menonton rises over time
- Unhealthy pattern: Keluar > Masuk early, Menonton drops and flatlines
Traffic Sources (Sumber Penonton)
- Feed Untuk Anda (FYP) — Algorithmic reach (usually 60-90%)
- Tombol LIVE — Followers clicking LIVE notification
- Tab Shop — Discovery via TikTok Shop tab
- Lainnya — Other sources (search, profile visits, shares)
Buyer Profile (Profil Pembeli)
- Jenis kelamin = Gender split
- Usia = Age demographics
- Pengikut = Follower vs non-follower buyers
Step 4: Common Diagnoses
Pattern: High Total Viewers, Low Average (Bounce Problem)
- Cause: Hook is weak — viewers enter and leave within seconds
- Evidence: Keluar line tracks Masuk line closely; Menonton stays flat/low
- Fix: Stronger first-3-second hook, engaging title, immediate interaction
Pattern: FYP Traffic High % but Low Absolute Numbers
- Cause: Algorithm has "cooled" the account — still sending FYP traffic but to fewer people
- Evidence: FYP % similar to before but total viewers way down
- Fix: Rebuild algorithm trust via consistent posting + high-retention content
Pattern: Performance Cliff (Was Good, Now Bad)
- Causes (check in order):
- Posting frequency dropped → algorithm deprioritized
- Content/niche changed → audience mismatch
- Community guidelines violation/warning → shadow restriction
- Ghost followers accumulated → engagement rate tanked
- Increased competition in niche
Pattern: Commerce User but Not TT Seller
- Impact: Doesn't get seller-tier algorithm priority for LIVE shopping
- Fix: Register as official TikTok Shop seller if eligible
Step 5: Recommendation Framework
Bio Optimization Template
[Emoji] [What you sell — specific]
[Emoji] LIVE [Schedule — day + time]
[Emoji] [Value prop / price hook]
Example:
👗 Fashion Wanita Murah & Berkualitas
🔴 LIVE Setiap Hari Jam 19:00-21:00
💰 Harga Mulai 25rb!
Recovery Timeline
| Phase |
Duration |
Focus |
| Foundation |
Week 1-2 |
Fix bio, clean following list, post 2-3 videos/day |
| Warm-up |
Week 3-4 |
Daily LIVE at consistent time, video teasers before LIVE |
| Scale |
Month 2+ |
TikTok Promote, collaborations, flash sales during LIVE |
LIVE Retention Tactics
- Giveaway/games every 15-20 minutes
- Greet every viewer by name
- "Surprise coming in 5 minutes" hooks
- Flash sales with countdown timers
- Pin products and mention them regularly
Pitfalls
- TikTok anti-bot detection: curl fetches may return empty
itemList (videos). The profile metadata still comes through in __UNIVERSAL_DATA_FOR_REHYDRATION__. Video-level data requires a real browser or authenticated API.
- Bot classification: TikTok sets
"botType": "others" and "needFix": true on bot-detected requests. Profile stats are still accurate; video lists are withheld.
- API endpoints blocked: Direct API calls like
/api/post/item_list/ return empty responses without proper cookies/tokens. Don't waste time on these.
- Indonesian language: TikTok Shop analytics in Indonesia use Bahasa. Key terms: Penonton=Viewers, Keterlibatan=Engagement, Jangkauan=Reach, Konversi=Conversion, Barang terjual=Items sold, Pesanan=Orders.
- Timestamp conversion:
createTime and nickNameModifyTime are Unix timestamps. Use datetime.fromtimestamp().
- Screenshot analysis: When user sends analytics screenshots, the image description provides structured data. Cross-reference multiple screenshots to build the full picture.
Output Format
Present audit results as:
- Data table — Profile stats with health indicators (✅/⚠️/🔴)
- Ratio analysis — Calculated metrics vs benchmarks
- Root cause chain — Visual cause→effect flow showing why performance dropped
- Prioritized action plan — Phased recommendations (Foundation → Warm-up → Scale)
References
references/tiktok-profile-fields.md — All extractable fields from TikTok profile HTML
references/tiktok-analytics-terms-id.md — Indonesian↔English analytics terminology
1---2name: social-media-account-audit3description: "Audit social media accounts (TikTok, IG, etc.): scrape profiles, calculate engagement metrics, diagnose performance drops, interpret analytics screenshots."4tags: [tiktok, instagram, analytics, audit, engagement, live-streaming, social-commerce]5related_skills: [social-media-slideshow-video, xurl]6origin: unknown7source_license: see upstream8language: en9metadata:10 source: https://skillmd.com/skills/kevinnft/social-media-account-audit11---1213# Social Media Account Audit1415## When to Use1617- User shares analytics screenshots (LIVE stats, dashboard data, engagement metrics)18- User asks "why is my account/LIVE performing badly?"19- User shares a TikTok/Instagram profile link for review20- User wants to compare past vs current performance21- User asks for growth strategy based on data2223## Workflow Overview2425```261. Scrape profile data (if link provided)272. Extract metrics from screenshots (if provided)283. Calculate health ratios294. Diagnose root causes305. Deliver actionable recommendations31```3233## Step 1: Scrape TikTok Profile Data3435### Fetch HTML36```bash37curl -s -L -A "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36" \38 "https://www.tiktok.com/@USERNAME" -o /tmp/tiktok_profile.html39```4041### Extract Basic Stats (grep approach — fast)42```bash43grep -oP '"uniqueId":"[^"]*"|"nickname":"[^"]*"|"signature":"[^"]*"|"followerCount":\d+|"followingCount":\d+|"heartCount":\d+|"videoCount":\d+|"verified":[a-z]+' /tmp/tiktok_profile.html44```4546### Extract Full Profile (Python — comprehensive)47```python48import json, re49from datetime import datetime5051with open('/tmp/tiktok_profile.html') as f:52 html = f.read()5354match = re.search(55 r'<script id="__UNIVERSAL_DATA_FOR_REHYDRATION__"[^>]*>(.*?)</script>',56 html, re.DOTALL57)58data = json.loads(match.group(1))59scope = data['__DEFAULT_SCOPE__']60user_info = scope['webapp.user-detail']['userInfo']61user = user_info['user']62stats = user_info['stats']6364# Key fields65print(f"Username: @{user['uniqueId']}")66print(f"Bio: {user['signature']}")67print(f"Created: {datetime.fromtimestamp(int(user['createTime']))}")68print(f"Category: {user.get('commerceUserInfo', {}).get('category', 'N/A')}")69print(f"Commerce User: {user.get('commerceUserInfo', {}).get('commerceUser', False)}")70print(f"TT Seller: {user.get('ttSeller', False)}")71print(f"Verified: {user['verified']}")72print(f"Followers: {stats['followerCount']:,}")73print(f"Following: {stats['followingCount']:,}")74print(f"Likes: {stats['heartCount']:,}")75print(f"Videos: {stats['videoCount']}")76```7778### Additional Metadata to Extract79```bash80# Commerce info, seller status, room ID, account settings81grep -oP '"commerceUserInfo":\{[^}]*\}|"category":"[^"]*"|"ttSeller":[a-z]+|"roomId":"[^"]*"|"privateAccount":[a-z]+|"nickNameModifyTime":\d+|"openFavorite":[a-z]+' /tmp/tiktok_profile.html82```8384### Get secUid (needed for API calls)85```bash86grep -oP '"secUid":"[^"]*"' /tmp/tiktok_profile.html | head -187```8889## Step 2: Calculate Health Metrics9091| Metric | Formula | Healthy Range | Warning |92|--------|---------|---------------|---------|93| **Engagement Rate** | (avg_likes / followers) × 100 | 4-8% | <3% is low |94| **Likes-to-Follower Ratio** | total_likes / followers | 10-20+ | <5 = ghost followers |95| **Follower:Following Ratio** | followers / following | 50:1+ for brands | <10:1 = follow-for-follow |96| **Video Output** | videos / account_age_months | 30-90/month (1-3/day) | <10/month is too low |97| **LIVE Retention Rate** | avg_viewers / total_viewers × 100 | 5-15% | <1% = bounce problem |98| **LIVE PCU Ratio** | PCU / avg_viewers | 2-4x | >10x = spike then crash |99100## Step 3: Interpret LIVE Analytics Screenshots101102### Key Metrics to Look For (TikTok LIVE)103- **Rata-Rata Penonton** = Average concurrent viewers104- **PCU** = Peak Concurrent Users105- **Penonton** = Total unique viewers106- **GMV** = Gross Merchandise Value (sales)107- **CTR LIVE** = Click-through rate on products108- **Barang terjual** = Items sold109110### Trend Graph Interpretation111- **Menonton (red)** = Currently watching — should stay stable or rise112- **Masuk (blue)** = Entering — inflow rate113- **Keluar (green)** = Leaving — outflow rate114- **Healthy pattern**: Masuk > Keluar, Menonton rises over time115- **Unhealthy pattern**: Keluar > Masuk early, Menonton drops and flatlines116117### Traffic Sources (Sumber Penonton)118- **Feed Untuk Anda (FYP)** — Algorithmic reach (usually 60-90%)119- **Tombol LIVE** — Followers clicking LIVE notification120- **Tab Shop** — Discovery via TikTok Shop tab121- **Lainnya** — Other sources (search, profile visits, shares)122123### Buyer Profile (Profil Pembeli)124- **Jenis kelamin** = Gender split125- **Usia** = Age demographics126- **Pengikut** = Follower vs non-follower buyers127128## Step 4: Common Diagnoses129130### Pattern: High Total Viewers, Low Average (Bounce Problem)131- **Cause**: Hook is weak — viewers enter and leave within seconds132- **Evidence**: Keluar line tracks Masuk line closely; Menonton stays flat/low133- **Fix**: Stronger first-3-second hook, engaging title, immediate interaction134135### Pattern: FYP Traffic High % but Low Absolute Numbers136- **Cause**: Algorithm has "cooled" the account — still sending FYP traffic but to fewer people137- **Evidence**: FYP % similar to before but total viewers way down138- **Fix**: Rebuild algorithm trust via consistent posting + high-retention content139140### Pattern: Performance Cliff (Was Good, Now Bad)141- **Causes** (check in order):142 1. Posting frequency dropped → algorithm deprioritized143 2. Content/niche changed → audience mismatch144 3. Community guidelines violation/warning → shadow restriction145 4. Ghost followers accumulated → engagement rate tanked146 5. Increased competition in niche147148### Pattern: Commerce User but Not TT Seller149- **Impact**: Doesn't get seller-tier algorithm priority for LIVE shopping150- **Fix**: Register as official TikTok Shop seller if eligible151152## Step 5: Recommendation Framework153154### Bio Optimization Template155```156[Emoji] [What you sell — specific]157[Emoji] LIVE [Schedule — day + time]158[Emoji] [Value prop / price hook]159```160Example:161```162👗 Fashion Wanita Murah & Berkualitas163🔴 LIVE Setiap Hari Jam 19:00-21:00164💰 Harga Mulai 25rb!165```166167### Recovery Timeline168| Phase | Duration | Focus |169|-------|----------|-------|170| Foundation | Week 1-2 | Fix bio, clean following list, post 2-3 videos/day |171| Warm-up | Week 3-4 | Daily LIVE at consistent time, video teasers before LIVE |172| Scale | Month 2+ | TikTok Promote, collaborations, flash sales during LIVE |173174### LIVE Retention Tactics175- Giveaway/games every 15-20 minutes176- Greet every viewer by name177- "Surprise coming in 5 minutes" hooks178- Flash sales with countdown timers179- Pin products and mention them regularly180181## Pitfalls1821831. **TikTok anti-bot detection**: curl fetches may return empty `itemList` (videos). The profile metadata still comes through in `__UNIVERSAL_DATA_FOR_REHYDRATION__`. Video-level data requires a real browser or authenticated API.1842. **Bot classification**: TikTok sets `"botType": "others"` and `"needFix": true` on bot-detected requests. Profile stats are still accurate; video lists are withheld.1853. **API endpoints blocked**: Direct API calls like `/api/post/item_list/` return empty responses without proper cookies/tokens. Don't waste time on these.1864. **Indonesian language**: TikTok Shop analytics in Indonesia use Bahasa. Key terms: Penonton=Viewers, Keterlibatan=Engagement, Jangkauan=Reach, Konversi=Conversion, Barang terjual=Items sold, Pesanan=Orders.1875. **Timestamp conversion**: `createTime` and `nickNameModifyTime` are Unix timestamps. Use `datetime.fromtimestamp()`.1886. **Screenshot analysis**: When user sends analytics screenshots, the image description provides structured data. Cross-reference multiple screenshots to build the full picture.189190## Output Format191192Present audit results as:1931. **Data table** — Profile stats with health indicators (✅/⚠️/🔴)1942. **Ratio analysis** — Calculated metrics vs benchmarks1953. **Root cause chain** — Visual cause→effect flow showing why performance dropped1964. **Prioritized action plan** — Phased recommendations (Foundation → Warm-up → Scale)197198## References199- `references/tiktok-profile-fields.md` — All extractable fields from TikTok profile HTML200- `references/tiktok-analytics-terms-id.md` — Indonesian↔English analytics terminology