Skip to content
Login Contact

Marfeel 2022 raw data exports format and columns

Data model columns

Section titled “Data model columns”
NameData typeDescription
user_idStringunique user id generated by Marfeel

Example: 61cadeab-5671-42a0-a677-7806fd3dfa3c
registered_user_idstringProvided user_id via setSiteUserId() sdk method
user_statusintegerId of the stage of user in the User Journey.

Example:
· 0,1: Anonymous
· 2: Registered
· 3: Subscriber
· 4: Custom statuses
rfvintegerRFV multiplied by 100. See docs for more information.
has_consentbooleantrue if the user gave consent.
session_idstringUnique session id
page_idstringUnique page id
site_idintegerMarfeel account Id
editorial_idintegerunique id identifying the article
editorial_titlestringtitle of the article
editorial_publish_timetimestampEditorial publish date as specified on its structure data.

Example: 2022-06-08 16:49:48
editorial_update_timetimestampEditorial last update date as specified on its structure data.

Example: 2022-06-10 09:25:47
sections_arraystringSections detected on the structure data or mrf:sections.

Example: [‘International’, ‘Politics’]
authors_arraystringAuthors detected on the structure data or mrf:authors.

Example: [‘Author 1’, ‘Author 2’]
entities_arraystringNLP extracted entities
tags_arraystringArray of tags.

Example: [‘Tag1’,‘Tag2’]
page_typeintegerPage technology. Possible values:
· 0: Web
· 1: AMP
· 2: FBIA
· 3: iOS App
· 4: Android app
· 5: Flowcard
· 7: App
start_timetimestampTimestamp in UTC of the first hit.

Example: 2022-06-10 10:05:37
end_timetimestampTimestamp in UTC of the last hit on a page. i.e: last scroll event.

Example: 2022-06-10 10:05:43
event_datedateSimple date of the event. Useful for data partitioning.

Example: 2022-06-10
event_local_timetimestampSame value of end_time in the local timezone of the account.
ip_v4stringIP of the user. When has_consent = 0 the last octet of the IP is replaced with XXX.
Example: 172.58.129.xxx
ip_v6string
user_countrystringCountry of the user in ISO Alpha-2 code.

Example: US, UK, ES, CO, AR, US, etc
user_regionstringUser regions as provided by GeoIP2 City database.

Example: Catalonia, New South Wales, Sao Paulo
user_citystringUser city as provided by GeoIP2 City database.

Example: Barcelona, Sydney, Franca
operating_systemstring

Example: Android, Windows, Macintosh, iPhone, iPad, Linux
user_agentstringComplete user-agent of the request.
full_urlstringComplete url of the request.
canonical_urlstringCanonical url as identified by <link rel="canonical" href="">
referrerstringReferrer of the request.

Example:
· https://www.google.com/
· android-app://com.google.android.googlequicksearchbox/
· https://lm.facebook.com/
browserstringName of the browser.

Example:
· Chrome
· Safari
· AppleWebKit
browser_versionstringVersion of the browser.

Example: 100.0.4896.127
device_categoryintegerPossible values:
· 0: Desktop
. 1: Mobile
· 2: Tablet
url_paramsstringQuery string of the request
search_phrasestring
client_event_timetimestamp
utm_sourcestring
utm_mediumstring
utm_campaignstring
utm_contentstring
utm_termstring
durationintegerNumber of seconds the user has been on the page. end_time - start_time.
scrollintegerPercent of page scroll
dns_timinginteger
connect_timinginteger
response_start_timinginteger
fetch_timinginteger
dom_interactive_timinginteger
dom_content_loaded_timinginteger
dom_complete_timinginteger
fcp_timinginteger
PageVarsstring

Example: {“key”:“value”, “key2”:“value2”}
SessionVarsstring

Example: {“key”:“value”, “key2”:“value2”}
UserVarsstring

Example: {“key”:“value”, “key2”:“value2”}
has_web_vitalsboolean
lcpinteger
fidinteger
clsinteger
recirculation_sourcestring

Example File

Section titled “Example File”
user_idregistered_user_iduser_statusrfvhas_consentsession_idpage_idsite_ideditorial_ideditorial_titleeditorial_publish_timeeditorial_update_timesections_arrayauthors_arrayentities_arraytags_arraypage_typestart_timeend_timeevent_dateevent_local_timeip_v4ip_v6user_countryuser_regionuser_cityoperating_systemuser_agentfull_urlcanonical_urlreferrerbrowserbrowser_versiondevice_categoryurl_paramssearch_phraseclient_event_timeutm_sourceutm_mediumutm_campaignutm_contentutm_termdurationscrolldns_timingconnect_timingresponse_start_timingfetch_timingdom_interactive_timingdom_content_loaded_timingdom_complete_timingfcp_timingPageVarsSessionVarsUserVarshas_web_vitalslcpfidclsrecirculation_sourcerfvengagement_time
254771a0-ec64-5242-9963-22b6c7ae1276101816102d772bc-a005-451f-a4e4-91c31b61c2e8088fe7a6-a099-4627-b316-859bbeabfcc212112247170519Title of the page2025-09-30T06:37:372025-09-30T11:10:19[“Politics”][“author”][“entity1”, “entity2”, “entity3”][“keyword:key1”,“keyword:key2”, “tagGroup:option”]02025-09-30T23:59:492025-10-01T00:002025-10-012025-10-01T02:001.2.3.4::CLSantiago MetropolitanSan BernardoAndroidMozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Mobile Safari/537.36https://www.site.com/path/to/articlehttps://www.site.com/path/to/articlehttps://www.referrer.com/pathChrome140.0.0.012025-09-30T23:59:59aspa(not set)111500768593110640988{“pagevar1”:“value”,“pagevar2”:“value”}{}{“key”:“712fd504-2c16”, “key2”:“value2”}19880271369