Dashboard Multi-Cuenta · Meta + Google  |  Rolling 30d (60d en tablas dedicadas) · CAC 30/60/90d  |  Generado: 2026-09-03 14:24 ET
📊 RESUMEN
VHE
TR
MARIO MORENO
GOOGLE
📊 KPIs Consolidados — Rolling 30 días (spend por plataforma, ventanas independientes)
CuentaPlataformaSpendLeads SQLSOLDsCAC 30d
Volt Home En (VHE) Meta $9,649 762 75 11 $3,216
Volt Solar Energy - TR (TR) Meta $490 2 0 0 n/a
Mario Moreno - Volt AdAccount (MARIO) Meta $9,819 228 42 4 $9,819
Volt Solar Energy (GOOGLE) Google Ads $183 (parcial) n/a n/a 4 n/a (cobertura parcial)
🏆 Ranking de Campañas por CPSOLD (cross-cuenta, 30d)
CuentaCampañaSpendSOLDsCPSOLD
VHECalifornia_ASE_SQL | v2$1,960 6$327
MARIO11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP$2,132 3$711
VHEFlorida_ASE_SQL |$2,451 3$817
MARIO07.31_ABO_Testing_FF_Central Florida_Video_Roof_ESP_GP$1,050 1$1,050
VHECalifornia_Español_SQL$2,237 2$1,118
🚨 Top Alertas — Todas las Cuentas
Google Ads: solo hay spend diario real para 2026-08-24→2026-09-02 (10 días) vía el bridge del Ads Script. CAC 30/60/90d de Google NO calculado — sería inventar datos.
Dedup pendiente: Jose Lopez (235974520502) vs Jose Efrain Lopez Villegas (243051611963) — Posible dup — misma persona, campañas distintas (NCC 18-Jul vs CA Español 19-Ago). Sin confirmar.
Excluido de conteo SOLD: Marlon Suarez dup confirmado (240816604215) — se mantiene solo el registro 233652031849 (6 Jul, NCC).
TR: 0 SOLDs atribuidos a este sub-account en 30d (1 en ventana 90d: Julia Hilbert). Volumen de campaña muy bajo (1 campaña activa, $489.92 spend 30d).
Mario Moreno: 6 campañas Dealers detectadas en 30d — excluidas del funnel/CAC (no son clientes) por regla especial.
ℹ️ Nota Metodológica
Total contactos HubSpot analizados (ventana 100d, portal 47559873): 4,250. Total SOLDs (100d, post-dedup): 151. Atribución Meta = hs_analytics_first_url CONTAINS_TOKEN sub-account ID. Atribución Google = señales 1-5 del brief (Original Traffic Source, drill-down, gclid, UTMs, direct+contexto). Señal 6 (planilla Total Sales) NO disponible en este run — reconciliación con la lista histórica de referencia queda pendiente de acceso a esa planilla.
📈 Media Performance (30d)
Spend (30d)
$9,649
gold
Leads (30d)
762
blue
CPL
$12.66
CTR prom.
1.74%
Impresiones (30d)
762
Campañas activas
4
🧭 Funnel HubSpot (30d)
SQL (30d)
75
9.8% rate · CPSQL $128.66
SOLDs (30d)
11
Sits verificadas
n/a
sin campo appointment_date poblado de forma confiable en la ventana
Closing rate
14.7%
SOLDs / SQL
💰 CAC Rolling
CAC 30d
$3,216
$9,649 / 3 SOLD
CAC 60d
$1,454
$17,452 / 12 SOLD
CAC 90d
n/a
spend 90d no extraído en este run (solo 30d/60d pulled)
📋 Análisis CAC Rolling — Detalle
VentanaSpendSOLDsCACClientes
30d$9,649 3$3,216 Rafael Figueroa, Jose Efrain Lopez Villegas, Jay P Narain
60d$17,452 12$1,454 Rafael Figueroa, Jose Efrain Lopez Villegas, Jay P Narain, Fernando Jorge Ribeiro Moreira, Huong Giang Tran, Dorothy Peña, Angel Sierra, Jose Lopez…
90dn/a 13n/a Rafael Figueroa, Jose Efrain Lopez Villegas, Jay P Narain, Fernando Jorge Ribeiro Moreira, Huong Giang Tran, Dorothy Peña, Angel Sierra, Jose Lopez…
📅 Performance por Campaña · 30 días
CampañaStatusSpendLeads CPLSQLSQL%CPSQL SOLDsCPSOLDClientes SOLD
Florida_ASE_SQL | ⭐ ACTIVE $2,451 254 $9.65 31 12.2% $79.06 3 $817 Fernando Jorge Ribeiro Moreira, Angel Si…
California_Español_SQL ⭐ ACTIVE $2,237 136 $16.45 20 14.7% $111.84 2 $1,118 Rafael Figueroa, Jose Efrain Lopez Ville…
California_ASE_SQL | v2 ⭐ PAUSED $1,960 152 $12.90 8 5.3% $245.04 6 $327 Jay P Narain, Huong Giang Tran, Dorothy …
California_Ingles_SQL_NV ACTIVE $1,723 160 $10.77 16 10.0% $107.67 0 n/a
California_Borja_SQL | v4 | ACTIVE $1,018 46 $22.12 0 0.0% n/a 0 n/a
California_ASE_SQL | v3 PAUSED $133 4 $33.27 0 0.0% n/a 0 n/a
California_New_SQL_V5 PAUSED $128 10 $12.81 0 0.0% n/a 0 n/a
ACCOUNT TOTAL $9,649 762 $12.66 75 9.8% $128.66 11 $877
📅 Performance por Campaña · 60 días
CampañaStatusSpendLeads CPLSQLSQL%CPSQL SOLDsCPSOLDClientes SOLD
Florida_ASE_SQL | ⭐ ACTIVE $4,334 454 $9.55 68 15.0% $63.74 3 $1,445 Fernando Jorge Ribeiro Moreira, Angel Si…
California_ASE_SQL | v2 ⭐ PAUSED $4,223 300 $14.08 26 8.7% $162.44 6 $704 Jay P Narain, Huong Giang Tran, Dorothy …
California_Español_SQL ⭐ ACTIVE $2,504 152 $16.48 21 13.8% $119.25 2 $1,252 Rafael Figueroa, Jose Efrain Lopez Ville…
North & Central_California_Solar_ASE ⭐ PAUSED $2,471 232 $10.65 15 6.5% $164.74 4 $618 Jose Lopez, Marlon Suarez, Jose R Meza, …
California_Ingles_SQL_NV ACTIVE $1,723 160 $10.77 16 10.0% $107.67 0 n/a
California_Borja_SQL | v4 | ACTIVE $1,018 46 $22.12 0 0.0% n/a 0 n/a
California_ASE_SQL | v3 PAUSED $913 20 $45.64 2 10.0% $456.44 0 n/a
Florida_ASE_SQL | V2 PAUSED $137 24 $5.71 0 0.0% n/a 0 n/a
California_New_SQL_V5 PAUSED $128 10 $12.81 0 0.0% n/a 0 n/a
ACCOUNT TOTAL $17,452 1,398 $12.48 148 10.6% $117.92 15 $1,163
🎯 Performance por Adset · 60 días

