skills.rest
mgivot
mgivotCOMMUNITY
Explore all skills by this author →
GitHub

pillar-analysis

Analyze content pillar performance across platforms and reporting periods using SQL data.

Updated Feb 25, 2026
Search Tags:#performance#benchmarking#social-media#content-pillar#platform-comparison#pillar-analysis
One-click install
npx skills add https://github.com/mgivot/synchrony-social --skill pillar-analysis-mgivot
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: pillar-analysis
Source: https://github.com/mgivot/synchrony-social/tree/main/.claude/skills/pillar-analysis
Command: npx skills add https://github.com/mgivot/synchrony-social --skill pillar-analysis-mgivot

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Provides a repeatable, data-grounded way to evaluate how a single content pillar (campaign) performs across platforms and reporting periods, removing manual spreadsheet work and surfacing format, platform fit, and strategic coaching tied to the client's goals.

Core Features & Use Cases

  • Cross-platform comparison: Aggregates posts, campaign period summaries, and platform benchmarks to show where a pillar over- or under-performs.
  • Format and engagement analysis: Breaks down performance by format, engagement mix, and follower/non-follower splits to recommend format × platform adjustments.
  • Client intelligence integration: Pulls corrections, wins, and pillar goals from the Obsidian vault to align recommendations with client strategy.
  • Use Case: Run a pillar deep dive to decide whether to reprioritize formats for an awareness-focused pillar after two reporting periods of underperformance.

Quick Start

Analyze the "Stay Gold" pillar across all platforms and reporting periods, compare to platform benchmarks, and give three prioritized recommendations.

Frequently Asked Questions about pillar-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I analyze a content pillar's performance across multiple social media platforms?▼

To analyze content pillar performance across platforms, you aggregate posts, campaign period summaries, and platform benchmarks to identify where the pillar over- or under-performs. This requires SQL access to campaigns, posts, and platform_benchmarks tables.

What is the best way to compare social media content formats against platform benchmarks?▼

Comparing social media content formats against platform benchmarks involves aggregating engagement data and platform_benchmarks to break down performance by format, engagement mix, and follower/non-follower splits to recommend format adjustments.

How do I integrate client vault goals into social media campaign reporting?▼

Integrating client vault goals into social media campaign reporting requires pulling corrections, wins, and pillar goals from referenced Obsidian vault documents to align cross-platform performance recommendations with client strategy.

Can I use SQL queries to find platform fit for an underperforming awareness campaign?▼

Yes, you can use SQL queries against campaigns, posts, and campaign_period_summaries tables to find platform fit for an underperforming awareness campaign, surfacing coaching-focused recommendations to reprioritize formats.

Does pillar analysis require access to campaign period summaries and platform benchmarks?▼

Yes, pillar analysis requires SQL access to campaign_period_summaries and platform_benchmarks tables, alongside campaigns, posts, and campaign_notes tables, plus read access to referenced Obsidian vault documents.

Why does cross-platform pillar analysis break down follower and non-follower engagement splits?▼

Cross-platform pillar analysis breaks down follower and non-follower engagement splits to evaluate format and platform fit, providing data-grounded recommendations that align with the client's specific content strategy and goals.

Related Skills

Explore More Data & Analytics Skills→
created-by-forgecreated-by-forge

platform-pulse

Analyze single-platform social media performance using Supabase post and benchmark data.

Official
Advanced
Mueza-EjazMueza-Ejaz

generate-ceo-briefing

Collect and analyze business performance metrics to generate weekly executive briefings.

Community
Advanced
Veloxia-agencyVeloxia-agency

social-media-analyzer

Analyze social media campaign metrics for engagement, reach, CTR, and ROI.

Community
Advanced
framerslabframerslab

social-automation

Automate social media posting, analytics aggregation, and batch scheduling across platforms.

Official
Advanced