NPS in Google Sheets from Different Entry Methods | Community
Skip to main content
Answered

NPS in Google Sheets from Different Entry Methods

  • December 20, 2023
  • 1 reply
  • 62 views
J

 

Hi everyone,

I'm using Typeform in NPS email campaigns where users can respond by clicking trackable buttons in the email integrated in the URL (directing them to the second page of Typeform for detailed feedback on their score) or a standard link (leading to the first page with scoring buttons) for those who can’t click on the button. This dual method is causing score data to be logged in separate columns in Google Sheets. I’m looking a solution to merge these data streams into a single column for uniform analysis. The email contains both clickable score buttons (tracked links) and a regular link for users to copy/paste or click directly, so 2 columns in my sheet

If you have one idea, currently i’m doing the merge on the google sheet  by creating a new column but it’s not optimal :)

 

Best

Best answer by MjP2

I’d say it’s totally fine to do this in Google Sheets. All in all, I have experienced that Google Sheets that are linked to a live Typeform are prone to breaking if you add custom stuff on the sheet. Hence, my approach is always to create a new sheet (i.e. tab) in the document and from there I refer to the actual live sheet where the data flows from Typeform.

Sometimes I have several Typeforms linked to the same Google Sheets document and I combine the data on a separate sheet in the same document. This is useful because it allows me to use the power of Google Sheets for merging the data just the way I need it.

This cleaned-up data can then be reported elsewhere if needed. In my case I have created dashboards in Looker Studio using this approach. 

View original

1 reply

M
Forum|alt.badge.img
  • MjP2
  • Socializer
  • 7 replies
  • Answer
  • December 20, 2023

I’d say it’s totally fine to do this in Google Sheets. All in all, I have experienced that Google Sheets that are linked to a live Typeform are prone to breaking if you add custom stuff on the sheet. Hence, my approach is always to create a new sheet (i.e. tab) in the document and from there I refer to the actual live sheet where the data flows from Typeform.

Sometimes I have several Typeforms linked to the same Google Sheets document and I combine the data on a separate sheet in the same document. This is useful because it allows me to use the power of Google Sheets for merging the data just the way I need it.

This cleaned-up data can then be reported elsewhere if needed. In my case I have created dashboards in Looker Studio using this approach. 

Grace
1 person likes this
  • Grace
    Grace

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs