--- title: Overview of the review export columns description: In this article, we provide an explanation of the different columns of the review export file. --- [Skip to content](https://help.localistico.com/knowledge/summary-of-reviews-export-columns#main-content) English Show submenu for translations [Go to Customer Portal](https://help.localistico.com/tickets?hsLang=en) ![logo](https://help.localistico.com/hubfs/logo.svg) - [Help & Support](https://help.localistico.com/knowledge) - [Go to Localistico](https://localistico.com/) Open main navigation Close main navigation - [Help & Support](https://help.localistico.com/knowledge) - [Go to Localistico](https://localistico.com/) - English Show submenu for translations - [Go to Customer Portal](https://help.localistico.com/tickets) Hi! 👋 What can we help you with? - There are no suggestions because the search field is empty. 1. [Help & Support](https://help.localistico.com/knowledge?hsLang=en) 2. [Reputation Management (Reviews, Q&A & Messages)](https://help.localistico.com/knowledge/reputation-management-reviews-qa-messages?hsLang=en) # Overview of the review export columns ## In this article, we provide an explanation of the different columns of the review export file. Reviews can be conveniently exported in either CSV or Excel file formats through the following methods: 1\. the reputation tab: ![](https://help.localistico.com/hs-fs/hubfs/image-png-Nov-04-2025-12-42-21-0914-PM.png?width=2746&height=842&name=image-png-Nov-04-2025-12-42-21-0914-PM.png) 2\. or as a data feed from the advanced settings: ![](https://help.localistico.com/hs-fs/hubfs/image-png-Jan-18-2024-09-45-09-3179-AM.png?width=688&height=382&name=image-png-Jan-18-2024-09-45-09-3179-AM.png) It is important to understand that the exported review data always reflects the most current version of each review. For instance, if the author makes any edits to their review, the data you receive will correspond to this updated version. ### The exported file contains the following columns: | **Column name** | **Definition** | | --- | --- | | localistico\_business\_name | Review related business name | | location\_code | Review related location code | | profile\_name | Review related profile name | | profile\_full\_address | Review related profile full address | | profile\_service | Platform name (Google, Facebook, etc...) | | author | Review author's name | | profile\_lat | Review related profile latitude | | profile\_lng | Review related profile longitude | | rating | Review's current rating | | max\_rating | Review's lifetime maximum rating obtained | | sentiment | Review's sentiment (good, neutral, bad) | | created\_at | Indicates when the review was created in Localistico | | published\_at | Indicates when the review was published on the platform (E.g. Google) | | platform\_updated\_at | Indicates when the review was last updated on the platform (the indicated time will be the same date as published\_at when the review has not been edited). | | text | Text written by the author in the review | | photos | Link to photos included in the review | | profile\_url | Review's profile URL | | has\_owner\_reply | Indicates if the review has been replied by the profile's owner | | owner\_reply\_text | Text written by the owner as reply in the review (this field will be empty if it hasn't been replied yet) | | owner\_reply\_date | Date of the last reply by the owner (this field will be empty if the owner hasn't replied yet) | | owner\_reply\_last\_updated\_by | Indicates who exactly added the last reply:  User's email: if the review was replied manually from Localistico Author's name: if the review was replied on the platform (this data may not be available, as the platform does not always include this information, i.e. Google) | | profile\_id | Localistico's internal profile Id | | platform\_review\_id | Platform's internal review Id | | localistico\_location\_id | Localistico's internal location Id | | localistico\_business\_id | Localistico's internal business Id | | localistico\_interaction\_id | Localistico's internal review Id | | location\_closed | Indicates whether the location associated with the review is open or permanently closed | | location\_temporarily\_closed | Indicates if the location associated with the review is temporarily closed (in this case, location\_closed will be false) | | platform\_reviews | Number of reviews associated with the location | | platform\_average\_rating | Average rating from all reviews associated with the location | | tags | Tags associated to the review | | last\_extracted\_at | The last time the review information was extracted from the platform | | edited\_review\_reply | Indicates if the last review update has already been checked and replied | | platform\_updated | Indicates if the original review has been updated by the author on the platform | | last\_reply\_by | Indicates whether the last reply is a manual or automatic response (this information is related to the field owner\_reply\_last\_updated\_by) |     - [Getting Started](https://help.localistico.com/knowledge/getting-started?hsLang=en#main-content) - [Basic Settings](https://help.localistico.com/knowledge/getting-started?hsLang=en#basic-settings) - [Business Structure](https://help.localistico.com/knowledge/getting-started?hsLang=en#business-structure) - [Integrations](https://help.localistico.com/knowledge/getting-started?hsLang=en#integrations) - [Onboarding](https://help.localistico.com/knowledge/getting-started?hsLang=en#onboarding) - [Frequently Asked Questions](https://help.localistico.com/knowledge/frequently-asked-questions?hsLang=en) - [Locations](https://help.localistico.com/knowledge/locations?hsLang=en#main-content) - [action links](https://help.localistico.com/knowledge/locations?hsLang=en#action-links) - [Presence Management](https://help.localistico.com/knowledge/presence-management?hsLang=en#main-content) - [An overview of profiles](https://help.localistico.com/knowledge/presence-management?hsLang=en#an-overview-of-profiles) - [Claiming profile ownership](https://help.localistico.com/knowledge/presence-management?hsLang=en#claiming-profile-ownership) - [Duplicated profiles](https://help.localistico.com/knowledge/presence-management?hsLang=en#duplicated-profiles) - [Publications](https://help.localistico.com/knowledge/presence-management?hsLang=en#publications) - [Reputation Management (Reviews, Q&A & Messages)](https://help.localistico.com/knowledge/reputation-management-reviews-qa-messages?hsLang=en#main-content) - [Q&A](https://help.localistico.com/knowledge/reputation-management-reviews-qa-messages?hsLang=en#qa) - [Reviews](https://help.localistico.com/knowledge/reputation-management-reviews-qa-messages?hsLang=en#reviews) - [Private Messages](https://help.localistico.com/knowledge/reputation-management-reviews-qa-messages?hsLang=en#private-messages) - [Metrics](https://help.localistico.com/knowledge/reputation-management-reviews-qa-messages?hsLang=en#metrics) - [Analytics (Metrics & Reports)](https://help.localistico.com/knowledge/analytics-metrics-reports?hsLang=en#main-content) - [Metrics](https://help.localistico.com/knowledge/analytics-metrics-reports?hsLang=en#metrics) - [Reports](https://help.localistico.com/knowledge/analytics-metrics-reports?hsLang=en#reports) - [Promotions (Paid Ads and Post Campaigns)](https://help.localistico.com/knowledge/promotions-paid-ads-and-post-campaigns?hsLang=en#main-content) - [Google Ads](https://help.localistico.com/knowledge/promotions-paid-ads-and-post-campaigns?hsLang=en#google-ads) - [Facebook Posts](https://help.localistico.com/knowledge/promotions-paid-ads-and-post-campaigns?hsLang=en#facebook-posts) - [Google Posts](https://help.localistico.com/knowledge/promotions-paid-ads-and-post-campaigns?hsLang=en#google-posts) - [Instagram Posts](https://help.localistico.com/knowledge/promotions-paid-ads-and-post-campaigns?hsLang=en#instagram-posts) - [Post comments](https://help.localistico.com/knowledge/promotions-paid-ads-and-post-campaigns?hsLang=en#post-comments) - [AI](https://help.localistico.com/knowledge/ai?hsLang=en) - [Photos](https://help.localistico.com/knowledge/photos?hsLang=en) - [Users and Passwords](https://help.localistico.com/knowledge/users-and-passwords?hsLang=en#main-content) - [Users](https://help.localistico.com/knowledge/users-and-passwords?hsLang=en#users) - [Passwords](https://help.localistico.com/knowledge/users-and-passwords?hsLang=en#passwords) - [Settings](https://help.localistico.com/knowledge/settings?hsLang=en#main-content) - [Business Info](https://help.localistico.com/knowledge/settings?hsLang=en#business-info) - [Advanced Settings](https://help.localistico.com/knowledge/settings?hsLang=en#advanced-settings) - [Platforms and Credentials](https://help.localistico.com/knowledge/platforms-and-credentials?hsLang=en#main-content) - [Platforms](https://help.localistico.com/knowledge/platforms-and-credentials?hsLang=en#platforms) - [Credentials](https://help.localistico.com/knowledge/platforms-and-credentials?hsLang=en#credentials) - [Store Pages Portal](https://help.localistico.com/knowledge/store-pages-portal?hsLang=en#main-content) - [Getting Started](https://help.localistico.com/knowledge/store-pages-portal?hsLang=en#getting-started) - [Store Pages Portal - An Overview](https://help.localistico.com/knowledge/store-pages-portal?hsLang=en#store-pages-portal-an-overview) - [Store Pages Portal - Locations](https://help.localistico.com/knowledge/store-pages-portal?hsLang=en#store-pages-portal-locations) - [Store Pages Portal - Areas](https://help.localistico.com/knowledge/store-pages-portal?hsLang=en#store-pages-portal-areas) - [Store Pages Portal - Pages](https://help.localistico.com/knowledge/store-pages-portal?hsLang=en#store-pages-portal-pages) - [Store Pages Portal - Custom Attributes](https://help.localistico.com/knowledge/store-pages-portal?hsLang=en#store-pages-portal-custom-attributes) - [Store Pages Portal - Settings](https://help.localistico.com/knowledge/store-pages-portal?hsLang=en#store-pages-portal-settings) - [Store Pages Portal - Domains](https://help.localistico.com/knowledge/store-pages-portal?hsLang=en#store-pages-portal-domains) - [Store Pages Portal - Themes](https://help.localistico.com/knowledge/store-pages-portal?hsLang=en#store-pages-portal-themes) - [Plan & Billing](https://help.localistico.com/knowledge/plan-billing?hsLang=en) - [Accounts Portal](https://help.localistico.com/knowledge/accounts-portal?hsLang=en) - [Go to Localistico](https://localistico.com/) - [Customer Portal](https://help.localistico.com/_hcms/mem/login?redirect_url=https%3A%2F%2Fhelp.localistico.com%2Ftickets) - [Help & Support](https://help.localistico.com/knowledge) [![logo (1)](https://help.localistico.com/hubfs/logo%20(1).svg "logo (1)")](http://localistico.com) © Localistico 2020