social-sentiment

TotalClaw 作者 totalclaw

Twitter、Reddit 和 Instagram 上的品牌和产品情绪分析。大规模监控公众舆论、跟踪品牌声誉、检测公关危机、表面投诉和赞扬 - 通过批量 CSV 导出和 Python/pandas 分析 70K 多个帖子。由 1.5B+ 索引帖子提供支持的社交聆听和品牌监控。

安装 / 下载方式

TotalClaw CLI推荐

totalclaw install totalclaw:totalclaw~atyachin-social-sentiment

cURL直接下载，无需登录

curl -fsSL https://skills.taituai.com/api/skills/totalclaw%3Atotalclaw~atyachin-social-sentiment/file -o atyachin-social-sentiment.md

## 概述（中文）

Twitter、Reddit 和 Instagram 上的品牌和产品情绪分析。大规模监控公众舆论、跟踪品牌声誉、检测公关危机、表面投诉和赞扬 - 通过批量 CSV 导出和 Python/pandas 分析 70K 多个帖子。由 1.5B+ 索引帖子提供支持的社交聆听和品牌监控。

## 原文

# Social Sentiment

**Analyze brand sentiment from live social conversations at scale.**

Surfaces themes, flags viral complaints, compares competitors. Analyzes 1K-70K posts via bulk CSV + Python.

## Setup

Run `xpoz-setup` skill. Verify: `mcporter call xpoz.checkAccessKeyStatus`

## 4-Step Process

### Step 1: Search Platforms

Queries: (1) `"Brand"` (2) `"Brand" AND (slow OR buggy)` (3) `"Brand" AND (love OR amazing)`

```bash
mcporter call xpoz.getTwitterPostsByKeywords query='"Notion"' startDate="YYYY-MM-DD"
mcporter call xpoz.checkOperationStatus operationId="op_..." # Poll 5s
```

Repeat for Reddit/Instagram. Default: 30 days.

### Step 2: Download CSVs

Use `dataDumpExportOperationId`, poll with `checkOperationStatus` for download URL (up to 64K rows).

### Step 3: Analyze

Python/pandas:

```python
import pandas as pd
df = pd.read_csv('/tmp/twitter-sentiment.csv')

POSITIVE = ['love', 'amazing', 'best', 'recommend']
NEGATIVE = ['hate', 'terrible', 'worst', 'broken']

def classify(text):
    t = str(text).lower()
    pos = sum(1 for k in POSITIVE if k in t)
    neg = sum(1 for k in NEGATIVE if k in t)
    return 'positive' if pos>neg else ('negative' if neg>pos else 'neutral')

df['sentiment'] = df['text'].apply(classify)
```

Extract themes, find viral by engagement. Customize keywords.

### Step 4: Report

```
Sentiment: 72/100 | Posts: 14,832
😊 58% | 😠 24% | 😐 18%

Themes: Performance (2K, 81% neg), UX (1.8K, 72% pos)
Viral: [Top 10]
```

Score: Engagement-weighted, 0-100. Include insights.

## Tips

Download full CSVs | Reddit = honest | Store `data/social-sentiment/` for trends