Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Metricool data to
Metricool Connector Reference
83 metrics62 dimensions
The Metricool connector exposes 145 fields (83 metrics, 62 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Metricool Fields
Metricool facebook_posts fields
The facebook_posts report of the Metricool connector includes 26 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| facebook_angry | NUMERIC | Facebook Angry Reactions | Number of angry reactions |
| facebook_clicks | NUMERIC | Facebook Clicks | Total number of clicks on the post |
| facebook_comments | NUMERIC | Facebook Comments | Number of comments on the post |
| facebook_content | TEXT | Facebook Content | Text content of the Facebook post |
| facebook_engagement | NUMERIC | Facebook Engagement Rate | Engagement rate for the post |
| facebook_haha | NUMERIC | Facebook Haha Reactions | Number of haha reactions |
| facebook_image_url | IMAGE_URL | Facebook Image URL | URL to the Facebook post's image |
| facebook_impressions | NUMERIC | Facebook Impressions | Total number of impressions |
| facebook_impressions_organic | NUMERIC | Facebook Organic Impressions | Number of organic impressions |
| facebook_impressions_paid | NUMERIC | Facebook Paid Impressions | Number of paid impressions |
| facebook_impressions_unique | NUMERIC | Facebook Unique Impressions | Number of unique impressions (reach) |
| facebook_likes | NUMERIC | Facebook Likes | Number of like reactions |
| facebook_link_clicks | NUMERIC | Facebook Link Clicks | Number of link clicks |
| facebook_love | NUMERIC | Facebook Love Reactions | Number of love reactions |
| facebook_page_id | TEXT | Metricool Facebook Page ID | ID of the Facebook page |
| facebook_post_id | TEXT | Metricool Facebook Post ID | Unique identifier for the Facebook post |
| facebook_reactions | NUMERIC | Facebook Reactions | Total number of reactions on the post |
| facebook_sad | NUMERIC | Facebook Sad Reactions | Number of sad reactions |
| facebook_shares | NUMERIC | Facebook Shares | Number of shares of the post |
| facebook_type | TEXT | Facebook Post Type | Type of Facebook post (e.g., photo, video, link) |
| facebook_url | TEXT | Metricool Facebook Post URL | URL link to the Facebook post |
| facebook_video_time_watched | NUMERIC | Facebook Video Time Watched | Total video watch time in seconds |
| facebook_video_views | NUMERIC | Facebook Video Views | Number of video views |
| facebook_video_views_organic | NUMERIC | Facebook Organic Video Views | Number of organic video views |
| facebook_video_views_paid | NUMERIC | Facebook Paid Video Views | Number of paid video views |
| facebook_wow | NUMERIC | Facebook Wow Reactions | Number of wow reactions |
Metricool facebook_reels fields
The facebook_reels report of the Metricool connector includes 7 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| facebook_reel_avg_watch_time | NUMERIC | Facebook Reel Avg Watch Time | Average watch time in seconds |
| facebook_reel_content | TEXT | Facebook Reel Content | Caption text of the reel |
| facebook_reel_id | TEXT | Facebook Reel ID | Unique identifier for the Facebook reel |
| facebook_reel_image_url | IMAGE_URL | Facebook Reel Thumbnail URL | URL to the reel's thumbnail |
| facebook_reel_plays | NUMERIC | Facebook Reel Play Count | Number of plays |
| facebook_reel_reactions | NUMERIC | Facebook Reel Reactions | Number of reactions on the reel |
| facebook_reel_url | TEXT | Facebook Reel URL | URL link to the Facebook reel |
Metricool facebook_stories fields
The facebook_stories report of the Metricool connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| facebook_story_id | TEXT | Facebook Story ID | Unique identifier for the Facebook story |
| facebook_story_image_url | IMAGE_URL | Facebook Story Image URL | URL to the story's image |
| facebook_story_url | TEXT | Facebook Story URL | URL link to the story |
Metricool instagram_posts fields
The instagram_posts report of the Metricool connector includes 14 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| instagram_comments | NUMERIC | Instagram Comments | Number of comments on the post |
| instagram_content | TEXT | Instagram Content | Caption text of the Instagram post |
| instagram_engagement | NUMERIC | Instagram Engagement Rate | Engagement rate for the post |
| instagram_image_url | IMAGE_URL | Instagram Image URL | URL to the Instagram post's image |
| instagram_impressions | NUMERIC | Instagram Impressions | Total number of times the post was displayed |
| instagram_interactions | NUMERIC | Instagram Interactions | Total number of interactions on the post |
| instagram_likes | NUMERIC | Instagram Likes | Number of likes on the post |
| instagram_post_id | TEXT | Metricool Instagram Post ID | Unique identifier for the Instagram post |
| instagram_reach | NUMERIC | Instagram Reach | Number of unique accounts that saw the post |
| instagram_saved | NUMERIC | Instagram Saved | Number of times the post was saved |
| instagram_shares | NUMERIC | Instagram Shares | Number of shares of the post |
| instagram_type | TEXT | Instagram Post Type | Type of Instagram post (e.g., image, video, carousel) |
| instagram_url | TEXT | Metricool Instagram Post URL | URL link to the Instagram post |
| instagram_video_views | NUMERIC | Instagram Video Views | Number of video views |
Metricool instagram_reels fields
The instagram_reels report of the Metricool connector includes 11 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| instagram_reel_comments | NUMERIC | Instagram Reel Comments | Number of comments on the reel |
| instagram_reel_content | TEXT | Instagram Reel Content | Caption text of the reel |
| instagram_reel_engagement | NUMERIC | Instagram Reel Engagement Rate | Engagement rate for the reel |
| instagram_reel_id | TEXT | Instagram Reel ID | Unique identifier for the Instagram reel |
| instagram_reel_image_url | IMAGE_URL | Instagram Reel Thumbnail URL | URL to the reel's thumbnail image |
| instagram_reel_likes | NUMERIC | Instagram Reel Likes | Number of likes on the reel |
| instagram_reel_reach | NUMERIC | Instagram Reel Reach | Number of unique accounts that saw the reel |
| instagram_reel_saved | NUMERIC | Instagram Reel Saved | Number of times the reel was saved |
| instagram_reel_shares | NUMERIC | Instagram Reel Shares | Number of shares of the reel |
| instagram_reel_url | TEXT | Instagram Reel URL | URL link to the Instagram reel |
| instagram_reel_views | NUMERIC | Instagram Reel Views | Number of views on the reel |
Metricool instagram_stories fields
The instagram_stories report of the Metricool connector includes 9 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| instagram_story_exits | NUMERIC | Instagram Story Exits | Number of times users exited the story |
| instagram_story_id | TEXT | Metricool Instagram Story ID | Unique identifier for the Instagram story |
| instagram_story_image_url | IMAGE_URL | Instagram Story Image URL | URL to the story's image |
| instagram_story_impressions | NUMERIC | Instagram Story Impressions | Total number of times the story was displayed |
| instagram_story_reach | NUMERIC | Instagram Story Reach | Number of unique accounts that saw the story |
| instagram_story_replies | NUMERIC | Instagram Story Replies | Number of replies to the story |
| instagram_story_taps_back | NUMERIC | Instagram Story Taps Back | Number of taps back |
| instagram_story_taps_forward | NUMERIC | Instagram Story Taps Forward | Number of taps forward |
| instagram_story_url | TEXT | Instagram Story URL | URL link to the story |
Metricool linkedin_posts fields
The linkedin_posts report of the Metricool connector includes 21 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| linkedin_appreciation | NUMERIC | LinkedIn Appreciation Reactions | Number of appreciation (celebrate) reactions |
| linkedin_clicks | NUMERIC | LinkedIn Clicks | Number of clicks on the post |
| linkedin_comments | NUMERIC | LinkedIn Comments | Number of comments on the post |
| linkedin_company_id | TEXT | LinkedIn Company ID | ID of the LinkedIn company page |
| linkedin_content | TEXT | LinkedIn Content | Text content of the LinkedIn post |
| linkedin_empathy | NUMERIC | LinkedIn Empathy Reactions | Number of empathy (support) reactions |
| linkedin_engagement | NUMERIC | LinkedIn Engagement Rate | Engagement rate for the post |
| linkedin_image_url | IMAGE_URL | LinkedIn Image URL | URL to the LinkedIn post's image |
| linkedin_impressions | NUMERIC | LinkedIn Impressions | Total number of impressions |
| linkedin_interest | NUMERIC | LinkedIn Interest Reactions | Number of interest (curious) reactions |
| linkedin_like_reactions | NUMERIC | LinkedIn Like Reactions | Number of like reactions (distinct from total likes) |
| linkedin_likes | NUMERIC | LinkedIn Likes | Number of likes on the post |
| linkedin_maybe | NUMERIC | LinkedIn Funny Reactions | Number of funny reactions |
| linkedin_post_id | TEXT | LinkedIn Post ID | Unique identifier for the LinkedIn post |
| linkedin_praise | NUMERIC | LinkedIn Praise Reactions | Number of praise (insightful) reactions |
| linkedin_shares | NUMERIC | LinkedIn Shares | Number of shares of the post |
| linkedin_type | TEXT | LinkedIn Post Type | Type of LinkedIn post |
| linkedin_unique_impressions | NUMERIC | LinkedIn Unique Impressions | Number of unique impressions |
| linkedin_url | TEXT | LinkedIn Post URL | URL link to the LinkedIn post |
| linkedin_video_views | NUMERIC | LinkedIn Video Views | Number of video views |
| linkedin_viewers | NUMERIC | LinkedIn Viewers | Number of unique viewers |
Metricool profile fields
The profile report of the Metricool connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| account_id | TEXT | Account ID | Account identifier (same as blog_id) |
| account_name | TEXT | Account Name | Account name (same as blog_name) |
| blog_id | TEXT | Blog ID | Metricool brand/blog identifier |
| blog_name | TEXT | Blog Name | Metricool brand/blog label |
Metricool twitter_posts fields
The twitter_posts report of the Metricool connector includes 30 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| twitter_content | TEXT | Tweet Content | Text content of the tweet |
| twitter_engagement | NUMERIC | Twitter Engagement Rate | Engagement rate for the tweet |
| twitter_image_url | IMAGE_URL | Tweet Image URL | URL to the tweet's image |
| twitter_is_promoted | BOOLEAN | Twitter Is Promoted | Whether the tweet was promoted |
| twitter_organic_impressions | NUMERIC | Twitter Organic Impressions | Number of organic impressions |
| twitter_organic_likes | NUMERIC | Twitter Organic Likes | Number of organic likes/favorites |
| twitter_organic_link_clicks | NUMERIC | Twitter Organic Link Clicks | Number of organic link clicks |
| twitter_organic_profile_clicks | NUMERIC | Twitter Organic Profile Clicks | Number of organic profile clicks |
| twitter_organic_replies | NUMERIC | Twitter Organic Replies | Number of organic replies |
| twitter_organic_retweets | NUMERIC | Twitter Organic Retweets | Number of organic retweets |
| twitter_organic_video_views | NUMERIC | Twitter Organic Video Views | Number of organic video views |
| twitter_post_id | TEXT | Metricool Tweet ID | Unique identifier for the tweet |
| twitter_promoted_impressions | NUMERIC | Twitter Promoted Impressions | Number of paid/promoted impressions |
| twitter_promoted_likes | NUMERIC | Twitter Promoted Likes | Number of paid likes/favorites |
| twitter_promoted_link_clicks | NUMERIC | Twitter Promoted Link Clicks | Number of paid link clicks |
| twitter_promoted_profile_clicks | NUMERIC | Twitter Promoted Profile Clicks | Number of paid profile clicks |
| twitter_promoted_replies | NUMERIC | Twitter Promoted Replies | Number of paid replies |
| twitter_promoted_retweets | NUMERIC | Twitter Promoted Retweets | Number of paid retweets |
| twitter_promoted_video_views | NUMERIC | Twitter Promoted Video Views | Number of paid video views |
| twitter_total_impressions | NUMERIC | Twitter Total Impressions | Total impressions (organic + promoted) |
| twitter_total_likes | NUMERIC | Twitter Total Likes | Total likes (organic + promoted) |
| twitter_total_link_clicks | NUMERIC | Twitter Total Link Clicks | Total link clicks (organic + promoted) |
| twitter_total_profile_clicks | NUMERIC | Twitter Total Profile Clicks | Total profile clicks (organic + promoted) |
| twitter_total_quotes | NUMERIC | Twitter Quotes | Number of quote tweets |
| twitter_total_replies | NUMERIC | Twitter Total Replies | Total replies (organic + promoted) |
| twitter_total_retweets | NUMERIC | Twitter Total Retweets | Total retweets (organic + promoted) |
| twitter_total_video_views | NUMERIC | Twitter Total Video Views | Total video views (organic + promoted) |
| twitter_type | TEXT | Tweet Type | Type of tweet (e.g., text, image, video) |
| twitter_url | TEXT | Tweet URL | URL link to the tweet |
| twitter_username | TEXT | Twitter Username | Twitter handle/username |
Metricool other fields
The Metricool connector has 20 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | The date of the post or data point | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| network | TEXT | Network | Social network platform name | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |