CN111582942A

CN111582942A - Batch marketing activity generation method and system of customized marketing template

Info

Publication number: CN111582942A
Application number: CN202010398308.1A
Authority: CN
Inventors: 武星燕
Original assignee: Beijing Si Tech Information Technology Co Ltd
Current assignee: Beijing Si Tech Information Technology Co Ltd
Priority date: 2020-05-12
Filing date: 2020-05-12
Publication date: 2020-08-25
Anticipated expiration: 2040-05-12
Also published as: CN111582942B

Abstract

The invention discloses a batch marketing activity generation method and system of a user-defined marketing template, and relates to the field of telecommunication services. The method comprises the following steps: acquiring an attribute combination of marketing elements selected by a planning staff, and generating a planning template according to a combination result and a preset configuration rule and a data storage relation; acquiring planning contents uploaded by a planning staff, and analyzing a planning template according to a preset configuration rule; and filling the planning content into the analyzed planning template according to a preset configuration rule to generate batched marketing activities. The method is suitable for generating the batch marketing activities, compared with the traditional interface configuration marketing mode, the method can greatly reduce the manual operation of policy personnel, can generate the marketing activities rapidly, massively and accurately, simultaneously supports the individual customization of different policy personnel by the batch template, also realizes the flexibility and the expansibility of the batch template, and supports the repeated use.

Description

Batch marketing activity generation method and system of customized marketing template

Technical Field

The invention relates to the field of telecommunication service, in particular to a batch marketing activity generation method and system of a customized marketing template.

Background

At present, with the development of intelligent hardware, the marketing strategy of telecommunication service is concerned with the fusion marketing of intelligent hardware and mobile service on the basis of various combined marketing of traditional basic service and value-added service, and in order to expand income growth points and develop new-mode intelligent hardware product sales, the customer stickiness is increased by combining with the mobile service, and a large amount of marketing activities are required to be frequently promoted.

However, because the product types of the intelligent hardware are rich, the activity planning demand is large, and the traditional mode of combining and configuring through the traditional interface needs to be combined and configured one by one manually, so the planning work is heavy and takes long time, the time of pushing the activity to the market is seriously influenced, and the requirement of batch marketing activities is difficult to meet.

Disclosure of Invention

The invention aims to solve the technical problem of the prior art and provides a batch marketing activity generation method and system of a user-defined marketing template.

The technical scheme for solving the technical problems is as follows:

a mass marketing activity generation method of a user-defined marketing template comprises the following steps:

acquiring an attribute combination of marketing elements selected by a planning staff, and generating a planning template according to a combination result and a preset configuration rule and a data storage relation;

acquiring planning content uploaded by a planning staff, and analyzing the planning template according to the preset configuration rule;

and filling the planning content into the analyzed planning template to generate batched marketing activities.

The invention has the beneficial effects that: the generation method provided by the invention is suitable for generating the batch marketing activities, and is characterized in that a combined interface is provided for a planning person, so that the planning person directly selects the attribute combination of marketing elements through the combined interface, the planning person self-defines a batch activity template in a page mode, only business information concerned by the planning person is reflected in the template, data elements stored at the bottom layer of the system are isolated, the planning person can rapidly customize the activities in batches based on the template, the template with the planning data is analyzed through an IT system, and association rules of the elements and the system storage data are provided, so that the batch activities are automatically generated. Compared with the traditional interface configuration marketing mode, the method and the system can greatly reduce the manual operation of policy personnel, can quickly, massively and accurately generate marketing activities, simultaneously support the individual customization of different policy personnel by the batch template, and also realize the flexibility and the expansibility of the batch template.

Another technical solution of the present invention for solving the above technical problems is as follows:

a system for generating a batched marketing campaign of a custom marketing template, comprising:

the template generating unit is used for acquiring the attribute combination of the marketing elements selected by the planning staff and generating a planning template according to the combination result and the preset configuration rule and the data storage relationship;

the template analysis unit is used for acquiring planning contents uploaded by planning personnel and analyzing the planning template according to the preset configuration rule;

and the example generating unit is used for filling the planning content into the analyzed planning template to generate batched marketing activities.

Advantages of additional aspects of the invention will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention.

Drawings

Fig. 1 is a schematic flow chart provided by an embodiment of a batched marketing campaign generation method according to the present invention;