Lectura clave: SOLDs mapeados por hsa_grp del first URL — coincide con adset real, no con nombre.

AdsetCampañaSpendLeads CPLCTRSOLDsCPSOLDClientes
California | BROAD ⭐ California_ASE_SQL | v2 $4,012 282 $14.23 1.88% 6 $669 Jay P Narain, Huong Giang Tran…
Florida | BROAD ⭐ Florida_ASE_SQL | $2,591 300 $8.64 1.46% 2 $1,295 Angel Sierra, Claudia Peñate
California | BROAD| ESPANOL ⭐ California_Español_SQL $2,504 152 $16.48 1.25% 2 $1,252 Rafael Figueroa, Jose Efrain L…
Florida | BROAD | EN ⭐ Florida_ASE_SQL | $1,523 142 $10.73 1.84% 1 $1,523 Fernando Jorge Ribeiro Moreira
North & South l Cali | BROAD| ESP ⭐ North & Central_California_Solar_ASE $1,295 134 $9.66 1.85% 4 $324 Jose Lopez, Marlon Suarez, Jos…
North & Central Cali | BROAD North & Central_California_Solar_ASE $1,176 98 $12.00 2.50% 0 n/a
Segmentado Cali | BROAD California_Ingles_SQL_NV $1,031 96 $10.74 1.61% 0 n/a
California | Zip Codes California_Borja_SQL | v4 | $1,018 46 $22.12 1.55% 0 n/a
California | BROAD California_ASE_SQL | v3 $913 20 $45.64 1.87% 0 n/a
All California | BROAD California_Ingles_SQL_NV $692 64 $10.81 1.80% 0 n/a
Florida | BROAD | New Ad Florida_ASE_SQL | $221 12 $18.40 1.98% 0 n/a
California | BROAD | Winner Ads | New Version California_ASE_SQL | v2 $212 18 $11.77 1.75% 0 n/a
Florida | BROAD Florida_ASE_SQL | V2 $137 24 $5.71 2.75% 0 n/a
California | BROAD| INGLES California_New_SQL_V5 $128 10 $12.81 1.68% 0 n/a
📊 Spend vs SQL por Campaña · Funnel por Status
⭐ Top Ads (spend > $50, 30d)
AdCampañaSpendLeads CPLCTRSOLDs
New Static | ESP |07 | New Copy ⭐ California_Español_SQL $1,773 112 $15.83 1.36% 2
Tampa & Orlando | New Static | $149 ⭐ Florida_ASE_SQL | $1,084 138 $7.86 1.36% 1
Florida SQL 4 ⭐ Florida_ASE_SQL | $1,002 82 $12.22 1.65% 1
ASE | Winner 3 California_Ingles_SQL_NV $885 80 $11.06 1.55% 0
ASE | SOLAR | STATIC | 1 California_Borja_SQL | v4 | $690 38 $18.15 1.58% 0
ASE | SOLAR | $149 Winner Ad | English ⭐ California_ASE_SQL | v2 $463 32 $14.46 1.48% 1
New Static | ESP |07 California_Español_SQL $440 24 $18.34 0.89% 0
ASE | SOLAR | STATIC | New Style - Copy 2 ⭐ California_ASE_SQL | v2 $427 26 $16.43 2.20% 2
ASE | Testing 2 California_Ingles_SQL_NV $310 22 $14.09 1.71% 0
ASE | SOLAR | Video | Mat California_Ingles_SQL_NV $303 40 $7.58 1.97% 0
ASE | SOLAR | V | 2 California_Borja_SQL | v4 | $300 8 $37.50 1.45% 0
Florida SQL 5 - New Ad Florida_ASE_SQL | $221 12 $18.40 1.98% 0
ASE | SOLAR | AD01 | v2 California_ASE_SQL | v2 $211 12 $17.58 3.52% 0
ASE | SOLAR | Winner Ad | New Style California_ASE_SQL | v2 $194 18 $10.80 1.79% 0
ASE | SOLAR | AD02 | v2 - Copy California_ASE_SQL | v2 $176 18 $9.77 2.27% 0
ASE | SOLAR | AD02 | v2 ⭐ California_ASE_SQL | v2 $131 8 $16.41 2.87% 1
ASE | SOLAR | STATIC | MIX ADS META California_ASE_SQL | v2 $121 18 $6.74 2.68% 0
ASE | Winner 2 California_Ingles_SQL_NV $119 14 $8.50 1.91% 0
ASE | SOLAR | Winner Ad | New Style - Copy California_ASE_SQL | v2 $103 8 $12.87 1.58% 0
ASE | SOLAR | Video | SQL | Mat California_ASE_SQL | v3 $99 2 $49.56 2.60% 0
Florida SQL 1 Florida_ASE_SQL | $86 8 $10.70 2.04% 0
ASE | SOLAR | AD04 California_New_SQL_V5 $79 6 $13.12 1.02% 0
ASE | Testing 3 California_Ingles_SQL_NV $64 2 $32.16 1.46% 0
Tampa & Orlando | New Static | 05 - Copy 2 Florida_ASE_SQL | $55 14 $3.89 3.45% 0
💡 Insights
Mayor inversión 30d: Florida_ASE_SQL | — $2,451, 254 leads, 3 SOLD.
Campañas con venta confirmada 30d: Florida_ASE_SQL | (3 SOLD), California_Español_SQL (2 SOLD), California_ASE_SQL | v2 (6 SOLD).
2 campaña(s) con <30 leads y 0 SOLD — regla de los 30 leads: NO recomendar pausa todavía (caso Jay P Narain).
📈 Media Performance (30d)
Spend (30d)
$490
gold
Leads (30d)
2
blue
CPL
$244.96
CTR prom.
1.11%
Impresiones (30d)
2
Campañas activas
1
🧭 Funnel HubSpot (30d)
SQL (30d)
0
0.0% rate · CPSQL n/a
SOLDs (30d)
0
Sits verificadas
n/a
sin campo appointment_date poblado de forma confiable en la ventana
Closing rate
n/a
SOLDs / SQL
💰 CAC Rolling
CAC 30d
n/a
0 SOLD, sin spend
CAC 60d
n/a
0 SOLD, sin spend
CAC 90d
n/a
spend 90d no extraído en este run (solo 30d/60d pulled)
📋 Análisis CAC Rolling — Detalle
VentanaSpendSOLDsCACClientes
30d$490 0n/a
60d$3,704 0n/a
90dn/a 1n/a Julia Hilbert
📅 Performance por Campaña · 30 días
CampañaStatusSpendLeads CPLSQLSQL%CPSQL SOLDsCPSOLDClientes SOLD
es-ca-solar-honesto ACTIVE $490 2 $244.96 0 0.0% n/a 0 n/a
ACCOUNT TOTAL $490 2 $244.96 0 0.0% n/a 0 n/a
📅 Performance por Campaña · 60 días
CampañaStatusSpendLeads CPLSQLSQL%CPSQL SOLDsCPSOLDClientes SOLD
10 Windows| For $8995 | Lead Form | 04_10_26 ⭐ ? $2,187 112 $19.53 13 11.6% $168.25 1 $2,187 Joseph Barrios
Roofing_Lead Form_ 6.26.26 ⭐ ? $1,026 16 $64.15 0 0.0% n/a 1 $1,026 Julia Hilbert
es-ca-solar-honesto ACTIVE $490 2 $244.96 0 0.0% n/a 0 n/a
ACCOUNT TOTAL $3,704 130 $28.49 13 10.0% $284.90 2 $1,852
🎯 Performance por Adset · 60 días

Lectura clave: SOLDs mapeados por hsa_grp del first URL — coincide con adset real, no con nombre.

AdsetCampañaSpendLeads CPLCTRSOLDsCPSOLDClientes
Open 24-65+ Miami Dade | Broward + Excluded States & Some county 04_10_26 ⭐ 10 Windows| For $8995 | Lead Form | 04_10_26 $1,891 102 $18.54 2.13% 1 $1,891 Joseph Barrios
Open 24-65+ Miami Dade | Broward + Excluded States & Some county 4_1_26 ⭐ Roofing_Lead Form_ 6.26.26 $807 14 $57.67 1.43% 1 $807 Julia Hilbert
honesto — SDGE 8 cities · ES · 30-60 · Reels+Feed es-ca-solar-honesto $490 2 $244.96 1.11% 0 n/a
SQL 7.17.26 | Open 24-65+ Miami Dade | Broward + Excluded States & Some county 04_10_26 10 Windows| For $8995 | Lead Form | 04_10_26 $297 10 $29.65 1.18% 0 n/a
NEW_Open 24-65+ Miami Dade | Broward + Excluded States & Some county 7_20_26 Roofing_Lead Form_ 6.26.26 $219 2 $109.53 0.85% 0 n/a
📊 Spend vs SQL por Campaña · Funnel por Status
⭐ Top Ads (spend > $50, 30d)
AdCampañaSpendLeads CPLCTRSOLDs
honesto-familia-portal es-ca-solar-honesto $130 2 $64.88 0.88% 0
honesto-reel-5-preguntas es-ca-solar-honesto $124 0 n/a 1.52% 0
honesto-sin-trucos-1x1 es-ca-solar-honesto $113 0 n/a 1.07% 0
💡 Insights
Mayor inversión 30d: es-ca-solar-honesto — $490, 2 leads, 0 SOLD.
1 campaña(s) con <30 leads y 0 SOLD — regla de los 30 leads: NO recomendar pausa todavía (caso Jay P Narain).
📈 Media Performance (30d)
Spend (30d)
$9,819
gold
Leads (30d)
228
blue
CPL
$43.07
CTR prom.
3.49%
Impresiones (30d)
228
Campañas activas
23
🧭 Funnel HubSpot (30d)
SQL (30d)
42
18.4% rate · CPSQL $233.79
SOLDs (30d)
4
Sits verificadas
n/a
sin campo appointment_date poblado de forma confiable en la ventana
Closing rate
9.5%
SOLDs / SQL
💰 CAC Rolling
CAC 30d
$9,819
$9,819 / 1 SOLD
CAC 60d
$5,366
$21,463 / 4 SOLD
CAC 90d
n/a
spend 90d no extraído en este run (solo 30d/60d pulled)
📋 Análisis CAC Rolling — Detalle
VentanaSpendSOLDsCACClientes
30d$9,819 1$9,819 Angel Gaud
60d$21,463 4$5,366 Angel Gaud, Diego Sánchez, Agustin Pico, Leans Felipe
90dn/a 4n/a Angel Gaud, Diego Sánchez, Agustin Pico, Leans Felipe
📅 Performance por Campaña · 30 días
CampañaStatusSpendLeads CPLSQLSQL%CPSQL SOLDsCPSOLDClientes SOLD
11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP ⭐ ACTIVE $2,132 80 $26.65 23 28.7% $92.69 3 $711 Angel Gaud, Agustin Pico, Leans Felipe
10.28_ABO_Testing_Web_California_Video_DL_GP ACTIVE $1,201 0 n/a 0 n/a n/a 0 n/a
07.31_ABO_Testing_FF_Central Florida_Video_Roof_ESP_GP ⭐ ACTIVE $1,050 72 $14.59 19 26.4% $55.29 1 $1,050 Diego Sánchez
07.28_ABO_Testing_Web_Florida_Video_DL_GP ACTIVE $726 12 $60.48 0 0.0% n/a 0 n/a
07.28_ABO_Testing_Web_Florida_Video_DL Techo_GP ACTIVE $502 48 $10.45 0 0.0% n/a 0 n/a
O4.14 | TR. VISITAS IG | ABO | HO EN CA | GP ACTIVE $431 0 n/a 0 n/a n/a 0 n/a
O8.17 | INT. FOLLOW FB | ABO | HO VH CA | GP ACTIVE $359 0 n/a 0 n/a n/a 0 n/a
O8.17 | TR. VISITAS IG | ABO | HO VH CA | GP ACTIVE $344 0 n/a 0 n/a n/a 0 n/a
07.29_ABO_Testing_FF_Central Florida_Video_Roof_EN_GP PAUSED $313 16 $19.59 0 0.0% n/a 0 n/a
06.17 | TR. VISITAS IG | ABO | DEALERS FL | GP ACTIVE $275 0 n/a 0 n/a n/a 0 n/a
O9.05 | TR. VISITAS IG | ABO | HO EN FL | GP ACTIVE $275 0 n/a 0 n/a n/a 0 n/a
08.17 | REC. VIDEO | ABO | HO VH CA | GP ACTIVE $266 0 n/a 0 n/a n/a 0 n/a
O6.21 | TR. VISITAS IG | ABO | HO VH FL | GP ACTIVE $250 0 n/a 0 n/a n/a 0 n/a
04.14 | REC. VIDEO | ABO | HO EN CA | GP ACTIVE $240 0 n/a 0 n/a n/a 0 n/a
04.14 | INT. FOLLOW FB | ABO | HO EN CA | GP ACTIVE $234 0 n/a 0 n/a n/a 0 n/a
12.03 | REC. VIDEO | ABO | DEALERS CA | GP ACTIVE $221 0 n/a 0 n/a n/a 0 n/a
O9.12 | INT. FOLLOW FB | ABO | DEALERS CA | GP ACTIVE $181 0 n/a 0 n/a n/a 0 n/a
11.25 | REC. VIDEO | ABO | DEALERS FL | GP ACTIVE $179 0 n/a 0 n/a n/a 0 n/a
12.16 | REC. VIDEO | ABO | HO VH FL | GP ACTIVE $134 0 n/a 0 n/a n/a 0 n/a
05.16 | INT. FOLLOW FB | ABO | DEALERS FL ACTIVE $121 0 n/a 0 n/a n/a 0 n/a
12.05 | REC. VIDEO | ABO | HO EN FL | GP ACTIVE $120 0 n/a 0 n/a n/a 0 n/a
O9.12 | TR. VISITAS IG | ABO | DEALERS CA | GP ACTIVE $112 0 n/a 0 n/a n/a 0 n/a
09.05 | INT. FOLLOW FB | ABO | HO EN FL | GP ACTIVE $83 0 n/a 0 n/a n/a 0 n/a
O4.12 | INT. FOLLOW FB | ABO | HO VH FL ACTIVE $70 0 n/a 0 n/a n/a 0 n/a
ACCOUNT TOTAL $9,819 228 $43.07 42 18.4% $233.79 4 $2,455
📅 Performance por Campaña · 60 días
CampañaStatusSpendLeads CPLSQLSQL%CPSQL SOLDsCPSOLDClientes SOLD
11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP ⭐ ACTIVE $6,330 208 $30.43 50 24.0% $126.60 3 $2,110 Angel Gaud, Agustin Pico, Leans Felipe
10.28_ABO_Testing_Web_California_Video_DL_GP ACTIVE $2,164 0 n/a 0 n/a n/a 0 n/a
07.28_ABO_Testing_Web_Florida_Video_DL_GP ACTIVE $1,615 12 $134.61 0 0.0% n/a 0 n/a
07.31_ABO_Testing_FF_Central Florida_Video_Roof_ESP_GP ⭐ ACTIVE $1,162 80 $14.52 20 25.0% $58.09 1 $1,162 Diego Sánchez
O4.14 | TR. VISITAS IG | ABO | HO EN CA | GP ACTIVE $1,026 0 n/a 0 n/a n/a 0 n/a
O9.05 | TR. VISITAS IG | ABO | HO EN FL | GP ACTIVE $998 0 n/a 0 n/a n/a 0 n/a
O6.21 | TR. VISITAS IG | ABO | HO VH FL | GP ACTIVE $855 0 n/a 0 n/a n/a 0 n/a
07.28_ABO_Testing_Web_Florida_Video_DL Techo_GP ACTIVE $763 104 $7.33 0 0.0% n/a 0 n/a
06.17 | TR. VISITAS IG | ABO | DEALERS FL | GP ACTIVE $708 0 n/a 0 n/a n/a 0 n/a
04.14 | REC. VIDEO | ABO | HO EN CA | GP ACTIVE $482 0 n/a 0 n/a n/a 0 n/a
12.03 | REC. VIDEO | ABO | DEALERS CA | GP ACTIVE $476 0 n/a 0 n/a n/a 0 n/a
07.29_ABO_Testing_FF_Central Florida_Video_Roof_EN_GP PAUSED $459 22 $20.87 0 0.0% n/a 0 n/a
O9.12 | TR. VISITAS IG | ABO | DEALERS CA | GP ACTIVE $446 0 n/a 0 n/a n/a 0 n/a
11.25 | REC. VIDEO | ABO | DEALERS FL | GP ACTIVE $437 0 n/a 0 n/a n/a 0 n/a
04.14 | INT. FOLLOW FB | ABO | HO EN CA | GP ACTIVE $385 0 n/a 0 n/a n/a 0 n/a
12.16 | REC. VIDEO | ABO | HO VH FL | GP ACTIVE $374 0 n/a 0 n/a n/a 0 n/a
01.10_CBO_Retargeting_FF_Florida_Video_Roof_ESP_GP PAUSED $362 14 $25.88 3 21.4% $120.75 0 n/a
O9.12 | INT. FOLLOW FB | ABO | DEALERS CA | GP ACTIVE $361 0 n/a 0 n/a n/a 0 n/a
O8.17 | INT. FOLLOW FB | ABO | HO VH CA | GP ACTIVE $359 0 n/a 0 n/a n/a 0 n/a
O8.17 | TR. VISITAS IG | ABO | HO VH CA | GP ACTIVE $344 0 n/a 0 n/a n/a 0 n/a
12.05 | REC. VIDEO | ABO | HO EN FL | GP ACTIVE $330 0 n/a 0 n/a n/a 0 n/a
05.16 | INT. FOLLOW FB | ABO | DEALERS FL ACTIVE $305 0 n/a 0 n/a n/a 0 n/a
08.17 | REC. VIDEO | ABO | HO VH CA | GP ACTIVE $266 0 n/a 0 n/a n/a 0 n/a
09.05 | INT. FOLLOW FB | ABO | HO EN FL | GP ACTIVE $234 0 n/a 0 n/a n/a 0 n/a
O4.12 | INT. FOLLOW FB | ABO | HO VH FL ACTIVE $220 0 n/a 0 n/a n/a 0 n/a
ACCOUNT TOTAL $21,463 440 $48.78 73 16.6% $294.01 4 $5,366
🎯 Performance por Adset · 60 días

