Survey questionnaire aggregation method, device, server, and storage medium

Abstract

The application provides a questionnaire summary method and device, a server and a storage medium. The method is applied to the technical field of questionnaire investigation. The method comprises the following steps: determining a plurality of topic questions matched with at least one preset topic field from a plurality of candidate questions, wherein the plurality of candidate questions come from a plurality of candidate questionnaires to be summarized; mapping a selected option of each topic question to a preset option of a preset question, wherein the preset question has a corresponding relationship with the at least one preset topic field; and determining the distribution of a plurality of preset options of the preset question based on the mapping relationship between the selected options of the plurality of topic questions and the plurality of preset options of the preset question. The method can summarize the plurality of candidate questions to be summarized into a plurality of topic questions, map the selected options of the topic questions to the preset options, and obtain the distribution of the plurality of preset options of the preset question, which is beneficial to analyzing the investigation results of a large number of questionnaires and improves the efficiency of questionnaire summarization.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of questionnaire survey, and in particular to a survey questionnaire summarizing method and device, a server and a storage medium. BACKGROUND

[0002] For different types of customers, the operation personnel often obtain customer feedback by sending different questionnaires. However, similar questions often exist in different questionnaires, and the similar questions in different questionnaires need to be summarized. The steps of the existing summarizing method are: 1, the operation personnel manually judge which questions belong to similar questions, and sort the similar questions in the same order; 2, manually adjust the options of the similar questions to ensure that the option order and the option value of each option are the same; 3, pile up the data of each questionnaire into the same table to realize the statistics of the questionnaire data.

[0003] The existing operation steps are relatively cumbersome, and all the steps are manual operations, which not only has low efficiency, but also is prone to errors when the workload is large. SUMMARY

[0004] The present application provides a survey questionnaire summarizing method, device, server and storage medium, which can improve the efficiency of summarizing the survey questionnaire.

[0005] In a first aspect, a survey questionnaire summarizing method is provided, and the method comprises:

[0006] determining a plurality of question titles from a plurality of candidate questions, the plurality of candidate questions being from a plurality of candidate questionnaires to be summarized; mapping a selected option of each of the plurality of question titles to a preset option of a preset question, the preset question having a corresponding relationship with at least one preset question field; and determining a distribution of the plurality of preset options of the preset question based on a mapping relationship between the selected options of the plurality of question titles and the plurality of preset options of the preset question.

[0007] In a second aspect, a survey questionnaire summarizing device is provided, and the device comprises:

[0008] a determining module configured to determine a plurality of question titles from a plurality of candidate questions, the plurality of candidate questions being from a plurality of candidate questionnaires to be summarized; a mapping module configured to map a selected option of each of the plurality of question titles to a preset option of a preset question, the preset question having a corresponding relationship with at least one preset question field; and the determining module is configured to determine a distribution of the plurality of preset options of the preset question based on a mapping relationship between the selected options of the plurality of question titles and the plurality of preset options of the preset question.

[0009] In a third aspect, a server is provided, comprising:

[0010] a memory for storing executable program code;

[0011] a processor for invoking and running the executable program code from the memory, so that the server performs the method as in the first aspect.

[0012] In a fourth aspect, a computer program product is provided, comprising: computer program code which, when run on a computer, causes the computer to perform the method in the first aspect.

[0013] In a fifth aspect, a computer-readable storage medium is provided, storing computer program code which, when run on a computer, causes the computer to perform the method in the first aspect or any possible implementation manner of the first aspect.

[0014] The application provides a survey questionnaire summarizing method, which comprises the following steps: determining a plurality of topic questions matched with at least one preset topic field from a plurality of candidate questions, wherein the plurality of candidate questions come from a plurality of candidate questionnaires to be summarized; mapping a selected option of each topic question to a preset option of a preset question, wherein the preset question has a corresponding relationship with the at least one preset topic field; and determining a distribution of a plurality of preset options of the preset question based on a mapping relationship between the selected options of the plurality of topic questions and the plurality of preset options of the preset question. Through the above technical solution, the plurality of candidate questions to be summarized can be summarized into the plurality of topic questions, the selected options of the topic questions are mapped to the preset options, and the distribution of the plurality of preset options of the preset question is obtained, which is beneficial to analyzing the survey results of a large number of survey questionnaires and improves the efficiency of questionnaire summarizing.

[0015] It should be understood that the foregoing general description and the following detailed description are only exemplary and explanatory, and are not limiting to the application. BRIEF DESCRIPTION OF DRAWINGS

[0016] Figure 1 is a schematic diagram of communication between a data source and a server provided by an embodiment of the application;

[0017] Figure 2 is a flowchart of a survey questionnaire summarizing method provided by an embodiment of the application;

[0018] Figure 3 is a schematic diagram of a visual interface provided by an embodiment of the application;

[0019] Figure 4is a schematic diagram of a title field configuration operation provided by an embodiment of the present application;

[0020] Figure 5 is a flowchart of a process for determining a title of a survey provided by an embodiment of the present application;

[0021] Figure 6 is a flowchart of another survey summary method provided by an embodiment of the present application;

[0022] Figure 7 is a structural schematic diagram of a survey summary device provided by an embodiment of the present application;

