Conversion raw data exports format and columns

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”