Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Pendo: support providing Poll Response PickList Text

Completed
Shawn Sousa User

Right now, any non-free-form poll response is returned as the control's identifier rather than the text for the option selected. This means we cannot use any the Pendo poll event data we've pulled since we can't resolve the ID response to the actual text option the person who is taking the poll selected. 

For example, we have a poll question "How do you make money from photography?" One of the Picklist accepted responses is, "I don't - photography is just a hobby for me." But, the provided poll_response for this returned as "0048peb21b674q". 

Pendo support has provided the following code snippet showing how calling the Aggregation API endpoint can resolve these IDs to the text value they represent:

{
    "response": {},
    "request": {
        "name": "pollIds",
        "pipeline": [
            {
                "source": {
                    "guides": null
                }
            },
            {
                "filter": "id==`{{guideId}}`"
            },
            {
                "select": {
                    "pollId1": "polls[0].id",
                    "pollPrompt1": "polls[0].question",
                    "responses1": "polls[0].idResponses",
                    "pollId2": "polls[1].id",
                    "pollPrompt2": "polls[1].question",
                    "responses2": "polls[1].idResponses",
                    "pollId3": "polls[2].id",
                    "pollPrompt3": "polls[2].question",
                    "responses3": "polls[2].idResponses"
                }
            }
        ],
        "requestId": "pollIds"
    }
}

Can this be added and supported by the Pendo Fivetran connector?

Please sign in to leave a comment.

Comments

6 comments

Date Votes
  • Official comment
    Drew Fivetranner

    Hi Shawn Sousa, Drew from the product team here!

    Thanks for sharing this request. I can see this being a challenge for analytics use cases where polls are used. I'm putting it in the backlog for now, but I'll work on researching how best to support this in the future.

  • Shawn Sousa User

    Thanks for the feedback Drew. We are very active users of polls with our user base, and so we're still very interested in using or even piloting this feature should that opportunity be made available to us. 

  • Benjamin Tengelsen User

    Would be a game changer! As is I ask the pendo admin to give me the CSV responses and I infer which answers are which based on how many of each answer there is. Not really fun or scalable.

  • Calvin Fivetranner

    Hi Everyone, Calvin from the Product team here!

    Quick update on this request - we have completed the implementation of adding PickList text responses to the Pendo schema. You will find a new table called picklist_poll_response with three fields: responseId, pollId, and responseText to help match the current response ID in the poll_event table with the actual response text.

  • Shawn Sousa User

    Calvin thanks for the update! Is there anything we need to do client-side to expose the option to add this table to our connector? Right now I don't see picklist_poll_response in our list of available tables. 

  • Drew Fivetranner

    Hey Shawn Sousa, typically these changes roll out to customers over a few days in cohorts. You should see the table available within the next week. If you do not see it, please respond back here.