[0023] Figure 8 is a structural schematic diagram of a server provided by an embodiment of the present application. DETAILED DESCRIPTION

[0024] The technical solutions in the present application will be described in detail below with reference to the accompanying drawings. In the description of the embodiments of the present application, unless otherwise specified, " / " represents the meaning of or, for example, A / B can represent A or B: "and / or" in the text only describes the association relationship of the associated objects, which means that there can be three relationships, for example, A and / or B, which means that there are three cases of A alone, A and B together, and B alone. In addition, in the description of the embodiments of the present application, "multiple" means two or more than two.

[0025] Hereinafter, the terms "first" and "second" are only used for descriptive purposes, and cannot be understood as implying or suggesting relative importance or implicitly indicating the number of indicated technical features. Therefore, the features defined with "first" and "second" can explicitly or implicitly include one or more features.

[0026] In the embodiments of the present application, the plurality of candidate questionnaires to be summarized are selected from a plurality of survey questionnaires, wherein the survey questionnaire refers to a questionnaire that collects information by formulating detailed and careful questions and asking the surveyed object to answer the questions; the plurality of survey questionnaires are obtained from a plurality of data sources.

[0027] Figure 1 is a schematic diagram of communication between a data source and a server provided by an embodiment of the present application.

[0028] In some embodiments, the data source is a different business system. For example, the different business systems include: potential customer system, sales system, after-sales system, etc. Each business system can communicate with the server, and each business system can send its plurality of survey questionnaires to the server for storage. Optionally, each business system is connected to the server through a specific data interface, and the server can summarize the data transmitted by each business system through the general data interface.

[0029] In some embodiments, the data sources are different client terminals. For example, the different client terminals include a mobile phone, a computer, a vehicle terminal, etc. Each of the client terminals is capable of communicating with the server, and each of the client terminals is capable of sending its own data to the server for storage.

[0030] Optionally, the data sources further include after-sales investigation, telephone investigation, intelligent maintenance, application (APP) investigation, short message investigation, and manual import.

[0031] It should also be understood that the server is further capable of receiving a plurality of questionnaires sent by different data sources, and the plurality of questionnaires are completed questionnaires. The completed questionnaire is a questionnaire after a respondent has replied. Each of the questionnaires carries a different questionnaire label, which is a questionnaire keyword of the questionnaire or a basic attribute of the questionnaire, wherein the questionnaire keyword is a commonly used questionnaire screening field manually imported by a user, and the basic attribute is a type of the questionnaire. For example, the questionnaire label includes a questionnaire-related item, questionnaire content, questionnaire delivery object, questionnaire delivery channel, and sending questionnaire delivery time, etc.

[0032] For example, as shown in Figure 1 the server is a questionnaire survey platform.

[0033] In some embodiments, the questionnaire survey platform is provided on a virtual server or a physical server, etc., and a user logs in a login address provided by the questionnaire survey platform through a terminal, and then inputs information in a visual interface provided by the questionnaire survey platform. In other embodiments, the visual interface provided by the questionnaire survey platform is installed in the form of an APP on a user terminal, and the input of the user is received based on the user terminal, which includes a mobile terminal such as a mobile phone and a fixed terminal such as a desktop computer.

[0034] Figure 2 is a schematic flowchart of a questionnaire summary method provided by an embodiment of the present application.

[0035] It should be understood that the questionnaire summary method provided by an embodiment of the present application can be applied to a server. Specifically, the questionnaire summary method can be applied to Figure 1 a server regarded as a questionnaire survey platform.

[0036] Referring to Figure 2 the questionnaire summary method includes the following steps.

[0037] Step 201, obtaining a plurality of candidate questionnaires to be summarized.

[0038] The candidate questionnaire includes a plurality of candidate questions and a plurality of selected options of the plurality of candidate questions.

[0039] In the embodiment of the application, the plurality of candidate questions are a plurality of questions to be summarized, and the selected options of the candidate questions are the options of the candidate questions selected by the surveyed object.

[0040] The surveyed object refers to an object to which a questionnaire is put, and the questionnaire refers to a questionnaire that collects data by formulating detailed and careful questions and asking the surveyed object to answer the questions. In the embodiment of the application, the plurality of candidate questionnaires to be summarized are selected from a plurality of questionnaires obtained from a plurality of data sources.

[0041] It should be understood that the questionnaire survey platform can receive the survey results returned by the surveyed object after the questionnaire is put once. Therefore, in order to count customer feedback and make business improvements, the survey results of each questionnaire need to be summarized.

[0042] In some embodiments, the survey results returned by the questionnaires put by each data source change in real time. In order to ensure the timeliness of the data, the survey results corresponding to the plurality of questionnaires need to be updated periodically. For example, each data source synchronously updates its plurality of questionnaires every day.

[0043] Optionally, the plurality of questionnaires are updated periodically.

[0044] In the embodiment of the application, the update period of the questionnaire can be set by itself, and the update period can be set as any one of each natural year, each natural quarter, each natural month, each week, each natural day, and a specified number of days; for example, the default update period is each natural day.

[0045] In some embodiments, step 201 includes:

[0046] The plurality of questionnaires are obtained, and the plurality of questionnaires are completed questionnaires; in response to a filtering condition configuration operation on the visual interface, a basic attribute of the questionnaire is determined, the basic attribute is used to represent a type of the questionnaire; based on the basic attribute, a plurality of candidate questionnaires to be summarized are selected from the plurality of questionnaires.

