Bring Twitter Analytics into Your Dashboard

Introduction

Twitter is a social networking service that lets users post messages known as tweets and interact with them, an activity known as engagement. This service can act as a social medium to improve the reach of your business. With Twitter activity data, you can measure your business’s reach and brand awareness based on tweet impressions, engagements, likes, replies, and retweets, and then use these metrics to grow your business. Visualizing such Twitter analytics data through a dashboard saves people in your organization time by streamlining the processes of collecting data and then transforming it into structured tables based on needed metrics, refreshing the data periodically, and repeating these steps on a daily basis.

In this blog, we’ll see how to bring analytics data from Twitter through the CData Connect Cloud connector and then create a live, interactive dashboard using Bold BI to visualize the data. CData Connect Cloud allows you to create a virtual database for all supported connectors and make it available as a standard SQL interface. Refer to this blog post for more details about CData Connect Cloud connector integration with Bold BI.

Creating a virtual database for a Twitter data source in CData Connect Cloud

In your CData Connect Cloud, click the Twitter data source and create a virtual database by logging in to your Twitter account.

Once you’ve authorized and saved the Twitter virtual database, connect to Bold BI with the MySQL endpoint.

Creating a Twitter analytics dashboard

To create dashboard, first connect to the Bold BI MySQL data source using the MySQL endpoint in CData Connect Cloud. It fetches the data from the database server by executing the query every time, and the dashboard shows the latest metrics in real time for live connections.

Once you’ve connected to the MySQL data source, a predefined list of tables and views will be displayed. Drag and drop the required tables or views to the canvas and save the data source.

Now you are all set to create a dashboard. Check out the How to Create a Dashboard video tutorial to get started with dashboard creation.

In the above sample dashboard, you see the metrics of total tweets, total users, trending tweets, and tweets by country. You can also filter the data by selecting a specific country on the map widget. Finally you can share your dashboard with your team and start collaborating on the Bold BI dashboard online.

If you have any questions, please post them in the comments section below. You can also contact us by submitting your questions through the Bold BI website, or if you already have an account, you can log in to submit your support question. Bold BI dashboards now come with a 15-day free trial with no credit card information required. We welcome you to start a free trial and experience Bold BI for yourself.