Reverse ETL

리버스 ETL

Push modeled customer fields from the warehouse back to operational tools.

···
html
<div class="retl"><div class="table"><b>WAREHOUSE</b><span>customer_42</span><strong>score = 82</strong></div><div class="bridge"><i>82</i><span>SYNC →</span></div><div class="crm"><b>CRM PROFILE</b><span>customer_42</span><strong>HIGH INTENT</strong></div></div>
css
.retl{width:min(92%,630px);display:flex;align-items:center;gap:clamp(5px,1.5vmin,16px);font:800 clamp(10px,max(3.7vmin,1vw),16px)/1.2 sans-serif}.table,.crm{flex:1;min-width:0;display:grid;gap:clamp(5px,1.5vmin,13px);padding:clamp(9px,2vmin,20px);border:2px solid var(--fg);background:var(--surface)}.table b,.crm b{color:var(--accent)}.table span,.crm span{font-family:monospace;color:var(--muted);overflow:hidden;text-overflow:ellipsis}.table strong,.crm strong{padding:clamp(5px,1vmin,10px);background:var(--fg);color:var(--bg);white-space:nowrap}.crm strong{animation:receive 3s infinite}.bridge{width:23%;height:clamp(65px,15vmin,110px);position:relative;display:grid;place-items:center;color:var(--accent)}.bridge:before{content:'';position:absolute;top:50%;left:0;right:0;border-top:3px solid var(--accent)}.bridge span{position:absolute;bottom:0;color:var(--muted);font-size:max(10px,1vw,.75em);white-space:nowrap}.bridge i{position:relative;display:grid;place-items:center;width:clamp(20px,4vmin,34px);aspect-ratio:1;border-radius:50%;background:var(--accent);color:white;font-style:normal;animation:sync 3s infinite}@keyframes sync{0%{transform:translateX(-90%);opacity:0}20%{opacity:1}80%{transform:translateX(90%);opacity:1}100%{transform:translateX(90%);opacity:0}}@keyframes receive{0%,65%,100%{background:var(--fg)}75%,90%{background:var(--accent)}}

Reverse ETL sends modeled customer scores or segments from a warehouse to operational tools such as a CRM or messaging platform. It turns analysis into action.

In the demo, a score calculated from purchase history travels into a CRM profile. Define field ownership and refresh intervals to avoid conflicts across systems.

A stale score should not masquerade as live behavior. Send its calculation time too.

When to use

Use it when warehouse models need to drive campaign conditions.

Open as page ↗