Skip to main content
Feedback

Pendo walkthrough

note

Data Integration currently supports Pendo API version 1.

Pendo is a data analytics tool designed to assist software companies in creating products appealing to customers.

Connection

An Integration Key authenticates requests. After activating the subscription, Admins can create and manage these keys.

Reports

Customization

After establishing a connection, you can create a custom report and select a specific report to pull data from the Pendo API.

Filters

Use the following parameters to filter some of the reports

You can select only one parameter at a time.

  1. Accounts
  2. Track Types
  3. Visitors
  4. All

After selecting a filter, Click To Select, and wait for the drop-down to fetch the necessary data. Choose all the IDs from which you require data.

note

Leaving this field empty has the same effect as choosing All.

Incremental function

Some of the reports are incremental, meaning Data Integration pulls them by time spans. You can use Incremental or All for extraction. If you select the incremental option, specify the date range.

note
  • Start date is mandatory.
  • Data Integration retrieves the data for the date range specified between the start and end dates.
  • If you leave the end date blank, Data Integration pulls the data at the current time of the Data Flow's run.
  • Dates align with the UTC timezone.
  • Use the Last Days Back For Each Run option to gather data from a specified number of days before the selected start date.

To make the request process easier, you can divide the calls into separate chunks (Daily, Weekly, or Monthly).

tip

Use divide by chunks when the data you pull is large, and if you are hitting sizing or timeout limits.

Visitors History

You can pull this report for a single ID to retrieve statistics for many visitors.

Choose the IDs, as collecting all visitors would take a long time.

Requests are limited to the last 180 days and cover a single 24-hour period starting on a specific day. Select a beginning and ending date to retrieve a period of time, and Data Integration automatically sends a separate request for each day in between.

Retrieving details

Data Integration performs API requests using either a POST method with the endpoint https://app.pendo.io/api/v1/aggregation and a specific MongoDB-like query JSON body, or a GET method with a specific URI for https://app.pendo.io.

ReportFiltersIncremental
AccountsAccount IDNo
VisitorsAccount ID, Visitor IDNo
Visitors HistoryVisitor IDYes
EventsAccount ID, Visitor IDYes
Feature EventsAccount ID, Feature ID, Visitor IDYes
Page EventsAccount ID, Page ID, Visitor IDYes
Track EventsAccount ID, Track Type, Visitor IDYes
Features-No
Guides-No
Pages-No
Resports-No
Track Types-No
Pendo's official Help Center

Hard delete feature

Microsoft-SQL Change Tracking with Snowflake target Data Flows features the Include Deleted Rows feature. You can activate Include Deleted Rows.

Procedure

  1. Navigate to the Microsoft SQL Server Data Flow and select Schema.
  2. Choose a dedicated Source Table.
  3. Go to Table settings.
  4. Select the Initiate Migration checkbox and Overwrite Table Migration to match the existing database in SQL Server with the Snowflake table (optional).

Skip this step if you want to keep working with the data in Snowflake that Data Integration has marked as deleted.

note

Data Integration turns off the checkbox after the first Initiate Migration completes.

  1. Click Include Deleted Rows.
note

If you select Include Deleted Rows, the Data Flow will retrieve all changes from the Change Tracking table, including deleted rows. It also adds a __DELETED column to indicate whether the source table deleted the row.

  1. Enable Remove Deleted Rows (optional).
note

This option requires selecting Upsert - Merge in Loading Mode.

caution

By enabling Remove Deleted Rows, Data Integration eliminates and removes all rows with the status True (Delete) from the Snowflake target table.

  1. Click Run.
  2. Connect to Snowflake.
On this Page