Building Customer Support Analytics infrastructure in minutes

Giorgos Psistakis

Why anyone needs customer support analytics? Because things break usually.

Building Customer Support Analytics infrastructure in minutes

How you fix them varies. But analyzing and measuring your customer support metrics is equally important to all the rest of a company’s departments.

In my life as an engineer, when I needed to buy something I wanted to be technically impressive and always to have great support. Either that was a laptop or my kid’s little toy. Here at Blendo, we are engineers at heart. We have our Customer Support analytics and value all responses for that same reason. You are looking for a solution with great support.

Currently, we use Intercom to help our customers. But as we grow our customer’s needs are growing too. Our needs for more advanced customer support analytics grow with them. In fact, they have to scale even faster.

But they say to eat your own dog food right?

Today we’re sharing how we built a customer support analytics infrastructure in minutes instead of weeks or months that can support a growing company and can quickly scale with it.

We gather data and take into account data sources from:

  • Customer Success services
  • Customer Support services
  • Project Management and Software development tools
  • Billing data

into one data warehouse where we run all our customer support analytics and metrics.

Icon: App: Used For:
Intercom Intercom Customer Success, Customer Support
Zendesk Zendesk Customer Support
Pivotal Tracker Pivotal Tracker Project Management, Software Development
Gitlab Gitlab Project Management, Software Development
Import your Xero data into your data warehouse - Xero Accounting, Billing
Stripe Stripe Billing, Subscription Management

Although the number of data sources you may use can vary, I would like you to follow through the process. I want to show you how building such an infrastructure is simpler than it sounds.

If you are in a hurry to tell me that yes, these cloud services offer APIs to extract data, so building and maintaining these integrations is easy, then you are right!

I will not disagree with you.

It is doable.

But with what cost in resources, time and people?

So let’s start. But first things first.

Load your data into a data warehouse

Currently, we push all our data in a PostgreSQL instance in AWS. As we are proud Amazon Web Services Partners, we could use an awesome Amazon Redshift cluster, but we resisted the urge 🙂

Customer Success services

Last time we talked about Customer Success and how we track our customer success metrics. Intercom is a very popular customer support platform. Although they have an analytics dashboard in their app, it does not fit in all the complex scenarios and use cases.

Building a data pipeline that will extract data from Intercom will get you a rich amount of data. If we take a look at the kind of data from Intercom you can get into your data warehouse, you will quickly find out that there are a lot of customer support questions you may answer.

Integrate data from Intercom

How long do you think you will need to integrate Intercom and sync your data into your data warehouse? It is actually two steps.

One… Connect Intercom as data source.

Intercom Sync your Customer Success data from Intercom to any data warehouse. Analytics-ready data with no hassle. Integrate Now

Load Intercom data into your data warehouse

Two… Sync your Intercom data

Load Intercom data into your data warehouse

There you go. Integrating Intercom and loading all your data into your data warehouse is a matter of minutes.

For more details read this guide on how to setup an Intercom integration.

Customer Support services

Customer Support cloud services have super valuable data. If you drill down to your tickets and customers, you may find out how support affects sales or retention.

Having such data you can measure customer support performance, ticket response and resolution time or how all of these affect your customer retention. Or even find out if the clients who pay more create more support tickets or not.

Integrate data from Zendesk

Load Zendesk data into your data warehouseThere goes 2 out of 4 data sources.


For more details read this guide on how to setup a Zendesk integration.

Project Management and Software development tools

There is an extensive list of Project management/task related and software development tools. Usually, their data are not that many, but they are context sensitive. If they are enriched with data from support and software development they can prove gold. You may combine data from tools like Gitlab, Pivotal Tracker or Jira and see how response and development time of a support ticket affects your customers.

We will make use of webhooks that provide event data as they happen and giving you almost immediate incremental updates to your data warehouse.

Integrate data from Pivotal Tracker

We will need to setup a webhook in Blendo.

Load Pivotal Tracker data into your data warehouse

and then add it in Pivotal

Load Pivotal Tracker data into your data warehouse


For more details read this guide on how to setup a Pivotal Tracker integration.

Integrate data from Gitlab

Again let’s add a new webhook in Blendo and then just add it in Gitlab.

Load Gitlab data into your data warehouse

3 down, 1 to go.

For more details read this guide on how to setup a Gitlab integration.

Billing data

This is the most no-brainer here. How can I even know who pays or not? What amount he pays and which tier he is.

Having my customer support data enriched with my billing data from Xero or Stripe will provide an entirely different dynamic in my customer support analytics view.

Integrate data from Xero

Getting started importing data from Xero is easy. We will need to connect Xero as a Data Source and Blendo will import your Xero data and load it into your data warehouse.

Load Xero data into your data warehouseFor more details read this guide on how to setup a Xero integration.

Building Financial Analytics Dashboards- an eBook for accountants and CFOs

Integrate data from Stripe

We will setup quickly an incoming webhook in Blendo
Load Stripe data into your data warehouse

Then just configure Stripe to send us the relevant events
Load Stripe data into your data warehouse

For more details read this guide on how to setup a Stripe integration.

Building Customer Support Analytics infrastructure in minutes with Blendo

Getting your customer support data into a data warehouse like Amazon Redshift, Google BigQuery or Microsoft SQL server is something that has to fit your use case and your team’s knowledge and experience. If you choose a service like Blendo for your data integration needs you will probably never need to worry about having to sync your data into your data warehouse instance ever again.

On the other side, scaling, switching customer support cloud tools or migrating from other solutions will not take ages of software development and design.

Maintenance is on us too.

Over to You

Now you know exactly how to get started building a customer support analytics for your business. Giving you the means to do it should not be hard, and that’s why we build Blendo.

Measuring quality of customer service, optimizing and taking fast and informed decisions help a company grow and earn loyal customers. That is what we want for our business, that is why it should be a win-win.

Let us know what you think about these customer support integrations by leaving a comment below!

Work with analytics-ready data into your database with no configuration - no maintenance data pipelines. Raw data to insights in minutes.

Blendo is the easiest way to automate powerful data integrations.

Try Blendo free for 14 days. No credit card required.