Data scope: 26,749 deduplicated activities (Nov 17 2025 – Feb 19 2026).
Agent filter applies to all charts and KPIs on this tab.
Appointment count = “Created appointment Cita Automeca-*” activities only.
StackAdapt data: 95 daily records · Nov 17, 2025 – Feb 19, 2026 ·
$18,395 total spend · 2.85M impressions · 7,462 clicks · 221 form leads.
Conversions = Automeca Form Submission click conversions only (221 total),
distributed proportionally by daily spend. Excludes “Solicitar Form” button-click events (~35K events, not real leads).
Date filter applies to all charts on this tab.
Google Ads data: 95 daily records · Nov 17, 2025 – Feb 19, 2026 ·
$12,796 total spend · 383,797 impressions · 11,586 clicks · 734 conversions (Matricula form + Call ads).
Note: “Conversions” include both Formulario de Matricula (website form submissions)
and Calls from ads — these are actual enrollment-intent actions tracked via Google Tag Manager.
They are tracked separately from Meta lead forms to avoid double-counting.
Date filter applies to all charts on this tab.
Events data: 5 experiential marketing events · Nov 2025 – Feb 2026 ·
$82,465 total spend · 122 event leads · 75 appointments.
Note: This data is currently static (dummy figures for planning purposes).
The live pipeline will connect a Typeform submission form to a webhook,
writing event leads directly to this dashboard. See the Typeform Integration section below for setup instructions.
Date filter shows events whose date falls within the selected range.
Step 1 — Create the Typeform
Build an event intake form with fields: Event Name, Event Date, Lead Name, Lead Phone, Email,
Program of Interest, Notes, Agent Name. One submission per lead captured at the event.
Step 2 — Set up a Webhook
In Typeform → Connect → Webhooks, point the webhook URL to a lightweight serverless function
(Cloudflare Worker, Vercel Edge, or AWS Lambda). The function parses the payload and appends a row
to a Google Sheet or a hosted JSON file.
Step 3 — Replace static data
Replace data/events_data.js with a fetch call to the JSON endpoint at dashboard load time,
or regenerate the file nightly via a GitHub Action / cron job that exports the Google Sheet to JS.
Step 4 — Track down-funnel
Add a second Typeform (or Zapier trigger) when an event lead books an appointment in the CRM,
and a third when they enroll. This closes the loop between event → appointment → enrolled.
Full Funnel: Total Spend = Meta Ads + StackAdapt + Events (all clipped to the selected date range).
Use the Touchpoint filter above to isolate a single channel.
Leads = form submissions & conversions from all selected touchpoints (Meta, SA conv. events, Google conversions, Events).
Appointments = Call Center activity feed (always all channels).
Meta spend is distributed proportionally; SA and Events spend are summed on the event/day date.
Enrollment count (265) is a static figure from the enrollment system.
All-time analysis · Nov 17, 2025 – Feb 19, 2026 ·
Insights are computed from the full dataset and do not respond to date filters.