FIG. 2 is a block diagram of a structure provided by an embodiment of a mass marketing campaign generation system of the present invention;

fig. 3 is a schematic diagram of gear data provided by an embodiment of the batched marketing campaign generation method of the present invention;

fig. 4 is a schematic view of landing information of gear data provided by an embodiment of the batched marketing campaign generation method of the present invention.

Detailed Description

The principles and features of this invention are described below in conjunction with the following drawings, which are set forth to illustrate, but are not to be construed to limit the scope of the invention.

As shown in fig. 1, a flow diagram provided by an embodiment of the batched marketing campaign generation method of the present invention is applicable to generating a batched marketing campaign of a customized marketing template, and includes:

s1, acquiring the attribute combination of the marketing elements selected by the planning staff, and generating a planning template according to the combination result and the preset configuration rule and the data storage relationship;

s2, acquiring the planning content uploaded by the planning personnel, and analyzing the planning template according to the preset configuration rule;

and S3, filling the planning content into the analyzed planning template to generate batched marketing activities.

It should be understood that the generated curated template may be implemented by excel.

It should be noted that the marketing elements may include cash, special money for a secondary card, system recharge, contract charge, payment by stages for a bank card, a promotional item, a mobile phone certificate, a terminal, a main charge, an additional charge, SP service, deduction points, offset points, a member number, a member main charge, a member additional charge, a member special money, and the like, and each marketing element is combined by a marketing attribute, the marketing attribute is a specific item of the marketing element, taking the special money as an example, and the attributes may include: the project manager can configure the specific type of the project, the total amount of the charge, the return in months, how much money is returned in months, the effective period of the return money for the user, whether the user is allowed to participate in the same project activity repeatedly, and the like.

Taking the terminal as an example, the attributes may include: the method comprises the steps of terminal brand, terminal model, terminal cost, machine purchase, cost subsidy mode, terminal model code, terminal brand code, unpacking time limit, whether monthly bottom line consumption is set or not, pre-storage proportion, monthly bottom line consumption amount, machine purchase type, tax rate, contract price, 4G customization, volte, terminal customization type and the like.

These elements, the planner can configure an example through the graphical interface to generate the template, for example, assuming that there are currently 10 mainstream fee packages, the fee ranges from 39 yuan to 199 yuan, and there are currently more mainstream mobile phones 300 with terminal brands and models, which now needs to generate batch planning activities. Assuming that the activity planned by the planning staff is binding a certain main package, the change is not changed in the contract period, the terminal can be purchased with a preferential price, that is, different tariffs and different terminal models are combined and configured, and each combination is an effective activity gear.

By adopting the scheme provided by the invention, template configuration can be used, for example, in the above scene, a planning person only needs to configure a template of a main tariff and a terminal combination, the operation is performed once, then the exported template is stored, batch activity generation can be performed by using the template, the exported template can be divided into two sheet pages of excel, each line of one sheet page can store information of an activity level information page, such as a marketing mode, a contract date, a main pricing code, a main tariff discount and the like, the corresponding table in the lower line can be filled with corresponding numbers, and the table in the lower line can be filled with corresponding numerical values. Each line of another sheet page can store terminal grade information, such as terminal brand, terminal model, machine purchasing money, unpacking time limit, machine purchasing type and the like, the corresponding table in the next line can be filled with corresponding numbers, and the table in the next line can be filled with corresponding numerical values.

In fact, the system has more attributes of the main tariff and the terminal element than the derived information content, but the information is processed by the system and does not need attention to the service planning personnel, so that only the related content configured for the planning personnel is derived, and the attributes of the elements are derived and not derived, and can be controlled by the configuration rule.

For example, whether the element attribute is derived or not can be determined by labeling the element attribute, for example, an element whose EXCE _ FLAG is N is an element that does not need to be derived, and an element whose Y is an element that needs to be derived, and the order of deriving the elements and header presentation information in chinese can also be set.

Then, the planner can use the derived excel template to fill in the tariff and terminal range to be planned, that is, fill in the content of the derived two sheet pages, and then upload the excel file.

The business strategy personnel can use the template excel to directly copy, paste, replace in batch and the like to edit the active content to be strategy.

It is assumed that the filled tariff codes are M101096, M101098 and M061294, and the terminal models are samsung D609, D728 and E578, and the following description will be made by way of example.

