Does anyone know if it is possible to export the Typeform statistics? Not the answers, but the information that comes out regarding the statistics of how many people view the form, how many downloaded it, the question-by-question behavior, etc.
Thanks a lot!
Best answer by john.desborough
the way i do tihis and it is a kludge is to go to the Insights tab and copy al the rows and paste it into a spreadheet - you can do this in Excel or Sheets:and then transpose the data into rows.. lemme walk thorugh a couple of screen shots:
here’s the insights page - well part of it - to give you a starting point:
the next shot is a start to the Sheet after i copy all the rows from the Insights tab above and paste it into the Sheet. it goes in as a single column.
Then i use the transpose() function to turn the column of data into the appropriate horizontal rows of data:
you can see in the image the transpose() function at the top with takes the first three tows and puts them horizontally. repeat this process for all the questions (three rows per each transform to create the table shown in the next image
using the transpose() function for each question row in the insigts table i can come up with the table
now i can do some analysis
note in the image that there are * characters in column F - and in the vertical column - those correspond to the “required” indicator on the questions. When do the transpose for this template, i had to take into account for some rows that only had three cells of data and some that had 4.
now every time i want to ‘update this table in my spreadsheet version, i simply have to go to the insights tab and copy the rows of data and paste it into the same starting cell - the formulae in the ‘transposed columns’ will automatically update and give me the current data.
it may not be perfect but it allows me to go in and create a tab for each month by copying the tab (including the data) - then each month i update the vertical list with the copy of end of month insights and compare to previous month etc.
now if you move questions around etc, to improve your drop off, you can do the same thing but remember to account for, as an example, moving q10 up to q4… when you do your comparison between points in time.
just some thoughts for a taco tuesday
des
+6
the way i do tihis and it is a kludge is to go to the Insights tab and copy al the rows and paste it into a spreadheet - you can do this in Excel or Sheets:and then transpose the data into rows.. lemme walk thorugh a couple of screen shots:
here’s the insights page - well part of it - to give you a starting point:
the next shot is a start to the Sheet after i copy all the rows from the Insights tab above and paste it into the Sheet. it goes in as a single column.
Then i use the transpose() function to turn the column of data into the appropriate horizontal rows of data:
you can see in the image the transpose() function at the top with takes the first three tows and puts them horizontally. repeat this process for all the questions (three rows per each transform to create the table shown in the next image
using the transpose() function for each question row in the insigts table i can come up with the table
now i can do some analysis
note in the image that there are * characters in column F - and in the vertical column - those correspond to the “required” indicator on the questions. When do the transpose for this template, i had to take into account for some rows that only had three cells of data and some that had 4.
now every time i want to ‘update this table in my spreadsheet version, i simply have to go to the insights tab and copy the rows of data and paste it into the same starting cell - the formulae in the ‘transposed columns’ will automatically update and give me the current data.
it may not be perfect but it allows me to go in and create a tab for each month by copying the tab (including the data) - then each month i update the vertical list with the copy of end of month insights and compare to previous month etc.
now if you move questions around etc, to improve your drop off, you can do the same thing but remember to account for, as an example, moving q10 up to q4… when you do your comparison between points in time.
just some thoughts for a taco tuesday
des
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
