Topics

Google Looker Studio connector

Overview

In this article you learn how to connect to Google Looker Studio and how to consume your Sitefinity Insight marketing data to create reports.

PREREQUISITES: To use the Sitefinity Insight Connector for Looker Studio, you must have an Insight subscription with quota higher than 100k visitors or to be in active trial period.

Connect to Looker Studio

To connect Sitefinity Insight and Looker Studio and get rich visualization of your unified data, perform the following:

  1. Navigate to Looker Studio’s Connect to Data page.
  2. Locate Progress Sitefinity Insight pane and click Create data source.

    To quickly locate the pane, you can use the filter on the top of the page to type Sitefinity.

  3. Log into Looker Studio.
    The Untitled data source page opens.
  4. To grant access to the specific data centers in Sitefinity Insight, click Authorize and enter your Sitefinity Insight data centers access key.

    Skip this step, if you have already connected your Sitefinity Insight and your Looker Studio accounts.

  5. In Sitefinity Insight Data Center dropdown select the Insight data center that contains the data, which you want to visualize in Looker Studio.
  6. Click Connect.

RESULT: Your Google and Insight accounts are linked and you can start building your reports.

Fields description

To build reports and charts in Looker Studio, you use fields, which are columns of data. Fields contain either Dimensions - for example, the categories or things that you want to measure, or Metrics - for example, the numbers that measure the items in each dimension. For more information, see Looker Studio documentation » Fields in reports.

When using Sitefinity Insight connector, field data is provided by your Sitefinity Insight data center.
When you configure the Sitefinity Insight connector, the full list of fields appears in Looker Studio. Another case when you can use fields is to create reports and charts, where you can drag and drop the fields to create charts or table reports.

IMPORTANT: Sitefinity Insight connector provides daily statistics for Insight artifacts. Each Sitefinity artifact has properties that you access and map to Data studio fields, according to the table below.

Field

Description

Type

The type of artifact stored in Sitefinity Insight. Artifacts are the objects you manage and measure in Insight. Sitefinity Insight Connector currently supports the following artifacts: Lead Scoring, Personas, Conversions, and Touchpoints.

Child

Applies to Lead Scorings only. Enables you to access the name of the stages in a Lead scoring.

Name

The name of the Sitefinity Insight artifact. You define this name in the Insight web app when you create it.

Date

The date in UTC of the daily statistic.

Unit

The type of the reported daily statistic. It relates to the Type. For example, this may be Total hit points for touchpoints.

Value

The numeric value of the daily statistic.

EXAMPLE: If you work with Conversions, the Type is Conversion, the Unit is Unique conversions. Value contains the daily number of unique conversions, for example 1000.

Sample report

To see a sample report in Looker Studio, click Sitefinity Insight Sample Report.

Was this article helpful?

Next article

Microsoft Power BI Connector