Tech Note: How do I use Pendo data with my reporting tool (PowerBI, Tableau, Looker, etc.)?

There is no direct connection between Pendo and common reporting tools such as PowerBI, Tableau, and Looker. Instead, you will need to do the following:

1) Move the data from Pendo into your own data warehouse: Snowflake, databricks, Google BigQuery, etc. Many customers choose to use a third party ETL tool to assist with this. 

2) Connect your data warehouse to the desired BI/reporting tool: PowerBI, Tableau, Looker, etc. 

There are two primary ways to get data out of Pendo. 

 Option 1: Pendo API 

• Request specific Pendo data to answer questions like “How many visitors clicked on a feature in the last 6 months, month by month?”
• Not designed for bulk export, each request is limited to 5 minutes/ 4 GB response size.
• Get access to processed data with page/feature events limited to hour-level granularity.
  

Learn more via these resources:

• Pendo Academy: Pendo API Course
• Help article: Setting up an integration key
• Developer Documentation: Engage API documentation

 Option 2: Pendo Data Sync

• Export your Pendo data in bulk to support more complex queries and analysis
• Set up recurring daily exports and backfill up to three calendar years of historical data to a cloud storage destination.
• Get access to processed data, specifically unaggregated events with exact timestamps and URLs.

Learn more via these resources:

• Short demo video: Connect Pendo data across your business
• Customer success stories and blog posts related to Data Sync
• Pendo Academy: Data Sync Course
• Help Article: Overview of Pendo Data Sync