[0047] In the embodiment of the application, the filtering condition configuration operation is a selection operation of a questionnaire data source, the selection operation is a selection of a data range of the questionnaire data source, and the basic attribute of the questionnaire can be obtained through the data range of the questionnaire data source.

[0048] In the embodiments of the present application, the basic attribute is the type of the questionnaire. Optionally, the basic attribute can include the data source type, the creation time, the surveyed object information, and the type corresponding to other labels. The data source type is used to indicate the source of the questionnaire, including random interview, telephone investigation, intelligent maintenance, APP investigation, etc. The surveyed object information is used to indicate the customer type related to the questionnaire, including the region of the surveyed object, the gender of the surveyed object, the education of the surveyed object, the age of the surveyed object, etc. Optionally, the other labels correspond to the special items of the questionnaire one by one. The special item of the questionnaire is used to indicate other types related to the questionnaire, including the business type of the investigation, the product brand of the investigation, the project to which the questionnaire belongs, etc.

[0049] Exemplarily, Figure 3 is a schematic diagram of a visual interface provided by the embodiments of the present application, referring to Figure 3 As shown in the figure, in the step of configuring the data filtering condition, the basic attribute of the questionnaire can be determined.

[0050] In this way, through the filtering condition configuration operation on the visual interface, the questionnaire survey platform can select the corresponding questionnaire as the plurality of candidate questionnaires to be summarized, realizes the automatic acquisition of the questionnaire, and does not need manual selection, thereby improving the efficiency of acquiring the plurality of candidate questionnaires to be summarized.

[0051] In some embodiments, step 201 includes:

[0052] acquiring a plurality of questionnaires, the plurality of questionnaires being completed questionnaires; determining a questionnaire keyword of the questionnaire; and selecting, based on the questionnaire keyword, a plurality of candidate questionnaires to be summarized from the plurality of questionnaires.

[0053] In the embodiments of the present application, the completed questionnaire is a questionnaire that has been replied by the surveyed object, and the questionnaire keyword is a commonly used questionnaire filtering field manually imported by the user. Optionally, the questionnaire keyword includes the province, the questionnaire source, the questionnaire creation time, etc., and the user can set the questionnaire keyword by himself.

[0054] In this way, based on the questionnaire keyword, the questionnaire survey platform can select the corresponding questionnaire as the plurality of candidate questionnaires to be summarized, realizes the automatic acquisition of the questionnaire, and does not need manual selection, thereby improving the efficiency of acquiring the plurality of candidate questionnaires to be summarized.

[0055] In a possible implementation, before step 201, the method further includes: determining whether the plurality of candidate questionnaires to be aggregated this time are manually imported or configured on a visualization interface; if the plurality of candidate questionnaires to be aggregated this time are manually imported, determining the questionnaire keywords imported by the user as the screening conditions; selecting the plurality of candidate questionnaires to be aggregated from the plurality of survey questionnaires based on the questionnaire keywords; if the plurality of candidate questionnaires to be aggregated this time are configured on the visualization interface, displaying the visualization interface and determining the basic attributes of the survey questionnaires according to the screening condition configuration operation on the visualization interface, and selecting the plurality of candidate questionnaires to be aggregated from the plurality of survey questionnaires based on the basic attributes of the survey questionnaires.

[0056] Optionally, after the plurality of candidate questionnaires to be aggregated are selected, a questionnaire number or a note is set for the plurality of candidate questionnaires to be aggregated in the questionnaire survey platform, and a corresponding relationship between the questionnaire number or the note and the questionnaire keywords or the basic attributes is stored in the server. In this way, when the user views different questionnaire keywords or basic attributes, the candidate questionnaires to be aggregated can be found based on the corresponding relationship, and then the data obtained by aggregation is used to improve the content of the business.

[0057] Optionally, a candidate questionnaire sample database is set for the plurality of candidate questionnaires to be aggregated, and the plurality of candidate questionnaires to be aggregated are stored in the candidate questionnaire sample database. When the original data before aggregation needs to be viewed, the plurality of candidate questionnaires are obtained by directly extracting samples from the candidate questionnaire sample database. Different questionnaire keywords or basic data can set different candidate questionnaire sample databases.

[0058] In some embodiments, the survey questionnaires are pre-stored in the server locally by the plurality of business systems; in other embodiments, the survey questionnaires are obtained by the server from other servers or devices corresponding to the plurality of business systems in real time.

[0059] In a possible implementation, step 201 includes: in a case where the number of survey questionnaires is greater than a preset threshold, selecting the plurality of candidate questionnaires to be aggregated from the survey questionnaires by sampling. The sampling method includes but is not limited to random sampling, stratified random sampling, matrix sampling, whole population sampling, systematic sampling, and multi-stage sampling.

[0060] Optionally, in a case where the number of survey questionnaires is less than or equal to the preset threshold, the plurality of survey questionnaires are determined as the plurality of candidate questionnaires to be aggregated without sampling.

[0061] It should be noted that step 201 is an optional step. In the embodiments of the present application, step 201 can be executed first, and then step 202 is executed, or step 202 is directly executed, and the embodiments of the present application do not limit this.

