Conversion Raw Data Exports

Implementation Guides Data Exports
1

Data model columns

Name Data type Description
registered_user_id String Provided user_id via setSiteUserId() sdk method
user_id String unique user id generated by Marfeel

Example: 61cadeab-5671-42a0-a677-7806fd3dfa3c
user_status Integer Id of the stage of user in the User Journey.

Example:
· 0,1: Anonymous
· 2: Registered
· 3: Subscriber
· 4: Custom statuses
session_id String Unique session id
page_id String Unique page id
site_id Integer Marfeel account Id
canonical_url String Canonical url as identified by <link rel="canonical" href="">
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’]
editorial_id Integer Unique id identifying the article
ref_editorial_id Integer Unique id identifying the referring article
event_time Timestamp Timestamp in UTC of the conversion.

Example: 2022-06-10 10:05:43
event_local_time Timestamp Same value of event_time in the local timezone of the account
user_country String Country of the user in ISO Alpha-2 code.

Example: US, ES, CO, AR, FR, 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, New York City
utm_source String
utm_medium String
utm_campaign String
utm_content String
utm_term String
conversion_name String Name of the conversion
conversion_initiator String Initiator of the conversion
rfm Integer RFM multiplied by 100
PageVars String Example: {“key”:“value”, “key2”:“value2”}
SessionVars String Example: {“key”:“value”, “key2”:“value2”}
UserVars String Example: {“key”:“value”, “key2”:“value2”}
ConversionVars String Example: {“key”:“value”, “key2”:“value2”}
conversion_id String Optional identifier of the conversion
conversion_value Integer Optional value of the conversion.

Example: 125

Example File

“registered_user_id” “user_id” “user_status” “session_id” “page_id” “site_id” “canonical_url” “editorial_title” “editorial_publish_time” “editorial_update_time” “sections_array” “authors_array” “entities_array” “tags_array” “editorial_id” “ref_editorial_id” “event_time” “event_local_time” “user_country” “user_region” “user_city” “utm_source” “utm_medium” “utm_campaign” “utm_content” “utm_term” “conversion_name” “conversion_initiator” “rfm” “PageVars” “SessionVars” “UserVars” “ConversionVars” “conversion_id” “conversion_value”
“9d921207-00a3-484b-9b85-223610d7f31d” “5c2ef5f4-211a-45e8-9f54-df3721e59b2d” “3” “904c8431-bba3-41c7-93db-e1323fd5a0cf” “8602eb0b-c19c-44d8-be03-cd92a74e76f8” “1435” “https://www.example.com/news1.html” "Barcelona 5 - 0 Athletic Club Resultado, goles, declaraciones y la última hora, en directo" “2026-01-07T17:25” “2026-01-07T21:46:05” “[”“Fútbol”“]” “[”“Alex Rodriguez Sanchez”“]” “[”“Fútbol Club Barcelona”“,”“Encuentro”“,”“Supercopa de España”“,”“horario”“,”“Partido”“,”“Arabia Saudita”“,”“Athletic Club”“,”“King Abdullah Sports City”“,”“Barcelona”“,”“Hans-Dieter Flick”“,”“Movistar LaLiga”“,”“La Vanguardia”“,”“LaLiga”“,”“Ernesto Valverde”“,”“Real Madrid Club de Fútbol”“,”“Club Atlético de Madrid”“]” “[”“keyword:hoy”“,”“keyword:barcelona”“,”“keyword:semifinal”“,”“keyword:alineaciones”“,”“keyword:previa”“,”“Noticias sin vídeo”“,”“webType:live”“,”“cms:xalok”“,”“keyword:fútbol”“,”“keyword:en directo”“,”“keyword:df”“,”“keyword:supercopa españa”“,”“keyword:athletic club”“]” “1544538886” “1544538886” “2026-01-08T10:00” “2026-01-08T11:00” “ES” “” “Google” “direct” “” “” “” “” “” “0” “{}” “{}” “{}” “{}” “” “0”