Data Explorer Quick Start Guide: Build a Report on Phrase Hits

In this guide, we show you how to build a report that gives you the number of analytics phrase hits from a specific phrase category for the past six months—all in one place. Here’s what the final report will look like:

If you haven’t worked with Data Explorer very much, don’t worry. We explain every step. But if you’re completely new to Data Explorer, you might want to start with the Beginner’s Guide to Data Explorer Dashboards.

The information in this guide also applies to Data Management.

Step 1: Build the basic report

NOTE   If your organization has a very high contact volume or you’ve been using Provider Analytics for a long time, Workforce Optimization might run a little slowly during this step. If that bothers you, skip to Step 2: Filter the data and come back to Step 1 when you’re done.

Add the Phrases measure

The first step in building any report is selecting the data you want to see.

  1. Click Data Explorer in the top menu.
  2. Click New Report (upper left corner of the page). The blank report page appears.
  3. Click [measure]. The Select Measure window opens.
  4. Select Phrases.
  5. Click Add. The Measure: Phrases window closes, and the basic report appears. At this point, it looks like this:

    This is the total number of phrases hits for all categories that have happened across all calls in your organization—for all time. This isn’t a very helpful number, but things will start to make more sense in the next step.

Group the phrases data

In this step, we sort phrase hits into meaningful buckets.

  1. Click [grouping]. The Select Grouping window opens.
  2. Select Phrase Category.
  3. Click Add. The Grouping: Phrase Category window closes, and the report now looks like this. We’ve shown only the first few rows here; you might have more.

    This grouping separates the total number of phrase hits by phrase category. Let’s keep going to separate these hits by phrase.

  4. Click [grouping].
  5. Select Phrase.
  6. Click Add. The report now looks like this.

    This grouping shows the total number of hits for each phrase. Now let’s see how these phrase hits have trended over time.

  7. Click [grouping].
  8. Click Time (upper right corner of the Select Grouping window).
  9. Select Contact Start Time.
  10. In the Period panel, select Year.
  11. Click Add. Here’s what we get:

    Now we’re getting somewhere! We can see how many phrase hits occurred in each year. Let’s narrow this further by month.

  12. Click [grouping].
  13. Click Time.
  14. Select Contact Start Time.
  15. In the Period panel, select Month.
  16. Click Add. Here’s what we have now:

Step 2: Filter the data

We’ve built the report, but it’s just too much data. Let’s add filters to narrow things down to just phrase hits that occurred during the last six months for one specific category.

Filter by date

In this step, we limit phrase hits to only those from the past six months.

  1. Click [limit]. The Select Filter window opens.
  2. Click Time.
  3. Select Contact Start Time.
  4. In the Period panel, select Contact Start Time.
  5. Click Add Filter (the + icon). The Select Period window opens.

  6. Select Month.
  7. Click OK. The Select Period window closes.
  8. Enter 6 in the Last column.
  9. Select This.

  10. Click Add. The Filter: Contact Start Time window closes. Here’s our report, with only phrase hits from the last six months showing:

Filter by phrase category

In this step, we limit the phrase hits to only those for a specific phrase category.

  1. Click [limit].
  2. Select Phrase Category.
  3. In the Field panel, select Phrase Category.
  4. Clear the All values check box.
  5. Select the category whose phrase hits you want to see.
  6. Click Add.

NOTE   If you would like to see hits from all phrase categories but see only one category at a time on your dashboard, see the Data Explorer Quick Start Guide: Filter Reports on Your Dashboard.

Step 3: Change the report to a line graph

We’ve made our report as a basic table, but let’s make it look cool.

Set the horizontal axis

  1. Click View (upper right corner of the page).
  2. Under View Type, select Line. Here’s what we get:

    Um, that wasn’t quite what we had in mind. Shouldn’t there be separate lines for each phrase? Let’s fix that.

  3. Click Question (upper right corner of the page).
  4. For the Phrase Category group, select series by from the rows (as categories) by drop-down.
  5. For the Phrase group, select series by from the rows (as categories) by drop-down.

    Whew, that looks better!

Customize the visuals

This step is optional. These instructions explain how to make your report look exactly like the example at the beginning of this guide. Feel free to experiment with your report’s appearance.

  1. Click View.
  2. Under Chart Options, select Curved.
  3. Under Legend, change the Size to 18.
  4. Under Styling, click the square next to Background Color. The Background Color window opens.
  5. Click the white square (in the top row of colors).

  6. Click Done. The Background Color window closes.
  7. Under Titles, turn on Show Title.
  8. Enter the title.
  9. Under Grid Options, click the square next to Line Color. The Grid Lines window opens.
  10. Click the white square.
  11. Click Done. The Grid Lines window closes.
  12. Under Data Series Format, change all the Line Widths to 5.
  13. Under Data Labels, select On from the Labels drop-down.

That’s it! The report is finished. Congratulations!

Step 4: Save the report

  1. Click Save (upper left corner of the page). The Save Report window opens.
  2. Enter a name for the report.
  3. Click Save. The Save Report window closes, and the report name appears in the upper left corner of the page.

Step 5: Share the report

This step is optional, but sharing reports helps you easily communicate the report’s information to other people, like direct reports or upper management. Anyone you share a report with sees only the data they have permission to see, so you don’t need to worry about exposing information to the wrong people.

  1. Click Data Explorer in the top menu.
  2. (Optional) Select Owned by Me from the drop-down list at the top left of the page.
  3. Right-click the report and select Share from the drop-down list. The Sharing window opens.
  4. Select the level of control to give the people you are sharing with.

    Permission What it means
    None No one else can see the report.
    View Other people can see the report but can’t copy it or make any changes to it.
    Explore Other people can adjust the groups and filters in the report but can’t save changes.
    Save As Other people can save their own copy of the report and edit their copy. This is the most commonly used option.
    Edit Other people can edit your original report.
  5. Click OK. The Sharing window closes.

Congratulations, you’ve built a Data Explorer report!

Keep learning about Data Explorer

Our Data Explorer library has a great collection of guides for people who are new to Data Explorer or are looking to grow their skills. Check them out!

For beginners

For QM

For Analytics

For intermediate users