lightricks/ltx-marketing-daily-report
agents/reports/ltx-marketing-daily-report/SKILL.md
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'.
$ install --global
skillsauthnpx skillsauth add lightricks/ltx-analytics-agents ltx-marketing-daily-reportInstall 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:51 AM157.1s2 files scanned
SKILL.md
- name:
- ltx-marketing-daily-report
- description:
- 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'.
- tags:
- [reporting, daily-metrics, ltxstudio, marketing, sales]
- author:
- dbeer
- version:
- 2.0
- created:
- 2026-03-13
LTX Marketing & Sales Daily Report
Overview
Daily snapshot of LTX Studio go-to-market performance: marketing spend and lead generation, sales activity (reach-outs, meetings), top enterprise org usage, new activations, and credit limit summary.
Slack channel: #ltx-marketing-auto-report
Instructions
Step 1: Run the Query
bq --project_id=ltx-dwh-explore query --use_legacy_sql=false --format=pretty "$(cat queries/marketing_sales_daily_report.sql)"
The query returns marketing & sales metrics including:
- Marketing Metrics — Daily spend, leads, PELs, PQLs vs 7-day avg
- Sales Metrics — Reach-outs, meetings (AE + BDR/SDR) vs 7-day avg
- New Activations — Count of new users yesterday
- Credit Limits — Accounts near 80%+ usage
Key tables:
ltx-dwh-prod-processed.marketing.sf_perf_marketing_agg_w_spend(marketing spend & leads)ltx-dwh-prod-processed.marketing.final_sf_lead_opportunity(sales metrics)
See shared/bq-schema.md for full table schemas.
Step 2: Format Output
Format per references/report-template.md.
Step 3: Highlight Anomalies
Flag any metric deviating >50% from 7-day average.
Context & References
Shared Knowledge (Read First)
shared/bq-schema.md— Table schemas, columns, joins, segmentation CTEsshared/metric-standards.md— Standardized metric definitions with SQLshared/product-context.md— LTX Studio overview, user types, business model
Constraints
DO NOT
- Run queries without
--project_id=ltx-dwh-explore - Use
is_enterprise_userflag — use org-based enterprise logic - Skip partition pruning (use
date(action_ts) >= ...)
DO
- Filter
ltx_studio = trueon sales funnel table - Exclude
is_lt_team = falseon all user-level queries - Use
SAFE_DIVIDEfor all percentage calculations - Use enterprise segmentation CTE for top orgs (see
shared/bq-schema.md)
Examples
User: "Marketing daily report"
User: "How did leads perform yesterday?"
User: "Marketing performance vs last week"
User: "Run the GTM report"
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-leadership-weekly-report
tools
VerifiedTrustedCommunity
Generate the LTX weekly leadership Slack post covering Open Source (HuggingFace LTX-2 family), API (revenue, endpoints, leads, industries), and Studio Enterprise (contracts, pilots, LTX-model consumption share). Runs every Monday via n8n: BigQuery → JSON parse → Slack render → LLM TL;DR → Slack webhook. Use when: weekly exec update, leadership Slack channel automation, or when asked for 'last week's LTX numbers'.
5SKILL.mdUpdated May 7, 2026