Exporting PPC Analytics data to Looker

Exporting PPC Analytics data to Looker

How to send PPC Analytics data to Looker

In order to send data to your Looker project, you need to generate LookML code. The code will contain details of the Octoboard Multi-Channel Combined data Warehouse table that can be accessed from within the Looker platform. This tutorial explains how to:

  • Generate Looker code in Octoboard
  • Create LookML project and Octoboard data model
  • Create Octoboard connection in Looker

How to generate LookML code in Octoboard

To generate the code, please visit LEFT PANEL > PPC Data Analytics > Destinations > Looker as shown in the image below:

Generating looker code

Click the GENERATE LOOKER MODEL CODE button. If you have not configured the Octoboard Data Warehouse, the code generation will fail and you will see a warning above. Click the link and proceed to the Data Warehouse configuration in order to complete the process. Octoboad Data Warehouse configuration is covered in detail in this tutorial.

After configuring the Data Warehouse, click the GENERATE LOOKER MODEL CODE button again. The generated code should be placed in the clipboard and you will see the following message:

Looker code generation success

Now you can go to your Looker project and paste the generated code.

How to create LookML project and Octoboard data model

Visit your Looker account URL and log in. The URL usually contains your business name, for example, https://mybusiness.cloud.looker.com/. After you have logged in, click Admin and make sure you are in Development mode.

Development mode in looker

In the LookML project list, click the “New LookeML Project” button.

Lookml project list

In the LookML project configuration, set the project name and make sure you select “Blank Project” option as shown below. This will allow you to load the Octoboard code that you generated earlier.

Configuring lookml project name

In the project tree, click the plus icon and select “Create Model” option that will allow you to load Octoboard code:

Create model button

Paste the LookML code that you created in Octoboard (the process was covered in the previous topic). Click Save Changes to create the model.

Saving lookml code in your project

Once you have saved the changes in the model, Looker would have all the details of the Octoboard Combined Multi-Channel stream. Now you need to create a Looker connection to the Octoboard data warehouse.

How to create Octoboard connection in Looker

Click on the Looker icon at the top-left corner of the screen and select Admin menu item shown below:

Locate administration console in looker

Select the list of connections and click the “Add Connection” button.

List of connections in looker

In the “New Connection” panel, you will need to enter the details of the Octoboard Data Warehouse.

New connection panel in looker
Make sure you check the SSL parameter. This will guarantee that Looker will use the secure protocol when accessing your Octoboard Data Warehouse.
Important: in the Additional Params configuration enter enabledSslProtocolSuites=TLSv1,TLSv1.1,TLSv1.2.

Use default settings for the rest of the connection parameters and click “Test These Settings” button. If everything is ok, you will see “Can connect” message at the bottom of the screen. Default settings and the result of a successful test are shown in the following image:

New connection options continued

After clicking the Add Connection button, you will see the newly added connection in the list. You can test your connection in the list again. The connection list and the results of the test are shown in the image below:

Connections list in looker

Finally, you need to associate your Looker project with the new connection. To achieve that visit the list of projects again, and click the Configure button:

Configure model for looker project

In the model configuration, make sure you select the “octoboard_data_warehouse” connection that you created earlier.

Edit lookml model panel

How to run queries in Looker

Finally, you can visit the SQLRunner interface in Looker and run queries against the Octoboard Data Warehouse database as shown below:

How to run database query in looker

You can also use the LookerML model that you loaded in this tutorial. Click the Model option in the SQLRunner and build your query using the Query edit panel:

Using sqlrunner model builder in looker

If you modify your Combined Multi-Channel stream in Octoboard (add or remove dimensions or redefine rules), you will need to re-generate the LookML code and paste it into the LookML code following the process again.

This completes the tutorial on the Looker export configuration for PPC Data Analytics in Octoboard.

In addition to the Looker data export feature covered in this Knowledge Base topic, you can use the following data destinations to access Octoboard data: