Fivetran Customer Video: Lob

With its data centralized in Redshift, Lob is able to build operations and customer health score dashboards in Looker that include data from multiple sources.
Ciara Rafferty
By Ciara Rafferty | 28 Feb 2020
Fivetran Customer Video: Lob

Fivetran Connectors

Postgres RDS, Amazon S3, Salesforce, Zendesk

Summary

Lob had three main sources of data that it needed to centralize into Redshift: application data in a relational database, static CSV files in S3 and streaming data. John Huang, Head of Data at Lob, estimates that it would probably have taken 2-3 engineers to build out a dedicated integration for each of these sources internally before being able to do any reporting. As a small company, Lob can leverage its data team for more strategic projects and increase agility by leaving the pipeline engineering to Fivetran. 

Lob has multiple Looker reports and dashboards that combine sources. The operational team can look at in-app usage data in combination with the CSV reporting provided by its printing partner to monitor overall service. The customer team has a customer health score and dashboard that monitors in-app behavior as well as Zendesk tickets, Salesforce items, and more to have a holistic view of the overall health of a customer. 

About Lob: Lob provides the building blocks for developers to automate the offline world. Enterprise companies use Lobs suite of APIs to mail fully dynamic and personalized customer communications with print media. We provide insight into deliverability with piece-by-piece tracing and utilize our proprietary Print Delivery Network to streamline production across fully redundant nodes all over the country. 

About Fivetran: Shaped by the real-world needs of data analysts, Fivetran technology is the smartest, fastest way to replicate your applications, databases, events, and files into a high-performance cloud warehouse. Fivetran connectors deploy in minutes, require zero maintenance, and automatically adjust to source changes so your data team can stop worrying about engineering and focus on driving insights.

Are You A Data Expert?

Start a free trial today.

Discover the smartest solution for data-driven results.
We have detected that you are using an adblocking plugin in your browser. We don't show ads, but we rely on advertising services, so it might restrict you from completing important functions or seeing important content. Please make sure you whitelist our website in your adblocking plugin.
Fivetran uses cookies to enhance your user experience and improve the quality of our website. Unless you disable cookies, you consent to the placement and use of cookies as described in our Privacy Policy by continuing to use this website.
Adblock Detection