Looker

​

Overview

​

Prerequisites

​

Components of Google Cloud Storage

• Bucket
• Folder
• Account

​

Bucket

​

Folder

​

Account

​

Create a Destination for Looker Studio

1

Log into the Zeotap CDP App and go to the DESTINATIONS application.

2

Click + Create Destination.

3

Under the All Destinations section, search for Looker Audience.

4

Click Google Cloud Storage. A screen appears displaying details about the particular destination towards the left. On the right-hand side of the screen find a list of fields that are required for the integration to be established. Provide the required details as mentioned in the following steps:a. Enter a name for the Destination.b. In the Destination Instance Name field, provide a desired value for this internal field.c. In the Bucket field, provide the name of the Google Cloud Storage Bucket.d. In the Folder field, provide the folder path in your storage location where Zeotap CDP can store your exported data.

Note:Ensure to follow the below points while providing the folder path:

• The folder path should follow the below structure:
  • folder_name/sub_folder_name/
• The folder name should not start with a /
• The folder name and sub-folder name should end with a 

e. Under Filename Prefix, enter a text value without special characters, such as underscores (_), spaces, or symbols (#, @, $, %, &, \*). Note that the file name follows the format: ${filenamePrefix}part-${sequence}_${destinationAudienceId}_${timestamp}.csv, where the timestamp is in yyyy-MM-dd format and destinationAudienceId is the ID associated with your audience (segment) in Zeotap CDP, which is generated by the Zeotap CDP after the audience (segment) is linked to a Destination.

Variable	Description
filenamePrefix	The prefix for the file name, typically indicating the context or purpose of the file (e.g., the segment or export type).
part-${sequence}	A sequential number or identifier indicating the part or chunk number if the data is split across multiple files.
${destinationAudienceId}	The unique ID assigned by Zeotap CDP to the audience (segment) after it is linked to a Destination.
${timestamp}	The date when the file is generated, formatted as yyyy-MM-dd (e.g., 2024-08-06).
.csv	The file extension, indicating that the file is in CSV (Comma-Separated Values) format.

Example File Name: exportpart-01_894548842_2024-08-06.csvf. Under Account, choose either Zeotap Service Account or Client Service Account Json using the drop-down menu based on the type of authentication you need. If you wish to use Zeotap Service Account, then ensure that you whitelist this it to push audiences (segments) from Zeotap CDP to Google Cloud Storage Platform.

i. If you choose Zeotap Service Account as the Account, then ensure that you whitelist the service account provided by Zeotap CDP to push the audiences (segments) from Zeotap CDP to Google Cloud Storage Platform. This service account information auto-populates under Service Account to be Whitelisted as shown in the image below.

ii. If you choose Client Service Account Json as the Account, then you need to upload the JSON file with the required authentication information using the + Select File option so that Zeotap CDP can push the audiences to Google Cloud Storage Platform.

g. Review all the values entered above and then click Next to proceed.

5

In the new screen that appears, choose the appropriate action and mapping as explained below. Under Choose your Action, Send CSV to Looker, as the action for activating your audience in Audiences.

6

After finalising the attributes and identifiers to send, click Create Destination. The created Destination gets listed in the Audiences application, which can be linked to an audience.

​

Identify Segment Files in the Google Cloud Storage Bucket

• partNumber refers to the parts or segments of a multipart upload in Google Cloud Storage. Multipart uploads allows you to upload large files in multiple parts or chunks rather than uploading the entire file in one go. In the above naming convention, Part 0 refers to the first part of the multipart upload.
• channelId is the ID associated with your audience (segment) in Zeotap CDP. This is generated by the Zeotap CDP after the audience (segment) is linked to a Destination. You can obtain this information as shown in the image below.

• epochmilliTimestamp is the timestamp in epoch format.

​

Link an Audience to the Google Cloud Storage Destination

​

Connecting Your CSV File to Looker Studio

1

Navigate to Looker Studio: Open your Looker Studio dashboard.

2

Create a New Data Source: In the top-left corner, click on the + Create button and then select Data Source.

3

Select the Google Cloud Storage Connector: From the list of Google Connectors, choose Google Cloud Storage.

4

Authorize Access: If you are connecting to Google Cloud Storage for the first time, you will be prompted to authorize Looker Studio to access your GCS data. Click AUTHORIZE.

5

Specify the File Path: In the Select a data source panel, provide the full path to your CSV file in the GCS bucket. The path should be in the format gs://your-bucket-name/your-file-name.csv. You can also navigate to the file by selecting your project and then browsing through your buckets and folders.

6

Configure Data Source Options (Optional): You can configure additional options such as the character encoding of your CSV file.

7

Connect: Click the CONNECT button in the top-right corner.

8

Configure Fields: Looker Studio will then display the fields from your CSV file. You can adjust the data type, aggregation, and other properties for each field.

9

Create a Report or Explore: Once you are satisfied with the field configurations, click on CREATE REPORT or EXPLORE to start building your visualizations.