Integrate reviews from another external source into SatisFactory

Track your performances and those of your competitors by integrating reviews from external sources (Facebook, TripAdvisor, Google Play Store, App Store, TheFork, Booking, Hotels.com, Expedia, or Zoover) in read-only mode for a global analysis of your market, without API interfacing.

Table of contents

Step 1: Subscribe to the integration of reviews from an external source without response from SatisFactory

Step 2: Activate the integration of reviews from an external source on the platform

Step 3: Add pages from an external source into the platform

Step 1: Subscribe to the integration of reviews from an external source without response from SatisFactory

To begin, request your SatisFactory Customer Success Manager to activate the integration of an external data source. You can notably import reviews from the following platforms:

• Facebook
• TripAdvisor
• Google Play Store
• Apple App Store
• TheFork
• Booking
• Hotels.com
• Expedia
• Zoover 

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: Activate the integration of reviews from an external source 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 appropriate channel 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 reviews from an external data source into SatisFactory are now in place. All that remains is to configure the pages in the tool.

Step 3: Add pages from an external source into the platform

You have 2 methods to integrate new pages originating from external data sources onto the SatisFactory platform:

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

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

Add a page from an external source 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 page originating from an external data source.

• Page label

Start by assigning a name to your page.

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 page at the beginning of the label.

Example: Prefer "SatisFactory Google App" to "Google SatisFactory".

• Metadata identifying the page

Next, select all the metadata associated with your page.

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 e-commerce site page = "channel="googleplaystore"&app="SatisFactory mobile".

• Page URL

Complete this field with the specific URL of the page, necessary for identification and data extraction.

Procedure for a social network or an application store (Facebook, Google Play Store, Apple App Store)

Procedure for a booking platform (TripAdvisor, TheFork, Expedia, Hotels.com, Booking.com, Zoover)

• ID (unique and technical identifier) of the page

Retrieve the unique identifier of the site or page and enter it in this field.

Procedure for a social network or an application store (Facebook, Google Play Store, Apple App Store)

Procedure for a booking platform (TripAdvisor, TheFork, Expedia, Hotels.com, Booking.com, Zoover)

• Page channel

Select the appropriate channel for your external data source.

• Page 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 page and potentially its geographical area or its type), but be vigilant: this identifier must be immutable, any modification of the identifier will break the integration.

• Competitors

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

Once the configuration of the page originating from your external data source is finalized, press the "Save" button to create it.

💭 The integration of historical data (last 24 months) of a new page 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 page from an external source manually by CSV file import

Build the import file with a spreadsheet

Before being able to add pages 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 pages and competitors.

Beforehand, retrieve one of the CSV page 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 page in an isolated manner.
• The "Site and Competitors" template: to configure a new page 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 pages.

The columns must be completed as follows:

⚠️ If your integration concerns both pages with and without competitors, you will have to perform two distinct imports. Use the "Site only" template for your sole pages, 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 pages (and their competitors if applicable) are automatically integrated into the platform. The integration of historical data (last 24 months) of a new page 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.