[0062] Step 202: Identify multiple target questions from multiple candidate questions that match at least one preset question field.

[0063] Among them, many candidate questions come from multiple candidate questionnaires that are yet to be compiled.

[0064] In this embodiment, the preset question field is a field from a preset question or a field similar to a preset question. Optionally, the preset question field is a commonly used field related to the questionnaire that is manually imported by the user.

[0065] Optionally, the target question is obtained by fuzzy matching of the preset question field. For example, when the preset question field is province, the target question that matches the preset question field can be "What is your province?" or "What is your region?". The region is a provincial-level administrative region, which can be any one of a province, autonomous region, municipality, or special administrative region.

[0066] Optionally, the target question is obtained by expanding the matching of the preset question field. For example, when the preset question field is province, the target question that matches the preset question field can be "What is your province?" or "What is your region?", where the region can be any one of the prefecture-level city, county-level city, county, or municipal district.

[0067] In some embodiments, prior to step 202, the method further includes:

[0068] In response to the question field configuration operation on the visualization interface, determine the preset question fields corresponding to the question field configuration operation.

[0069] For example, see Figure 4 As shown in (a), the visualization interface displays multiple selectable question fields. When the user clicks on at least one question field, the selected question field is designated as the preset question field.

[0070] Optionally, in response to the question field configuration operation on the visual interface, after determining the preset question field corresponding to the question field configuration operation, the above method further includes: determining the preset question that matches the preset question field based on the correspondence between the preset question field and the preset question. The preset question field and the preset question have a one-to-one correspondence and are pre-set and imported into the questionnaire survey platform by the operations personnel.

[0071] For example, the correspondence between the preset question field and the preset question is shown in Table 1.

[0072] Table 1

[0073]

[0074] In this way, by configuring the question field on the visual interface, the preset question field is determined, and the question title matching the preset question field is conveniently obtained, without manually determining the question title, simplifying the process of survey questionnaire data aggregation, and improving the efficiency of aggregating multiple candidate questions into question titles.

[0075] In some embodiments, step 202 comprises:

[0076] determining a first similarity between each candidate question and each of the at least one preset question field; determining, as reference questions, candidate questions in the multiple candidate questions having a first similarity greater than or equal to a first similarity threshold; and determining, from the multiple reference questions, multiple question titles based on a second similarity between the multiple reference questions and the preset question.

[0077] In the embodiments of the present application, the reference questions are similar questions of the candidate questions, and optionally, the multiple reference questions are determined as the multiple question titles in response to a confirmation operation on the visual interface. The confirmation operation can be a click operation, or a drag operation, which is not limited in the embodiments of the present application.

[0078] In the embodiments of the present application, the first similarity and the second similarity can be the same or different. For example, the first similarity is 20%, and the second similarity is 50%; or for example, the first similarity is 50%, and the second similarity is 80%.

[0079] Optionally, the step of determining the first similarity comprises: performing natural language processing (NLP) on each candidate question, and then matching the candidate question with the at least one preset question field. For example, the words and parts of speech, semantic relationships, punctuation marks, etc. of each candidate question are analyzed, and then matched with the words and parts of speech, etc. of the at least one preset question field, the similarities of each item are calculated, and the first similarity between the candidate question and the at least one preset question field is obtained by weighted summation of the similarities.

[0080] Optionally, the step of determining the second similarity comprises: dividing the multiple reference questions into short sentences according to punctuation marks, determining whether there is a verb in the short sentences, and if there is a verb, dividing the short sentences again according to the verb; matching each part obtained by dividing the multiple reference questions with the preset question, calculating the similarity of each part; and obtaining the second similarity between the multiple reference questions and the preset question by weighted summation of the similarities of each part.

[0081] In a possible implementation, the multiple topic titles are determined from the multiple reference questions based on the second similarities between the multiple reference questions and the preset question field, including: determining the multiple reference questions with the second similarity greater than a second similarity threshold as the multiple topic titles.

[0082] In a possible implementation, the multiple topic titles are determined from the multiple reference questions based on the second similarities between the multiple reference questions and the preset question field, including: determining the multiple reference questions with the second similarity greater than a second similarity threshold as the multiple topic titles.

[0083] In a possible implementation, the multiple topic titles are determined from the multiple reference questions based on the second similarities between the multiple reference questions and the preset question field, including: determining the multiple reference questions with the second similarity greater than a second similarity threshold as the multiple topic titles.

[0084] In a possible implementation, after the first similarities between the multiple candidate questions and the at least one preset question field are determined, the method further includes: in the case that there is no candidate question with the first similarity greater than or equal to a first similarity threshold in the multiple candidate questions, displaying multiple non-topic questions, the non-topic questions being the candidate questions with the first similarity less than the first similarity threshold in the multiple candidate questions; and determining the multiple non-topic questions as the topic titles in response to a confirmation operation on the at least one non-topic question on the visual interface.

[0085] In a possible implementation, after the first similarities between the multiple candidate questions and the at least one preset question field are determined, the method further includes: displaying the candidate questions with the first similarity greater than or equal to the first similarity threshold and the candidate questions with the first similarity less than the first similarity threshold on the visual interface, and determining the multiple candidate questions as the topic titles in response to a confirmation operation on the multiple candidate questions on the visual interface.