The system identifies the attribute of the marketing element according to the English column header information of the second row in the file, and generates the marketing activity by combining the configuration rule of the element attribute.

For example, a rule configuration may identify:

(1) default values for the import attributes may be configured.

(2) The length limit of the imported attribute values may be configured, for example, the length requires a fixed 10-bit string, or the length does not exceed a fixed value.

(3) The incidence relation of the imported attribute can be configured, and when the corresponding value of the input attribute A is a, the attribute B can be configured.

(4) The import attribute value may be configured to be within an enumerated range of values.

(5) It is possible to configure whether the import attribute value is null or non-null.

(6) The import attribute value type may be configured as an integer, a positive real number, or a character.

As shown in table 1, an exemplary element rule configuration information is given below:

TABLE 1

The system then automatically combines according to the templates, which may be, for example:

gear 1, tariff M101096 and three stars D608 model

Gear 2, tariff M101096 and three stars D728 type

Gear 3, charge M101096 and three stars E578 model

.........

According to 3 charges and 3 terminal models imported by a template, the three are automatically combined into 9 gears, namely 9 activities, and then the system stores and generates gear data, as shown in fig. 3, an exemplary generated gear data schematic diagram is provided, and as shown in fig. 4, an exemplary schematic diagram is provided, wherein the gear data system landing information of the first gear is taken as an example, and as can be seen from the diagram, H26 element default configuration default terms and main charges H10 and element information automatically supplemented by the system in the terminal H09 are included, which do not need attention to planners, but are information used when subsequent effective activities are used for acceptance.

In the generation method provided by this embodiment, a combination interface is provided for a planning staff, so that the planning staff directly selects an attribute combination of marketing elements through the combination interface, the planning staff self-defines a batch activity template in a page manner, only business information concerned by the planning staff is embodied in the template, data elements stored in a bottom layer of a system are isolated, the planning staff rapidly perform batch customization activities based on the template, the template with planning data is analyzed through an IT system, and association rules of the elements and the system storage data are provided, so that batch activities are automatically generated. Compared with the traditional interface configuration marketing mode, the method and the system can greatly reduce the manual operation of policy personnel, can quickly, massively and accurately generate marketing activities, simultaneously support the individual customization of different policy personnel by the batch template, and also realize the flexibility and the expansibility of the batch template.

Optionally, in some possible embodiments, the preset configuration rule includes at least one of a category, a default value, a length limit, an association, a value range, whether null or not, and a data type of the attribute of the derived marketing element.

Optionally, in some possible embodiments, the method further includes:

the generation process of the marketing campaign is controlled by the DATA _ SINGLE method, the BATCH _ LIMIT method, the match _ RETURN method, and the DATA _ RAGE method.

Wherein:

(1) DATA _ SINGLE method: attribute values configured in multiple batches are not allowed to be duplicated among batches.

(2) BATCH _ LIMIT method: the number of batch configuration pieces cannot exceed the configuration value.

(3) MATH _ RETURN method: the method mainly aims at the conditions that the sum of the monthly sum and the monthly count is required to be consistent with the total sum of the monthly sum and the monthly count in special money, special money of an auxiliary card, system recharging and the like.

(4) DATA _ RAGE method: the attribute values need to be in the configuration range interval, as needed between 0 and 200.

That is, the rule is configured by the element attribute, whether the file imported by the service planning personnel is legal can be verified, meanwhile, the system can supplement the file according to the rule without inputting by the planning personnel, but after the system verification is passed, the information value is automatically calculated according to the configuration default value and the association rule, and then the system can automatically combine according to the template.

Optionally, in some possible embodiments, the method further includes:

and acquiring a query instruction of the planning personnel, searching a target planning template from the generated planning template according to the query instruction and the data storage relation, and sending the target planning template to a query end for the planning personnel to browse or download.

Optionally, in some possible embodiments, the method further includes:

and converting the content contained in the target planning template into service element information.

By converting the downloaded template content into the service element information identified by the service personnel, other data elements accepted and judged by the system can be shielded, and the method is simple and easy to understand.

It is understood that some or all of the alternative embodiments described above may be included in some embodiments.

As shown in fig. 2, a structural framework diagram provided for an embodiment of the batched marketing campaign generation system of the present invention is applicable to generating a batched marketing campaign of a customized marketing template, and includes:

