Recirculation export files contain data of whole hours.
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 | Traffic Medium and Traffic Source |
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
| “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”“]” |