[0086] For example, as shown in (a) of FIG. 5, Figure 5 When the user clicks at least one preset question field, the similarities between the multiple candidate questions and the preset question field are calculated, and (b) of FIG. 5 displays the candidate questions with the first similarity less than the first similarity threshold in the multiple candidate questions, and the candidate questions with the first similarity greater than or equal to the first similarity threshold in the multiple candidate questions. Figure 5 When the user selects at least one candidate question in 501 or 502, the selected candidate question is taken as the topic title.

[0087] In this way, the reference question is obtained by the similarity between the candidate question and the preset question field first, and then the multiple reference questions are determined as the target question by the similarity between the reference question and the preset question, so that the same type of questions and similar questions in the questionnaire can be summarized as the same target question, the automatic classification and summarization of the questions in the questionnaire are realized, and the efficiency of summarizing the questionnaire is improved.

[0088] In step 203, the selected option of each target question is mapped to a preset option of the preset question.

[0089] The preset question has a corresponding relationship with at least one preset question field.

[0090] For example, as shown in (b) of FIG. 1, when the user clicks at least one question field, the target question matched with the preset question field is displayed. Figure 4

[0091] In some embodiments, step 203 includes:

[0092] For any target question in the multiple target questions, the selected option of the target question is matched with the multiple preset options to obtain a third similarity between the selected option and the multiple preset options, and the selected option is mapped to the preset option with a similarity greater than or equal to a third similarity threshold.

[0093] In the embodiments of the present application, the third similarity can be the same as or different from the first similarity and the second similarity.

[0094] In the embodiments of the present application, the third similarity is obtained in a manner similar to the step of determining the first similarity, and belongs to the same inventive concept, which will not be described here.

[0095] For example, the preset question is "What is your gender?", the selected option of the target question 1 is "B: female", the selected option of the target question 2 is "A: female", and the selected option of the target question 3 is "A: female". The above method is used to map the selected options of the three target questions to the preset option "A: female".

[0096] In a possible implementation, after the selected option of the target question is matched with the multiple preset options to obtain a third similarity between the selected option and the multiple preset options, the above method further includes: displaying, on the visual interface, a first type of option with a similarity greater than or equal to a third similarity threshold and a second type of option with a similarity less than the third similarity threshold, determining the selected option as the preset option in response to a selection operation on at least one option of the first type of option and the second type of option on the visual interface, and mapping the selected option to the preset option.

[0097] ​In this way, by mapping the selected options of the target topics to the preset options of the preset topics according to the similarity between the selected options of the target topics and the preset options, the answers to the same preset topic in the questionnaire can be classified and summarized, and the efficiency of summarizing the questionnaire can be improved.

[0098] In step 204, the distribution of the preset options of the preset topic is determined based on the mapping relationship between the selected options of the target topics and the preset options of the preset topic.

[0099] In the embodiment of the application, the distribution refers to the proportion of the selected option corresponding to each preset option of the preset topic in the selected options of the target topics.

[0100] In some embodiments, step 204 includes:

[0101] For any preset option in the preset options, the number of the selected options corresponding to the preset option is determined based on the mapping relationship between the selected options and the preset options, and the distribution of the preset options of the preset topic is determined based on the number of the selected options corresponding to the preset option and the number of the selected options of the target topics.

[0102] In the embodiment of the application, the mapping relationship between the selected options and the preset options is a one-to-one correspondence between each selected option and the preset option.

[0103] In the embodiment of the application, the distribution of the preset options of the preset topic is the proportion of the selected option corresponding to each preset option in all selected options.

[0104] It should be understood that in step 204, the selected options of the preset topics are mapped to the preset options of the preset topic, and there is a specific mapping relationship between the selected options and the preset options. Based on the mapping relationship, the number of the selected options corresponding to any preset option can be obtained. Therefore, based on the mapping relationship between the selected options and the preset options, the number of the selected options corresponding to the preset option can be determined.

[0105] In this way, for each preset option, the distribution is obtained by the mapping relationship between the selected options and the preset options, and the reply situation of the preset topic can be intuitively perceived.

[0106] In some embodiments, after step 204, the method further includes:

[0107] determine distribution of a plurality of other preset options of a plurality of other preset questions; the other preset questions are questions other than the preset questions, and the other preset options are target options corresponding to the other preset questions; and generate a questionnaire summary table based on the distribution of the plurality of preset options of the preset questions and the distribution of the plurality of other preset options of the plurality of other preset questions.

[0108] In the embodiments of the present application, the other preset questions are preset questions matched with the other question field, and the other question field is a question field other than the preset question field in a commonly used field related to the questionnaire.

[0109] The step of determining the distribution of the plurality of other preset options of the plurality of other preset questions belongs to the same inventive concept as the above method, and is similar, and will not be described here.

[0110] In a possible implementation, after the questionnaire summary table is generated, the above method further includes: generating a plurality of questionnaire summary tables in the above manner, and performing cross analysis on the plurality of questionnaire summary tables. Optionally, the cross analysis on the plurality of questionnaire summary tables includes the following steps:

