RVJosé Ramón Vergara
Book a diagnosticES
Back to work
Growth · Inteligencia comercial

SEM/SEO dashboard

From 10 scattered sheets with PII to a clean dashboard by country and channel.

Role
Growth · Builder
Stack
Apps Script · HubSpot · Privacy-by-design
SEM/SEO dashboard
RVSystem in production
ContextGrowth · Inteligencia comercialOutcomeOne dashboard, not ten sheets
01

The problem

Marketing leads arrived scattered, with personal data, and no clarity on which channel or country actually converted.

02

The system

A pipeline that ingests leads, dedupes, enriches with the HubSpot funnel and publishes a dashboard by country, channel and keyword. A guardrail blocks publishing if it detects PII.

Apps ScriptHubSpotPrivacy-by-design
SignalSystemDecision
OutcomeOne dashboard, not ten sheets
03 · What changed
03

What changed

The work had to be felt in the operation.

  1. 01

    One dashboard, not ten sheets

  2. 02

    Privacy by design (anti-PII)

  3. 03

    Source of the regional acquisition data

Do you have a similar operating challenge?