the template generating unit 1 is used for acquiring an attribute combination of marketing elements selected by a planning staff and generating a planning template according to a combination result and a preset configuration rule and a data storage relation;

the template analysis unit 2 is used for acquiring planning contents uploaded by planning personnel and analyzing the planning template according to a preset configuration rule;

and the example generating unit 3 is configured to fill the planning content into the analyzed planning template, so as to generate batched marketing campaigns.

The generation system provided by this embodiment provides a combination interface for a planning staff, so that the planning staff directly selects attribute combinations of marketing elements through the combination interface, the planning staff self-defines batch activity templates in a page mode, only business information concerned by the planning staff is embodied in the templates, data elements stored in the bottom layer of the system are isolated, the planning staff rapidly perform batch customization activities based on the templates, the templates with the planning data are analyzed through an IT system, and association rules of the elements and the system storage data are provided, so that batch activities are automatically generated. Compared with the traditional interface configuration marketing mode, the method and the system can greatly reduce the manual operation of policy personnel, can quickly, massively and accurately generate marketing activities, simultaneously support the individual customization of different policy personnel by the batch template, and also realize the flexibility and the expansibility of the batch template.

Optionally, in some possible embodiments, the instance generating unit 3 is further configured to control the generation process of the marketing campaign by a DATA _ SINGLE method, a BATCH _ LIMIT method, a match _ RETURN method, and a DATA _ RAGE method.

Optionally, in some possible embodiments, the method further includes:

and the template query unit 4 is used for acquiring a query instruction of the planning staff, searching the target planning template from the generated planning template according to the query instruction and the data storage relation, and sending the target planning template to a query end for the planning staff to browse or download.

Optionally, in some possible embodiments, the template query unit 4 is further configured to convert the content contained in the target planning template into the service element information.

It should be noted that the above embodiments are product embodiments corresponding to the previous method embodiments, and for the description of each optional implementation in the product embodiments, reference may be made to corresponding descriptions in the above method embodiments, and details are not described here again.

The reader should understand that in the description of this specification, reference to the description of the terms "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, the schematic representations of the terms used above are not necessarily intended to refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.

In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described method embodiments are merely illustrative, and for example, the division of steps into only one logical functional division may be implemented in practice in another way, for example, multiple steps may be combined or integrated into another step, or some features may be omitted, or not implemented.

While the invention has been described with reference to specific embodiments, it will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention as defined by the appended claims. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.

Claims

1. A mass marketing campaign generation method of a user-defined marketing template is characterized by comprising the following steps:

2. The method for generating a batched marketing campaign by using a customized marketing template according to claim 1, wherein the preset configuration rule comprises at least one of a type, a default value, a length limit, an association relationship, a value range, whether the attribute is null, and a data type of the derived marketing element.

3. The method for batched marketing campaign generation of customized marketing template according to claim 1, further comprising:

4. The method for batched marketing campaign generation of a custom marketing template according to any of claims 1 to 3, further comprising:

and acquiring a query instruction of a planning staff, searching a target planning template from the generated planning template according to the query instruction and the data storage relation, and sending the target planning template to a query end for the planning staff to browse or download.

5. The method for batched marketing campaign generation of customized marketing template according to claim 4, further comprising:

6. The utility model provides a batched marketing campaign generating system of self-defined marketing template which characterized in that includes:

7. The system for batched marketing campaign generation of customized marketing template according to claim 1, wherein the preset configuration rule comprises at least one of a category, a default value, a length limit, an association relationship, a value range, whether null or not, and a data type of the attribute of the derived marketing element.

8. The system for batched marketing campaign generation of customized marketing templates of claim 1, wherein the instance generation unit is further configured to control the generation process of the marketing campaign by a DATA _ SINGLE method, a BATCH _ LIMIT method, a match _ RETURN method, and a DATA _ RAGE method.

9. The system for batched marketing campaign generation of custom marketing templates of any of claims 1-3, further comprising:

and the template query unit is used for acquiring a query instruction of a planning staff, searching a target planning template from the generated planning template according to the query instruction and the data storage relation, and sending the target planning template to a query end for the planning staff to browse or download.

10. The system for batched marketing campaign generation of custom marketing templates of claim 4, wherein the template query unit is further configured to convert content contained in the target planning template into business element information.