Looker

This is for:

Developer

Looker is our preferred analytics and business intelligence partner, providing a best-in-class approach to data analysis.

Getting started with Looker

  • For documentation on how to get started with Looker, see the Looker training guide

  • Take a look at how to explore your Live Tap data

  • Consider the excellent Looker webinars and training courses that cover topics such as data analysis and data exploration

Note

If you are not yet a Looker customer, we can take you through the benefits of leveraging Looker to get the most out of your Qubit data. Contact Coveo Support for details.

Creating new Looks

To create a new Look, navigate to the menu at the top of the page and select Explore > Qubit Analytics. This will open the Explore page, as shown in the following screenshot:

creating new looks

The Explore page consists of four sections that you will use to create your report:

  • The subject area section on the left that contains a set of subject areas that are used to organize your Live Tap data into groups of related metrics and attributes.

    You can filter the subject area to show All Fields, only Dimensions, or only Measures:

    subject area

  • The Filters section used to display and set report filters:

    filters

  • The Visualization section for displaying your query results as charts, tables, maps, and other visualization types:

    visualization

  • The Data section that lists the columns returned by your query:

    data section

When you select metrics and attributes from multiple subject areas, Looker will automatically make the underlying table joins in the background, allowing you to explore and analyze your entire Live Tap dataset without the need for using SQL, or an understanding of the underlying data model.

Performing other tasks

Downloading Looker dashboards as a PDF

Step 1

Open the Look and select settings-cog in the upper-right hand corner of the page

Step 2

Select Download as PDF…​

Re-running underlying queries

Step 1

Open the Look and select settings-cog in the upper-right hand corner of the page

Step 2

Select Clear Cache & Refresh

Scheduling dashboards

Step 1

Open the Look and select settings-cog in the upper-right hand corner of the page

Step 2

Select Schedule and define when you want the it to run, the recipients, and the delivery format, such as a PDF or image

Live Tap subject area guide

The following table identifies the subject areas we provide for analyzing Live Tap data.

Note

These may change over time as we add new content or products. They may also be customized by Qubit, or a partner, if you have requested this as part of an engagement.
Subject Area Description of Contents

Attribution

Metrics and attributes used for attributing revenue by first click, last click, event click, or using Qubit’s behavioral model

Entrances

Contains metrics and dimensions specific to the start of a user entrance, for example, referrer or UTM source

Experiences

Contains details of experiences you have set up in the Qubit platform, test results, control, and variants along with metrics for converters, visitors, and revenue recorded resulting from those experiences:

* Use Include Post Experience Views? to filter in/out user behavior after after viewing an experience, or just look at the Views the experience was displayed on.

* Use Experience Paused on View to filter out user behavior where the experience was not active.

Goal Achieved

Contains details of experience goals you have set-up on the Qubit platform, test results, control, and variants along with metrics for converters, visitors, and revenue recorded resulting from those experience goals

Product Interaction and Sales

Metrics and attributes relating to product events, for example interacting with a product in a product listing page or adding a product to basket or purchase of productinfo-icon Some product interaction types may be missing if you’re not emitting appropriate product events

Segment Membership

Metrics and attributes relating to customer segments, allowing you to breakdown experience results and other metrics by a segment.info-icon Segment data for a specified date range represents only users that were active on site during that date range, and the segments they were active in

Sessions

Metrics and attributes that relate to the entire visitor session, for example the device they used to access your site, or the country that they are located in

Transactions

Metrics and attributes relating to transaction events on your site

Views

Metrics and dimensions relating to pageviews including user login data, such as email, visitors and views counts, along with derived metrics such as session bounce rate.Use this view for basic activity reports such as number of visitors, categories of pages viewed, bounce rate.

User Action

Metrics and attributes relating to various visitor-related events on your site such as attempt to redeem a voucher, user subscription, custom UI interaction.info-icon This subject area will have data only if your website emits appropriate QP events, for example ecUserSignup, ecInteraction, ecVoucher

