← Back to projectsAutomation · Real project
Full funnel automation: download, editing, and republishing
PythonSqlAutomated WorkflowData Extraction
Python automation tool for marketing funnel management. The system extracts funnel data from the database via SQL queries, downloads funnels via links, applies modifications using POD/PDR and clustering logic, and republishes them automatically. Key Results: Reduced manual funnel editing time from hours to minutes Ensured precise, repeatable updates at required steps Minimized human errors and maintained consistency across multiple funnels
app.dtdigital.it/funnel/pipeline● Running
Funnel Automation · Python
funnel-automation.py · SQL → download → cluster → edit → republish
Republished22 published
Files downloaded3avg 1840ms
Edits applied60 conflicts
Errors avoided3avg publish 560ms
Pipeline20% pipeline complete
Active step420 ms
SQL ExtractSELECT funnel_id, link, config FROM funnels WHERE status='active'| Step | Avg exec time | Status |
|---|---|---|
| SQL Extract | 420 ms | Running |
| Download | 1840 ms | Queued |
| Clustering | 290 ms | Queued |
| Auto-Edit | 180 ms | Queued |
| Republish | 560 ms | Queued |
Live logrun #1
2 funnels republished · HTTP 200560ms
6 diffs applied, 0 conflicts180ms
