monthly-report

Generate Vietnamese monthly marketing reports as PowerPoint slides from CSV, Excel, and Markdown data.

Updated Feb 5, 2026
One-click install
npx skills add https://github.com/binhnndigital/batch-watermark --skill monthly-report-binhnndigital
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: monthly-report
Source: https://github.com/binhnndigital/batch-watermark/tree/main/skills/monthly-report
Command: npx skills add https://github.com/binhnndigital/batch-watermark --skill monthly-report-binhnndigital

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires python-pptx, pandas, openpyxl, and includes scripts (resource) components.

What problem does it solve? Marketing teams spend hours each month manually compiling KPIs, campaign results, and channel metrics into presentation decks. This Skill automates the entire workflow: reading raw data files, researching market context, analyzing performance, and exporting a polished Vietnamese-language .pptx report. ## Core Features & Use Cases - Automated Data Ingestion: Scans a data/ folder for CSV, Excel, images, and notes, then parses a structured Markdown input template for KPIs, campaigns, budgets, and channel metrics. - Market Context Research: Queries Perplexity for current Vietnamese marketing and SEO trends to benchmark company results against industry data. - AI-Driven Analysis: Compares target vs actual KPIs, evaluates channel performance, and auto-generates strengths, weaknesses, lessons, and recommendations. - PowerPoint Export: Runs a Python script (python-pptx) to produce an 11-slide navy-and-yellow themed deck, skipping slides that lack data. - Use Case: A marketing manager drops GA4 exports and ad reports into the data folder, fills the input template, and asks the AI to create the February 2026 monthly report — receiving a ready-to-present .pptx in Vietnamese. ## Quick Start Ask the AI to create a monthly marketing report for a specific month after filling in the input template and placing your data files in the data folder.

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 marketing report in PowerPoint with Python?

Fill in the input-template.md with your KPIs, campaigns, and channel data, place CSV or Excel files in the data folder, then run generate_report.py. The script uses python-pptx to build a themed multi-slide .pptx deck automatically.

What data formats does the monthly report generator support?

The skill reads CSV, XLSX, and XLS files for tabular metrics, PNG and JPG images for embedding into slides, and Markdown or TXT files as supplementary notes. All files go into the skills/monthly-report/data/ directory.

What Python libraries are required to run generate_report.py?

The script requires python-pptx for slide generation, pandas for data handling, and openpyxl for Excel file reading. Install them with pip install python-pptx pandas openpyxl before running the script.

Does the report generator work if some data sections are missing?

Yes, slides are generated conditionally based on available data. Sections without data are skipped entirely rather than producing empty slides, and the AI auto-generates strengths, weaknesses, and recommendations if left blank.

Can the monthly report be generated in languages other than Vietnamese?

The skill is designed to output entirely in Vietnamese, including slide titles, chart labels, and AI commentary, as specified in its instructions. Changing the output language would require modifying the SKILL.md instructions and script strings.