Navigate back to the homepage

Introducing RudderStack Cloud Extract and Warehouse Actions

Gavin Johnson
January 26th, 2021 · 4 min read

This post was originally published on RudderStack’s blog. I wrote this as part of a launch for RudderStack’s new features Cloud Extract, ELT functionality, and Warehouse Extract, data warehouse sync functionality.


Use all your customer data. Answer more difficult questions. Send insights to your whole customer data stack.

RudderStack Event Stream is what we are known for and has always been top-notch. Our SDKs and plugins, like our Gatsby plugin, make it easy to instrument your sites and apps, collect your event data, and route it to all of your customer tools. Your event data isn’t all of your customer data though. It’s only a subset. You still have non-event customer data locked into cloud applications, like Salesforce and ZenDesk, that is near-impossible to combine and correlate with your event data, apply deep analysis to, and activate in your customer tools. It’s too difficult to use all of your customer data.

RudderStack has been warehouse-first since the beginning as well. We build your customer data warehouse on your data warehouse for you. It’s a first-class citizen for us, because the most valuable work on your customer data happens in your warehouse. But it’s very manual and difficult to activate the insights from your warehouse in your customer tools. Like data in cloud apps, these insights get trapped in your data warehouse.

Today, we’re solving both of these issues with the launch of two new, powerful features, Cloud Extract and Warehouse Actions. Cloud Extract makes it easy to build ELT pipelines from your cloud applications to your warehouse by providing out-of-the-box integrations for popular tools like Salesforce, ZenDesk, and many more (even Google Sheets). Warehouse Actions takes being warehouse-first to the next level by letting you route analysis-driven insights from your warehouse to all of your customer tools for activation.

Now, with RudderStack, you can use all your customer data to answer more difficult questions and send those insights to your whole customer data stack.

Cloud Extract

RudderStack Cloud Extract lets you go beyond event streaming and use all of your customer data. It makes it easy to build ELT pipelines from your cloud applications to your data warehouse, letting you aggregate all of your customer data in your warehouse, from customer event data generated by digital touchpoints to non-event customer data from different cloud applications. This enables you to easily integrate data from your product, sales, marketing, support, and finance teams’ cloud tools with your customer event data so that you can surface answers to more complicated, nuanced business questions.

Learn more about Cloud Extract including how to use it in our post RudderStack Cloud Extract makes cloud-to-warehouse pipelines easy.

Warehouse Actions

Once data is successfully ingested into your warehouse, your teams can then apply advanced queries or models to generate valuable insights that are frequently materialized as their own tables and stored in your data warehouse.

RudderStack Warehouse Actions let you send this rich analysis from your warehouse to your entire customer data stack. Your data warehouse effectively becomes a data source for enriched audiences and events that RudderStack can ingest and route to all of the customer tool destinations we support.

Learn more about Warehouse Actions including how to use it in our post RudderStack Warehouse Actions unlocks the data in your warehouse.

Solve more complex analytical problems

Cloud Extract and Warehouse Actions are both powerful features that when used along with Event Stream can help you solve difficult problems that aren’t easy to tackle with the existing tools on the market.

Audience Segmentation

This marketing strategy refers to creating subgroups (based on demographics and customer buying patterns) within your target audience that lead to customized experiences and stronger connections with your customers.

Now you can perform your own segmentation on your warehouse using complex queries or tools like DBT, then use Warehouse Actions to send audiences and cohorts to all of your customer tool destinations.

Recommendation Engines

A recommendation engine is a system that suggests related and relevant products, services, and other information based on the analysis of customer data. With a recommendation engine, companies can easily boost revenue, conversions, and other sales and engagement metrics. Good recommendations also improve customer satisfaction and, as a result, retention.

Now you can build your own recommendation engine, using tools like Google BigQuery ML, on your data warehouse and use RudderStack Warehouse Actions to send the results to all of your customer tool destinations.

Personalization

Personalization customizes the customer experience on a cohort or even individual level, making interactions smoother and more powerful. This leads to increased customer satisfaction and the likelihood of repeat customer visits.

Just like the recommendation engine, you can build your own personalization engine on your data warehouse and use Warehouse Actions to send the results to your user profile store in tools like Redis, which drive website and app personalization.

Lead Scoring/Tagging

Lead scoring is a popular sales and marketing method for ranking leads to determine their sales-readiness or intent to buy. Leads are scored are largely based on behavior, which is represented as events (like browsing behavior, conversion, etc.), and profile, which is represented as customer traits. Many companies also group leads based on different categories using a tagging system.

Now you can use your complete customer data set to perform lead scoring and automatically sync it back to your CRM. With Event Stream and Cloud Extract, you can:

  • Use Event Stream to collect behavioral event data from your websites and apps.
  • Use Cloud Extract to combine event data in your warehouse with up-to-date lead data from your CRM.
  • Build the lead scoring/tagging logic on your warehouse that uses all of your customer data (event and non-event).
  • Use Warehouse Actions to send the results back to your CRM.

Try RudderStack today

Start building a smarter customer data pipeline. Use all your customer data. Answer more difficult questions. Send insights to your whole customer data stack. Sign up for RudderStack Cloud Free today.

Join our Slack to chat with our team, check out our open source repos on GitHub, subscribe to our blog, and follow us on social: Twitter, LinkedIn, dev.to, Medium, YouTube.

More articles from thtmnisamnstr

RudderStack Cloud Extract - Feature Overview Video

Feature overview video for RudderStack Cloud Extract.

January 25th, 2021 · 1 min read

Why You Don’t Want a Customer Data Platform

The warehouse-first approach eliminates the problems that CDP users frequently face. It solves the use cases associated with a CDP.

January 13th, 2021 · 8 min read
© 2020–2021 thtmnisamnstr
Link to $https://twitter.com/gavinjtechLink to $https://dev.to/thtmnisamnstrLink to $https://github.com/thtmnisamnstrLink to $https://www.linkedin.com/in/gavin-johnson/Link to $https://www.instagram.com/thtmnisamnstr