Marfeel 2022 Raw Data Exports

Implementation Guides Data Exports
1

Data model columns

Name Data type Description
user_id String unique user id generated by Marfeel

Example: 61cadeab-5671-42a0-a677-7806fd3dfa3c
registered_user_id string Provided user_id via setSiteUserId() sdk method
user_status integer Id of the stage of user in the User Journey.

Example:
· 0,1: Anonymous
· 2: Registered
· 3: Subscriber
· 4: Custom statuses
rfv integer RFV multiplied by 100. See docs for more information.
has_consent boolean true if the user gave consent.
session_id string Unique session id
page_id string Unique page id
site_id integer Marfeel account Id
editorial_id integer unique id identifying the article
editorial_title string title of the article
editorial_publish_time timestamp Editorial publish date as specified on its structure data.

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

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

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

Example: [‘Author 1’, ‘Author 2’]
entities_array string NLP extracted entities
tags_array string Array of tags.

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

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

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

Example: 2022-06-10
event_local_time timestamp Same value of end_time in the local timezone of the account.
ip_v4 string IP of the user. When has_consent = 0 the last octet of the IP is replaced with XXX.
Example: 172.58.129.xxx
ip_v6 string
user_country string Country of the user in ISO Alpha-2 code.

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

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

Example: Barcelona, Sydney, Franca
operating_system string

Example: Android, Windows, Macintosh, iPhone, iPad, Linux
user_agent string Complete user-agent of the request.
full_url string Complete url of the request.
canonical_url string Canonical url as identified by <link rel="canonical" href="">
referrer string Referrer of the request.

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

Example:
· Chrome
· Safari
· AppleWebKit
browser_version string Version of the browser.

Example: 100.0.4896.127
device_category integer Possible values:
· 0: Desktop
. 1: Mobile
· 2: Tablet
url_params string Query string of the request
search_phrase string
client_event_time timestamp
utm_source string
utm_medium string
utm_campaign string
utm_content string
utm_term string
duration integer Number of seconds the user has been on the page. end_time - start_time.
scroll integer Percent of page scroll
dns_timing integer
connect_timing integer
response_start_timing integer
fetch_timing integer
dom_interactive_timing integer
dom_content_loaded_timing integer
dom_complete_timing integer
fcp_timing integer
PageVars string

Example: {“key”:“value”, “key2”:“value2”}
SessionVars string

Example: {“key”:“value”, “key2”:“value2”}
UserVars string

Example: {“key”:“value”, “key2”:“value2”}
has_web_vitals boolean
lcp integer
fid integer
cls integer
recirculation_source string

Example File

user_id registered_user_id user_status rfv has_consent session_id page_id site_id editorial_id editorial_title editorial_publish_time editorial_update_time sections_array authors_array entities_array tags_array page_type start_time end_time event_date event_local_time ip_v4 ip_v6 user_country user_region user_city operating_system user_agent full_url canonical_url referrer browser browser_version device_category url_params search_phrase client_event_time utm_source utm_medium utm_campaign utm_content utm_term duration scroll dns_timing connect_timing response_start_timing fetch_timing dom_interactive_timing dom_content_loaded_timing dom_complete_timing fcp_timing PageVars SessionVars UserVars has_web_vitals lcp fid cls recirculation_source r f v engagement_time
254771a0-ec64-5242-9963-22b6c7ae12761 0 1816 1 02d772bc-a005-451f-a4e4-91c31b61c2e8 088fe7a6-a099-4627-b316-859bbeabfcc2 12 112247170519 Title of the page 2025-09-30T06:37:37 2025-09-30T11:10:19 [“Politics”] [“author”] [“entity1”, “entity2”, “entity3”] [“keyword:key1”,“keyword:key2”, “tagGroup:option”] 0 2025-09-30T23:59:49 2025-10-01T00:00 2025-10-01 2025-10-01T02:00 1.2.3.4 :: CL Santiago Metropolitan San Bernardo Android Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Mobile Safari/537.36 Salesforce Platform for Application Development | Salesforce Salesforce Platform for Application Development | Salesforce referrer.com Chrome 140.0.0.0 1 2025-09-30T23:59:59 aspa (not set) 11 15 0 0 76 85 931 1064 0 988 {“pagevar1”:“value”,“pagevar2”:“value”} {} {“key”:“712fd504-2c16”, “key2”:“value2”} 1 988 0 27 1 3 6 9
1 Like