Create a Report With Insight Builder

Gladly provides out-of-the-box reports you can generate via the UI. Each report uses hardcoded Time Anchors and a set of metrics to produce data. With Insight Builder, you can choose your own adventure and create reports by allowing you to mix metrics on the subject of your report.

Gladly leverages Looker Business Intelligence (BI) solution to power the Insight Builder experience to provide an extensive list of features designed to bring the level of data clarity that you need. We’ll reference Looker documentation where it’s helpful so you can better understand how Insight Builder works.

Some of you may be seasoned Looker users and will feel right at home with the embedded builder experience in Gladly. If you’re new to Looker, follow the steps below for step-by-step instructions on how to build a report. As a bonus, you can also use many resources to learn about Looker.

• Visit https://www.cloudskillsboost.google/journeys/28  to register for a free Looker training account. There, you’ll find a library of lessons, help docs, and videos to help you learn how to build reports in Looker.
• We reference relevant Looker documentation, which is helpful as you follow the instructions below to build a report.
• Check out the Insight Builder interface overview to get to know the Insight Builder interface.

Insight Builder steps #

Below is a high-level introduction to your steps to successfully build a report.

Before you start #

Before you build a report, we recommend reviewing the following information to learn how metrics and data are defined in Gladly. Knowing these can help you better understand how to combine metrics to build your report.

• Metrics in Detail – Defines and explains Gladly report metrics.
• Time Anchors – Defines how Time Anchors work.
• Report Datasets for Insight Builder – Describes metrics available for each dataset used in Insight Builder.

Once you understand how data is structured in Gladly, it’s time to start creating your report to answer your question. Still, you may ask yourself, “What dataset should I start with?” This truly depends on what you are trying to learn, and Report Datasets for Insight Builder should help you understand how to build a report from each dataset.

Create a Report #

1. Click on the top left corner of the screen.
2. Click Reports.
3. On the top left of the Reports page, click the Create a Report drop-down list and select the dataset you want to build your report with.
   

Proceed to build a report using a particular dataset or by selecting a Quick Start report.

Quick Start #

• Quick Start – Pre-configured reports designed to answer a specific question.
  For example, the Channel Mix Quick Start in the Contact Metrics dataset is pre-configured to show you a breakdown of incoming Contacts over each Channel for the last week. You can also manipulate these reports (e.g., add/remove filters, change date filter, update metrics, etc.) to change the output. Click a Quick Start report to open the pre-configured report. Each dataset has its own set of Quick Start reports.
• Start from a blank Builder – If you start from scratch instead of using Quick Start, we suggest watching the short overview video to get a feel of the Insight Builder experience and how to get started building your own report from scratch.

Insight Builder experience #

1. Upon selecting a dataset, the Insight Builder interface opens on the right side of the screen. The dataset you chose is also visible in the top-left area of the Builder. 
   • The Explore page is a starting point for a query that builds a report exploring a particular dataset with specific metrics.
   • The Explore page opens with the dataset you selected, ready for you to start adding metric dimensions and measures for more details.

At this point, you’re officially able to begin building the report.

Begin building a report #

From the blank Builder page with your chosen dataset, proceed by adding dimensions or measures found under the All Fields tab.

• Dimension – Appears as blue columns in the Builder. It’s a group or bucket of data containing all the metrics available for your selected dataset.
• Measure – Appears as orange columns in the Builder. It’s the method chosen to measure the bucket of data (dimension) selected — for example, Count, Average, Time.
  

1. Click the All Fields  tab. This tab is the starting place for building a report and displays all the fields you can select for a query. Event or Metric data available here tab depends on your selected dataset.
2. Select the dimensions (metrics for the selected dataset) you’d like to use and see them added to the Data area on the right side of the Builder.
   
3. Select the measure you’d like to use and see them added to the Data area.
   
   • The icons next to each dimension or measure provide more information about the field and indicate available options. The icons are visible when you hover over them. See Field-specific information and actions  for more information on how to use this.
     
     • [A] Pivot icon – Click this icon to pivot or unpivot  a field in a Builder. This icon will appear gray when a field is not pivoted and blue when a field is pivoted.
     • [B] Filter icon – Click this icon to use a dimension or measure as a filter  or to remove them as a filter. The selected items immediately appear in the Filter section.
     • [C] Information icon – Click this icon to see a metric description.
4. Once you have added the desired dimensions and measures, click the In Use  tab to see all active fields in the Builder.
5. Next, click the Filters section to select filter parameters for the report. Use filters to restrict the data you’re viewing to items of interest.
   • Clicking the filter icon next to a metric adds the metric to the Filter section. See Filtering data overview  to learn more about the Filter function.
   • Some datasets have default date filters in place.
     
   • Apply Filters as a way to aggregate data, especially if you choose to use different Time Anchor(s).
     • Click + to add another filter with new conditions.
     • Click X to remove a filter.
     • Click the Custom Filter box to create filters with custom conditions that might not be available with the other, simpler filter types. See Add a custom filter  to learn how to use this feature.
6. Click Run to generate the report. Results are displayed in the Data section in table format.
   

Once the report is generated in the Data section, you can pick which visualization type to use to better make sense of your data, create pivots to make large sets of information easier to consume and use table calculations/formulas as you would in a spreadsheet.

Filters #

