Create reports and visualizations with data from UserVoice and other sources by using a data warehouse
We know you love UserVoice as your customer feedback platform, and chances are you use other SaaS tools for things like analytics, billing, CRM, and support. Since marketers are data-driven, you probably want to combine data from all of your cloud platforms and internal databases to surface insights and improve performance — but how?
The best tactic is to create a data warehouse that consolidates all of your data in a single location. Most businesses nowadays use cloud data warehouses for that purpose. You can extract the data from your SaaS applications and on-premises databases and load it to your data warehouse using an ETL (extract, transform, load) tool such as Stitch. Once the data is available, analysts can use it to create reports.
In this post, we’ll walk through the process of connecting UserVoice to Stitch, setting up replication to a data warehouse, and accessing the data with a business intelligence (BI) tool to create reports.
Three tiers of the data analytics architecture
Data sources like UserVoice form a foundation for a data analytics stack that comprises three tiers: ETL software, data warehouse, and business intelligence (BI) software.
Stitch provides a simple, powerful ETL service for businesses of all sizes. Signup is simple — you can be moving data from one or more sources to a data warehouse in five minutes.
The last few years have seen the emergence of cloud-native data warehouses such as Amazon Redshift, Google BigQuery, and Snowflake. Because they run on cloud infrastructure that scales quickly and cost-effectively to meet performance demands, they can handle transformation using the same hardware on which the data warehouse runs.
Finally, to unlock the value of your data, you can connect a BI or data visualization tool to your data warehouse and create reports that analyze data from multiple sources, which you can share via browser-based dashboards.
Setting up a data warehouse
Let’s set up a three-tiered data analytics stack, starting with the data warehouse. If you don’t already have a data warehouse, choose one that meets your needs. If you choose Redshift, BigQuery, Snowflake, or one of the other destinations Stitch supports, you can follow the setup steps for your data warehouse in the Stitch documentation.
Setting up Stitch for ETL
The next step is setting up an ETL pipeline to move data from your sources to the data warehouse. Stitch makes extracting data from a source and loading it into a data warehouse easy. To get started, visit the signup page, enter your email address, then enter your name and a password.
Add an integration
Next, add UserVoice as an integration within Stitch. Click on the UserVoice icon to get started:
Enter a name for the integration. The name will display on the Stitch Dashboard for the integration and will be used to create the name in your destination. You must also enter a UserVoice API Key and API Secret, which you can generate using the instructions in the Stitch documentation.
The other two settings ask how much historical data you want to replicate to your data warehouse and how often you want to replicate new data.
When you click Save, Stitch displays another screen that lets you choose what tables you want to replicate.
Each time you check a table, Stitch will display all the fields in the table, so you can choose the ones you want.
When you’re done with one table, click the name of the integration in the breadcrumb bar to return to the previous screen, where you can click additional tables. When you have all you want, click Finalize Your Selections, and voilà!
All new fields and records of the types you’ve selected will be replicated to your data warehouse — but first you have to connect the data warehouse you set up to Stitch as a destination.
Add a destination
Suppose you’ve chosen an Amazon Redshift data warehouse. Clicking on the Redshift icon brings you to a screen where you can enter your credentials:
Now all the pieces are in place, and the data is ready to flow.
When you visit your Stitch dashboard, the status for your new integration may show as pending while Stitch schedules the initial replication job. If you refresh the screen after a few minutes the status will change to active.
From the dashboard you can also do things like adding integrations from other data sources. The Stitch documentation walks through the process for each one.
Connecting BI software to your data warehouse
The final stage of the process is connecting an analytics platform to your data warehouse. If you don’t already use BI software, you have dozens of analysis tools to choose from, including popular options such as Tableau, Microsoft Power BI, Google Data Studio, Looker, Chartio, Periscope Data, and Mode.
That’s all there is to it. Using an ETL tool like Stitch to move data from UserVoice and other sources into a data warehouse lets you employ BI tools to correlate and report on data from all of your sources.