[0111] For any questionnaire summary table, a corresponding table name code column is added in the questionnaire summary table; the questionnaire summary table is filtered according to a preset first filtering condition to determine data containing a target field that needs to be analyzed, and data of all questionnaire summary tables is merged according to the target field to form a first intermediate result set; the data of the first intermediate result set is grouped according to the target field and the table name code column values are statistically summarized to form a second intermediate result set; the summary values of the table name code column of each group of the second intermediate result set are statistically summarized, and the summary values of each type of table name code column and the number of each group are counted to form a final result set; and the summary values of each type of table name code column and the number of each group obtained by statistical counting in the final result set are used to determine the intersection and / or difference set relationship between all questionnaire summary tables.

[0112] The table name code column is a code identifier of the questionnaire summary table, and the name is named in accordance with a general data local variable value rule, for example, an after-sales information table is directly coded as 1, and a market research table is directly coded as 2.

[0113] The first filtering condition is mainly used to select data containing the target field, for example, the questionnaire summary table contains information such as the age and gender of the surveyed object user, and in the process of data analysis at a certain time, only the age of the surveyed object user is used, and the age is not used. The age of the surveyed object user can be used as the first filtering condition to filter the data of the questionnaire summary table.

[0114] In the above implementation, the data of the target data tables is merged according to the target fields, mainly after the table name coding columns are added to the target data tables, the data of the target data tables all contain corresponding table name coding column information, and thus the data of the target data tables can be distinguished by the table name coding columns. After the data is merged, all the data is mixed, and many target data tables (data sets) are fused into a large data set, i.e., a first intermediate result set. After the data is merged, the data in the first intermediate result set is grouped according to the target fields, and thus the data from different target data tables that are associated can be put into the same group, and the relationship between the data of the target data tables can be confirmed. After the table name coding columns are set, the data containing the target fields all contain the table name coding column information of the corresponding target data tables, and thus the data in a group can be distinguished by the table name coding columns, which is the purpose and effect of forming a final result set. Specifically, the table name coding columns of the data in a group about the age of the surveyed users are identified and calculated, and thus the target data tables to which the data in a group about the ID belong can be known, and the specific association relationship between the target data tables about the age of the surveyed users can be known. After the data is grouped, the number of associated data between a target data table and other data tables can be known, and the association relationship between the target data tables can be fully analyzed, and the intersection between the target data tables can be fully calculated. Conversely, if there is no intersection between two target data tables, there is a difference set between the two target data tables, and the difference set between the target data tables can be further calculated.

[0115] In this way, by identifying the questionnaire summary tables, tracking the target fields, grouping the data, and analyzing the data, all the intersection and difference sets between multiple questionnaire summary tables can be obtained at one time, and the analysis efficiency is greatly improved.

[0116] The embodiment of the present application provides a questionnaire summary method, which comprises the following steps: determining a plurality of topic questions matched with at least one preset question field from a plurality of candidate questions, wherein the plurality of candidate questions are from a plurality of candidate questionnaires to be summarized; mapping a selected option of each topic question to a preset option of a preset question, wherein the preset question has a corresponding relationship with the at least one preset question field; and determining a distribution of the plurality of preset options of the preset question based on a mapping relationship between the selected option of the topic question and the plurality of preset options of the preset question. Through the above technical solution, the plurality of candidate questions to be summarized can be summarized as a plurality of topic questions, the selected option of the topic question can be mapped to a preset option, and the distribution of the plurality of preset options of the preset question can be obtained, which is beneficial to analyzing the survey results of a large number of questionnaires and improves the efficiency of questionnaire summarization.

[0117] Figure 6 is another flowchart of the questionnaire summarizing method provided by the embodiment of the present application.

[0118] Referring to Figure 6 in combination with the above embodiment, the questionnaire summarizing method comprises the following steps.

[0119] Step 601, judging whether to manually import; if yes, executing Step 602, and if no, executing Step 603.

[0120] The manual import refers to importing the related data of the questionnaire summary table.

[0121] Step 602, selecting the format of the questionnaire summary table and importing the data.

[0122] The format of the summary table can be the table header, the name of the row, the name of the column, etc.

[0123] Step 603, creating the questionnaire summary table.

[0124] The Step 603 creates a binary table containing the field name of the row or column, which is filled in the following steps.

[0125] Step 604, judging whether to match the keyword; if yes, executing Step 605, and if no, executing Step 606.

[0126] The keyword is the questionnaire keyword. For example, the questionnaire keyword includes the delivery time and the delivery channel of the survey questionnaire.

[0127] Step 605, selecting the questionnaire keyword and the special item.

[0128] The special item is a label corresponding to the questionnaire one by one, which includes the business type of the survey, the product brand of the survey, the project to which the survey questionnaire belongs, etc.

[0129] Step 606, judging whether to match the basic field; if yes, executing Step 607; and if no, ending.

[0130] The basic field is the preset question field.

[0131] Step 607, selecting the basic attribute of the data source.

[0132] The basic attribute of the data source corresponds to the basic attribute of the survey questionnaire. The basic attribute needs to be completely matched, and if not matched, the field value corresponding to the basic attribute of the questionnaire summary table can be empty. For example, the basic attribute includes the age, gender, education, income, etc. of the surveyed object.

[0133] Step 608, whether the field value matches; if yes, step 609 is executed, and if no, step 610 is executed.

