This website requires JavaScript.
7228cf1b65
Integración con OpenCode
main
Rompetechos cuenta de desarrollo
2026-07-09 16:49:00 +02:00
a7f8ddad08
Add backfill scripts for MetricasDiarias gaps caused by the month-change bug
José Manuel Gómez
2026-07-03 00:43:41 +02:00
31193c57ee
Fix month-change MetricasDiarias overwrite bug, add per-date Ads metrics helpers
José Manuel Gómez
2026-07-03 00:43:33 +02:00
ea201ef565
Replace ambiguous cost-vs-revenue bar charts with clearer line charts
José Manuel Gómez
2026-07-03 00:43:21 +02:00
8cb5832f8b
Replace deprecated use_container_width with width param in dashboard
José Manuel Gómez
2026-07-02 20:17:43 +02:00
94745cfda3
Fix month-change MetricasDiarias corruption and -0€ display in Slack report
José Manuel Gómez
2026-07-02 17:48:42 +02:00
bfd130578a
Improve SEM dashboard: split Histórico tabs, shrink KPI metrics, add daily P&L chart
José Manuel Gómez
2026-07-02 17:43:55 +02:00
2ffc28cfbc
Allow dashboard WebSocket origin from public reverse-proxy domain
José Manuel Gómez
2026-07-02 14:20:53 +02:00
b30377e307
Set Streamlit dashboard to listen on port 15002
José Manuel Gómez
2026-07-02 13:54:25 +02:00
94c2d3b730
Add Streamlit dashboard for leads-optimizer metrics
José Manuel Gómez
2026-07-02 13:08:42 +02:00
d23cb6b9c2
Fix tracking discrepancy direction, improve daily metrics table, increase max_tokens
José Manuel Gómez
2026-06-13 20:27:31 +02:00
a024508062
Add run.sh with env vars and utf8 flag
José Manuel Gómez
2026-06-13 17:15:52 +02:00
858755a6b8
Disable ambiguous attribution paths for cursoids with multiple PMX campaigns
José Manuel Gómez
2026-06-13 09:41:52 +02:00
4d03ddf271
Increase decide() max_tokens 600→700 to prevent JSON truncation
José Manuel Gómez
2026-06-12 15:57:08 +02:00
f1fba2dfb2
Show git commit hash as version in Slack header
José Manuel Gómez
2026-06-11 23:10:26 +02:00
4848253c49
Fix leadform double-attribution and Slack message truncation
José Manuel Gómez
2026-06-11 23:04:40 +02:00
0eb360bf6d
Increase decide() max_tokens to 600 to fix JSON truncation
José Manuel Gómez
2026-06-11 19:06:41 +02:00
170f0a3207
Add 5th lead attribution path: cursoid + Google-Ads-Notifications UserAgent
José Manuel Gómez
2026-06-11 18:35:55 +02:00
c025a5f828
Downgrade Claude calls to sonnet-4-6 for cost efficiency
José Manuel Gómez
2026-06-06 10:00:58 +02:00
3028123c81
Switch all Claude calls to claude-opus-4-8
José Manuel Gómez
2026-06-06 09:53:46 +02:00
bf945f2d75
Add SLACK_WEBHOOK_URL to environment variables
Francisco Monteagudo
2026-06-05 10:27:18 +02:00
d82e604a15
Add attr_cursoid + attr_utm_source as 4th lead attribution path
José Manuel Gómez
2026-05-21 22:31:03 +02:00
b30a075c59
Fix leadform attribution: sum PMX + leadform conversions for margin analysis
José Manuel Gómez
2026-05-21 21:53:45 +02:00
a94c18c13c
Add daily portfolio analysis and weekly strategic report
José Manuel Gómez
2026-05-21 20:22:37 +02:00
aa9225d338
Add PPLMedio, CPAMedio, CosteMes, ConvMes to GAMes record
José Manuel Gómez
2026-05-18 17:03:03 +02:00
a489a08785
Fix margin consistency: use MetricasDiarias for sumatorio cost
José Manuel Gómez
2026-05-18 12:46:07 +02:00
624f5e484d
Slack daily margin table: show only sumatorio margin
José Manuel Gómez
2026-05-18 11:48:43 +02:00
bdc0d5ede3
Add GAMes table and daily margin table in Slack
José Manuel Gómez
2026-05-18 11:44:18 +02:00
523e04d61f
Backfill Google Ads daily leads for May in MetricasDiarias
José Manuel Gómez
2026-05-04 10:47:27 +02:00
f65f793c95
Rename leads field: Google Ads as 'leads', Airtable as 'leads_lake'
José Manuel Gómez
2026-05-04 10:36:20 +02:00
f1dec1c887
Add daily leads count per campaign to MetricasDiarias
José Manuel Gómez
2026-05-04 10:24:28 +02:00
26eeff794c
Count Google Lead Form leads in Airtable lead attribution
José Manuel Gómez
2026-05-02 12:11:22 +02:00
a85bc90b80
Fix Slack monthly summary: correct investment, conversions and margin calculations
José Manuel Gómez
2026-05-01 10:55:58 +02:00
64fb151de9
Add GitHub Actions workflow for daily execution at 2 AM (CEST)
José Manuel Gómez
2026-04-30 13:40:58 +02:00
3eec871d93
Add Slack summary report with daily metrics and campaign rankings
José Manuel Gómez
2026-04-30 12:38:10 +02:00
45e9515ae8
Add daily metrics snapshot (MetricasDiarias) to GACampaignMes
José Manuel Gómez
2026-04-30 10:44:53 +02:00
d58448f698
Add technical documentation (docu.md)
José Manuel Gómez
2026-04-27 15:19:30 +02:00
369bca604e
Add leadform campaign detection and log notes for attribution discrepancies
José Manuel Gómez
2026-04-25 16:32:38 +02:00
9edd74b9ad
Add PMX attribution detection and ConvLeadsLakeMesGrupo field
José Manuel Gómez
2026-04-25 14:46:03 +02:00
a1aef8f58e
Multiple fixes: lead matching, metrics aggregation, Log field, SPRINT with capping=0
José Manuel Gómez
2026-04-25 11:05:06 +02:00
5639bd6e76
Fix ConvLeadsLakeMesFinal: use fresh leads count instead of stale pre-run value
José Manuel Gómez
2026-04-23 13:08:52 +02:00
c62e2de9e8
Add FIND on GoogleCampaignID field as fallback for lead matching
José Manuel Gómez
2026-04-23 12:49:16 +02:00
c728cfc149
Improve lead tracking and agent advice quality
José Manuel Gómez
2026-04-22 12:25:00 +02:00
e80ed58000
Fix leads filter: use FIND(gad_campaignid) in attr_referer instead of formula field; remove catalog Leads Lake update
José Manuel Gómez
2026-04-22 10:23:08 +02:00
88523dc0a7
Simplify Leads Lake filter: remove utm_source, keep only GoogleCampaignID + utm_medium=paid_search
José Manuel Gómez
2026-04-21 16:10:53 +02:00
7bd1cf20da
Add Criticidad field sync to GACampaignMes
José Manuel Gómez
2026-04-21 13:12:05 +02:00
d9a8e7ee0d
Update campaign status in both tables from per-campaign Google Ads metrics
José Manuel Gómez
2026-04-21 13:05:42 +02:00
f6f897adeb
Include campaign status in analysis and fix agent reactivation advice
José Manuel Gómez
2026-04-21 13:01:41 +02:00
a5ce85ed32
Add GACampaignMes sync and use it as optimization source
José Manuel Gómez
2026-04-21 13:00:34 +02:00
7344cc0c52
Order campaign output by priority and add direct Google Ads links
José Manuel Gómez
2026-04-20 18:27:51 +02:00
b0f0ad394b
Recalculate PPL weighted by centro invalidation rate and sync CapTotalMes from CursoMes
José Manuel Gómez
2026-04-20 16:41:48 +02:00
2191a498d7
Link Leads Lake records to campaign on each run
José Manuel Gómez
2026-04-20 10:21:30 +02:00
ec3802eccf
Auto-calculate PPL and CPAMax from CENTROCURSO on sync
José Manuel Gómez
2026-04-19 12:35:49 +02:00
952fabe4ca
Sync ConvMes and CosteMes to Airtable on each run
José Manuel Gómez
2026-04-17 21:12:05 +02:00
e4362c6ad9
Add sync detail and per-campaign advice
José Manuel Gómez
2026-04-17 16:16:43 +02:00
2f88eb119d
Add execution logging to logs/ directory
José Manuel Gómez
2026-04-17 16:13:43 +02:00
f954b7ee38
Fix encoding, batch sync and field mapping
José Manuel Gómez
2026-04-17 16:10:56 +02:00
ef7d494aeb
Merge pull request #1 from jmgomezroi/claude/help-project-setup-t4hyw
jmgomezroi
2026-04-17 14:02:45 +02:00
67d5104dca
Sync campaign Status from Google Ads (ENABLED→Activa, PAUSED→Pausada)
Claude
2026-04-17 11:52:38 +00:00
905ad3bcd2
Align field names with actual Airtable schema
Claude
2026-04-17 11:48:52 +00:00
d68f9f5659
Sync Google Ads campaigns to Airtable before analysis
Claude
2026-04-17 11:33:37 +00:00
f0d7f65c1a
Initial commit
José Manuel Gómez
2026-04-17 12:53:25 +02:00