What file format is the final output?

The skill generates a professional PDF file, named following a standard convention: {program_name}_loyalty_report_{YYYY-MM-DD}.pdf.

What kind of analysis does the report provide?

The report covers subscription trends, membership tiers, revenue impact, engagement flows, and includes a 12-month growth projection using current vs. optimized metrics.

Does it work if I only use certain JeriCommerce features?

Yes. The skill includes an integration detection step that checks for specific features like 'loyalty' and 'rewards', automatically skipping irrelevant report sections and queries.

How does the skill access loyalty program data?

The skill utilizes the Metabase MCP connector to execute secure SQL queries against the JeriCommerce production database (database ID 3) using predefined query templates.

JeriCommerce Loyalty Report Generator

Name: JeriCommerce Loyalty Report Generator
Author: JeriCommerce

byJeriCommerce

0•

Data Science & ML

Generates comprehensive loyalty program performance reports and data-driven growth projections via Metabase integration.

The JeriCommerce Loyalty Report Generator automates the end-to-end workflow for analyzing loyalty programs, from querying production databases via Metabase to generating professional, branded PDF reports. It intelligently detects active features—such as loyalty points or reward catalogs—to tailor its analysis, providing actionable recommendations, revenue impact assessments, and 12-month growth projections based on historical performance and optimized configurations.

Key Features

01Dynamic feature detection to customize report sections for Loyalty and Rewards features

020 GitHub stars

0312-month growth projections comparing current performance vs. optimized scenarios

04Professional PDF generation with custom branding, tables, and visual hierarchies

05Automated SQL data collection across 16 specialized queries via Metabase MCP

06Actionable heuristic-based recommendations for program optimization

Use Cases

01Generating stakeholder-ready monthly reports with revenue and engagement metrics

02Optimizing loyalty configurations based on data-driven parameter comparisons

03Conducting deep-dive audits of JeriCommerce loyalty program performance

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jericommerce/claude-plugins loyalty-report-generator

For use in Claude.ai and ChatGPT

Download Skill