ltx-marketing-daily-report

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"]
compatibility	["bq CLI installed and authenticated","GCP project access (ltx-dwh-explore for query execution)"]
metadata	{"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: