What is Google Data Studio?
Google Data Studio is a reporting and dashboard that "turns your data into informative dashboards and reports that are easy to read, easy to share, and fully customizable." You can learn more from Google on their Data Studio page.
If you are familiar with building reports using tools like Tableau or PowerBI, you'll feel right at home in Data Studio. With live connections to Google Analytics, Search Console, and now, Rival IQ, you'll be able to build live dashboards for your clients and teams.
To get started creating your first report, you need to set up the data source. We will be publishing our connector to the Data Studio Community Collector Gallery. In the meantime, use the button below to add the Rival IQ Connector to your Data Studio account. Please note, you only have to do this once. After you've done it, you'll have the Rival IQ connector permanently available to you within Data Studio.
Once you click this link, you'll set up your first instance of our connector. To do this, you'll need two things to get going: your API key, and your landscape ID. Each time you create a new instance of the connector, you'll need these two things. Each connector instance that you create is connected to a single landscape in Rival IQ.
To find your API key, go to your Email & Password page in the Account Settings.
To find the landscape ID of the landscape you want to connect, go to your landscape page and open the Get Landscape ID modal.
Once you've found both of these items, insert them into the data source configuration page. At this point, you'll need to make one more decision. Which type of data source are you connecting to in Rival IQ: social posts, daily metrics, or summary metrics?
Social Posts will give you access to the post-level data, including engagement metrics, message, and metadata like published date. There is one row of data per post. Our social posts API documentation shares all of the details about which metrics are available.
Daily Metrics will give you access to aggregate social and SEO metrics, with one row of data per company per day. Our time-series metrics API documentation has more details on which metrics are available. If you are looking to make time-series graphs, this will be the way to go. Please note: if you are aggregating over time periods that are longer than one day, you will need to create calculated fields for rate and average metrics.
Summary Metrics will give you access to aggregate social and SEO metrics, with one row of data per company that covers the entire time period. Our summary metrics API documentation has more details on which metrics are available.
Please note: you can connect to each of these data sources in a single report, but you'll have to set it up once for each metric type.
Pro-tip 1: name your connector something meaningful so that you can remember what it is within a report. Also, you can re-use these configured connections in multiple reports. Having good names will help you pick the right ones.
Pro-tip 2: you can access previously configured connections to use again in new reports. Find them in your Data Sources screen within Data Studio.
Building Your First Report
Once you have finished connecting your data source, you're ready to go. For this example, we've used the Social Posts data source.
Let's build a bar chart showing the total engagement for social posts, with one bar per company, and stacked by channel.
First, draw a bar chart on the report. Our defaults will use Engagement Total as the metric.
Now, to color by channel, add a dimension, and choose 'Channel.'
In the bar chart properties, go to the Style tab and select 'Stacked Bars'.
To pick your date range, you can use the Report settings and override their default with a custom time period.
You've just built your first custom visualization! Congrats. :)