Skip to content
Book a demoStart free
Connectors

Mention connector

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

Mention connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Mention 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 Mention media monitoring data into BigQuery with Kaivo to analyse brand mentions and sentiment over time.

CategoryMarketing & Sales
AuthenticationAPI key
SetupSelf-service

Getting started with the Mention connector

Section titled “Getting started with the Mention connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Mention 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 API Key.

Field Description
API Key
Your Mention API access token, used to authenticate to the Mention API.

|

When you set up the connector, you provide:

Field Description
Statistics Interval
How often statistics are aggregated.

| | Start Date |

Only statistics from this date onward will be synced.

|

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

account (129 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
avatar_url STRING
bucket FLOAT64
client_state STRING
company_name STRING
company_size STRING
created_at STRING
email STRING
email_subscriptions__quota_exceeded BOOL
enabled_mfa BOOL
extended_profile_set BOOL
graph_qlid STRING
hide_mark_all_read_mentions BOOL
id STRING
language_code STRING
name STRING
notifications_preferences__alert_notifications__alert_notif_alert_shared_with_you__email BOOL
notifications_preferences__alert_notifications__alert_notif_alert_shared_with_you__inapp BOOL
notifications_preferences__alert_notifications__alert_notif_mention_assigned_to_you__email BOOL
notifications_preferences__alert_notifications__alert_notif_mention_assigned_to_you__inapp BOOL
notifications_preferences__alert_notifications__alert_notif_quota_exceeded__email BOOL
notifications_preferences__alert_notifications__alert_notif_quota_exceeded__inapp BOOL
notifications_preferences__alert_notifications__alert_notif_quota_nearly_exceeded__email BOOL
notifications_preferences__alert_notifications__alert_notif_quota_nearly_exceeded__inapp BOOL
notifications_preferences__publish_notifications__publish_notif_approved_post__email BOOL
notifications_preferences__publish_notifications__publish_notif_approved_post__inapp BOOL
notifications_preferences__publish_notifications__publish_notif_denied_post__email BOOL
notifications_preferences__publish_notifications__publish_notif_denied_post__inapp BOOL
notifications_preferences__publish_notifications__publish_notif_failure__desktop BOOL
notifications_preferences__publish_notifications__publish_notif_failure__email BOOL
notifications_preferences__publish_notifications__publish_notif_failure__inapp BOOL
notifications_preferences__publish_notifications__publish_notif_in_review_post__email BOOL
notifications_preferences__publish_notifications__publish_notif_in_review_post__inapp BOOL
notifications_preferences__publish_notifications__publish_notif_ongoing__desktop BOOL
notifications_preferences__publish_notifications__publish_notif_ongoing__email BOOL
notifications_preferences__publish_notifications__publish_notif_ongoing__inapp BOOL
notifications_preferences__publish_notifications__publish_notif_success__desktop BOOL
notifications_preferences__publish_notifications__publish_notif_success__email BOOL
notifications_preferences__publish_notifications__publish_notif_success__inapp BOOL
notifications_preferences__pulse_notifications__default_trending_email_notification_frequency STRING
notifications_preferences__pulse_notifications__default_trending_sms_notification_frequency STRING
notifications_preferences__respond_notifications__respond_notif_assigned_to_you__desktop BOOL
notifications_preferences__respond_notifications__respond_notif_assigned_to_you__email BOOL
notifications_preferences__respond_notifications__respond_notif_assigned_to_you__inapp BOOL
notifications_preferences__respond_notifications__respond_notif_new_message__desktop BOOL
notifications_preferences__respond_notifications__respond_notif_new_message__email BOOL
notifications_preferences__respond_notifications__respond_notif_new_message__inapp BOOL
notifications_preferences__team_notifications__social_account_token_needs_refresh__email BOOL
notifications_preferences__team_notifications__social_account_token_needs_refresh__inapp BOOL
notifications_preferences__team_notifications__team_notif_user_promoted__email BOOL
notifications_preferences__team_notifications__team_notif_user_promoted__inapp BOOL
notifications_preferences__top_mentions_notifications__default_desktop_notification_frequency STRING
notifications_preferences__top_mentions_notifications__default_email_notification_frequency STRING
notifications_preferences__top_mentions_notifications__grouped_email_notification BOOL
notifications_preferences__unsubscribe_notifications__application_notification_enabled BOOL
notifications_preferences__unsubscribe_notifications__marketing_notification_enabled BOOL
permissions__create_alert BOOL
permissions__read_quotastats BOOL
permissions__read_teammembers BOOL
permissions__read_teamrequests BOOL
registration_country STRING
seen_onboarding FLOAT64
signup_values__industry STRING
signup_values__job_position STRING
subscription__advanced_query_access BOOL
subscription__broadcast_sources_access BOOL
subscription__chart_access BOOL
subscription__collaborative_features_access BOOL
subscription__custom BOOL
subscription__data_export_access BOOL
subscription__facebook_keyword_access BOOL
subscription__feature_discovery__add_alert BOOL
subscription__feature_discovery__add_team BOOL
subscription__feature_discovery__assign_task BOOL
subscription__feature_discovery__check_stats BOOL
subscription__feature_discovery__share_alert BOOL
subscription__feature_discovery__social_account BOOL
subscription__geofiltering_access BOOL
subscription__has_been_manually_blocked BOOL
subscription__has_contract BOOL
subscription__has_failed_renews BOOL
subscription__has_paid_subscription BOOL
subscription__history FLOAT64
subscription__history_access BOOL
subscription__instant_notification_daily_quota FLOAT64
subscription__instant_notification_monthly_quota FLOAT64
subscription__instant_notification_monthly_quota_usage FLOAT64
subscription__is_blocked BOOL
subscription__is_using_wire_payment BOOL
subscription__max_alerts FLOAT64
subscription__max_languages_per_alert FLOAT64
subscription__max_members FLOAT64
subscription__max_reports FLOAT64
subscription__mentions_quota FLOAT64
subscription__mentions_remaining FLOAT64
subscription__permissions__can_manage_account BOOL
subscription__permissions__change_plan BOOL
subscription__permissions__manage BOOL
subscription__permissions__manage_team_members BOOL
subscription__permissions__use_mfa BOOL
subscription__permissions__use_sms_for_mfa BOOL
subscription__permissions__view_price BOOL
subscription__pinterest_crawling_access BOOL
subscription__plan_category STRING
subscription__plan_code STRING
subscription__plan_name STRING
subscription__plan_team BOOL
subscription__publish_access BOOL
subscription__resets_at STRING
subscription__respond_access BOOL
subscription__search_access BOOL
subscription__seen_onboarding FLOAT64
subscription__self_served BOOL
subscription__sentiment_analysis_access BOOL
subscription__statistics_access BOOL
subscription__team_owner BOOL
subscription__tiktok_crawling_access BOOL
subscription__trial_plan BOOL
subscription__whitelabeling BOOL
subscription__will_switch_to_free BOOL
subscription__youtube_crawling_access BOOL
team_has_exceeded_quota_on_accessible_resources BOOL
team_has_reached_quota_on_accessible_resources BOOL
team_id STRING
timezone STRING
trial_search_count FLOAT64
updated_at STRING
validated_mfa BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • account__features (4 columns)
  • account__groups (54 columns)
account_me (129 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
avatar_url STRING
bucket FLOAT64
client_state STRING
company_name STRING
company_size STRING
created_at STRING
email STRING
email_subscriptions__quota_exceeded BOOL
enabled_mfa BOOL
extended_profile_set BOOL
graph_qlid STRING
hide_mark_all_read_mentions BOOL
id STRING
language_code STRING
name STRING
notifications_preferences__alert_notifications__alert_notif_alert_shared_with_you__email BOOL
notifications_preferences__alert_notifications__alert_notif_alert_shared_with_you__inapp BOOL
notifications_preferences__alert_notifications__alert_notif_mention_assigned_to_you__email BOOL
notifications_preferences__alert_notifications__alert_notif_mention_assigned_to_you__inapp BOOL
notifications_preferences__alert_notifications__alert_notif_quota_exceeded__email BOOL
notifications_preferences__alert_notifications__alert_notif_quota_exceeded__inapp BOOL
notifications_preferences__alert_notifications__alert_notif_quota_nearly_exceeded__email BOOL
notifications_preferences__alert_notifications__alert_notif_quota_nearly_exceeded__inapp BOOL
notifications_preferences__publish_notifications__publish_notif_approved_post__email BOOL
notifications_preferences__publish_notifications__publish_notif_approved_post__inapp BOOL
notifications_preferences__publish_notifications__publish_notif_denied_post__email BOOL
notifications_preferences__publish_notifications__publish_notif_denied_post__inapp BOOL
notifications_preferences__publish_notifications__publish_notif_failure__desktop BOOL
notifications_preferences__publish_notifications__publish_notif_failure__email BOOL
notifications_preferences__publish_notifications__publish_notif_failure__inapp BOOL
notifications_preferences__publish_notifications__publish_notif_in_review_post__email BOOL
notifications_preferences__publish_notifications__publish_notif_in_review_post__inapp BOOL
notifications_preferences__publish_notifications__publish_notif_ongoing__desktop BOOL
notifications_preferences__publish_notifications__publish_notif_ongoing__email BOOL
notifications_preferences__publish_notifications__publish_notif_ongoing__inapp BOOL
notifications_preferences__publish_notifications__publish_notif_success__desktop BOOL
notifications_preferences__publish_notifications__publish_notif_success__email BOOL
notifications_preferences__publish_notifications__publish_notif_success__inapp BOOL
notifications_preferences__pulse_notifications__default_trending_email_notification_frequency STRING
notifications_preferences__pulse_notifications__default_trending_sms_notification_frequency STRING
notifications_preferences__respond_notifications__respond_notif_assigned_to_you__desktop BOOL
notifications_preferences__respond_notifications__respond_notif_assigned_to_you__email BOOL
notifications_preferences__respond_notifications__respond_notif_assigned_to_you__inapp BOOL
notifications_preferences__respond_notifications__respond_notif_new_message__desktop BOOL
notifications_preferences__respond_notifications__respond_notif_new_message__email BOOL
notifications_preferences__respond_notifications__respond_notif_new_message__inapp BOOL
notifications_preferences__team_notifications__social_account_token_needs_refresh__email BOOL
notifications_preferences__team_notifications__social_account_token_needs_refresh__inapp BOOL
notifications_preferences__team_notifications__team_notif_user_promoted__email BOOL
notifications_preferences__team_notifications__team_notif_user_promoted__inapp BOOL
notifications_preferences__top_mentions_notifications__default_desktop_notification_frequency STRING
notifications_preferences__top_mentions_notifications__default_email_notification_frequency STRING
notifications_preferences__top_mentions_notifications__grouped_email_notification BOOL
notifications_preferences__unsubscribe_notifications__application_notification_enabled BOOL
notifications_preferences__unsubscribe_notifications__marketing_notification_enabled BOOL
permissions__create_alert BOOL
permissions__read_quotastats BOOL
permissions__read_teammembers BOOL
permissions__read_teamrequests BOOL
registration_country STRING
seen_onboarding FLOAT64
signup_values__industry STRING
signup_values__job_position STRING
subscription__advanced_query_access BOOL
subscription__broadcast_sources_access BOOL
subscription__chart_access BOOL
subscription__collaborative_features_access BOOL
subscription__custom BOOL
subscription__data_export_access BOOL
subscription__facebook_keyword_access BOOL
subscription__feature_discovery__add_alert BOOL
subscription__feature_discovery__add_team BOOL
subscription__feature_discovery__assign_task BOOL
subscription__feature_discovery__check_stats BOOL
subscription__feature_discovery__share_alert BOOL
subscription__feature_discovery__social_account BOOL
subscription__geofiltering_access BOOL
subscription__has_been_manually_blocked BOOL
subscription__has_contract BOOL
subscription__has_failed_renews BOOL
subscription__has_paid_subscription BOOL
subscription__history FLOAT64
subscription__history_access BOOL
subscription__instant_notification_daily_quota FLOAT64
subscription__instant_notification_monthly_quota FLOAT64
subscription__instant_notification_monthly_quota_usage FLOAT64
subscription__is_blocked BOOL
subscription__is_using_wire_payment BOOL
subscription__max_alerts FLOAT64
subscription__max_languages_per_alert FLOAT64
subscription__max_members FLOAT64
subscription__max_reports FLOAT64
subscription__mentions_quota FLOAT64
subscription__mentions_remaining FLOAT64
subscription__permissions__can_manage_account BOOL
subscription__permissions__change_plan BOOL
subscription__permissions__manage BOOL
subscription__permissions__manage_team_members BOOL
subscription__permissions__use_mfa BOOL
subscription__permissions__use_sms_for_mfa BOOL
subscription__permissions__view_price BOOL
subscription__pinterest_crawling_access BOOL
subscription__plan_category STRING
subscription__plan_code STRING
subscription__plan_name STRING
subscription__plan_team BOOL
subscription__publish_access BOOL
subscription__resets_at STRING
subscription__respond_access BOOL
subscription__search_access BOOL
subscription__seen_onboarding FLOAT64
subscription__self_served BOOL
subscription__sentiment_analysis_access BOOL
subscription__statistics_access BOOL
subscription__team_owner BOOL
subscription__tiktok_crawling_access BOOL
subscription__trial_plan BOOL
subscription__whitelabeling BOOL
subscription__will_switch_to_free BOOL
subscription__youtube_crawling_access BOOL
team_has_exceeded_quota_on_accessible_resources BOOL
team_has_reached_quota_on_accessible_resources BOOL
team_id STRING
timezone STRING
trial_search_count FLOAT64
updated_at STRING
validated_mfa BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • account_me__features (4 columns)
  • account_me__groups (54 columns)
alert (56 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
color STRING
connection_type STRING
created_at STRING
display_empty_feed_suggestions BOOL
graph_qlid STRING
group_graph_qlid STRING
group_id STRING
has_a_generated_alert_summary BOOL
hd__enabled BOOL
hd__pending BOOL
hd__progress FLOAT64
id STRING
index_version FLOAT64
last_update STRING
look_for_spread BOOL
name STRING
noise_detection BOOL
paused BOOL
permissions__can_use_linkedin_sources BOOL
permissions__can_use_reviews_sources BOOL
permissions__can_use_twitter_sources BOOL
permissions__create_tag BOOL
permissions__edit BOOL
permissions__edit_mentions BOOL
permissions__export_mentions BOOL
permissions__list_logs BOOL
permissions__list_tasks BOOL
permissions__share BOOL
query__type STRING
quota_used FLOAT64
read_access_secret STRING
role STRING
sentiment_analysis BOOL
slack_configuration__is_configured BOOL
slack_configuration__minimal_influence_score FLOAT64
slack_configuration__new_mentions BOOL
slack_configuration__recurring_recap BOOL
slack_configuration__timezone STRING
stats__done_tasks__total STRING
stats__favorite_mentions__total STRING
stats__logs__total STRING
stats__mention_folders__archive__total STRING
stats__mention_folders__inbox__total STRING
stats__mention_folders__spam__total STRING
stats__mention_folders__trash__total STRING
stats__mention_sources__total STRING
stats__tasks__total STRING
stats__todo_tasks___1302703_y0_kpi_ul_f3hq_za_ce57_e_vhda4_tjo_p9oda_gn_oz_ne_a1a_c4d_pi_n_plu_cwcmn8xh_x8_ja_hd_z STRING
stats__todo_tasks__total STRING
stats__unread_mentions__total STRING
stats__unseen_mentions__total STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • alert__blocked_sites (4 columns)
  • alert__countries (4 columns)
  • alert__languages (4 columns)
  • alert__mentions_sources (4 columns)
  • alert__monitored_facebook_pages (4 columns)
  • alert__monitored_instagram_accounts (4 columns)
  • alert__monitored_linkedin_pages (4 columns)
  • alert__monitored_twitter_accounts (4 columns)
  • alert__query__excluded_keywords (4 columns)
  • alert__query__included_keywords (4 columns)
  • alert__query__required_keywords (4 columns)
  • alert__shares (76 columns)
  • alert__shares__account__features (4 columns)
  • alert__shares__account__groups (54 columns)
  • alert__sources (4 columns)
alert_author (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
alert_id STRING
author_unique_id STRING
country STRING
graph_qlid STRING
id STRING
kind STRING
max_domain_reach FLOAT64
mentions_count FLOAT64
name STRING
picture STRING
realname STRING
score FLOAT64
scored_id STRING
tone___0 FLOAT64
tone___1 FLOAT64
tone___1 FLOAT64
tone__total FLOAT64
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • alert_author__sub_authors (14 columns)
  • alert_author__topics (4 columns)
alert_tag (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
mention_count STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • alert_tag__keywords (4 columns)
alert_tasks (189 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
assigned_by_account__avatar_url STRING
assigned_by_account__bucket FLOAT64
assigned_by_account__company_name STRING
assigned_by_account__company_size STRING
assigned_by_account__created_at STRING
assigned_by_account__email STRING
assigned_by_account__enabled_mfa BOOL
assigned_by_account__graph_qlid STRING
assigned_by_account__hide_mark_all_read_mentions BOOL
assigned_by_account__id STRING
assigned_by_account__language_code STRING
assigned_by_account__name STRING
assigned_by_account__notifications_preferences__alert_notifications__alert_notif_alert_shared_with_you__email BOOL
assigned_by_account__notifications_preferences__alert_notifications__alert_notif_alert_shared_with_you__inapp BOOL
assigned_by_account__notifications_preferences__alert_notifications__alert_notif_mention_assigned_to_you__email BOOL
assigned_by_account__notifications_preferences__alert_notifications__alert_notif_mention_assigned_to_you__inapp BOOL
assigned_by_account__notifications_preferences__alert_notifications__alert_notif_quota_exceeded__email BOOL
assigned_by_account__notifications_preferences__alert_notifications__alert_notif_quota_exceeded__inapp BOOL
assigned_by_account__notifications_preferences__alert_notifications__alert_notif_quota_nearly_exceeded__email BOOL
assigned_by_account__notifications_preferences__alert_notifications__alert_notif_quota_nearly_exceeded__inapp BOOL
assigned_by_account__notifications_preferences__publish_notifications__publish_notif_approved_post__email BOOL
assigned_by_account__notifications_preferences__publish_notifications__publish_notif_approved_post__inapp BOOL
assigned_by_account__notifications_preferences__publish_notifications__publish_notif_denied_post__email BOOL
assigned_by_account__notifications_preferences__publish_notifications__publish_notif_denied_post__inapp BOOL
assigned_by_account__notifications_preferences__publish_notifications__publish_notif_failure__desktop BOOL
assigned_by_account__notifications_preferences__publish_notifications__publish_notif_failure__email BOOL
assigned_by_account__notifications_preferences__publish_notifications__publish_notif_failure__inapp BOOL
assigned_by_account__notifications_preferences__publish_notifications__publish_notif_in_review_post__email BOOL
assigned_by_account__notifications_preferences__publish_notifications__publish_notif_in_review_post__inapp BOOL
assigned_by_account__notifications_preferences__publish_notifications__publish_notif_ongoing__desktop BOOL
assigned_by_account__notifications_preferences__publish_notifications__publish_notif_ongoing__email BOOL
assigned_by_account__notifications_preferences__publish_notifications__publish_notif_ongoing__inapp BOOL
assigned_by_account__notifications_preferences__publish_notifications__publish_notif_success__desktop BOOL
assigned_by_account__notifications_preferences__publish_notifications__publish_notif_success__email BOOL
assigned_by_account__notifications_preferences__publish_notifications__publish_notif_success__inapp BOOL
assigned_by_account__notifications_preferences__pulse_notifications__default_trending_email_notification_frequency STRING
assigned_by_account__notifications_preferences__pulse_notifications__default_trending_sms_notification_frequency STRING
assigned_by_account__notifications_preferences__respond_notifications__respond_notif_assigned_to_you__desktop BOOL
assigned_by_account__notifications_preferences__respond_notifications__respond_notif_assigned_to_you__email BOOL
assigned_by_account__notifications_preferences__respond_notifications__respond_notif_assigned_to_you__inapp BOOL
assigned_by_account__notifications_preferences__respond_notifications__respond_notif_new_message__desktop BOOL
assigned_by_account__notifications_preferences__respond_notifications__respond_notif_new_message__email BOOL
assigned_by_account__notifications_preferences__respond_notifications__respond_notif_new_message__inapp BOOL
assigned_by_account__notifications_preferences__team_notifications__social_account_token_needs_refresh__email BOOL
assigned_by_account__notifications_preferences__team_notifications__social_account_token_needs_refresh__inapp BOOL
assigned_by_account__notifications_preferences__team_notifications__team_notif_user_promoted__email BOOL
assigned_by_account__notifications_preferences__team_notifications__team_notif_user_promoted__inapp BOOL
assigned_by_account__notifications_preferences__top_mentions_notifications__default_desktop_notification_frequency STRING
assigned_by_account__notifications_preferences__top_mentions_notifications__default_email_notification_frequency STRING
assigned_by_account__notifications_preferences__top_mentions_notifications__grouped_email_notification BOOL
assigned_by_account__notifications_preferences__unsubscribe_notifications__application_notification_enabled BOOL
assigned_by_account__notifications_preferences__unsubscribe_notifications__marketing_notification_enabled BOOL
assigned_by_account__permissions__create_alert BOOL
assigned_by_account__permissions__read_quotastats BOOL
assigned_by_account__permissions__read_teammembers BOOL
assigned_by_account__permissions__read_teamrequests BOOL
assigned_by_account__registration_country STRING
assigned_by_account__signup_values__industry STRING
assigned_by_account__signup_values__job_position STRING
assigned_by_account__team_has_exceeded_quota_on_accessible_resources BOOL
assigned_by_account__team_has_reached_quota_on_accessible_resources BOOL
assigned_by_account__team_id STRING
assigned_by_account__timezone STRING
assigned_by_account__trial_search_count FLOAT64
assigned_by_account__updated_at STRING
assigned_by_account__validated_mfa BOOL
assigned_to_account__avatar_url STRING
assigned_to_account__bucket FLOAT64
assigned_to_account__company_name STRING
assigned_to_account__company_size STRING
assigned_to_account__created_at STRING
assigned_to_account__email STRING
assigned_to_account__enabled_mfa BOOL
assigned_to_account__graph_qlid STRING
assigned_to_account__hide_mark_all_read_mentions BOOL
assigned_to_account__id STRING
assigned_to_account__language_code STRING
assigned_to_account__name STRING
assigned_to_account__notifications_preferences__alert_notifications__alert_notif_alert_shared_with_you__email BOOL
assigned_to_account__notifications_preferences__alert_notifications__alert_notif_alert_shared_with_you__inapp BOOL
assigned_to_account__notifications_preferences__alert_notifications__alert_notif_mention_assigned_to_you__email BOOL
assigned_to_account__notifications_preferences__alert_notifications__alert_notif_mention_assigned_to_you__inapp BOOL
assigned_to_account__notifications_preferences__alert_notifications__alert_notif_quota_exceeded__email BOOL
assigned_to_account__notifications_preferences__alert_notifications__alert_notif_quota_exceeded__inapp BOOL
assigned_to_account__notifications_preferences__alert_notifications__alert_notif_quota_nearly_exceeded__email BOOL
assigned_to_account__notifications_preferences__alert_notifications__alert_notif_quota_nearly_exceeded__inapp BOOL
assigned_to_account__notifications_preferences__publish_notifications__publish_notif_approved_post__email BOOL
assigned_to_account__notifications_preferences__publish_notifications__publish_notif_approved_post__inapp BOOL
assigned_to_account__notifications_preferences__publish_notifications__publish_notif_denied_post__email BOOL
assigned_to_account__notifications_preferences__publish_notifications__publish_notif_denied_post__inapp BOOL
assigned_to_account__notifications_preferences__publish_notifications__publish_notif_failure__desktop BOOL
assigned_to_account__notifications_preferences__publish_notifications__publish_notif_failure__email BOOL
assigned_to_account__notifications_preferences__publish_notifications__publish_notif_failure__inapp BOOL
assigned_to_account__notifications_preferences__publish_notifications__publish_notif_in_review_post__email BOOL
assigned_to_account__notifications_preferences__publish_notifications__publish_notif_in_review_post__inapp BOOL
assigned_to_account__notifications_preferences__publish_notifications__publish_notif_ongoing__desktop BOOL
assigned_to_account__notifications_preferences__publish_notifications__publish_notif_ongoing__email BOOL
assigned_to_account__notifications_preferences__publish_notifications__publish_notif_ongoing__inapp BOOL
assigned_to_account__notifications_preferences__publish_notifications__publish_notif_success__desktop BOOL
assigned_to_account__notifications_preferences__publish_notifications__publish_notif_success__email BOOL
assigned_to_account__notifications_preferences__publish_notifications__publish_notif_success__inapp BOOL
assigned_to_account__notifications_preferences__pulse_notifications__default_trending_email_notification_frequency STRING
assigned_to_account__notifications_preferences__pulse_notifications__default_trending_sms_notification_frequency STRING
assigned_to_account__notifications_preferences__respond_notifications__respond_notif_assigned_to_you__desktop BOOL
assigned_to_account__notifications_preferences__respond_notifications__respond_notif_assigned_to_you__email BOOL
assigned_to_account__notifications_preferences__respond_notifications__respond_notif_assigned_to_you__inapp BOOL
assigned_to_account__notifications_preferences__respond_notifications__respond_notif_new_message__desktop BOOL
assigned_to_account__notifications_preferences__respond_notifications__respond_notif_new_message__email BOOL
assigned_to_account__notifications_preferences__respond_notifications__respond_notif_new_message__inapp BOOL
assigned_to_account__notifications_preferences__team_notifications__social_account_token_needs_refresh__email BOOL
assigned_to_account__notifications_preferences__team_notifications__social_account_token_needs_refresh__inapp BOOL
assigned_to_account__notifications_preferences__team_notifications__team_notif_user_promoted__email BOOL
assigned_to_account__notifications_preferences__team_notifications__team_notif_user_promoted__inapp BOOL
assigned_to_account__notifications_preferences__top_mentions_notifications__default_desktop_notification_frequency STRING
assigned_to_account__notifications_preferences__top_mentions_notifications__default_email_notification_frequency STRING
assigned_to_account__notifications_preferences__top_mentions_notifications__grouped_email_notification BOOL
assigned_to_account__notifications_preferences__unsubscribe_notifications__application_notification_enabled BOOL
assigned_to_account__notifications_preferences__unsubscribe_notifications__marketing_notification_enabled BOOL
assigned_to_account__permissions__create_alert BOOL
assigned_to_account__permissions__read_quotastats BOOL
assigned_to_account__permissions__read_teammembers BOOL
assigned_to_account__permissions__read_teamrequests BOOL
assigned_to_account__registration_country STRING
assigned_to_account__signup_values__industry STRING
assigned_to_account__signup_values__job_position STRING
assigned_to_account__team_has_exceeded_quota_on_accessible_resources BOOL
assigned_to_account__team_has_reached_quota_on_accessible_resources BOOL
assigned_to_account__team_id STRING
assigned_to_account__timezone STRING
assigned_to_account__trial_search_count FLOAT64
assigned_to_account__updated_at STRING
assigned_to_account__validated_mfa BOOL
comment STRING
created_at STRING
done BOOL
id STRING
mention__description STRING
mention__alert_id FLOAT64
mention__author_influence__alert_id STRING
mention__author_influence__author_unique_id STRING
mention__author_influence__country STRING
mention__author_influence__graph_qlid STRING
mention__author_influence__id STRING
mention__author_influence__kind STRING
mention__author_influence__name STRING
mention__author_influence__picture STRING
mention__author_influence__realname STRING
mention__author_influence__score FLOAT64
mention__author_influence__scored_id STRING
mention__author_influence__url STRING
mention__children__total FLOAT64
mention__clickable_url STRING
mention__country STRING
mention__created_at STRING
mention__description_medium STRING
mention__description_short STRING
mention__display_site BOOL
mention__displayable_url STRING
mention__domain_reach FLOAT64
mention__favorite BOOL
mention__folder STRING
mention__folder_set_by_user BOOL
mention__graph_qlid STRING
mention__id STRING
mention__language_code STRING
mention__original_url STRING
mention__permissions__change_folder BOOL
mention__permissions__create_task BOOL
mention__permissions__edit BOOL
mention__permissions__favorite BOOL
mention__permissions__share_email BOOL
mention__permissions__share_facebook BOOL
mention__published_at STRING
mention__read BOOL
mention__relevance_score FLOAT64
mention__source_name STRING
mention__source_type STRING
mention__source_url STRING
mention__title STRING
mention__tone FLOAT64
mention__tone_score FLOAT64
mention__unique_id STRING
mention__updated_at STRING
permissions__delete BOOL
permissions__mark_done BOOL
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • alert_tasks__assigned_by_account__features (4 columns)
  • alert_tasks__assigned_by_account__groups (54 columns)
  • alert_tasks__assigned_to_account__features (4 columns)
  • alert_tasks__assigned_to_account__groups (54 columns)
  • alert_tasks__mention__author_influence__topics (4 columns)
  • alert_tasks__mention__children__children (4 columns)
  • alert_tasks__mention__emotions (4 columns)
  • alert_tasks__mention__logs (4 columns)
  • alert_tasks__mention__offsets__description (4 columns)
  • alert_tasks__mention__offsets__description_medium (4 columns)
  • alert_tasks__mention__offsets__description_short (4 columns)
  • alert_tasks__mention__offsets__source_name (4 columns)
  • alert_tasks__mention__offsets__source_url (4 columns)
  • alert_tasks__mention__offsets__title (4 columns)
  • alert_tasks__mention__offsets__url (4 columns)
  • alert_tasks__mention__tags (4 columns)
  • alert_tasks__mention__tasks (143 columns)
  • alert_tasks__mention__tasks__assigned_by_account__features (4 columns)
  • alert_tasks__mention__tasks__assigned_by_account__groups (54 columns)
  • alert_tasks__mention__tasks__assigned_to_account__features (4 columns)
  • alert_tasks__mention__tasks__assigned_to_account__groups (54 columns)
mention (56 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_c STRING
alert_id FLOAT64
author_influence__alert_id STRING
author_influence__author_unique_id STRING
author_influence__country STRING
author_influence__graph_qlid STRING
author_influence__id STRING
author_influence__kind STRING
author_influence__name STRING
author_influence__picture STRING
author_influence__realname STRING
author_influence__score FLOAT64
author_influence__scored_id STRING
author_influence__url STRING
children___links__more__href STRING
children___links__more__params__before_date STRING
children___links__more__params__limit FLOAT64
children__total FLOAT64
clickable_url STRING
country STRING
created_at STRING
cumulative_reach FLOAT64
description_medium STRING
description_short STRING
direct_reach FLOAT64
display_site BOOL
displayable_url STRING
domain_reach FLOAT64
favorite BOOL
folder STRING
folder_set_by_user BOOL
graph_qlid STRING
id STRING
language_code STRING
original_url STRING
permissions__change_folder BOOL
permissions__create_task BOOL
permissions__edit BOOL
permissions__favorite BOOL
permissions__share_email BOOL
permissions__share_facebook BOOL
picture_url STRING
published_at STRING
read BOOL
relevance_score FLOAT64
source_name STRING
source_type STRING
source_url STRING
title STRING
tone FLOAT64
tone_score FLOAT64
unique_id STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • mention__author_influence__topics (4 columns)
  • mention__children__children (55 columns)
  • mention__children__children__author_influence__topics (4 columns)
  • mention__children__children__children__children (4 columns)
  • mention__children__children__emotions (4 columns)
  • mention__children__children__logs (4 columns)
  • mention__children__children__offsets__description (4 columns)
  • mention__children__children__offsets__description_medium (4 columns)
  • mention__children__children__offsets__description_short (4 columns)
  • mention__children__children__offsets__source_name (4 columns)
  • mention__children__children__offsets__source_url (4 columns)
  • mention__children__children__offsets__title (4 columns)
  • mention__children__children__offsets__url (4 columns)
  • mention__children__children__tags (4 columns)
  • mention__children__children__tasks (4 columns)
  • mention__emotions (4 columns)
  • mention__logs (4 columns)
  • mention__offsets__description (4 columns)
  • mention__offsets__description_medium (4 columns)
  • mention__offsets__description_short (4 columns)
  • mention__offsets__source_name (4 columns)
  • mention__offsets__source_url (4 columns)
  • mention__offsets__title (4 columns)
  • mention__offsets__url (4 columns)
  • mention__tags (6 columns)
  • mention__tags__keywords (4 columns)
  • mention__tasks (143 columns)
  • mention__tasks__assigned_by_account__features (4 columns)
  • mention__tasks__assigned_by_account__groups (54 columns)
  • mention__tasks__assigned_to_account__features (4 columns)
  • mention__tasks__assigned_to_account__groups (54 columns)
mention_children (50 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
alert_id FLOAT64
author_influence__alert_id STRING
author_influence__author_unique_id STRING
author_influence__country STRING
author_influence__graph_qlid STRING
author_influence__id STRING
author_influence__kind STRING
author_influence__name STRING
author_influence__picture STRING
author_influence__realname STRING
author_influence__score FLOAT64
author_influence__scored_id STRING
author_influence__url STRING
children__total FLOAT64
clickable_url STRING
country STRING
created_at STRING
description_medium STRING
description_short STRING
display_site BOOL
displayable_url STRING
domain_reach FLOAT64
favorite BOOL
folder STRING
folder_set_by_user BOOL
graph_qlid STRING
id STRING
language_code STRING
original_url STRING
parent_id FLOAT64
permissions__change_folder BOOL
permissions__create_task BOOL
permissions__edit BOOL
permissions__favorite BOOL
permissions__share_email BOOL
permissions__share_facebook BOOL
published_at STRING
read BOOL
relevance_score FLOAT64
source_name STRING
source_type STRING
source_url STRING
title STRING
tone FLOAT64
tone_score FLOAT64
unique_id STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • mention_children__author_influence__topics (4 columns)
  • mention_children__children__children (4 columns)
  • mention_children__emotions (4 columns)
  • mention_children__logs (4 columns)
  • mention_children__offsets__description (4 columns)
  • mention_children__offsets__description_medium (4 columns)
  • mention_children__offsets__description_short (4 columns)
  • mention_children__offsets__source_name (4 columns)
  • mention_children__offsets__source_url (4 columns)
  • mention_children__offsets__title (4 columns)
  • mention_children__offsets__url (4 columns)
  • mention_children__tags (4 columns)
  • mention_children__tasks (4 columns)
mention_tasks (52 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
alert_id FLOAT64
author_influence__alert_id STRING
author_influence__author_unique_id STRING
author_influence__country STRING
author_influence__graph_qlid STRING
author_influence__id STRING
author_influence__kind STRING
author_influence__name STRING
author_influence__picture STRING
author_influence__realname STRING
author_influence__score FLOAT64
author_influence__scored_id STRING
author_influence__url STRING
children___links__more__href STRING
children___links__more__params__before_date STRING
children___links__more__params__limit FLOAT64
children__total FLOAT64
clickable_url STRING
country STRING
created_at STRING
description_medium STRING
description_short STRING
display_site BOOL
displayable_url STRING
domain_reach FLOAT64
favorite BOOL
folder STRING
folder_set_by_user BOOL
graph_qlid STRING
id STRING
language_code STRING
original_url STRING
permissions__change_folder BOOL
permissions__create_task BOOL
permissions__edit BOOL
permissions__favorite BOOL
permissions__share_email BOOL
permissions__share_facebook BOOL
published_at STRING
read BOOL
relevance_score FLOAT64
source_name STRING
source_type STRING
source_url STRING
title STRING
tone FLOAT64
tone_score FLOAT64
unique_id STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • mention_tasks__author_influence__topics (4 columns)
  • mention_tasks__children__children (51 columns)
  • mention_tasks__children__children__author_influence__topics (4 columns)
  • mention_tasks__children__children__children__children (4 columns)
  • mention_tasks__children__children__emotions (4 columns)
  • mention_tasks__children__children__logs (4 columns)
  • mention_tasks__children__children__offsets__description (4 columns)
  • mention_tasks__children__children__offsets__description_medium (4 columns)
  • mention_tasks__children__children__offsets__description_short (4 columns)
  • mention_tasks__children__children__offsets__source_name (4 columns)
  • mention_tasks__children__children__offsets__source_url (4 columns)
  • mention_tasks__children__children__offsets__title (4 columns)
  • mention_tasks__children__children__offsets__url (4 columns)
  • mention_tasks__children__children__tags (4 columns)
  • mention_tasks__children__children__tasks (4 columns)
  • mention_tasks__emotions (4 columns)
  • mention_tasks__logs (4 columns)
  • mention_tasks__offsets__description (4 columns)
  • mention_tasks__offsets__description_medium (4 columns)
  • mention_tasks__offsets__description_short (4 columns)
  • mention_tasks__offsets__source_name (4 columns)
  • mention_tasks__offsets__source_url (4 columns)
  • mention_tasks__offsets__title (4 columns)
  • mention_tasks__offsets__url (4 columns)
  • mention_tasks__tags (4 columns)
  • mention_tasks__tasks (4 columns)
statistics (72 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
from STRING
stats___2624127__alert_id FLOAT64
stats___2624127__languages_total__data__en FLOAT64
stats___2624127__languages_total__total FLOAT64
stats___2624127__mentions_per_interval__avg FLOAT64
stats___2624127__mentions_per_interval__data___2024_10_10 FLOAT64
stats___2624127__mentions_per_interval__data___2024_10_11 FLOAT64
stats___2624127__mentions_per_interval__data___2024_10_12 FLOAT64
stats___2624127__mentions_per_interval__data___2024_10_13 FLOAT64
stats___2624127__mentions_per_interval__data___2024_10_14 FLOAT64
stats___2624127__mentions_per_interval__data___2024_10_15 FLOAT64
stats___2624127__mentions_per_interval__data___2024_10_16 FLOAT64
stats___2624127__mentions_per_interval__data___2024_10_17 FLOAT64
stats___2624127__mentions_per_interval__data___2024_10_18 FLOAT64
stats___2624127__mentions_per_interval__data___2024_10_19 FLOAT64
stats___2624127__mentions_per_interval__data___2024_10_20 FLOAT64
stats___2624127__mentions_per_interval__data___2024_10_21 FLOAT64
stats___2624127__mentions_per_interval__data___2024_10_22 FLOAT64
stats___2624127__mentions_per_interval__data___2024_10_23 FLOAT64
stats___2624127__mentions_per_interval__max FLOAT64
stats___2624127__mentions_per_interval__min FLOAT64
stats___2624127__mentions_per_interval__total FLOAT64
stats___2624127__sources_total__data__blogs FLOAT64
stats___2624127__sources_total__data__facebook_keyword FLOAT64
stats___2624127__sources_total__data__forums FLOAT64
stats___2624127__sources_total__data__instagram FLOAT64
stats___2624127__sources_total__data__news FLOAT64
stats___2624127__sources_total__data__reddit FLOAT64
stats___2624127__sources_total__data__videos FLOAT64
stats___2624127__sources_total__data__web FLOAT64
stats___2624127__sources_total__total FLOAT64
stats___2624127__tones_total__data___0 FLOAT64
stats___2624127__tones_total__data___1 FLOAT64
stats___2624127__tones_total__data___1 FLOAT64
stats___2624127__tones_total__total FLOAT64
stats___2625268__alert_id FLOAT64
stats___2625268__languages_total__data__en FLOAT64
stats___2625268__languages_total__total FLOAT64
stats___2625268__mentions_per_interval__avg FLOAT64
stats___2625268__mentions_per_interval__data___2024_10_10 FLOAT64
stats___2625268__mentions_per_interval__data___2024_10_11 FLOAT64
stats___2625268__mentions_per_interval__data___2024_10_12 FLOAT64
stats___2625268__mentions_per_interval__data___2024_10_13 FLOAT64
stats___2625268__mentions_per_interval__data___2024_10_14 FLOAT64
stats___2625268__mentions_per_interval__data___2024_10_15 FLOAT64
stats___2625268__mentions_per_interval__data___2024_10_16 FLOAT64
stats___2625268__mentions_per_interval__data___2024_10_17 FLOAT64
stats___2625268__mentions_per_interval__data___2024_10_18 FLOAT64
stats___2625268__mentions_per_interval__data___2024_10_19 FLOAT64
stats___2625268__mentions_per_interval__data___2024_10_20 FLOAT64
stats___2625268__mentions_per_interval__data___2024_10_21 FLOAT64
stats___2625268__mentions_per_interval__data___2024_10_22 FLOAT64
stats___2625268__mentions_per_interval__data___2024_10_23 FLOAT64
stats___2625268__mentions_per_interval__max FLOAT64
stats___2625268__mentions_per_interval__min FLOAT64
stats___2625268__mentions_per_interval__total FLOAT64
stats___2625268__sources_total__data__blogs FLOAT64
stats___2625268__sources_total__data__facebook_keyword FLOAT64
stats___2625268__sources_total__data__forums FLOAT64
stats___2625268__sources_total__data__instagram FLOAT64
stats___2625268__sources_total__data__news FLOAT64
stats___2625268__sources_total__data__reddit FLOAT64
stats___2625268__sources_total__data__videos FLOAT64
stats___2625268__sources_total__data__web FLOAT64
stats___2625268__sources_total__total FLOAT64
stats___2625268__tones_total__data___0 FLOAT64
stats___2625268__tones_total__data___1 FLOAT64
stats___2625268__tones_total__data___1 FLOAT64
stats___2625268__tones_total__total FLOAT64
to STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • statistics__stats___2624127__incomplete_datapoints (4 columns)
  • statistics__stats___2625268__incomplete_datapoints (4 columns)

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Mention 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 Mention?

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

It depends on how much history is in your Mention 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 Mention’s schema changes?

Section titled “What happens when Mention’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 Mention, 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 Mention 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 Mention connector in Kaivo and all of its synced data is deleted with it.

Use mention and statistics to track how often your brand is mentioned over time.

Join alert with mention to see which topics drive coverage.

Analyse mentions to understand sentiment and themes in coverage.

Once Mention 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 Mention 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 Mention connector pricing and plan details.