Data
Reverse ETL
Reverse ETL is copying modelled data from a data warehouse back into operational tools, such as a CRM, support desk or ad platform, so staff see it where they work.
How it works in practice
ETL brings data into the warehouse for analysis. Reverse ETL sends the useful results back out: lifetime value onto the CRM contact, product usage onto the support ticket, a churn-risk flag into the account manager’s task list. Tools such as Hightouch and Census do this, and simple cases can be a scheduled job.
The benefit is one calculation used everywhere instead of each tool computing its own version. The risk is overwriting fields people edit by hand, so we agree which fields the warehouse owns and make those read-only in the destination.
A worked example
A SaaS company calculates account health in its warehouse from usage, tickets and payments. Reverse ETL writes the score to HubSpot every morning, and accounts that drop below a threshold create a task for their customer success manager.
Examples in this glossary describe typical builds for companies of 1 to 1,000 people. They are not named client results.















