Meltwater data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Table: EXPORT_MEDIA

atom
Display name Datetime
Field type dimension
Data type string.time.datetime
author_external_id
Display name Author external ID
Description The external ID for the author of the document
Field type dimension
Data type string.text.value
author_name
Display name Author name
Description The name or social handle of the author
Field type dimension
Data type string.text.value
author_profile_url
Display name Author profile URL
Description The URL for the author's profile
Field type dimension
Data type string.text.url
author_type
Display name Author type
Description The information type of the author
Field type dimension
Data type string.text.value
city
Display name City
Description The city of the author/source
Field type dimension
Data type string.geo.city
company_id
Display name Company ID
Description The ID of the company/customer who ran the export
Field type dimension
Data type string.text.value
country
Display name Country
Description The country of the author/source
Field type dimension
Data type string.geo.country.twolettercode
dataSourceName
Display name 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
date
Display name Date
Field type dimension
Data type string.time.date
document_id
Display name Document ID
Description The ID of the document
Field type dimension
Data type string.text.value
document_url
Display name Document URL
Description The URL for the document
Field type dimension
Data type string.text.url
engagement
Display name Engagement
Description Indicates the level of engagement for this source
Field type metric
Data type int.number.value
external_id
Display name External ID
Description The external ID for the document
Field type dimension
Data type string.text.value
facebook_social_echo
Display name Facebook social echo
Description The social echo of the document on Facebook
Field type metric
Data type int.number.value
hashtags
Display name Hashtags
Description The hashtags extracted from the document's content
Field type dimension
Data type string.text.value
hidden
Display name Hidden
Description Whether or not the document has been marked as hidden in the app
Field type dimension
Data type bool
hit_sentence
Display name Hit sentence
Description The sentence which matched the query
Field type dimension
Data type string.text.value
key_phrases
Display name Key Phrases
Description The key phrases extracted from the document's content
Field type dimension
Data type string.text.value
language_code
Display name Language
Description The language of the document's content
Field type dimension
Data type string.language.twolettercode
matched_keywords
Display name Matched keywords
Description The document keywords that matched the query
Field type dimension
Data type string.text.value
media_type
Display name Media type
Description The media type of the document
Field type dimension
Data type string.text.value
opening_text
Display name Opening text
Description The opening text of the document
Field type dimension
Data type string.text.value
reddit_social_echo
Display name Reddit social echo
Description The social echo of the document on Reddit
Field type metric
Data type int.number.value
search_id
Display name Search ID
Description The ID of the search used for export
Field type dimension
Data type string.text.value
search_name
Display name Search name
Description The name of the search used for export
Field type dimension
Data type string.text.value
sentiment
Display name Sentiment
Description The sentiment of the document
Field type dimension
Data type string.text.value
source_ave
Display name AVE
Description Advertising value equivalency, value assigned to the source
Field type metric
Data type float.currency.value
source_id
Display name Source ID
Description The ID of the source
Field type dimension
Data type string.text.value
source_name
Display name Source name
Description The name of the source
Field type dimension
Data type string.text.value
source_type
Display name Source type
Description The information type of the source
Field type dimension
Data type string.text.value
state
Display name State
Description The state of the author/source
Field type dimension
Data type string.geo.region
sub_region
Display name Sub-region
Description The sub-region of the author/source
Field type dimension
Data type string.geo.region
tag_name
Display name Tag name
Description The name of the tag used for export
Field type dimension
Data type string.text.value
tags
Display name Tags
Description The tags given to the document
Field type dimension
Data type string.text.value
title
Display name Document title
Description The title of the document
Field type dimension
Data type string.text.value
total_mentions
Display name Total mentions
Description Total number of mentions
Field type metric
Data type int.number.value
twitter_social_echo
Display name Twitter social echo
Description The social echo of the document on Twitter
Field type metric
Data type int.number.value
visibility
Display name Visibility
Description Whether the document is public or private to the customer
Field type dimension
Data type string.text.value