Recirculation raw data exports format and columns
Recirculation export files contain data of whole hours.
Data model columns
Section titled “Data model columns”| Name | Data type | Description |
|---|---|---|
event_time | Timestamp | Date and time in UTC that summary belongs to. Example: 2026-01-08T10:00 |
src_editorial_id | Integer | Unique id identifying the source article |
src_url | String | URL of the source article |
dest_editorial_id | Integer | Unique id identifying the destination article |
dest_url | String | URL of the destination resource |
dest_canonical_url | String | Canonical URL of the destination article |
module_name | String | Name assigned to the module |
module_position | String | Position, starting from 0 |
impression | Integer | Amount of impressions |
click | Integer | Amount of clicks |
elegible | Integer | Total count of links that users could potentially view or interact with |
is_mobile | Integer | Possible values: · 0 : Desktop · 1 : Mobile · 2 : Tablet |
page_type | Integer | Page technology. Possible values: · 0 : Web · 1 : AMP · 2 : FBIA · 3 : iOS App · 4 : Android app · 5 : Flowcard · 7 : App |
user_type | Integer | Id of the stage of user in the User Journey. Example: · 0, 1 : Anonymous · 2 : Registered · 3 : Subscriber · 4 : Custom statuses |
engagement_type | Integer | |
medium | String | https://community.marfeel.com/t/traffic-medium-and-traffic-source/7787#traffic-medium-2 |
src_editorial_title | String | Title of the source editorial |
dest_editorial_title | String | Title of the destination editorial |
src_editorial_publish_time | Timestamp | Source editorial publish date as specified on its structure data. Example: 2022-06-08 16:49:48 |
dest_editorial_publish_time | Timestamp | Destination editorial publish date as specified on its structure data. Example: 2022-06-08 16:49:48 |
src_editorial_update_time | Timestamp | Source editorial last update date as specified on its structure data. Example: 2022-06-08 16:49:48 |
dest_editorial_update_time | Timestamp | Destination editorial last update date as specified on its structure data. Example: 2022-06-08 16:49:48 |
src_sections_array | String | Sections detected on the structure data or mrf:sections of the source editorial. Example: [‘International’, ‘Politics’] |
dest_sections_array | String | Sections detected on the structure data or mrf:sections of the destination editorial. Example: [‘International’, ‘Politics’] |
src_authors_array | String | Authors detected on the structure data or mrf:authors of the source editorial. Example: [‘Author 1’, ‘Author 2’] |
dest_authors_array | String | Authors detected on the structure data or mrf:authors of the destination editorial. Example: [‘Author 1’, ‘Author 2’] |
src_entities_array | String | NLP extracted entities of the source editorial |
dest_entities_array | String | NLP extracted entities of the destination editorial |
src_tags_array | String | Array of tags of the source editorial. Example: [‘Tag1’,‘Tag2’] |
dest_tags_array | String | Array of tags of the destination editorial. Example: [‘Tag1’,‘Tag2’] |
Example File
Section titled “Example File”| ”event_time" | "src_editorial_id" | "src_url" | "dest_editorial_id" | "dest_url" | "dest_canonical_url" | "module_name" | "module_position" | "impression" | "click" | "elegible" | "is_mobile" | "page_type" | "user_type" | "engagement_type" | "medium" | "src_editorial_title" | "dest_editorial_title" | "src_editorial_publish_time" | "dest_editorial_publish_time" | "src_editorial_update_time" | "dest_editorial_update_time" | "src_sections_array" | "dest_sections_array" | "src_authors_array" | "dest_authors_array" | "src_entities_array" | "dest_entities_array" | "src_tags_array" | "dest_tags_array" |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| "2026-01-08T10:00" | "114293835” | "https://www.lavanguardia.com/" | ”1546548848” | "https://www.lavanguardia.com/vida/20260108/11420404/igualdad-confirma-crimen-machista-palmas-pese-denuncia-previa-archivada.html" | "https://www.lavanguardia.com/vida/20260108/11420404/igualdad-confirma-crimen-machista-palmas-pese-denuncia-previa-archivada.html" | ”bloquehomeSociedad" | "2" | "279" | "0" | "2630" | "0" | "0" | "3" | "5" | "direct" | "Últimas noticias, actualidad y última hora en Catalunya, España y el mundo" | "Igualdad confirma el crimen machista de Las Palmas pese a una denuncia previa archivada" | "1970-01-01T00:00" | "2026-01-08T10:29:16" | "1970-01-01T00:00" | "2026-01-08T12:27:35" | "[]" | "[""Sociedad""]" | "[]" | "[""La Vanguardia""]" | "[]" | "[""MINISTRA"",""menores de edad"",""crimen"",""Violencia de Género"",""Ministerio de Igualdad"",""Las Palmas de Gran Canaria"",""Tribunal Superior de Justicia de Cataluña"",""C Z A R I N A"",""Filipinas""]" | "[""Unknown"",""social:nofacebook"",""Noticias sin vídeo"",""suscriptorestag"",""webType:homepage""]" | "[""keyword:confirma"",""keyword:igualdad"",""keyword:denuncia"",""keyword:palmas"",""keyword:pese"",""keyword:previa"",""keyword:machista"",""keyword:archivada"",""Noticias sin vídeo"",""webType:story""""keyword:crimen""]” |