ContactBook a call

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.

See which of these apply to your team

On a discovery call we map the manual work in your team and show you which of these would change it first.

Book a discovery call

Cookie preferences

Choose what this site may use on your device. You can change this at any time from “Cookie settings” in the footer.

Strictly necessary

Keep the site working and remember the choices you make here. These cannot be switched off, and none of them track you.

Always on
What this includes (4)
NameProvider PurposeDuration
sbd-consentThis site Remembers your cookie choices12 months
Vercel Web AnalyticsVercel Inc. Counts page views in aggregate. Sets no cookie and stores nothing on your deviceNone
ticker-dismissed, sbd-note-offThis site Remembers that you closed a notice or language tipUntil the tab closes
sbd-voice-resume, sbd-voice-prefillThis site Carries a voice conversation across pages, only if you start oneUntil the tab closes

Analytics

Tell us which pages are read and where visitors leave, so we can improve them. IP addresses are anonymised and nothing is used for advertising.

What this includes (2)
NameProvider PurposeDuration
_gaGoogle Analytics (Google LLC) Distinguishes visitors with a random ID13 months
_ga_FPXDMQPRV1Google Analytics (Google LLC) Keeps the session state for this site13 months

Functional

Embedded services that set their own cookies. Without them the site still works; you get a link to open the service instead.

What this includes (1)
NameProvider PurposeDuration
Booking calendarCal.com Inc. Shows live availability and books the call on the booking pageSet by Cal.com

Advertising

Not used. This site has no advertising, retargeting or social media tracking, and we never sell data.

Not used

Questions about your data: hello@smallbaydigital.com