Skip to main content

Business Intelligence (BI)

Showpad's data enables you to take a deep dive into your content and gain valuable insights into how your content and training is being used and interacted with:

  • Content - What content is your sales team is using? What content resonates with prospects?

  • Sellers - What content and learning courses are your top salespeople consuming?

  • Engagement - Are your emails being opened? What pages are viewed, downloaded, and shared?

This is just a few of the questions you can answer with your Showpad data. The possibilities are endless. Need some inspiration? Keep reading!

BI = API v3 use exports endpoints

Scenarios​

do we have any examples of what customers have done/want to do?

User / Asset Interaction​

Want information about the assets a user is interacting with? The Content Reporting (Export) API is available to download a CSV or JSON file of your Showpad data.

  1. Your first stop is the Events export table.
  2. Next, join the User table to the Events table via the userId.
  3. Join the Assets table to the Events table via the assetId.
  4. From here, you can let your imagination run wild!

  • List of assets viewed

  • In-App Views - This will tell you the total number of distinct assets a user has viewed within Showpad.

  • Viewing time - viewing time = difference between start / end time

  • Downloads Per User - The following query returns the number of distinct assets each user has downloaded within a specified date range.

  • track the lifecycle of an asset from creation to share to view

-- events > channelId >

info

events endpoint important to use the logged parameters x-showpad-scroll-id (expand info on this) for Events

Asset Usage​

shared space/asset relation -> which asset belongs to which shared space - check shared space events to see added assets

use logged time to know when an event was logged in Showpad (rather than start/end time)

channels/experiences visited -> events endpoints

does not include coach (coach = OP reports)

Custom Analytics​

General Process​

  1. Showpad data

  2. Scheduled Extract

  3. Data Warehouse (ex. Sharepoint)

  4. BI tool (ex. PowerBI)

    • Load extract (CSV or JSON)

      • into a Data Warehouse (accessible to a BI tool)

    • Transform

      • Prepare/optimize some queries
      • Enrich with company specific data

    • BI Tool

      • Combine data
      • Visualisations