SimilarWeb API Connector

• Channel: Social Listening
• Data Stream Type: Competitive
• Data Lagging: Retrieves the last full month

Prerequisites

To connect to the SimilarWeb API, you need a valid API Key. Contact your SimilarWeb representative to receive an API Key.

Details

• SimilarWeb displays data up to the last month. For example, if the date is May 4 SimilarWeb displays data up until April.
• When reprocessing a SimilarWeb Data Stream, the reprocess retrieves only whole months, even if you entered only part of a month. For example, if you chose to reprocess Jan 8 to Feb 14, the whole month of January and February will be retrieved in this reprocess.
• Data can only be retrieved as far back as 16 months. All the Measurements pulled by the SimilarWeb connector aren’t summable, except for Visits. The Measurements retrieved are either Rate Measurements for example, Pages Per Visit or Average Measurements for example, Avg visit duration.
  • You might experience inconsistencies when pulling these types of Measurements, as they’re retrieved from SimilarWeb with calculated values, and not as ‘native’ Measurements.
  • It’s recommended to view these Measurements in the lowest granularity available.
• The Avg Visits Duration Measurement is retrieved from SimilarWeb as seconds. To ensure that it’s displayed properly in Marketing Cloud Intelligence, change the Measurement type to Duration by completing the following steps:
  • Navigate to Connect & Mix > Measurements > Measurement List
  • Filter your Measurements to Avg Visit Duration
  • Under Type select Duration
  • Click Save
• Marketing Cloud Intelligence Transposes the data based on the Device entity - SimilarWeb metrics have the Device Value and Metric Name merged into one. For example, Mobile Visits contains Mobile, which is a Dimension value and Visits, which is a Measurement. Transposing the data separates the two fields so that the Device value is mapped to the relevant Dimension, and the Measurement value is mapped to the relevant Measurement.
  • This process adds more rows depending on the number of Device values, but it’s the best way to process the data so that you can filter the data by device, and so you can easily update any new devices that are added in the future, without having to update the mapping each time.
• Marketing Cloud Intelligence pulls worldwide data (if it’s available in the account) by default. If worldwide data is not available, Marketing Cloud Intelligence pulls data only for the countries available within the account.

General Setup

In this section you can define the general details. After entering your credentials, select the relevant Account you want to retrieve data for.

Advanced Settings

This section allows you to define advanced settings for your API connector. These settings are the same for all API connectors. For more information about the different settings, see API Connector - Advanced Settings.

Extended Properties

• Domain- Insert up to five domains you want to pull data for. The domains should be separated by a comma.
  • Ensure that the domain entered doesn’t include the ‘www’ prefix, for example, salesforce.com and not www.salesforce.com. Inserting invalid domains results in an error.

How to QA Your Data

• Create the desired report in the SimilarWeb UI for the required date range.
• Next, process the relevant Data Stream in Marketing Cloud Intelligence for the same date range.
• Create a Report/Table Widget/Pivot Table within Marketing Cloud Intelligence containing the exact same Dimensions and Measurements for the same report and date range.
• Compare the Measurement Totals and make sure they’re aligned.