[0134] The field value is a selected option of the candidate question.

[0135] Step 609, matching the field value.

[0136] Step 610, generating a questionnaire summary table.

[0137] Through the above technical solution, complex data cleaning operations can be visualized and reused later; the same type of questions in different questionnaires issued at different times, through different channels, and for different crowds are classified and summarized, thereby reducing the work of exporting each questionnaire and performing summary for the operation personnel.

[0138] Figure 7 FIG. 1 is a structural schematic diagram of a questionnaire summary device provided by an embodiment of the present application.

[0139] For example, as shown in FIG. 1, the device can include: Figure 7

[0140] The determining module 701 is configured to determine a plurality of question titles that match at least one preset question field from a plurality of candidate questions, the plurality of candidate questions being from a plurality of candidate questionnaires to be summarized.

[0141] The mapping module 702 is configured to map a selected option of each question title to a preset option of a preset question, the preset question having a corresponding relationship with the at least one preset question field.

[0142] The determining module 701 is configured to determine a distribution of the plurality of preset options of the preset question based on a mapping relationship between the selected option of the plurality of question titles and the plurality of preset options of the preset question.

[0143] In other embodiments of the present application, based on the above scheme, the above device further includes an obtaining module, the obtaining module being configured to:

[0144] obtain a plurality of survey questionnaires, the plurality of survey questionnaires all being completed questionnaires; obtain a plurality of survey questionnaires, the plurality of survey questionnaires all being completed questionnaires; in response to a filtering condition configuration operation on the visual interface, determine a basic attribute of the survey questionnaire, the basic attribute being used to represent a type of the survey questionnaire; based on the basic attribute, select a plurality of candidate questionnaires to be summarized from the plurality of survey questionnaires.

[0145] In other embodiments of the present application, based on the above scheme, the determining module 701 is further configured to:

[0146] ​determine a first similarity of each candidate question and each preset question field; determine a candidate question in the plurality of candidate questions as a reference question if the first similarity of the candidate question is greater than or equal to a first similarity threshold; and determine a plurality of question topics from the plurality of reference questions based on a second similarity between the plurality of reference questions and the preset questions.

[0147] In other embodiments of the present application, based on the above scheme, the determining module 701 is further configured to:

[0148] In response to a question field configuration operation on the visualization interface, determine at least one preset question field corresponding to the question field configuration operation.

[0149] In other embodiments of the present application, based on the above scheme, the mapping module 702 is further configured to:

[0150] For any question topic in the plurality of question topics, match the selected option of the question topic with the plurality of preset options to obtain a third similarity between the selected option and the plurality of preset options; and map the selected option to a preset option with a similarity greater than or equal to a third similarity threshold.

[0151] In other embodiments of the present application, based on the above scheme, the determining module 701 is further configured to:

[0152] For any preset option in the plurality of preset options, determine the number of selected options corresponding to the preset option based on the mapping relationship between the selected options and the plurality of preset options; and determine the distribution of the plurality of preset options of the preset question based on the number of selected options corresponding to the preset option and the number of selected options of the plurality of question topics.

[0153] In other embodiments of the present application, based on the above scheme, the determining module 701 is further configured to:

[0154] Determine the distribution of a plurality of other preset options of a plurality of other preset questions; the other preset questions are questions other than the preset questions, and the other preset options are target options corresponding to the other preset questions; and generate a questionnaire summary table based on the distribution of the plurality of preset options of the preset question and the distribution of the plurality of other preset options of the plurality of other preset questions.

[0155] Figure 8 FIG. 1 is a structural schematic diagram of a server according to an embodiment of the present application.

[0156] For example, Figure 8As shown, the server 800 comprises a processor 801, a memory 802 and a communication bus 803, wherein the communication bus 803 is used to realize the communication connection between the processor 801 and the memory 802; the processor 801 is used to execute the communication interaction program stored in the memory 802, so that the server can execute any one of the questionnaire summary methods introduced above.

[0157] Optionally, the server can be specifically regarded as a questionnaire survey platform.

[0158] The embodiment can divide the function modules of the server according to the above method examples, for example, each function module can be corresponded, or two or more functions can be integrated in one processing module, and the integrated module can be realized in the form of hardware. It should be noted that the division of the modules in the embodiment is illustrative, and is only a logical function division, and another division mode can be used in actual implementation.

[0159] In the case of dividing each function module according to each function, the server can comprise a display module, a merging module, a verification module, a display module and a processing module, etc. It should be noted that all related contents of each step involved in the above method embodiment can be referred to the function description of the corresponding function module, and will not be repeated here.

[0160] The server provided in the embodiment is used to execute the above questionnaire summary method, and therefore the same effect as the above implementation method can be achieved.

[0161] In the case of using the integrated unit, the server can comprise a processing module and a storage module. The processing module can be used to control and manage the actions of the server. The storage module can be used to store the program codes and data executed by the server.

[0162] The processing module can be a processor or a controller, which can realize or execute various exemplary logical blocks, modules and circuits described in combination with the disclosure of the present application. The processor can also be a combination of computing functions, such as one or more microprocessor combinations, digital signal processing (DSP) and microprocessor combinations, etc. The storage module can be a memory.

