- It seems that when you view the Results from Control it displays the post´s original location (=category). But, if you export Report to csv, there you can see the location where the post is moved (if it is moved). Why the moved posts and their location cant be seen from Control, without exporting them to csv? There are times when I dont want to export data and the subforum data should be ok, no matter where to look at.
- When I export Analysis report to csv, all the posts doesn´t have subforum & post creation time & username data? They have only postID & post_url & post_description data and nothing else.
Questions about Post fields Analysis
+2
+2Not sure about #1 but for #2, your export the posts report it should contain 17 columns.
+2Not sure about #1 but for #2, your export the posts report it should contain 17 columns.
I cant remember exactly how many columns there are but I think less than 17. Even so, all posts doesnt include all the data.
+2I have created a ticket for this and I will share info to everyone:
- It seems that when you view the Results from Control it displays the post´s original location (=category). But, if you export Report to csv, there you can see the location where the post is moved (if it is moved). Why the moved posts and their location cant be seen from Control, without exporting them to csv? There are times when I dont want to export data and the subforum data should be ok, no matter where to look at.
When I created this topic, and later on ticket to Support, there were posts where category was wrong when viewing Report from Control. For some reason, few days later, categories updated (automatically?) and categories displayed then ok. I have to monitor this now, does this occur again.
- When I export Analysis report to csv, all the posts doesn´t have subforum & post creation time & username data? They have only postID & post_url & post_description data and nothing else.
I got nice tip for this, I have to open .csv file like this and then all the data can be seen.
Normally I have done like this:
- .csv file → Open to Excel
- I activate column A
- I go to the “Data tab” and choose “Text to columns”
- Delimited → Next → Comma → Finish
This will split the data to the columns but for some reason it deletes some data during the process. Is there anyone who know how/why this happens? I am using Macbook, is this just because Office for MacOS is…. 😗 😀
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.