Visitor pulse

Metrics and attributes relating to Visitor pulse surveys filled in by visitors on your website

Creating an example post-experience analysis Look

Step 1

Navigate to the menu at the top of the page and select Explore > Live Tap - your_company_name.

Step 2

Select the Experiences folder within the list of subject areas in the side menu to show the list of associated subfolders, attributes, and metrics

Step 3

Select the following items to add them to the report canvas:

  • Experience > Experience Name dimension

  • Experience Visitors measure

  • Revenue per Visitor measure

  • Transaction Total measure

  • Visitor Conversion Rate measure

post-experience

Step 4

Navigate to the top-right-hand corner of the page and select post-experience to execute the query

Once the query has completed, you should see a table of results that shows the above metrics for all of the experiences seen.

Working with the results of a Look

Extending the Look by applying filters

Once you have run the query, you can filter the results. Using the example above, we will apply filters to show only those experiences seen by at least 1,000 visitors and with a low Conversion Rate.

Of course, you can amend the filters in line with your own Live Tap dataset.

Step 1

Navigate back to the Experiences folder and locate the Experience Visitors measure. Select experience visitor measure

Step 2

Set the filter condition to is greater than or equal to 1000. Do not run the query yet

rerun

Step 3

Locate the Visitor Conversion Rate measure and select visitor Conversion Rate to add it as a second report filter. Set the filter condition to is less than 0.05

Step 4

Select execute to execute the query and return the filtered results

Sorting results

Select a column header to sort the results by that column and in descending order. Select the column header again to sort in ascending order

Changing the theme

Step 1

Select the VISUALIZATION tab:

visualization

Step 2

Select table to change to the Table visualization type

Step 3

Select table theme to display the visualization properties dialog and select Gray from the Table Theme dropdown menu

Saving a report to the catalog as a Look

Step 1

Select settings-cog in the upper-right hand corner of the page and select Save as a Look…​

Step 2

In the Save Look dialog, select your personal folder on the left side of the dialog and enter a name and description for the Look. Select store report to store your report to the catalog

Sharing a report

You can share a report with colleagues or customers if they also have a login to Looker and permission to view the data that the report is based on.

Step 1

Select settings-cog in the upper-right hand corner of the page and select Share…​. You will then be presented with short and expanded URLs for the report

Step 2

You can now share the Look by copying and pasting either URL

Tip
Leading-practice

In the expanded version, all of the report definition elements are encoded in the URL.

Saving the report as a CSV file

Step 1

Select settings-cog in the upper-right hand corner of the page and select Download…​

Step 2

Select CSV from the File Format combo box

Step 3

Leave the remaining download options in their default state

Warning

Be careful when changing Limit to All Results. Live Tap views can have millions of rows of data in them.

Glossary of terms

Term Explanation

Look

A single, saved report - often created from an Explore that you save for later. Dashboard,Combine multiple Looks and filters onto a dashboard.

Explore

Refers to either the page in the Looker UI used to create new reports or a collection of Looker views joined together using primary keys. Similar to a database schema

Space

A place to store Looks and dashboards around a common theme or for a particular organization. Can contain sub-spaces and be either private or public. Similar to directories and sub-directories on a filesystem

Further training & support

If you need any help or support in working with Looker and Live Tap, contact Coveo Support.

There are regular Looker public training courses that cover topics such as data analysis, and data exploration. There are also webinars for business users new to Looker.

Expanding your relationship with Looker

Your Looker access through Qubit is designed to help you understand and activate data that lives within Qubit’s Data Store. Looker is also suitable for use cases far beyond marketing and personalization. As you and your organization get accustomed to using Looker with Qubit, you may have the appetite to analyze datasets that live outside of Qubit.

If so, we are happy to introduce you to Looker directly, and discuss procuring your own license. Contact Coveo Support for details.