Meltwater fields

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Meltwater data into BigQuery, Snowflake, Redshift, Azure

9 metrics59 dimensions

AUTHOR

author_name
Field label Author name
Description The name or social handle of the author
Field type dimension
Data type string.text.value
author_type
Field label Author type
Description The information type of the author
Field type dimension
Data type string.text.value
author_external_id
Field label Author external ID
Description The external ID for the author of the document
Field type dimension
Data type string.text.value
author_profile_url
Field label Author profile URL
Description The URL for the author's profile
Field type dimension
Data type string.text.url

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

DOCUMENT

title
Field label Document title
Description The title of the document
Field type dimension
Data type string.text.value
document_id
Field label Document ID
Description The ID of the document
Field type dimension
Data type string.text.value
opening_text
Field label Opening text
Description The opening text of the document
Field type dimension
Data type string.text.value
hit_sentence
Field label Hit sentence
Description The sentence which matched the query
Field type dimension
Data type string.text.value
media_type
Field label Media type
Description The media type of the document
Field type dimension
Data type string.text.value
matched_keywords
Field label Matched keywords
Description The document keywords that matched the query
Field type dimension
Data type string.text.value
publish_date
Field label Publish date
Description The date when the document was published
Field type dimension
Data type string.time.date
publish_datetime
Field label Publish datetime
Description The datetime when the document was published
Field type dimension
Data type string.time.datetime
document_url
Field label Document URL
Description The URL for the document
Field type dimension
Data type string.text.url
external_id
Field label External ID
Description The external ID for the document
Field type dimension
Data type string.text.value
tags
Field label Tags
Description The tags given to the document
Field type dimension
Data type string.text.value
hidden
Field label Hidden
Description Whether or not the document has been marked as hidden in the app
Field type dimension
Data type bool
visibility
Field label Visibility
Description Whether the document is public or private to the customer
Field type dimension
Data type string.text.value

ENRICHMENTS

sentiment
Field label Sentiment
Description The sentiment of the document
Field type dimension
Data type string.text.value
key_phrases
Field label Key Phrases
Description The key phrases extracted from the document's content
Field type dimension
Data type string.text.value
language_code
Field label Language
Description The language of the document's content
Field type dimension
Data type string.language.twolettercode
hashtags
Field label Hashtags
Description The hashtags extracted from the document's content
Field type dimension
Data type string.text.value

LOCATION

country
Field label Country
Description The country of the author/source
Field type dimension
Data type string.geo.country.twolettercode
state
Field label State
Description The state of the author/source
Field type dimension
Data type string.geo.region
sub_region
Field label Sub-region
Description The sub-region of the author/source
Field type dimension
Data type string.geo.region
city
Field label City
Description The city of the author/source
Field type dimension
Data type string.geo.city

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

REACH & ENGAGEMENT

total_mentions
Field label Total mentions
Description Total number of mentions
Field type metric
Data type int.number.value
total_reach
Field label Total reach
Description Total monthly visitors to the source, or social followers
Field type metric
Data type int.number.value
reach_desktop
Field label Reach (desktop)
Description Monthly unique desktop visitors to the source
Field type metric
Data type int.number.value
reach_mobile
Field label Reach (mobile)
Description Monthly unique mobile visitors to the source
Field type metric
Data type int.number.value
twitter_social_echo
Field label Twitter social echo
Description The social echo of the document on Twitter
Field type metric
Data type int.number.value
facebook_social_echo
Field label Facebook social echo
Description The social echo of the document on Facebook
Field type metric
Data type int.number.value
reddit_social_echo
Field label Reddit social echo
Description The social echo of the document on Reddit
Field type metric
Data type int.number.value
source_ave
Field label AVE
Description Advertising value equivalency, value assigned to the source
Field type metric
Data type float.currency.value
engagement
Field label Engagement
Description Indicates the level of engagement for this source
Field type metric
Data type int.number.value

SEARCH

search_name
Field label Search name
Description The name of the search used for export
Field type dimension
Data type string.text.value
search_id
Field label Search ID
Description The ID of the search used for export
Field type dimension
Data type string.text.value
tag_name
Field label Tag name
Description The name of the tag used for export
Field type dimension
Data type string.text.value
company_id
Field label Company ID
Description The ID of the company/customer who ran the export
Field type dimension
Data type string.text.value

SOURCE

source_name
Field label Source name
Description The name of the source
Field type dimension
Data type string.text.value
source_type
Field label Source type
Description The information type of the source
Field type dimension
Data type string.text.value
source_id
Field label Source ID
Description The ID of the source
Field type dimension
Data type string.text.value

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Field type dimension
Data type string.time.year
year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Field type dimension
Data type string.time.date
atom
Field label Datetime
Field type dimension
Data type string.time.datetime