Lectura clave: SOLDs mapeados por hsa_grp del first URL — coincide con adset real, no con nombre.

AdsetCampañaSpendLeads CPLCTRSOLDsCPSOLDClientes
07.08_ABO_Testing SQL_South Florida_IA_60 ⭐ 11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP $2,243 80 $28.03 1.34% 2 $1,121 Angel Gaud, Leans Felipe
05.15_ABO_Testing_California_Dealers ES_IA_30 10.28_ABO_Testing_Web_California_Video_DL_GP $1,328 0 n/a 2.01% 0 n/a
07.31_ABO_Testing SQL_Central Florida_IA_40 ⭐ 07.31_ABO_Testing_FF_Central Florida_Video_Roof_ESP_GP $1,162 80 $14.52 1.14% 1 $1,162 Diego Sánchez
08.06_ABO_Testing SQL_South Florida_IA_30 11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP $773 32 $24.17 1.44% 0 n/a
07.23_ABO_Testing SQL_South Florida_IA_60 ⭐ 11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP $730 22 $33.16 1.29% 1 $730 Agustin Pico
11.06_ABO_Testing_California_Dealers EN_IA_50 10.28_ABO_Testing_Web_California_Video_DL_GP $682 0 n/a 3.54% 0 n/a
01.23_ABO_Testing_C.Florida EN_10 07.28_ABO_Testing_Web_Florida_Video_DL_GP $638 0 n/a 2.82% 0 n/a
07.17_ABO_Testing_South Florida_IA_60 11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP $612 26 $23.53 1.98% 0 n/a
04.14_ABO_Testing_California_Video O4.14 | TR. VISITAS IG | ABO | HO EN CA | GP $602 0 n/a 4.64% 0 n/a
07.08_ABO_PS SQL_South Florida_IA_70 11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP $528 12 $44.00 1.44% 0 n/a
10.01_ABO_Testing_Miami_Dealers ES_IA_20 07.28_ABO_Testing_Web_Florida_Video_DL_GP $516 8 $64.44 2.53% 0 n/a
07.10_ABO_Testing_South Florida_IA_60 11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP $500 14 $35.71 2.20% 0 n/a
07.28_ABO_Testing_C.Florida_ES_15 07.28_ABO_Testing_Web_Florida_Video_DL Techo_GP $490 46 $10.66 1.77% 0 n/a
04.14_ABO_Testing_California_Video 04.14 | REC. VIDEO | ABO | HO EN CA | GP $482 0 n/a 0.02% 0 n/a
12.12_ABO_Retargeting_Florida_Dealers_10 07.28_ABO_Testing_Web_Florida_Video_DL_GP $462 4 $115.42 2.92% 0 n/a
07.31_ABO_Testing SQL_Central Florida_UGC_40 07.29_ABO_Testing_FF_Central Florida_Video_Roof_EN_GP $459 22 $20.87 2.96% 0 n/a
12.16_ABO_Testing_Florida_Video 12.16 | REC. VIDEO | ABO | HO VH FL | GP $374 0 n/a 1.30% 0 n/a
09.26_ABO_Testing_Florida_Video_Tesla O9.05 | TR. VISITAS IG | ABO | HO EN FL | GP $355 0 n/a 4.85% 0 n/a
12.05_ABO_Testing_Florida_Video 12.05 | REC. VIDEO | ABO | HO EN FL | GP $330 0 n/a 0.52% 0 n/a
10.06_ABO_Testing_Florida_Video_Solar O9.05 | TR. VISITAS IG | ABO | HO EN FL | GP $319 0 n/a 4.12% 0 n/a
01.28_ABO_Testing_Florida_Video O6.21 | TR. VISITAS IG | ABO | HO VH FL | GP $316 0 n/a 3.73% 0 n/a
07.22_ABO_Testing SQL_South Florida_IA_60 11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP $310 12 $25.82 1.22% 0 n/a
04.14_ABO_Testing_California_Video 04.14 | INT. FOLLOW FB | ABO | HO EN CA | GP $301 0 n/a 7.82% 0 n/a
12.04_ABO_Testing FOH_South Florida_IA_80 11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP $294 8 $36.72 1.61% 0 n/a
12.03_ABO_Testing_California_EN 12.03 | REC. VIDEO | ABO | DEALERS CA | GP $275 0 n/a 0.00% 0 n/a
07.28_ABO_Testing_Miami_ES_7 07.28_ABO_Testing_Web_Florida_Video_DL Techo_GP $272 58 $4.69 3.19% 0 n/a
01.20_CBO_Retargeting CV_South Florida_IA 01.10_CBO_Retargeting_FF_Florida_Video_Roof_ESP_GP $248 14 $17.72 1.39% 0 n/a
11.25_ABO_Testing_Florida_ES 11.25 | REC. VIDEO | ABO | DEALERS FL | GP $219 0 n/a 0.63% 0 n/a
11.25_ABO_Testing_Florida_EN 11.25 | REC. VIDEO | ABO | DEALERS FL | GP $218 0 n/a 0.35% 0 n/a
06.09_ABO_Testing_Florida_Video_EN O6.21 | TR. VISITAS IG | ABO | HO VH FL | GP $194 0 n/a 3.31% 0 n/a
12.15_ABO_Testing_Florida_ ES 06.17 | TR. VISITAS IG | ABO | DEALERS FL | GP $186 0 n/a 4.55% 0 n/a
12.03_ABO_Testing_California_ES 12.03 | REC. VIDEO | ABO | DEALERS CA | GP $178 0 n/a 0.54% 0 n/a
07.03_ABO_Testing_Florida_Video_ES 06.17 | TR. VISITAS IG | ABO | DEALERS FL | GP $171 0 n/a 3.03% 0 n/a
09.16_ABO_Testing_California_Imagen_EN O9.12 | INT. FOLLOW FB | ABO | DEALERS CA | GP $162 0 n/a 2.75% 0 n/a
07.03_ABO_Testing_Florida_Video O6.21 | TR. VISITAS IG | ABO | HO VH FL | GP $162 0 n/a 4.14% 0 n/a
08.17_ABO_Testing_California_Video 08.17 | REC. VIDEO | ABO | HO VH CA | GP $156 0 n/a 1.16% 0 n/a
12.12_ABO_Retargeting_California_Dealers EN_10 10.28_ABO_Testing_Web_California_Video_DL_GP $154 0 n/a 2.16% 0 n/a
S1_02 | FL | DEALER 05.16 | INT. FOLLOW FB | ABO | DEALERS FL $130 0 n/a 9.68% 0 n/a
07.12_ABO_SQL FOH_South Florida_IA_50 11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP $129 2 $64.34 1.63% 0 n/a
11.04_ABO_Testing_Florida_Video_Solar O4.12 | INT. FOLLOW FB | ABO | HO VH FL $128 0 n/a 11.43% 0 n/a
📊 Spend vs SQL por Campaña · Funnel por Status
⭐ Top Ads (spend > $50, 30d)
AdCampañaSpendLeads CPLCTRSOLDs
RF1125_05.2 (VAR. Volt RF 02) IA Si tu techo ⭐ 07.31_ABO_Testing_FF_Central Florida_Video_Roof_ESP_GP $1,032 72 $14.34 1.10% 1
RF0626_04 (VOLT AGR 01) UGC Estamos aquí en ⭐ 11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP $918 36 $25.49 1.48% 2
RF0726_03 (VOLT AGR 04) IA Probablemente te conviene 11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP $687 28 $24.54 1.49% 0
DSVH0426_02.1 (Volt Dealers Solar CA 02) IA Eres vendedor solar 10.28_ABO_Testing_Web_California_Video_DL_GP $686 0 n/a 1.74% 0
RF0526_04 (Roof VOLT MSFH 01) IA Buenas noticias para ⭐ 11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP $441 12 $36.76 1.25% 1
IMG Bigger commissiones 10.28_ABO_Testing_Web_California_Video_DL_GP $336 0 n/a 3.79% 0
DRVH0726_01 (Volt Dealers Roof 01) IA Eres vendedor de 07.28_ABO_Testing_Web_Florida_Video_DL Techo_GP $320 16 $19.97 1.50% 0
Eres vendedor o dealer 07.28_ABO_Testing_Web_Florida_Video_DL_GP $310 2 $154.96 2.43% 0
We have a O4.14 | TR. VISITAS IG | ABO | HO EN CA | GP $302 0 n/a 4.61% 0
Hear what peace of mind 04.14 | REC. VIDEO | ABO | HO EN CA | GP $218 0 n/a 0.03% 0
VH_S1_01 UGC Tenemos más de 07.28_ABO_Testing_Web_Florida_Video_DL_GP $192 2 $96.04 2.70% 0
RF0726_04 (VOLT ING 01) IA You'll probably 07.29_ABO_Testing_FF_Central Florida_Video_Roof_EN_GP $191 10 $19.11 2.84% 0
DRVH0726_01 (Volt Dealers Roof 01) IA Eres vendedor de 07.28_ABO_Testing_Web_Florida_Video_DL Techo_GP $182 32 $5.70 2.84% 0
Volt Home está completamente 06.17 | TR. VISITAS IG | ABO | DEALERS FL | GP $146 0 n/a 4.58% 0
We have a 04.14 | INT. FOLLOW FB | ABO | HO EN CA | GP $146 0 n/a 7.68% 0
Malas noticias: los apagones 08.17 | REC. VIDEO | ABO | HO VH CA | GP $141 0 n/a 1.20% 0
Selling home improvement in Tampa 07.28_ABO_Testing_Web_Florida_Video_DL_GP $136 0 n/a 2.20% 0
Malas noticias: los apagones 12.16 | REC. VIDEO | ABO | HO VH FL | GP $127 0 n/a 1.58% 0
At Volt Home, we help dealers 12.03 | REC. VIDEO | ABO | DEALERS CA | GP $115 0 n/a 0.00% 0
We have a O9.05 | TR. VISITAS IG | ABO | HO EN FL | GP $114 0 n/a 4.64% 0
RF0226_07 (Volt RF Ing 01) UGC I don't know 07.29_ABO_Testing_FF_Central Florida_Video_Roof_EN_GP $109 6 $18.16 3.60% 0
Solar Tile O9.05 | TR. VISITAS IG | ABO | HO EN FL | GP $107 0 n/a 4.02% 0
Mi techo tenía 26 años O6.21 | TR. VISITAS IG | ABO | HO VH FL | GP $105 0 n/a 3.88% 0
Más control, más ahorro 08.17 | REC. VIDEO | ABO | HO VH CA | GP $103 0 n/a 0.57% 0
From $700 energy bills 12.05 | REC. VIDEO | ABO | HO EN FL | GP $101 0 n/a 0.00% 0
California, this is your moment 10.28_ABO_Testing_Web_California_Video_DL_GP $95 0 n/a 2.20% 0
RF0726_02 (VOLT AGR 03) Probablemente disfrutarás 11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP $86 4 $21.52 1.07% 0
A home that's ready for anything O8.17 | TR. VISITAS IG | ABO | HO VH CA | GP $86 0 n/a 5.46% 0
Mi techo tenía 26 años O8.17 | TR. VISITAS IG | ABO | HO VH CA | GP $86 0 n/a 4.62% 0
Stop chasing leads 11.25 | REC. VIDEO | ABO | DEALERS FL | GP $79 0 n/a 0.00% 0
No vendas solo un producto 11.25 | REC. VIDEO | ABO | DEALERS FL | GP $77 0 n/a 0.00% 0
California, es tu momento 12.03 | REC. VIDEO | ABO | DEALERS CA | GP $77 0 n/a 0.01% 0
IMG Volt Home in action O9.12 | INT. FOLLOW FB | ABO | DEALERS CA | GP $72 0 n/a 2.34% 0
At Volt Home O9.12 | INT. FOLLOW FB | ABO | DEALERS CA | GP $71 0 n/a 3.33% 0
Más control, más ahorro O6.21 | TR. VISITAS IG | ABO | HO VH FL | GP $69 0 n/a 3.74% 0
IMG Más ventas. Más confianza O9.12 | TR. VISITAS IG | ABO | DEALERS CA | GP $68 0 n/a 2.67% 0
IMG Instalalo hoy y disfruta los beneficios O8.17 | INT. FOLLOW FB | ABO | HO VH CA | GP $67 0 n/a 3.02% 0
Una mejora completa para su hogar O8.17 | TR. VISITAS IG | ABO | HO VH CA | GP $65 0 n/a 4.11% 0
Tu también puedes O8.17 | INT. FOLLOW FB | ABO | HO VH CA | GP $64 0 n/a 13.88% 0
Sabías que los paneles O8.17 | INT. FOLLOW FB | ABO | HO VH CA | GP $61 0 n/a 13.85% 0
💡 Insights
Mayor inversión 30d: 11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP — $2,132, 80 leads, 3 SOLD.
Campañas con venta confirmada 30d: 11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP (3 SOLD), 07.31_ABO_Testing_FF_Central Florida_Video_Roof_ESP_GP (1 SOLD).
2 campaña(s) con <30 leads y 0 SOLD — regla de los 30 leads: NO recomendar pausa todavía (caso Jay P Narain).
🏷️ Mario Moreno — Awareness (18 campañas)

Solo Reach/Frequency/CPM/Impressions/spend — sin funnel HubSpot ni CAC (no aplican).

CampañaSpendLeadsCPLCTR
O4.14 | TR. VISITAS IG | ABO | HO EN CA | GP$431 0n/a 4.89%
O8.17 | INT. FOLLOW FB | ABO | HO VH CA | GP$359 0n/a 8.37%
O8.17 | TR. VISITAS IG | ABO | HO VH CA | GP$344 0n/a 4.15%
06.17 | TR. VISITAS IG | ABO | DEALERS FL | GP$275 0n/a 3.49%
O9.05 | TR. VISITAS IG | ABO | HO EN FL | GP$275 0n/a 6.06%
08.17 | REC. VIDEO | ABO | HO VH CA | GP$266 0n/a 97.27%
O6.21 | TR. VISITAS IG | ABO | HO VH FL | GP$250 0n/a 3.69%
04.14 | REC. VIDEO | ABO | HO EN CA | GP$240 0n/a 3.97%
04.14 | INT. FOLLOW FB | ABO | HO EN CA | GP$234 0n/a 6.94%
12.03 | REC. VIDEO | ABO | DEALERS CA | GP$221 0n/a 2.40%
O9.12 | INT. FOLLOW FB | ABO | DEALERS CA | GP$181 0n/a 2.22%
11.25 | REC. VIDEO | ABO | DEALERS FL | GP$179 0n/a 5.31%
12.16 | REC. VIDEO | ABO | HO VH FL | GP$134 0n/a 1.59%
05.16 | INT. FOLLOW FB | ABO | DEALERS FL$121 0n/a 6.90%
12.05 | REC. VIDEO | ABO | HO EN FL | GP$120 0n/a 4.13%
O9.12 | TR. VISITAS IG | ABO | DEALERS CA | GP$112 0n/a 3.01%
09.05 | INT. FOLLOW FB | ABO | HO EN FL | GP$83 0n/a 7.95%
O4.12 | INT. FOLLOW FB | ABO | HO VH FL$70 0n/a 11.16%
🏷️ Mario Moreno — Lead Gen — Roofing (6 campañas)

