Our Google’s Looker Studio connectors integrate Brandwatch Social Media Management (SMM) to your BI platform to enhance data visualization and reporting capabilities. This integration allows your Looker Studio users to pull in social media metrics and performance data directly into Looker Studio, enabling comprehensive analysis and reporting.
What is the Looker Studio connector?
Introducing our new connectors designed to enhance your experience in analysing social media data within Looker Studio. We offer two distinct connectors at no cost, provided you have your API keys. These tools allow you to easily synchronise and extract performance metrics from your social media channels and content.
The connectors operate seamlessly in the background, connecting to our API endpoints to retrieve raw social media metrics. This means you can focus on utilising your insights without the hassle of complex setups. Follow our guides help you understand the data structure, ensuring that your Looker Studio users can start making the most of their data right away. Get ready to improve your data analysis capabilities!
Your Looker Studio users can create custom dashboards that reflect real-time social media performance, track engagement metrics, and visualize trends over time. By combining SMM data with other business intelligence sources, Your organization can gain deeper insights into your marketing strategies and make data-driven decisions to optimize your social media efforts.
Connecting Looker Studio to Social Media Management
You can quickly integrate Social Media Management with your Looker Studio instance with just a few clicks.
Note: In Social Media Management, navigate to Settings > Integration marketplace > API keys to obtain your API key. (For detailed instructions, visit our article on Getting Access to Social Media Management APIs).
Understanding the data structure provided by Brandwatch
As mentioned previously, the Looker Studio connectors follow the existing logic within our Measure product where we structure our incoming social media metrics within Channel and Content oriented metrics.
Please use the following articles to get to know the data structure better:
Use the Extract functionality in Looker Studio
Our connectors by default maintain a live connection to Brandwatch via the API endpoints we have built into the connectors. This live connection makes sure, that every time you update a dashboard or report, you use the latest data.
When you want to do an in-depth analysis and you want super fast response within Looker Studio, you can use the built-in Extract tool in Looker Studio to get a selected data set for a specific time frame loaded straight into your Looker Studio instance and stored there.
This method will provide you almost instantaneous experience playing with social media data you retrieved from Brandwatch SMM.
To use the Extract functionality, follow the guide provided by Looker Studio here: Extract data for faster performance.
The first steps look like this:
In the connectors list, select Extract Data.
Select the already configured Brandwatch connectors as existing data source to extract from.
Select the dimensions and metrics to extract by dragging them from the Available Fields list onto the targets, or by clicking Add. All the fields you add appear in the list on the far right.
Apply a date range. Date ranges are required by some connectors, such as Analytics, but are optional for other connector types.
In the lower right, click SAVE AND EXTRACT.