Filters allow you to limit the data you see. For example, you can use filters to limit the number of Contacts created in a particular Inbox for the last month. You can also design and control how non-analyst users filter reports in a dashboard. See Set Report filter for Non-Analyst Users for more information.

Visualization #

Visualizations make consuming a large amount of data easy by utilizing visual elements like charts and tables. See Quick Guide  for a short overview of how Visualizations work.

1. Select the visualization type you’d like to use to display your data from the row of visualization icons.
   
2. Each visualization type  includes different settings you can use to customize the appearance of the visualization. Click Edit to view these settings.
   
   • See Visualization types  for detailed information on how to customize each visualization type.
   • Some visualization types may be incompatible, and you will see an error if you try using incompatible ones.

Forecast in visualizations #

Add data projections  to help predict and monitor specific data points.

Pivots #

Multiple dimensions are usually easier to see when you pivot one of them horizontally. Each value in the dimension becomes a column, making the information easier to consume visually and reducing the need to scroll down to find data. Looker supports up to 200 pivoted values.

See Pivoting dimensions  to learn how to use the pivot feature.

Totals #

Click Totals to see the total value of a measure. For example, to see the total number of Conversation Metrics Conversation Created, click Totals to expose a Total row.

• Having a Row Limit reduces your number of rows, but the total would remain the same, although you may see a warning that you may be viewing incomplete data.

Row Limit #

Set a row limit to limit the number of rows visible. Looker warns you might be hiding data if you set the row limit too low. Sort order is important here since Looker first applies the sort and then the limit. For example, if you only want to see the top 10 Topics daily, ensure you’re sorting by day.

• Note – You must have a row limit applied if you plan on downloading a report. 

Calculations #

Table calculations make it easy to create ad-hoc metrics. They are similar to formulas that are found in spreadsheet tools like Excel.

When used, table calculations appear as green columns in the Data table rather than as blue columns (dimensions) or orange columns (measures).

Use table calculations to perform mathematical, logical (true/false), lexical (text-based), and date-based calculations on the dimensions, measures, and other table calculations in your query. The formulas that you use to execute these calculations are called Looker expressions. See Using table calculations  for a deeper look at how this works.

• See Looker functions and operations  to learn more about functions and operators.

Once you’re happy with what you have, download the report, save it on your personal dashboard, or save it as part of a shared dashboard.

Custom fields #

Add Custom Dimensions, Custom Measure, or Table Calculation as custom fields  on top of fields available in Insight Builder, allowing you to create ad hoc dimensions and measures.

Download report #

Download reports in formats like CSV, TXT, HTML, and even JSON that you can use to send to other users outside of your organization (or if they don’t have access to Gladly). You can even use downloaded reports to feed into other analytics tools you have. See Downloading content  to learn more.

Name and save report to a dashboard #

A dashboard can house one or a collection of reports where similar or related reports can be stored for access. Think of dashboards as a way to organize and create themes around reports. Each report appears as a tile in the dashboard. 

Save report to a personal dashboard #

Only the Analyst that created the report can access a report they built and saved in their personal dashboard.

Create a new personal dashboard

1. Click on the top right corner of the Builder, click Save, then click As a new dashboard.
2. From the Save as a new dashboard screen, in the Settings tab, enter a title for your new dashboard.
3. From the Folder section, select Embed User. 
   • Note – Select the alphanumeric ID (this is your Org ID) to save and create the report as a new dashboard instead. The dashboard and report inherit the title but can be changed anytime.
4. Click the Filters tab, which shows the filters used in the report you are saving for the first time. These become the default dashboard filter for all reports added to the dashboard.
5. Click Save.

The report is now saved in a new personal dashboard.

Save report to an existing personal dashboard

1. Click on the top right corner of the Builder, click Save, then click To an existing dashboard.
2. From the Add to a Dashboard screen, click Personal on the left side of the window, select the existing dashboard’s name from the list, and then click Save to Dashboard.
   • Note – If you decide to create a new dashboard instead, click New Dashboard first, enter the dashboard name, then click Save to Dashboard.

The report is now saved in an existing personal dashboard.

Save report to a Group dashboard #

Save reports in a Group dashboard so Administrators, Team Managers, and other Analysts can view them. Reports saved in a group dashboard are found in the Shared category on the left side of the Reports page.

Save to a new group dashboard

1. Click on the top right corner of the Builder, click Save, then click As a new dashboard.
2. From the Save as a new dashboard screen, in the Settings tab, enter a title for your new dashboard.
3. From the Folder section, select the alphanumeric ID (this is your Org ID).
   • Note – Select Embed User to save and create the report as a new personal dashboard instead. The dashboard and report inherit the title but can be changed anytime.
4. Click the Filters tab, which shows the filters used in the report you are saving for the first time. Non-analyst users viewing the dashboard can apply the filters you select here to update the report when viewing the dashboard.
   • Note – Future reports you add to this dashboard inherit the filter you apply.
5. Click Save.

The shared dashboard is created by inheriting the report’s name, but the dashboard name and the reports it contains can be renamed at any time.

Save report to an existing group dashboard

1. Click on the top right corner of the Builder, click Save, then click To an existing dashboard.
2. From the Add to a Dashboard screen, click Group on the left side of the window.
3. Select the existing Group dashboard where you’d like to save the report, then click Save to Dashboard.
   • Note – If you create a new group dashboard instead, click New Dashboard first, enter the dashboard name, and then click Save to Dashboard.

The report is now saved in an existing shared dashboard.