Field | Description |
|---|---|
Integration Key | Enter your Pendo integration key. For information about generating a key, see "Prerequisites," above. |
Region | Select the region from the drop-down list. |
|
Menu |
Description |
||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Report |
Select the report you want to run. The following reports are available:
|
||||||||||||||||||||||||||||||
| Pendo Report | Select the Pendo report you want to pull into Domo. | ||||||||||||||||||||||||||||||
| Source |
Select the desired source for the Row Aggregation report. The following table describes the available sources:
|
||||||||||||||||||||||||||||||
| Guide ID | Enter the ID of the guide you want to retrieve information for. To find the ID for a desired guide, navigate to the page for that guide (from the Guides page in Pendo), then copy the last portion of the URL. For example, in the URL [https://app.pendo.io/guides/abcd\_xyz1234](https://app.pendo.io/guides/abcd_xyz1234) , the guide ID would be abcd\_xyz1234 . | ||||||||||||||||||||||||||||||
| Poll ID | Enter the Poll ID to get the details for a specific poll. | ||||||||||||||||||||||||||||||
| Guide Step ID | Enter the Guide Step ID to get the details for a specific guide or step. | ||||||||||||||||||||||||||||||
| Custom Aggregation |
Enter the request json. For example:
```json theme={"dark"}
{
"pipeline": [
{
"limit": 5
}
],
"source": {
"pageEvents": null
},
"timeSeries": {
"count": 1,
"first": 1493596800000,
"period": "dayRange"
}
}
```
Specifying dates - Common examples: `'now()', 'date(yyyy,MM,dd)', '1693540800000' (epoch timestamp), 'yyyy-MM-dd'` |
||||||||||||||||||||||||||||||
| All Guides | Select 'Yes' if you wish to query for all guides. 'No' to select specific ones. | ||||||||||||||||||||||||||||||
| Guides | Select the guides to query. | ||||||||||||||||||||||||||||||
| Do not hash the Visitor ID? | Select this checkbox to NOT use hashing for the visitor ID, by default. | ||||||||||||||||||||||||||||||
| Application Id Selection Type | Select whether to retrieve data from all or only specific application id. | ||||||||||||||||||||||||||||||
| Enter Application IDs | Enter the Application ID for which we need to retrieve the data. | ||||||||||||||||||||||||||||||
| Handle Records |
This field appears when you select the Row Aggregation report and the source as Guides . If you encounter an error when the columns exceeds the allowed limit, you can use one of the following options to handle the records. None – This option is selected by default. It does not handle the error when the column exceeds the specified limit. Skip Step\_Translations Data – The stepTranslations data will be skipped and not added to the dataset. Handle Step\_Translations Data – The data will be flattened to reduce the row count. |
||||||||||||||||||||||||||||||
| Duration (GMT) | Select the duration for the report (a Single Date, or a Date Range). | ||||||||||||||||||||||||||||||
| Report Date | Select the report date using relative or specific dates. Relative indicates the number of days from today or a specific date using the date selector. | ||||||||||||||||||||||||||||||
| Select Specific Date | Select the report date using the date selector. | ||||||||||||||||||||||||||||||
| Days back | The number of days back that you would like to get data for. Specify either today or 0, yesterday or 1, or today-7 or 7 to get data for 7 days into the past. | ||||||||||||||||||||||||||||||
| Start Date | Select the report start date using relative or specific dates. Relative indicates the number of days from today or a specific date using the date selector. | ||||||||||||||||||||||||||||||
| Select Specific Start Date | Select the report date using the date selector. | ||||||||||||||||||||||||||||||
| Days back to start from | The number of days back that you would like to get data from (start day). Specify either today or 0, yesterday or 1, or today-7 or 7 to get data for 7 days into the past. | ||||||||||||||||||||||||||||||
| End Date | Select the report end date using relative or specific dates. Relative indicates the number of days from today or a specific date using the date selector. | ||||||||||||||||||||||||||||||
| Select Specific End Date | Select the report date using the date selector. | ||||||||||||||||||||||||||||||
| Days back to end at | The number of days back that you would like to get data to (end day). Specify either today or 0, yesterday or 1, or today-7 or 7 to get data for 7 days into the past. | ||||||||||||||||||||||||||||||
| Use Report Schema | Select the checkbox if you want to have report schema as column names. |