Work with reviews
      Back to home
      1. Help Center
      2. General questions about the service
      3. Work with reviews

      Reports (uploads) on reviews from your personal account

      Contents:

      Full upload of reviews (old and new versions)

      • Differences between the old and new versions 

      • Reviews tab

      • Review Report tab

      • Tag Report tab

      How to filter a full upload of reviews

      Statistics on reviews by brand and city

      Statistics on responses by brand and city

      Rating statistics by source

      Rating of companies on the Google, 2GIS (URBI) sources

      The data in the report will be displayed depending on the filters installed on the Reviews page in the personal account. That is, if you set a certain period in this section and download the report, then the upload will display reviews only for the selected period.

      Attention! Filtering is based on reviews specifically! That is, the report may contain responses that were left outside the selected period. For instance, the filters were set to the period from 26.03.2022 to 26.04.2022. The report may contain the date 27.04.2022 - this is the day when the response to the review dated 25.04.2022 was given.

      Full upload of reviews (old and new versions)

      Differences between the old and new versions 

      There are differences between the old and new versions in the following fields:    

      1. In the old version, the export is divided into two tabs: Reviews and Review report. 
        In the new version - Reviews, Review report, Tag report.    
      2. In the old version, there is no Companies Group.
      3. In the old version, the ID review field displays the ID of the review or response.
        In the new version, only the review ID is displayed.    
      4. In the old version, there is a field for the ID review to which sended answer (this field is not present in the new version), in which the ID of the review is entered. If this field is empty, it means that the line displays a review, not a response.This column is necessary to understand which review the response, indicated in the next column Response to review, was given to. 
      5. In the old version, there is no Reply time field.

      Reviews tab


      The Reviews tab has the following fields:

      • Total reviews - displays the number of absolutely all reviews, depending on the filters set.

      • Positive - the number of only positive reviews.

      • Negative - the number of only negative reviews.

      • Without rating - reviews without valuation.

      • Average rating - the average rating of all reviews.

      • Date - the date when the review was left in the catalog.

      • Brand - the name of the brand in relation to which the review was left.

      • Store code - the code of the company in relation to which the review was left.

      • Companies Group - a group created in the personal account, which includes this location.

      • Company - the name of the company in relation to which the review was left.

      • Country - the country where the company is located.

      • City - the city where the company is located.

      • Street - the name of the street where the company is located.

      • Street number - the number of the house where the company is located.

      • Catalog - the source where the review was left in relation to the company.

      • Rating - the rating of the company in relation to which the review was left.

      • Author - the name of the client (who wrote the review) or the company/user (who responded to the review).

      • ID review - id of the review.

      • Comment - the text of the review itself.

      • State - the review status is displayed. If the review has been deleted by the author, then Deleted will be written in the field. If the field is empty, it means it has not been deleted.

      • ID reply - the ID of the response to the review.

      • Reply time - the time in minutes. It is calculated as follows: time of response creation - time of review creation. The time of the first appearance of the review and response is taken exactly.
        For example, a review was created by a user on 05.04.2024 at 9:00, it appeared in the account on 05.04.2024 at 10:00. The response to it was given through the personal account on 06.04.2024 at 9:00, and it appeared in the catalog on 06.04.2024 at 11:00. To calculate the response time, we will take the earliest response time of 06.04.2024 at 9:00 and subtract the earliest review time of 05.04.2024 at 9:00.

      • Reply to reviews - the text of the response of the review.

      • Answered employee - the email of the employee who responded to the review.

      • Link to review in catalog - a link that opens a review in the catalog when clicking on it.

      • Processing status - the status of review processing that employees set in the personal account while working with reviews.

      • Tags - the tags with which the reviews are marked in the personal account.

      Attention! 

      If there are empty columns: Branch code, Company, Country, City, Street, House - this means that a brand review is displayed in this line!



      Review Report tab


      The Review Report tab has the following fields:

      • Company name.

      • Branch code.

      • City.

      • Catalog. In this column, in addition to the name of the catalog, the word All may also occur. This means that this line shows the rating of a particular company in all catalogs.

      • Address - the address of the company in relation to which the response was left.

      • Month and year in XX.XXXX (03.2022) format - the rating for each month of the selected period is displayed. The period is selected on the personal account page in filters. If it is not set, the report will display data for all time.



      This report has levels. The second level displaying all the information is presented by default. The rating for each brand, company, city, catalog and month is shown here.

      To go to the first level, you need to click on the icon 1 in the top left corner of the table. Statistics will be displayed only for the brand and all catalogs in the context of the city.


       

      To return to the second level, you need to click on 2.



      Lines with additional data for each city and brand can be opened separately. To do this, click on the + icon after the required field.



      To hide a line with additional fields, click on the - icon next to the desired field.


      Tag Report tab

      The Tag Report tab has the following fields: 

      • Tag's title. 
      • Count reviews by tag.

      How to filter a full upload of reviews


      In the full upload, you can filter the fields. To do this, click on the arrow in the bottom right corner of the field.



      A window will open in which you can sort by:

      • Ascending.

      • Descending.

      • Empty - only empty fields will be displayed.

      • Not empty - the fields in which there is data will be displayed.

      Attention! When the 10 First filter is set, empty fields will be displayed.



      When you click on the Standard Filter, a window will open in which you need to set the necessary values for filtering.



      In this window, you need to select the values in the columns.

      In the Operation column, the value AND/OR is selected:

      • If you select the OR value, then all filters will be executed separately. That is, one condition will not affect the other, and as a result, those data that do not fit, for instance, the first condition, but completely fit the second, can be shown.

      • If you select the AND value, then the selected filters in the remaining columns and fields will be summed up. That is, if two conditions are selected, then only the data that fits both the first condition and the second will be displayed as a result. This will be shown in more detail in the example below.

      In the Field Name column, you must select the name of the table field by which you want to filter.

      In the Condition column, you must select the rule depending on which the field will be sorted.

      In the Value column, you must select the content of this field to which the condition will be applied.

       

      Example: Filtering the uploading of reviews by brand and city. In the Operation field, select the AND value, in the Field Name field, select the City and Brand values, in the conditions, select =, in the values - Bucharest and Brand Name, respectively. Then click on OK.



      The report will display data sorted by the selected brand and by the city of Bucharest.



      Example: In the Operation field, select the OR, in the Field Name field, select the City and Rating values, in the conditions, select = , in the values - Bucharest and 3, respectively. Then click on OK.



      The report will display data sorted by the city of Bucharest and by rating with a value of 3. In this case, the City field indicates other cities besides Bucharest, in which there are companies with reviews with a value of 3. While in the Rating field, in addition to the value 3, others are also indicated, since reviews with other ratings have been left in relation to the companies in Bucharest.


       

      Next, in the main drop-down filter there is a Search for Items field and a list with all the values that are in this column, in this case the Date.

      If you need to sort by the content of the field, you can enter the necessary data in the Search for Items field or check the box next to the desired value in the list below.

      By default, the boxes on all the data will be checked.



      To select only one value, you need to click on the selected field content, and not the checkbox. Then click on the checkbox icon.



      To select all values except one, you need to click on the field content, and not the checkbox. Then click on the cross icon in the checkbox.



      Statistics on reviews by brand and city


      The report has the following fields:

      • Brand - the name of the brand in relation to which the reviews have been left.

      • Branch code -  the code of the company in relation to which the reviews have been left.

      • City - the city where the company of this brand is located.

      • Address - the address of the brand company.

      • Total reviews - displays the number of reviews left in relation to the company by brand and city.

      • Positive - the number of only positive reviews that have been left in relation to the company in the context of the brand and the city.

      • Negative - the number of only negative reviews that have been left in relation to the company in the context of the brand and the city.

      • No rating - the number of reviews without valuation that have been left in relation to the company in the context of the brand and the city.

      • Rating for the period - the rating of the brand in the specified city for the selected period of time.

      • Google reviews count - the number of reviews that have been left on Google for this brand and city.
      • Google reviews count updated date - the date when the information on the number of reviews on Google was updated.
      • 2GIS reviews count - the number of reviews that have been left on 2GIS for this brand and city.
      • 2GIS reviews count updated date - the date when the information on the number of reviews on 2GIS was updated.
      • Yandex reviews count - the number of reviews that have been left on Yandex for this brand and city.
      • Yandex reviews count updated date - the date when the information on the number of reviews on Yandex was updated.

      Attention! In the Reviews section, you can set the date for which you want to view the statistics and download this report. Statistics for a specific date can only be viewed starting from November 7, 2024.



      This report has levels. By default, the first level is presented, in which there is no data for the Branch code and Address. This level shows the statistics on the reviews of the specified brand in a certain city.

      To go to the second level, you need to click on icon 2 in the top left corner of the table. Company statistics will be displayed.



      To return to the first level, click on 1.



      Lines with additional data for each city and brand can be opened separately. To do this, click on + icon after the required field.



      To hide a line with additional fields, click on the icon next to the desired field.



      Statistics on responses by brand and city


      The report has the following fields:

      • Brand - the name of the brand in relation to which the reviews have been left.

      • Branch code - the code of the company in relation to which the reviews have been left.

      • City - the city where the companies of this brand are located.

      • Address - the address of the brand company.

      • Total reviews - displays the number of all reviews that have been left in relation to the companies in the context of the brand and the city.

      • With answer - displays the number of reviews with answers that have been left in relation to the companies in the context of the brand and the city.

      • Without answer  - displays the number of unanswered reviews that have been left in relation to the companies in the context of the brand and the city.

      • Total reply time in the personal account  (in hours, minutes) - is the sum of the response times in the personal account for reviews of this brand in this city. The time for one response is calculated by the formula: response creation time in the personal account - review creation time in the personal account.
      • Total reply time in catalog (in hours, minutes) - is the sum of the response times in the catalog for reviews of this brand in this city. The time for one response is calculated by the formula: response creation time in the catalog - review creation time in the catalog.
      • Average reply time in the personal account (in hours, minutes) - is the arithmetic mean of the response times in the personal account for reviews of this brand in this city. It is calculated by the formula: total response time in the personal account/number of responses. 
        For example, 
        • The total response time in the personal account is 1114 hours and 30 minutes. 
        • The number of responses is 2. 
        • Therefore, dividing 1114 hours and 30 minutes by 2, we get 557 hours and 15 minutes.
      • Average reply time in catalog (in hours, minutes) - is the arithmetic mean of the response times in the catalog for reviews of this brand in this city. It is calculated by the formula: total response time in the catalog/number of responses. 
        For example, 
        • The total response time in the personal account is 4223 hours and 16 minutes. 
        • The number of responses is 2. 
        • Therefore, dividing 4223 hours and 16 minutes by 2, we get 2111 hours and 38 minutes.

       

      This report has levels. By default, the first level is presented, in which there is no data for the Branch code and Address columns. The statistics on the responses of the specified brand in a certain city are shown here.

      To go to the second level, you need to click on the icon 2 in the upper left corner of the table. Company statistics will be displayed.



      To return to the first level, click on 1.



      Lines with additional data for each city and brand can be opened separately. To do this, click on the + icon after the required field.


      To hide a line with additional fields, click on the icon next to the desired field.



      Rating statistics by source

      • Catalog - the service where the reviews have been left.

      • Brand - the name of the brand in relation to which the reviews have been left.

      • Branch code - the code of the company in relation to which the reviews have been left.

      • Company name - the name of the brand company.

      • City - the city where the companies of this brand are located.

      • Address - the address of the brand company.

      • Average rating - the average rating of the company in the directory.

      • Average review rating is the rating calculated for all reviews (location + brand).

      • Average rating by filial is the rating calculated for reviews to locations (i. e. brand reviews are excluded).


      This report has levels. By default, the first level is presented, in which there is no data on the Brand, Branch code, Company name, City, Address columns. This level displays the statistics on the rating of reviews for each catalog, the average rating of reviews for all catalogs and the average rating for branches.

      To go to the second level, you need to click on icon 2 in the upper left corner of the table. Company statistics will be displayed.


      To return to the first level, you need to click on 1.



      Lines with additional data for each city and brand can be opened separately. To do this, click on the + icon after the required field.



      To hide a line with additional fields, click on the icon next to the desired field.



      Rating of companies on Google, Yandex, 2GIS (URBI) sources

      • Brand - the name of the brand in relation to which the reviews have been left.

      • Location status - whether the location is open or closed is displayed.

      • Branch code - the code of the company in relation to which the reviews have been left.
      • City - the city where the companies of this brand are located.
      • Address - the address of the brand company.
      • Google - the rating of the company in this catalog for the last day is displayed.

      • Google reviews count - displays the number of reviews in the directory for this address."

      • Link to Google - the link to the corresponding company in the Google catalog.
      • Yandex - the rating of the company in this catalog for the last day is displayed.
      • Yandex reviews count - displays the number of reviews in the directory for this address."
      • Link to Yandex - the link to the corresponding company in the Yandex catalog.
      • 2GIS (URBI) - the rating of the company in this catalog for the last day is displayed.

      • 2GIS (URBI) reviews count - displays the number of reviews in the directory for this address."

      • Link to 2GIS (URBI) - the link to the corresponding company in the 2GIS (URBI) catalog.

      Attention! For this upload, only the filter by company is used. The day rating is the rating for yesterday in the company’s card on the source.