Skip to content
Book a demoStart free
Connectors

Metricool connector

Set up the Metricool connector in Kaivo: authentication, configuration, the 21 BigQuery tables it syncs, and answers to common questions.

Metricool connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Metricool data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your marketing and sales data instead of moving it.

Sync your Metricool social media data into BigQuery with Kaivo to analyse posts and performance across networks.

CategoryMarketing & Sales
AuthenticationAPI key
SetupSelf-service

Getting started with the Metricool connector

Section titled “Getting started with the Metricool connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Metricool account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your User Token.

Field Description
User Token
User token to authenticate API requests. Find it in Account Settings → API section of your Metricool account.

|

When you set up the connector, you provide:

Field Description
User ID
Your Metricool account ID.

| | Blog IDs |

IDs of the brands (social media profiles) you want to sync from Metricool.

| | Start Date |

Any data before this date will not be fetched.

|

Kaivo syncs 21 tables from Metricool into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

brands (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
deleted BOOL
engagement_ratio FLOAT64
facebook STRING
facebook_ads STRING
facebook_page_id STRING
fb_business_id STRING
first_connection_date FLOAT64
hash STRING
id FLOAT64
instagram STRING
is_shared BOOL
join_date FLOAT64
label STRING
linkedin_company STRING
owner_user_id FLOAT64
owner_username STRING
picture STRING
pinterest STRING
role STRING
tiktok STRING
tiktokads STRING
timezone STRING
user_id FLOAT64
youtube STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
facebook_competitors (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
display_name STRING
favorite BOOL
id FLOAT64
is_demo BOOL
picture STRING
provider STRING
provider_id STRING
screen_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
facebook_posts (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
blog_id FLOAT64
clicks FLOAT64
comments FLOAT64
created FLOAT64
engagement FLOAT64
impressions FLOAT64
impressions_organic FLOAT64
impressions_paid FLOAT64
impressions_unique FLOAT64
impressions_unique_organic FLOAT64
impressions_unique_paid FLOAT64
link STRING
linkclicks FLOAT64
page_id STRING
picture STRING
post_id STRING
reactions FLOAT64
shares FLOAT64
spend FLOAT64
text STRING
timestamp FLOAT64
video_time_watched FLOAT64
video_views FLOAT64
video_views_organic FLOAT64
video_views_paid FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
facebook_posts_timelines (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
blog_id FLOAT64
datetime STRING
metric STRING
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
facebook_reels (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
blog_id FLOAT64
blue_reels_play_count FLOAT64
created__date_time STRING
created__timezone STRING
engagement FLOAT64
length FLOAT64
page_id STRING
post_impressions_unique FLOAT64
post_video_avg_time_watched_seconds FLOAT64
post_video_reactions FLOAT64
post_video_social_actions FLOAT64
post_video_view_time_seconds FLOAT64
reel_id STRING
reel_url STRING
thumbnail_url STRING
video_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
facebook_reels_timelines (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
blog_id FLOAT64
datetime STRING
metric STRING
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
facebook_stories (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
blog_id FLOAT64
created__date_time STRING
created__timezone STRING
media_id STRING
media_type STRING
page_id STRING
story_id STRING
story_url STRING
thumbnail_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
facebook_stories_timelines (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
blog_id FLOAT64
datetime STRING
metric STRING
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
instagram_competitors (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
comments FLOAT64
cost FLOAT64
cost_per_interaction FLOAT64
display_name STRING
engagement FLOAT64
favorite BOOL
followers FLOAT64
id FLOAT64
is_demo BOOL
likes FLOAT64
picture STRING
posts FLOAT64
provider STRING
provider_id STRING
reels FLOAT64
screen_name STRING
updated FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
instagram_posts (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
blog_id FLOAT64
business_id STRING
clicks FLOAT64
comments FLOAT64
content STRING
created STRING
engagement FLOAT64
filter STRING
image_url STRING
impressions FLOAT64
impressions_total FLOAT64
interactions FLOAT64
likes FLOAT64
post_id STRING
reach FLOAT64
saved FLOAT64
shares FLOAT64
timestamp FLOAT64
url STRING
user_id STRING
video_views_total FLOAT64
views FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
instagram_posts_timelines (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
blog_id FLOAT64
datetime STRING
metric STRING
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
instagram_reels (32 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
blog_id FLOAT64
business_id STRING
clicks FLOAT64
comments FLOAT64
content STRING
created STRING
engagement FLOAT64
filter STRING
image_url STRING
impressions FLOAT64
impressions_paid FLOAT64
impressions_total FLOAT64
interactions FLOAT64
likes FLOAT64
post_clicks_paid FLOAT64
post_interactions_paid FLOAT64
reach FLOAT64
reach_paid FLOAT64
reel_id STRING
saved FLOAT64
shares FLOAT64
spend FLOAT64
timestamp FLOAT64
url STRING
user_id STRING
video_views FLOAT64
video_views_paid FLOAT64
video_views_total FLOAT64
views FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
instagram_reels_timelines (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
blog_id FLOAT64
datetime STRING
metric STRING
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
instagram_stories (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
blog_id FLOAT64
business_id STRING
content STRING
exits FLOAT64
impressions FLOAT64
media_url STRING
owner STRING
permalink STRING
post_id STRING
reach FLOAT64
replies FLOAT64
taps_back FLOAT64
taps_forward FLOAT64
thumbnail_url STRING
timestamp FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
instagram_stories_timelines (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
blog_id FLOAT64
datetime STRING
metric STRING
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
linkedin_posts (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
blog_id FLOAT64
clicks FLOAT64
comment STRING
comments FLOAT64
company_id STRING
created FLOAT64
created_timestamp FLOAT64
engagement FLOAT64
impressions FLOAT64
likes FLOAT64
picture STRING
post_id STRING
shares FLOAT64
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tiktok_account_timelines (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
blog_id FLOAT64
datetime STRING
metric STRING
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tiktok_posts (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
average_time_watched FLOAT64
blog_id FLOAT64
comment_count FLOAT64
cover_image_url STRING
create_time STRING
duration FLOAT64
embed_link STRING
engagement FLOAT64
full_video_watched_rate FLOAT64
height FLOAT64
impression_sources__follow FLOAT64
impression_sources__for_you FLOAT64
impression_sources__personal_profile FLOAT64
impression_sources__search FLOAT64
impression_sources__sound FLOAT64
like_count FLOAT64
open_id STRING
reach FLOAT64
share_count FLOAT64
share_url STRING
title STRING
total_time_watched FLOAT64
video_description STRING
video_id STRING
view_count FLOAT64
width FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tiktok_video_timelines (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
blog_id FLOAT64
datetime STRING
metric STRING
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
twitter_posts (36 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
blog_id FLOAT64
created FLOAT64
created_at FLOAT64
favorite_count FLOAT64
favorites FLOAT64
has_media BOOL
has_photo BOOL
has_tags BOOL
has_urls BOOL
has_video BOOL
id FLOAT64
id_str STRING
is_retweet BOOL
lang STRING
link_clicks FLOAT64
metrics_v2__organic_impressions FLOAT64
metrics_v2__organic_likes FLOAT64
metrics_v2__organic_replies FLOAT64
metrics_v2__promoted_impressions FLOAT64
metrics_v2__promoted_likes FLOAT64
metrics_v2__promoted_replies FLOAT64
metrics_v2__total_engagement FLOAT64
metrics_v2__total_impressions FLOAT64
metrics_v2__total_likes FLOAT64
metrics_v2__total_replies FLOAT64
promoted BOOL
retweet BOOL
retweet_count FLOAT64
retweets FLOAT64
text STRING
tweet_id STRING
updated_at FLOAT64
user_id FLOAT64
user_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
youtube_posts (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
average_view_duration FLOAT64
blog_id FLOAT64
comments FLOAT64
dislikes FLOAT64
has_revenue_data BOOL
likes FLOAT64
published_at__date_time STRING
published_at__timezone STRING
shares FLOAT64
thumbnail_url STRING
title STRING
video_id STRING
views FLOAT64
watch_minutes FLOAT64
watch_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Metricool supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Metricool?

Section titled “How long does the initial sync take for Metricool?”

It depends on how much history is in your Metricool account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Metricool’s schema changes?

Section titled “What happens when Metricool’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Metricool, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Metricool instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Metricool connector in Kaivo and all of its synced data is deleted with it.

Use the posts and timelines tables to compare performance across Facebook, Instagram, and more.

Join posts and reels with their timelines to see what content performs best over time.

Use the competitors tables to benchmark your performance against others.

Use Metricool data in your AI and BI tools

Section titled “Use Metricool data in your AI and BI tools”

Once Metricool data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Metricool data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Metricool connector pricing and plan details.