Funnel completo igual que VHE (ya incluido en las tablas principales de esta cuenta arriba).

CampañaSpendLeadsCPLCTR
11.12_ABO_Testing_FF_South Florida_Video_Roof_ESP_GP$2,132 80$26.65 1.40%
10.28_ABO_Testing_Web_California_Video_DL_GP$1,201 0n/a 2.16%
07.31_ABO_Testing_FF_Central Florida_Video_Roof_ESP_GP$1,050 72$14.59 1.11%
07.28_ABO_Testing_Web_Florida_Video_DL_GP$726 12$60.48 2.65%
07.28_ABO_Testing_Web_Florida_Video_DL Techo_GP$502 48$10.45 1.93%
07.29_ABO_Testing_FF_Central Florida_Video_Roof_EN_GP$313 16$19.59 3.06%
Gap de datos parcial: no hay acceso a la API nativa de Google Ads (sin credenciales OAuth en .env). Los datos abajo vienen del bridge del Ads Script in-account (push horario a Cloudflare Worker → R2), que solo retiene una ventana corta reciente: 2026-08-24 → 2026-09-02 (10 días). Métricas a nivel Ad Group NO están disponibles por este bridge — solo campaña. CAC 30/60/90d de Google Ads NO se calcula con datos parciales (ver tabla abajo).
📈 Campañas — snapshot ayer/hoy (4 activas de 25 totales)
CampañaStatusCost hoyCost ayer Clicks ayerImpr. ayerConv. ayer
ASE_Local_Pmax_FL ACTIVE $76.67 $145.84 40 639 8
ASE_Leads_Solar_Panels_FL_CA ACTIVE $244.36 $33.53 4 152 0
ASE_Search_Brand_Volt_FL ACTIVE $12.79 $17.96 2 10 0
es-ca-segunda-opinion ACTIVE $0.00 $7.87 2 21 0
Z - Search - Leads - ES PAUSED $0.00 $0.00 0 0 0
Z - Leads - Performance Max - EN PAUSED $0.00 $0.00 0 0 0
Z - Leads - Search - EN PAUSED $0.00 $0.00 0 0 0
Z - Leads - Performance Max - ES PAUSED $0.00 $0.00 0 0 0
Z - Leads - Search - EN - V2 PAUSED $0.00 $0.00 0 0 0
Z - Leads - Search - ES - V2 PAUSED $0.00 $0.00 0 0 0
Z - Leads - Performance Max - EN - V2 PAUSED $0.00 $0.00 0 0 0
Z_search_hvac_english PAUSED $0.00 $0.00 0 0 0
ASE_Pmax_NB_Solar&Tesla_FL PAUSED $0.00 $0.00 0 0 0
OTTO Validation campaign - 74148 - 112377 PAUSED $0.00 $0.00 0 0 0
Kocer - Ads - Air Conditioning Repair PAUSED $0.00 $0.00 0 0 0
Search | HVAC Company PAUSED $0.00 $0.00 0 0 0
ASE_RMKT_Display_SolarEnergy_FL PAUSED $0.00 $0.00 0 0 0
ASE_NB_Search_Powerwall_Florida PAUSED $0.00 $0.00 0 0 0
ASE_NB_Search_Solar_Roof_FL PAUSED $0.00 $0.00 0 0 0
ASE_Search_NB_Remove&Reinstall_FL PAUSED $0.00 $0.00 0 0 0
ASE_NB_Search_Powerwall_Tampa_Orlando PAUSED $0.00 $0.00 0 0 0
ASE_Roof_Pmax_FL_Roof PAUSED $0.00 $0.00 0 0 0
Demand_Gen PAUSED $0.00 $0.00 0 0 0
ASE_Local_Pmax_CA PAUSED $0.00 $0.00 0 0 0
VOLT_SDGE_Search_ES_ PAUSED $0.00 $0.00 0 0 0
💰 CAC Rolling — Google (cobertura parcial, ver nota)
VentanaSpend (días cubiertos)SOLDsCACClientes
30d $183.29 (parcial) 4 n/a Patricia Freeman, Cesar Castro, Steven G Gatchell, Pamela Davis
60d $183.29 (parcial) 7 n/a Patricia Freeman, Cesar Castro, Steven G Gatchell, Pamela Davis, Jon Cameron, Markel Izhakov, Hung Tien
90d $183.29 (parcial) 7 n/a Patricia Freeman, Cesar Castro, Steven G Gatchell, Pamela Davis, Jon Cameron, Markel Izhakov, Hung Tien
📅 Daily series — últimos 10 registros (es-ca-segunda-opinion)
FechaCampañaCostClicksImpresionesConversiones
2026-08-24es-ca-segunda-opinion $0.00 0 4 0
2026-08-25es-ca-segunda-opinion $13.93 2 15 0
2026-08-26es-ca-segunda-opinion $59.39 6 26 0
2026-08-27es-ca-segunda-opinion $40.61 4 30 1
2026-08-28es-ca-segunda-opinion $47.00 1 3 0
2026-08-29es-ca-segunda-opinion $3.28 1 27 0
2026-08-30es-ca-segunda-opinion $3.29 1 29 0
2026-08-31es-ca-segunda-opinion $3.94 1 15 0
2026-09-01es-ca-segunda-opinion $3.98 1 9 0
2026-09-02es-ca-segunda-opinion $7.87 2 21 0
💡 Insights
Google Ads: sin API nativa configurada. Solo bridge de Ads Script con ventana corta (10d). CAC rolling 30/60/90d NO calculable con integridad hasta que se autentique pipeboard-google a nivel de sesión de agente o se configuren credenciales OAuth nativas en .env.
7 SOLDs atribuidos a Google por señales HubSpot 1-5 en ventana 100d (sin reconciliar aún con la planilla de Total Sales — señal 6 del brief, no disponible en este run).