[0163] The embodiment provides a computer readable storage medium, which stores instructions, when the instructions run on a computer or a processor, the computer or the processor executes any one of the questionnaire summary methods introduced above.

[0164] The embodiment further provides a computer program product containing instructions, which, when executed on a computer or processor, causes the computer or processor to perform the above related steps to realize any one of the survey questionnaire summarizing methods introduced above.

[0165] In the embodiment, the server, the computer readable storage medium, the computer program product containing instructions or the chip are used to execute the corresponding method provided above, and thus the beneficial effects thereof can refer to the beneficial effects of the corresponding method provided above, which will not be repeated here.

[0166] Through the above description of the embodiments, those skilled in the art can understand that, for the convenience and brevity, only the above division of the functional modules is taken as an example, and in actual application, the above functions can be completed by different functional modules according to needs, that is, the internal structure of the device is divided into different functional modules to complete all or part of the functions described above.

[0167] In the embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other manners. For example, the device embodiments described above are only schematic; the division of the modules or units is only a logical function division, and there can be another division manner in actual implementation; for example, a plurality of units or components can be combined or integrated into another device, or some features can be ignored or not executed. In addition, the displayed or discussed mutual couplings or direct couplings or communication connections between different units, can be indirect couplings or communication connections through some interfaces, devices or units, and can be electrical, mechanical or in other forms.

[0168] The above only serves as a specific implementation of the present application, but the protection scope of the present application is not limited thereto, and any person skilled in the art can easily think of changes or replacements within the technical range disclosed in the present application, which should be covered in the protection scope of the present application. Therefore, the protection scope of the present application should be subject to the protection scope of the claims.

Claims

1. A method for summarizing questionnaires, characterized in that, include: From a pool of candidate questions, identify multiple target questions that match at least one preset question field, wherein the multiple candidate questions are derived from multiple candidate questionnaires to be aggregated; Each selected option of the target question is mapped to a preset option of a preset question, and the preset question has a corresponding relationship with the at least one preset question field; Based on the mapping relationship between the selected options of the multiple target questions and the multiple preset options of the preset questions, the distribution of the multiple preset options of the preset questions is determined.

2. The method according to claim 1, characterized in that, Before determining multiple target questions that match at least one preset question field from multiple candidate questions, the method further includes: Obtain multiple questionnaires, all of which are completed questionnaires; In response to the filter configuration operation on the visual interface, the basic attributes of the questionnaire are determined, which are used to indicate the type of the questionnaire; Based on the aforementioned basic attributes, multiple candidate questionnaires to be summarized are selected from the multiple questionnaires.

3. The method according to claim 1, characterized in that, The step of determining multiple target questions from multiple candidate questions that match at least one preset question field includes: Determine the first similarity between each of the candidate questions and the at least one preset question field; Candidate questions with a first similarity greater than or equal to a first similarity threshold among the plurality of candidate questions are identified as reference questions; Based on the second similarity between multiple reference questions and the preset questions, the multiple target questions are determined from the multiple reference questions.

4. The method according to claim 3, characterized in that, Before determining the first similarity between each of the candidate questions and the at least one preset question field, the method further includes: In response to a question field configuration operation on a visual interface, determine the at least one preset question field corresponding to the question field configuration operation.

5. The method according to claim 1, characterized in that, The step of mapping the selected option of each target question to a preset option of a preset question includes: For any target question among the plurality of target questions, the selected option of the target question is matched with the plurality of preset options to obtain a third similarity between the selected option and the plurality of preset options; The selected option is mapped to a preset option whose similarity is greater than or equal to the third similarity threshold.

6. The method according to claim 1, characterized in that, The determination of the distribution of the multiple preset options of the preset question based on the mapping relationship between the selected options of the multiple target questions and the multiple preset options of the preset question includes: For any one of the plurality of preset options, the number of selected options corresponding to the preset option is determined based on the mapping relationship between the selected option and the plurality of preset options; Based on the number of selected options corresponding to the preset options and the number of selected options for the multiple target questions, the distribution of the multiple preset options for the preset questions is determined.

7. The method according to claim 1, characterized in that, After determining the distribution of the multiple preset options of the preset question based on the mapping relationship between the selected options of the multiple target questions and the multiple preset options of the preset question, the method further includes: Determine the distribution of multiple other preset options for multiple other preset questions; the other preset questions are questions other than the preset questions, and the other preset options are the target options corresponding to the other preset questions; Based on the distribution of multiple preset options for the preset questions and the distribution of multiple other preset options for the multiple other preset questions, a questionnaire summary table is generated.

8. A questionnaire aggregation device, characterized in that, The device includes: The determination module is used to determine multiple target questions that match at least one preset question field from multiple candidate questions, wherein the multiple candidate questions are from multiple candidate questionnaires to be summarized; The mapping module is used to map the selected option of each target question to a preset option of a preset question, wherein the preset question has a corresponding relationship with the at least one preset question field; The determining module is used to determine the distribution of the multiple preset options of the preset question based on the mapping relationship between the selected options of the multiple target questions and the multiple preset options of the preset question.

9. A server, characterized in that, include: Memory, used to store executable program code; A processor for calling and running the executable program code from the memory, causing the server to perform the method as described in any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program that, when executed, implements the method as described in any one of claims 1 to 7.

Images