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

monthly-report

Generate a 17-slide monthly organic social media PowerPoint report from Supabase data.

Updated Feb 25, 2026
Search Tags:#supabase#pptx#generate#report#social-media#monthly-report#engagement-rate
One-click install
npx skills add https://github.com/mgivot/synchrony-social --skill monthly-report-mgivot
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: monthly-report
Source: https://github.com/mgivot/synchrony-social/tree/main/.claude/skills/monthly-report
Command: npx skills add https://github.com/mgivot/synchrony-social --skill monthly-report-mgivot

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Converts fragmented Supabase social data and manual slide-work into a single, repeatable pipeline that produces a client-ready 17-slide monthly organic social media PowerPoint, eliminating manual data entry and inconsistent calculations.

Core Features & Use Cases

  • Automated Data Extraction: Queries reporting_periods, posts, campaign_period_summaries, and platform_benchmarks to collect the full dataset for a reporting period.
  • Platform-Specific Analysis: Computes Instagram Feed and Stories, Facebook (photo/video), and YouTube Shorts metrics including ER variants, non-follower percentages, and per-pillar tables.
  • MoM Comparisons & Takeaways: Identifies shared pillars for month-over-month comparisons, computes deltas, and generates three strategic takeaways framed for client presentation.
  • Report Generation & Validation: Produces a 17-slide PPTX using the project's generator or Node/Python pipeline and runs quality checks for slide count, populated sections, and ER formula consistency.
  • Use Case: A social media analyst asks to "build the monthly report" and receives a validated, slide-ready PowerPoint with platform breakdowns, top posts, pillar tables, MoM insights, and coaching notes.

Quick Start

Generate the May 2024 organic social report for Client Name using Supabase data.

Frequently Asked Questions about monthly-report

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

FAQPage Schema
How do I generate a monthly social media report from Supabase data automatically?▼

This Skill automates monthly social media report generation by querying Supabase tables for posts and campaign summaries, computing engagement rates and month-over-month deltas, then outputting a client-ready 17-slide PPTX presentation with platform breakdowns and strategic takeaways.

Can I create a PPTX social media performance report with platform breakdowns and pillar tables?▼

Yes, the generated PPTX social media performance report includes platform-specific breakdowns for Instagram Feed, Stories, Facebook, and YouTube Shorts, featuring per-pillar tables, top performer lists, and engagement rate variants formatted for client presentation.

Does this reporting tool calculate month-over-month comparisons and engagement rates automatically?▼

Yes, it automatically identifies shared content pillars across reporting periods to calculate month-over-month deltas and engagement rate variants, then generates three strategic takeaways framed for client presentation directly from the Supabase data.

What Supabase tables are required to build the monthly organic social report?▼

Building the monthly organic social report requires querying four Supabase tables: reporting_periods, posts, campaign_period_summaries, and platform_benchmarks to gather the full dataset needed for computing metrics and generating the 17-slide presentation.

What is included in the 17-slide monthly social media PowerPoint output?▼

The 17-slide PowerPoint output includes platform-specific metric breakdowns, per-pillar performance tables, top post lists, month-over-month comparisons, three strategic takeaways, and coaching notes, validated for slide count and engagement rate formula consistency.

How do I validate that my generated social media PPTX report is accurate and complete?▼

The report generation pipeline runs quality checks validating the slide count, ensuring all sections are populated, and verifying engagement rate formula consistency to guarantee the PPTX output is accurate and client-ready before delivery.

Related Skills

Explore More Marketing & Sales Skills→
created-by-forgecreated-by-forge

platform-pulse

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

Official
Advanced
created-by-forgecreated-by-forge

monthly_report

Generate a 17-slide PowerPoint monthly organic social media report from Supabase data.

Official
Advanced
created-by-forgecreated-by-forge

parse-sprinklr

Parse Sprinklr Excel exports into Supabase tables while handling schema drift.

Official
Advanced
AradotsoAradotso
8

powerbi-campaign-roi-analyzer

Analyzes social campaign ROI and audience demographics using Power BI dashboards.

Official
Advanced