Integrate Google reviews into SatisFactory (without the ability to respond)

Track your performances and those of your competitors by integrating Google reviews in read-only mode for a global analysis of your market, without API interfacing.

Table of contents

Step 1: Subscribe to the integration of Google reviews without response from SatisFactory

Step 2: Retrieve the Google Place ID of each site and build its unique URL

Step 3: Activate the integration of Google reviews on the platform

Step 4: Add the Google establishments into the platform

Step 1: Subscribe to the integration of Google reviews without response from SatisFactory

To begin, request your SatisFactory Customer Success Manager to activate the Google Business Profile integration. You will thus be able to automate the collection of your reviews in the platform to effectively manage your e-reputation, at the local as well as global level.

Step 2: Retrieve the Google Place ID of each site and build its unique URL

The Place ID is a unique alphanumeric identifier assigned by Google to each place referenced on Google Maps. It presents itself in the form of a long string of characters (letters and numbers), generally starting with "ChIJ".

Google makes an official and free tool available in its API documentation to find this identifier easily.

This identifier is essential for the configuration of Google integrations on the platform. The Place ID serves in particular as a root to generate the URL link specific to each establishment.

Start by accessing the dedicated page within the Google API documentation: Google Place_ID Finder.

Scroll down the page to the interactive Google Maps map, then, in the "Enter a location" search bar, enter the name and location of your establishment to search for it.

In the list of search suggestions, select the appropriate establishment.

Copy the string of characters, it is the Place ID of the site.

The retrieval of the Place ID must be repeated for each establishment and each competing site whose reviews you wish to integrate into SatisFactory.

Next, build the unique URL specific to each establishment. To do this, complete the generic base URL ("https://search.google.com/local/reviews?placeid=") with the Place ID specific to each site (example below).

We invite you to compile all of this information (Site name, and URL built from the Place ID) in an Excel or CSV file. This document will serve as a technical base for the integration of your establishments into SatisFactory, whether you proceed by CSV file import or by manual entry in the interface.

Step 3: Activate the integration of Google reviews on the platform

⚠️ This step is usually performed by your SatisFactory Customer Success Manager.

From the administration center of the platform, access the "Program settings" section.

Once in the program settings, check the "Google" option in the "Social network channels" field to allow the collection of reviews without API interfacing (and therefore without response).

The configuration requirements for the integration of Google reviews into SatisFactory are now in place. All that remains is to configure the establishments in the tool.

Step 4: Add the Google establishments into the platform

You have 2 methods to integrate new establishments originating from Google Business Profile onto the SatisFactory platform:

• Manual creation: directly from the administration interface, ideal for adding an establishment occasionally
• Manual mass import: from a preformatted CSV file, to be used when you wish to configure multiple establishments simultaneously

Each method thus responds to a specific need depending on the volume of sites to configure. Furthermore, the settings to define for these new sites are the same, regardless of the creation method.

Add a Google establishment manually via the interface

From the "Social networks" section of the administration center, click on the "Add a social network" button, located on the upper right part of the page.

A new configuration pane opens on the right, allowing you to enter the information necessary for the integration of a new Google establishment.

• Site label

Start by assigning a name to your site.

This name will appear in the competitive analysis, as well as in the exports available on the platform.

To facilitate the reading of benchmarks, place the name of the brand associated with the site at the beginning of the label.

Example: Prefer "SatisFactory Levallois-Perret" to "Levallois Branch".

• Metadata identifying the site

Next, select all the metadata associated with your site.

This configuration will make it possible to precisely identify the data that specifically concerns this element in the data flow and associate them with the correct metadata in the platform.

Example: For the New-York 5th Avenue store and its dedicated Google page = "channel="google"&store_name="BRAND-5th-Ave"&store_country="USA"&store_city="New-York"&store_id="002".

• Site URL

Complete this field with the specific URL of the site or establishment (built from its unique place ID).

• ID (unique and technical identifier) of the site

This field must be filled with site-specific data that will be completed by the SatisFactory technical team via your Customer Success Manager. You can leave it empty initially.

• Site channel

Select the "google" channel.

• Site identifier

Enter a unique identifier for the establishment. This code will serve as a linking key to correctly associate the competitors to the corresponding sites in the platform.

The choice of the label is free (it can include the name of the site and potentially its geographical area), but be vigilant: this identifier must be immutable, any modification of the identifier will break the integration.

• Competitors

Enter the information of your site's competitors now if you wish, or do so at a later time by following the procedure.

Once the configuration of the Google site is finalized, press the "Save" button to create it.

💭 The integration of historical data (last 24 months) of a new site into the platform can take between 2 to 3 days. The system queries the external source every 24 hours to ensure data updating.

Add a Google establishment manually by CSV file import

Build the import file with a spreadsheet

Before being able to add Google establishments with or without their competitors, the first step consists of preparing a CSV file. This file will be imported into the platform to create the sites and competitors.

Beforehand, retrieve one of the CSV site import templates. They are available as attachments to this article. You can also download it directly from the platform via the "Export" button, or create it yourself by respecting the required format (CSV, UTF-8 encoding, semicolon separator).

Two CSV file templates are at your disposal depending on your integration needs:

• The "Site only" template: to configure a new establishment in an isolated manner.
• The "Site and Competitors" template: to configure a new establishment and up to 9 of its competitors.

These two files share a common structure, but the template including the competition contains specific additional columns necessary for referencing third-party sites.

The columns must be completed as follows:

⚠️ If your integration concerns both establishments with and without competitors, you will have to perform two distinct imports. Use the "Site only" template for your sole establishments, and the "Site and Competitors" template for those requiring competition monitoring.

Load the CSV file into the platform

From the "Social networks" section of the administration center, click on the "Upload a file" button, located on the upper right part of the page.

Once the CSV template is completed and loaded into the platform, the establishments (and their competitors if applicable) are automatically integrated into the platform. The integration of the historical data (last 24 months) of a new site into the platform can take between 2 to 3 days. The system queries the external source every 24 hours to ensure the updating of the data.

For further assistance or to report a specific issue, please contact our Support team.