Can I use Metricool with Tableau?
Updated 5 months ago
How to connect Metricool with Tableau using the API
If you work with Tableau and need to visualize your Metricool metrics, you can do it through our API.
You can set up queries to fetch data directly from the Metricool API and build dynamic visualizations in Tableau.
What you need
A Metricool account with access to the Metricool API
Tableau Desktop installed
Basic knowledge of Web/API queries and data modeling
What data can you access
The Metricool API allows you to access various areas of your account, such as:
Social media stats (followers, interactions, posts)
Ad campaign metrics (Facebook Ads, Instagram Ads, Google Ads, TikTok Ads)
Inbox data
See all available endpoints here:
👉 Metricool API documentation
How to use Metricool in Tableau
The steps in this article are intended as a general guide and may vary depending on updates to each platform. We recommend checking the official documentation of the tool you’re using to ensure you follow the most up-to-date process.
Open Tableau Desktop
Go to Data > Connect to Data > Web Data Connector.Enter the endpoint URL you want to query
Example to retrieve your connected accounts: https://app.metricool.com/apiAdd your authentication token
In the headers section, add:
Key:
AuthorizationValue:
YOUR_TOKEN
👉 You can check how to create a Web Data Connector in Tableau to include token authentication.
Extract the data and use Tableau Prep or the built-in modeler
This way you can transform, join, or filter the data as needed.
⚠️ Make sure your request always includes the parameters blogId and userId
Create your visualizations
Build dashboards, charts, or tables to analyze the performance of your content and campaigns.
Keep in mind
This type of connection requires technical knowledge and experience with APIs and Web Data Connectors.
If you’re unsure how to use a specific endpoint, refer to the documentation or contact our team.