Use a Leaderboard to create a custom Interactions Report and CSV interactions download

Watershed’s Interactions Report allows you to see interaction statements and download a CSV file included in that report’s filter at the click of the button. It’s quick and easy to use, and gives you all the main properties of the xAPI statement. Great!

But what if you want more than just the main properties? What if you need to include some less commonly used property or a specific value within a custom statement extension? In that case what you need is a custom column interactions leaderboard and guess what? This guide explains exactly how to do just that.

Step 1: Organize By Statement

Use Explore to start a new Leaderboard (or start with a report you’ve already set up and filtered and switch it into a Leaderboard). Then, jump into advanced configuration mode.

image1.png

Find the dimensions property and change the statementProperty value to “id”:

image2.png

You’ve now got a leaderboard where every row is a different xAPI statement.

Step 2: Define your CSV columns as measures

Next you need to define which xAPI properties you want to include on your leaderboard and in your CSV download. This is done by creating a measure for each property.

Measures relating to statement data use a STATEMENT_PROPERTY value provider and LAST aggregation. LAST is used because since each row is an individual statement, displaying the LAST value for that statement is the same as displaying the only value. It’s the last of a list of 1.

Here’s the full configuration you’d use to add a column for a context extension value:

{
  "name": "Some extension",
  "aggregation": {
    "type": "LAST"
  },
  "valueProducer": {
    "type": "STATEMENT_PROPERTY",
    "statementProperty": "context.extensions.[https://example.com/example]",
    "caseSensitive": true
  }
}

Measures relating to group data use a GROUPS_OF_TYPE value provider and LAST aggregation.

Here’s the full configuration you’d use to add a column for the person's region group:

{
  "name": "Region",
  "aggregation": {
    "type": "LAST"
  },
  "valueProducer": {
    "type": "GROUPS_OF_TYPE",
    "groupType": "Region"
  }
}

Step 3 (Optional): Download your CSV

You’re all done! Save your report and then click Download Data Tables to get your CSV!

image3.png

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.

If you can't find what you need or you want to ask a real person a question, please contact customer support.