social-media-analysis

To analyze social media performance metrics, you can query a unified view of platform data to compare content performance and generate reports. This skill processes data from platforms like Douyin, Kuaishou, and Xiaohongshu to evaluate cross-platform engagement.

Yes, you can generate performance reports for social media trends using TimescaleDB. The skill executes SQL queries against time-series data to identify growth rates, detect viral content, and output the results as Markdown reports or JSON files.

The best way to identify trending content on Douyin and Kuaishou is by querying time-series data to analyze engagement growth rates. This allows you to detect viral posts and track performance changes over specific periods.

Yes, this social media analysis requires a TimescaleDB setup. It relies on executing SQL queries against a unified view of your platform data, utilizing bash scripts to run commands and retrieve the necessary metrics.

You compare cross-platform metrics by querying a unified database view that aggregates data from different social media channels. This allows you to evaluate how the exact same content performs across platforms like Douyin and Xiaohongshu.

The social media data analysis results are exported in Markdown or JSON formats. You can generate structured performance reports summarizing engagement trends or export raw queried data for further processing.