lightricks/revenue-monitor
agents/monitoring/revenue/SKILL.md
Monitors revenue metrics, tracks subscription changes, and alerts on revenue anomalies or threshold breaches.
$ install --global
skillsauthnpx skillsauth add lightricks/ltx-analytics-agents revenue-monitorInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: May 7, 2026, 6:50 AM109.5s1 file scanned
SKILL.md
- name:
- revenue-monitor
- description:
- Monitors revenue metrics, tracks subscription changes, and alerts on revenue anomalies or threshold breaches.
- tags:
- [monitoring, revenue, subscriptions]
Revenue Monitor
When to use
- "Monitor revenue trends"
- "Alert when revenue drops"
- "Track subscription churn"
- "Monitor MRR/ARR changes"
- "Alert on refund spikes"
What it monitors
- Revenue metrics: MRR, ARR, daily revenue
- Subscription metrics: New subscriptions, cancellations, churns, renewals
- Refunds: Refund rate, refund amount
- Tier changes: Upgrades, downgrades
- Enterprise contracts: Contract value, renewals
Steps
-
Gather requirements from user:
- Which revenue metric to monitor
- Alert threshold (e.g., "drop > 10%", "< $X per day")
- Time window (daily, weekly, monthly)
- Notification channel (Slack, email)
-
Read shared files:
shared/bq-schema.md— Subscription tables (ltxstudio_user_tiers_dates, etc.)shared/metric-standards.md— Revenue metric definitions
-
Write monitoring SQL:
- Query current metric value
- Compare against historical baseline or threshold
- Flag anomalies or breaches
-
Present to user:
- Show SQL query
- Show example alert format
- Confirm threshold values
-
Set up alert (manual for now):
- Document SQL in Hex or BigQuery scheduled query
- Configure Slack webhook or notification
Reference files
| File | Read when |
|------|-----------|
| shared/bq-schema.md | Writing SQL for subscription/revenue tables |
| shared/metric-standards.md | Defining revenue metrics |
Rules
- DO use LTX Studio subscription tables from bq-schema.md
- DO exclude is_lt_team unless explicitly requested
- DO validate thresholds with user before setting alerts
- DO NOT hardcode dates — use rolling windows
- DO account for timezone differences in daily revenue calculations
Related Skills
lightricks/self-serve-analysis
development
VerifiedTrustedCommunity
Adds the analyst layer (segmentation framing, filter/KPI surfacing, LTX-specific definitions, contextual follow-ups) on top of any Data MasterMind data interaction for LTX stakeholders (PMs, marketers, design, leadership). Wraps `get-data` / `validate-data` / `understand-data` / `visualize-data` — dialing intensity from a full guided session (for "look into X", "investigate Y", "do an analysis of …") down to a compressed wrap (for "what's MRR?", "is this number right?"). Output mode (chat-only or HTML artifact) is chosen up front for session-style asks. Always asks about Enterprise / paid non-Enterprise / Free segmentation and Studio-feature tier-gating when relevant. Do NOT use only when the user explicitly opts out ("just give me the number, no extras") or for templated feature dashboards (that's the Hex-based `dashboard-builder`).
6SKILL.mdUpdated May 20, 2026
lightricks/ltx-sales-daily-report
testing
VerifiedTrustedCommunity
Generate LTX Studio sales opportunities report and credit limit alerts. Covers pipeline by rep/product (yesterday + QTD), new PELs/PQLs, future meetings, and enterprise orgs at 80%+ token usage. Use when: sales standup, pipeline review, account health check, or when asked for 'sales numbers' or 'credit alerts'.
5SKILL.mdUpdated May 7, 2026
lightricks/ltx-product-daily-report
data-ai
VerifiedTrustedCommunity
Generate LTX Studio product daily report with revenue, usage by segment (Enterprise, Pilot, Paying Non-Enterprise, Free), and DoD/DOW-avg comparisons. Use when: daily product standup, executive reporting, or when asked for 'yesterday's product numbers'.
5SKILL.mdUpdated May 7, 2026
lightricks/ltx-marketing-daily-report
data-ai
VerifiedTrustedCommunity
Generate LTX Studio marketing & sales daily report with lead gen, spend, PELs/PQLs, sales metrics, and top org usage vs 7-day averages. Use when: daily marketing standup, GTM review, or when asked for 'marketing numbers' or 'lead performance'.
5SKILL.mdUpdated May 7, 2026