CN103220204B - The generation method and apparatus of marketing mail - Google Patents
The generation method and apparatus of marketing mail Download PDFInfo
- Publication number
- CN103220204B CN103220204B CN201210017189.6A CN201210017189A CN103220204B CN 103220204 B CN103220204 B CN 103220204B CN 201210017189 A CN201210017189 A CN 201210017189A CN 103220204 B CN103220204 B CN 103220204B
- Authority
- CN
- China
- Prior art keywords
- user
- database table
- marketing
- marketing target
- field
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Abstract
This application discloses a kind of generation method and apparatus of mail of marketing.Wherein, the generation method of mail of marketing comprises: judge whether to need renewal first to market and be pushed to the marketing target information of the first user in multiple user in mail; When judging to need to upgrade marketing target information, revising marketing target ID corresponding to first user in the first database table and numbering; Read the user profile of the first user in the first database table and the amended ID numbering corresponding with first user; Read from the second database table and number with amended ID the marketing target information associated; And according to first user user profile and number with amended ID the marketing target information associated and generate second and to market mail.By the application, solving personal marketing mail in prior art, when modifying to mail data, needs the problem by carrying out just completing compared with the operation of multi-step amendment to database table, and then reaches the effect of reduced data storehouse operation.
Description
Technical field
The application relates to data processing field, in particular to a kind of generation method and apparatus of mail of marketing.
Background technology
Marketing mail is under the prerequisite of permitting in advance user, is transmitted a kind of network marketing means of valuable information by the mode of Email to targeted customer.Mail marketing has three Fundamentals: user's license, email delivery information, information are valuable to user.Along with the user of the Internet and the continuous increase of content, the demand of user becomes increasingly complex, and traditional one-to-many mail marketing mode cannot meet the requirement of user, so the personal marketing mail of multi-to-multi just arises at the historic moment.
The Mail Contents that in personal marketing mail, each user of the characteristic requirements of multi-to-multi sees is different, is all personalized.Personalized content not only comprises the state of showing user, also comprises the product information of displaying.Along with the continuous increase of market content, need the information of the personalization shown also just more and more.
Personal marketing mail received by user be by mail assemble server the mail data corresponding with user of the variable in e-mail module is replaced, be assembled into mail text formed.So-called e-mail module, is namely the framework of Mail Contents, can sends to the mail that a large amount of users is different with same email template.Email template comprises: often seal all identical information of mail, such as addresser address, promote the homepage link etc. of website, generally directly write in template; The multidate information of some personalizations, such as address name, the date of birth, the relevant information of recommended products, then need to substitute with variable in a template.So-called mail data, be namely the carrier of Mail Contents, all the elements seen in mail are all representing of mail data.In personal marketing mail, the Mail Contents that each user sees is personalized, so need to prepare corresponding mail data to each user, comprises the status data of user, also comprises the data for its personalized product recommended.Wherein, mail data is made up of the database table be organized in terms of rows and columns, is illustrated with table 1.
Table 1
| User's name | User's sex | Age of user | User native place |
| Zhang San | Man | 21 | Zhejiang |
| Li Si | Female | 20 | Beijing |
Wherein, what the first row was placed is the row name information of database table, and wherein " user's name ", " user's sex ", " age of user ", " user native place " is all belong to concrete row name.And the second row, the third line is then corresponding data line, " Zhang San ", and " Li Si " is the occurrence that " user's name " these row are corresponding respectively, and " man " and " female " is the occurrence that " user's sex " these row are corresponding respectively.
Database, first can according to the row name of table and relevant setting when storage, and the structure of this database table first defined, such as user's name, can allocate the size in 20 spaces in advance, user's sex can allocate the size etc. in 10 spaces in advance.Afterwards when the data line that Zhang San is corresponding is come in time, each value (" Zhang San " will be given, " man ", " 21 ", " Zhejiang ") distribute corresponding size, " Zhang San " will take 20 space sizes, and " man " will take 10 space sizes, and the size that so this data line of Zhang San is corresponding is exactly 30 space sizes.The access of system conveniently between data line, except between reserved a certain proportion of free area, is all close between row and row physically.In time having new data line to enter, system can the record of then above last column, and row goes down to store this line in order, and its structural representation as shown in Figure 1.
When needs during newly-increased product information, so first will revise list structure in mail, newly-increased corresponding product information field in table, and then value concrete under upgrading corresponding product information field.And revise list structure and need each row of data to rearrange, because the size of each row of data is different, if read according to the row size of initial data, the misdata of other row can be read.As shown in Figure 2, the position of Li Si's data by Hangzhou to having replaced, if read according to the row size of initial data, the data of other row can be read when reading the data of Li Si, causing read error data.A conclusion can be drawn, once need to revise list structure, when increasing a new displaying field, just must be shifted to all data lines, move between clearancen to the field increased newly and store.If suppose that the cost revising every a line is C, so insert new data line, or upgrade original data, so resource consumption is exactly the cost C of amendment 1 row; If the amendment of list structure, be exactly so the capable cost of amendment N, be C*N, wherein N is the data line in table, because it capable data all will adjust all N; Also need to carry out Data Update to amended row after amendment list structure, the resource consumption of C*N can be brought the capable Data Update of N, so, the resource consumption of 2*C*N can be brought in prior art when increasing product information.The namely amendment of prior art to list structure is dumb, and efficiency is low.
In prior art, increase the flow process of the method for product information as shown in Figure 3, the method comprises the following steps:
Step S1, first determine to need newly-increased product information number, such as an original envelope mail recommends 3 product informations, needs now recommendation 4 products, and that just represents the information needing a newly-increased product.
Step S2, in single table, the field of newly-increased N number of product information, than example described above, is increased to 4 product informations from 3 product informations, and that relevant list structure change is embodied to table 4 by table 2, and table 2 is original list structure:
Table 2
Wherein, the first row represents row name, " name ", " age ", " product IDs _ 1 ", " product name _ 1 ", " product internal memory _ 1 ", " product IDs _ 2 ", " product name _ 2 ", " product internal memory _ 2 ", " product IDs _ 3 ", " product name _ 3 ", " product internal memory _ 3 " are respectively row name.Second row is that data line represents user M1, and name is " Zhang San ", and the age is " 20 ", and three products recommended to it are " 0001 " respectively, " 0002 ", " 0003 ".Wherein the name of 0001 product is " blue evil spirit ", and internal memory is " 8G "; The name of 0002 product is " Meizu ", and internal memory is " 8G "; The name of 0003 product is " Ipod ", and internal memory is " 2G ".After the field that newly-increased product information is relevant, list structure is as shown in table 3, and table 3 is amended list structure:
Table 3
Wherein, part with underscore represents newly-increased product information field, " product IDs _ 4 " represent the ID of the 4th product that marketing mail is recommended to user (Zhang San), " product name _ 4 " represent the name of the 4th product recommended, " product internal memory _ 4 " represent the memory size of the 4th product recommended, and the meaning of other row is constant.
Step S3, upgrades the related data of the 4th recommended products of each user.After list structure has increased the 4th Products Show newly, need to upgrade the data in related data row.After have updated the information of the 4th Products Show of user M1, tables of data becomes as shown in table 4 below:
Table 4
Wherein, the part of band underscore represents the 4th newly-increased product, and the concrete meaning recommends four products to M1 user exactly in mail, first three product is the same with previously described, the ID of the 4th product is " 0004 ", and the name of product is " association ", and internal memory is " 4G ".
Can be found out by above-mentioned analysis, when mail assembling server can only support that single file carries out the reading of data, when using and assemble, the storage of bottom mail data stores by single file with regard to necessary.The bottom data design of other multirow, system can be allowed to think the data of many envelope mails, can assemble many envelope mails to send, often sealing mail all can the content (they are combined and are only complete Mail Contents) of exposition mail, has now just occurred email error.In order to avoid an envelope mail is thought by mistake be the data of sealing mail by system more, in prior art, all personalized exhibition information are all pooled in a table, product information is increased according to the mode of user one line item, building database table, but there is following two problems in the mode that this kind increases product information:
1, in mail data, personalized product information of showing has a large amount of repetitions, waste memory space.Such as, to user M1 recommended products P1, also recommend product P 1 to user M2, so the information of P1 product can provide twice, in the data line respectively in the data line corresponding to M1 user and corresponding to M2 user.
2, in mail data, personalized product information of showing, when revising, needs first to carry out interpolation field to the data line of user, and revises field name, and then revise the data message in each new interpolation field successively, complex operation step.Be originally such as that a user recommends 6 products, each product introduction 3 fields.Present increase product, is turned into a user and recommends 7 products, then not only need the data increasing new product, also will increase by 3 the literary name sections representing new product needs simultaneously.
For personal marketing mail in correlation technique when modifying to mail data, needing to carry out to database table the problem that complex operations just can complete amendment, not yet proposing effective solution at present.
Summary of the invention
The main purpose of the application is the generation method and apparatus providing a kind of mail of marketing, and, needs to carry out to database table the problem that complex operations just can complete amendment when modifying to mail data to solve personal marketing mail in prior art.
To achieve these goals, according to an aspect of the application, a kind of generation method of mail of marketing is provided.Generation method according to the marketing mail of the application comprises: judge whether to need renewal first to market and be pushed to the marketing target information of the first user in multiple user in mail; When judging to need to upgrade marketing target information, revising the ID numbering of marketing target corresponding to first user in the first database table, wherein, in the first database table, storing the user profile of multiple user and the ID numbering of the marketing target corresponding with user; Read the user profile of the first user in the first database table and the amended ID numbering corresponding with first user; Read from the second database table and number with amended ID the marketing target information associated, wherein, in the second database table, store the ID numbering of marketing target and number with ID the marketing target information associated; And according to first user user profile and number with amended ID the marketing target information associated and generate second and to market mail.
To achieve these goals, according to the another aspect of the application, provide a kind of generating apparatus of mail of marketing.According to the generating apparatus of the marketing mail of the application generation method of any one marketing mail for performing the application and proposing.
To achieve these goals, according to the another aspect of the application, provide a kind of generating apparatus of mail of marketing, generating apparatus according to the marketing mail of the application comprises: the first judge module, and marketing for judging whether to need renewal first is pushed to the marketing target information of the first user in multiple user in mail; Modified module, for when judging to need to upgrade marketing target information, revise the ID numbering of marketing target corresponding to first user in the first database table, wherein, in the first database table, store the user profile of multiple user and the ID numbering of the marketing target corresponding with user; First read module, for reading the user profile of the first user in the first database table and the amended ID numbering corresponding with first user; Second read module, numbers with amended ID the marketing target information associated for reading from the second database table, wherein, stores the ID numbering of marketing target and number with ID the marketing target information associated in the second database table; And generation module, for according to first user user profile and number with amended ID the marketing target information associated and generate second and to market mail.
Pass through the application, adopting is stored in the first database table by the information of user, by the data information memory of marketing target in the second database table, by the ID numbering of target of marketing, two database tables are associated simultaneously, compared with prior art: the technical scheme that the application limits is when mail of marketing carries out the amendment of the information of recommending marketing target, only need the information of ID numbering place field in amendment first database table, without the need to revising other any information, to solve in prior art personal marketing mail when modifying to mail data, need by carrying out the problem that complex operations just can complete amendment to database table, and then reach the operation of reduced data storehouse, save system resources consumption and improve the effect of resource utilization ratio.
Accompanying drawing explanation
The accompanying drawing forming a application's part is used to provide further understanding of the present application, and the schematic description and description of the application, for explaining the application, does not form the improper restriction to the application.In the accompanying drawings:
Fig. 1 is the schematic diagram of the raw data base table according to correlation technique;
Fig. 2 is the schematic diagram of the amended database table according to correlation technique;
Fig. 3 is the flow chart shown according to the Update Table storehouse of correlation technique;
Fig. 4 is the block diagram of the marketing mail generating apparatus according to the application first embodiment;
Fig. 5 is the block diagram of the marketing mail generating apparatus according to the application second embodiment;
Fig. 6 is the block diagram of the marketing mail generating apparatus according to the application the 3rd embodiment;
Fig. 7 is the block diagram of the marketing mail generating apparatus according to the application the 4th embodiment;
Fig. 8 is the block diagram of the marketing mail generating apparatus according to the application the 5th embodiment;
Fig. 9 is the flow chart of the marketing mail generation method according to the embodiment of the present application;
Figure 10 is the flow chart being pushed to the product information of user according to the marketing mail generation method amendment of the embodiment of the present application; And
Figure 11 is the flow chart of the marketing mail generation method according to the application's preferred embodiment.
Embodiment
Technical scheme in the application is understood better in order to make those skilled in the art person, below in conjunction with the accompanying drawing in the embodiment of the present application, technical scheme in the embodiment of the present application is clearly and completely described, obviously, described embodiment is only some embodiments of the present application, instead of whole embodiments.Based on the embodiment in the application, the every other embodiment that those of ordinary skill in the art obtain, all should belong to the scope of the application's protection.
The generating apparatus of the marketing mail of the application first embodiment is described, as shown in Figure 4, the generating apparatus of the marketing mail in this embodiment comprises: the first judge module 10, modified module 20, first read module 30, second read module 40 and generation module 50.
When the true directional user of marketing mailing system sends personal marketing mail, need to use mail assembling server to be replaced by the mail data corresponding with user of the variable in e-mail module, then assembling forms mail text.In the embodiment of the present application, be divided into two database tables to preserve the mail data of marketing mail, wherein, schematically illustrating of the first database table is as shown in table 5:
Table 5
| Name | Age | The ID of exhibiting product |
| Zhang San | 19 | 0001，0002，0003 |
| Li Si | 20 | 0001，0003 |
As can be seen from Table 5, only retain the information of original database table user in first database table and be pushed to the ID numbering of user for the product shown, wherein, if when the product being pushed to user is multiple, each ID separates with comma between numbering, in the first database table, using the data rows of storing subscriber information as the first field, can will store the data rows of ID numbering as the second field.For the convenience described and understand, the embodiment of the present application is described to send product information to user in mail of marketing, certainly not applying for that embodiment is not limited to is only send product information to user, also can be send any advertising message, such as, e-magazine, e-novel, video information etc., therefore, the recommendation information sent to user in the embodiment of the present application marketing mail may be summarized to be marketing target information.
When needing amendment to be pushed to the information of the product of user, just need to change the data in mail data, in this embodiment, the generating apparatus of marketing mail judges whether to need renewal first to market mail (namely by the first judge module 10, original e-mail) in be pushed to the product information of certain user, when judging to need renewal to be pushed to the information of the product of this user, the ID that modified module 20 revises propelling movement product corresponding with this user in the first database table numbers, then from the first database table, read out the user profile of this user by the first read module 30 and be pushed to the amended ID numbering of this user, and the ID numbering reading from the second database table read out according to the first read module 30 by the second read module 40 numbers with this ID the product information associated, finally generate the second marketing mail (namely by generation module 50 according to the user profile of certain user read out and the product information that is pushed to this user, marketing mail after renewal) send to this user, wherein, schematically illustrating of second database table is as shown in table 6:
Table 6
| Product IDs | Product name | Product internal memory |
| 0001 | Blue evil spirit | 8G |
| 0002 | Meizu | 2G |
| 0003 | Ipod | 2G |
As can be seen from Table 6, in the second database table, the ID of a storage products numbers and numbers with ID the corresponding product information that is associated.
By the mail generating apparatus in the application first embodiment, adopting is stored in the first database table by the information of user, by the data information memory of product in the second database table, by the ID numbering of product, two database tables are associated simultaneously, corresponding function Executive Module in mail generating apparatus is utilized to carry out reading or the amendment of mail data, compared with prior art: when mail of marketing carries out the amendment of the information pushing product, only need the information of ID numbering place field in amendment first database table, without the need to revising other any information, to solve in prior art personal marketing mail when modifying to mail data, need by carrying out the problem that just can complete amendment compared with the operation of multi-step to database table, and then reach the effect of reduced data storehouse operation.
Particularly, mail generating apparatus in the application first embodiment is when carrying out increasing the product being pushed to user, its concrete structure as shown in Figure 5, the generating apparatus of the marketing mail of this embodiment is compared with the generating apparatus of the marketing mail of the application first embodiment, its difference is, in this embodiment, modified module 20 comprises the first judgement submodule 21, adds submodule 22 and preserves submodule 23.
When mail of marketing needs to newly increase propelling movement product to user Li Si, be described for a newly-increased product, first judges that submodule 21 judges whether the product information of this newly-increased product has been stored in the second database table, when judging that this needs the information of newly-increased product to be stored in the second database table, preserving direct the numbering by the ID corresponding with this newly-increased product of submodule 23 and being stored in the second field corresponding with user Li Si in the first database table; If judge that this needs the information of newly-increased product also for being stored in the second database table and is, first by interpolation submodule 22 ID of newly-increased product to be numbered and product information is stored in the second database table, then the ID corresponding with this newly-increased product numbered be stored in the second field corresponding with user Li Si in the first database table by preserving submodule 23.Wherein, after interpolation submodule 22 adds the information of newly-increased product in the second database table, the second database table is as shown in table 7:
Table 7
| Product IDs | Product name | Product internal memory |
| 0001 | Blue evil spirit | 8G |
| 0002 | Meizu | 2G |
| 0003 | Ipod | 2G |
| 0004 | Association | 4G |
Wherein, the part of underscore is with to represent newly-increased product information.
Accordingly, the first database table after renewal is as shown in table 8 or table 9:
Table 8
| Name | Age | The ID of exhibiting product |
| Zhang San | 19 | 0001，0002，0003 |
| Li Si | 20 | 0001，0003， 0002 |
Table 9
| Name | Age | The ID of exhibiting product |
| Zhang San | 19 | 0001，0002，0003 |
| Li Si | 20 | 0001，0003， 0004 |
Wherein, the part of band underscore represents the ID numbering of the product being newly pushed to user Li Si, and table 8 represents to user Li Si and newly pushed the product that ID is numbered 0002, and the product that this ID is numbered 0002 has been stored in the second database table; Table 9 represents to user Li Si and has newly pushed the product that ID is numbered 0004, the product that this ID is numbered 0004 is not stored in the second database table, to be added to by this newly-increased product after in the second database table and numbers (0004) by the ID preserving submodule 23 and this to be newly increased product by adding submodule 22 again and be stored in the second field corresponding with Li Si in the first database table.
When increasing multiple product newly to certain user, the action of each Executive Module when increasing a product newly to certain user only need be repeated; In like manner, when increasing multiple product newly to multiple user, similar method is adopted.
Particularly, mail generating apparatus in the application first embodiment is when carrying out reducing the product being pushed to user, its concrete structure as shown in Figure 6, the generating apparatus of the marketing mail of this embodiment is compared with the generating apparatus of the marketing mail of the application first embodiment, its difference is, in this embodiment, modified module 20 comprises the second judgement submodule 24 and deletes submodule 25.
When mail of marketing needs to reduce the product pushed to user Zhang San, be described to reduce by a product, second judges that submodule 24 judges that this needs the information of the product reduced whether to be stored in the second field corresponding with user Zhang San in the first database table, when judging that this needs the information of the product reduced to be stored in the first database table, deleting direct the numbering in the second field corresponding with user Zhang San from the first database table by the ID corresponding with this minimizing product of submodule 25 and deleting.Wherein, after the ID corresponding with this minimizing product to number and delete in the second field corresponding with user Zhang San from the first database table by deletion submodule 25, the first database table is as shown in table 10:
Table 10
| Name | Age | The ID of exhibiting product |
| Zhang San | 19 | 0001，0003 |
| Li Si | 20 | 0001，0003 |
Suppose that the ID of the product that marketing mail reduces is numbered the product corresponding to 0002, can find out, table 10, compared with table 5, has deleted the product that ID is numbered 0002 in the second field corresponding with Zhang San.
When reducing multiple product to certain user, the action of each Executive Module when reducing by a product to certain user only need be repeated; In like manner, when reducing multiple product to multiple user, similar method is adopted.
Particularly, when mail generating apparatus in the application first embodiment needs to newly increase the user sending marketing mail, its concrete structure as shown in Figure 7, the generating apparatus of the marketing mail of this embodiment is compared with the generating apparatus of the marketing mail of the application first embodiment, and its difference is, in this embodiment, generating apparatus also comprises the second judge module 70, first preserves module 80, determination module 90, and first searches module 01 and second preserves module 02.
When judging through the second judge module 70 to need to newly increase the user sending marketing mail, need to newly increase a user king five with mail of marketing to be illustrated, first preserves module 80 will preserve in user profile to the first database table of king five, the product being determined to need to be pushed to king five by determination module 90 (suppose this product be numbered the product corresponding to 0003 for ID), first search module 01 find from the second database table this product ID numbering after, preserve module 02 by second this ID numbering is saved in the second field corresponding with king five in the first database table.Wherein, after marketing mail Adds User, the first database table is as shown in table 11:
Table 11
| Name | Age | The ID of exhibiting product |
| Zhang San | 19 | 0001，0002，0003 |
| Li Si | 20 | 0001，0003 |
| King five | 20 | 0003 |
Wherein, the part of underscore is with to represent the user newly increased and the product pushed to this user.
Particularly, when mail generating apparatus in the application first embodiment needs to delete existing user, its concrete structure as shown in Figure 8, the generating apparatus of the marketing mail of this embodiment is compared with the generating apparatus of the marketing mail of the application first embodiment, its difference is, in this embodiment, generating apparatus also comprises second and searches module 03 and removing module 04.
When mail of marketing needs to delete existing user, second searches module 03 inquires about the first database table, get the ID numbering of product needing the user profile of the user deleted and push to this user, the ID that removing module 04 is deleted in the information of this user in the first database table and the second field corresponding with this user numbers.Wherein, after marketing mail deletes certain user (supposing that the user deleted is Li Si), the first database table is as shown in table 12:
Table 12
| Name | Age | The ID of exhibiting product |
| Zhang San | 19 | 0001，0002，0003 |
Table 12 compared with table 5, the user profile of user Li Si and the ID numbering of product pushed to Li Si all deleted.
As can be seen from the description of generating apparatus of above execution mode to marketing mail, without being disorderly increase or the minimizing of carrying out pushing product to existing user, or increase or delete user, only need to change the content in associated databases table, all do not need the structure of this table database table, reach the effect of reduced data storehouse operation.
Corresponding with the embodiment of the generating apparatus of mail of marketing in the embodiment of the present application, present invention also provides the embodiment of marketing mail generation method.
As shown in Figure 9, the generation method of the marketing mail of the embodiment of the present application comprises step S102 to step S110.
Step S102: judge whether to need renewal first to market and be pushed to the product information of the first user in multiple user in mail.In this step, first marketing mail refers to that system had previously sent to the marketing mail of user, first user is a user in multiple user, market mail with a week for the cycle upgrades the product information being pushed to user in the embodiment of the present application, system sends the time of marketing mail for starting point timing with first forward direction user, upgrades marketing mail when timing reaches a week.
Step S104: when judging in step S102 to need renewal to be pushed to the product information of first user, system is modified to the second field corresponding with first user in the first database table, and the first database table is that the ID of the user profile storing multiple user and the product being pushed to each user numbers (ID numbering is stored in the second field).
Step S106: after modifying to the second field corresponding with first user, the information and the amended ID that read the first user in the first database table number.
Step S108: read from the second database table according to the ID numbering read out from the first database table and number with corresponding ID the product information associated, store the ID numbering of product in the second database table and number with ID the product information associated.
Step S110: generate the second marketing mail (that is, upgrade send to the marketing mail of first user) according to the user profile of the first user read from the first database table and the product information being pushed to first user that reads from the second database table.
Particularly, when step S104 increase is pushed to the product of first user, to the amendment of second field corresponding with first user as shown in Figure 10, when mail increase of marketing is pushed to the product of first user, relate to the operation of the first database table to system (M ' table) and the second database table (P ' show), to the concrete steps of the amendment of second field corresponding with first user be: first determine to need to newly increase the number to the product of first user, then judge whether the information of each newly-increased product has been stored in the second database table, if the product information of certain newly-increased product has been stored in the second database table, now directly upgrade the second field that the first database table is corresponding with first user, if judge that the product information of certain newly-increased product is not stored in the second database table, now need first the product information of this newly-increased product to be stored in the second database table, and then the ID of this product numbering is stored in the second field corresponding with first user in the first database table.
When carrying out increasing the product recommending user, adopt the generation method of the marketing mail in the embodiment of the present application, only need the information of ID numbering place field in amendment first database table, without the need to revising other any information, to solve in prior art personal marketing mail when modifying to mail data, need by carrying out the problem that just can complete amendment compared with the operation of multi-step to database table, and then reach the effect of reduced data storehouse operation.
The generation method of the marketing mail in the embodiment of the present application simplifies the operation of database, decrease resource consumption when database table is revised simultaneously, particularly, according to the hypothesis set by the application's background technology part, namely, suppose that the cost revising data line storehouse table is C, when increasing one to N number of use per family newly and pushing product, if this newly-increased product is stored in the second database table, the resource consumption that then newly-increased propelling movement product brings is N*C, if this newly-increased product is not stored in the second database table, the resource consumption that then newly-increased propelling movement product brings is C+N*C, no matter be that N*C or C+N*C is all less than 2*N*C.
Wherein, step S106, S108 and S110 reads amended first tables of data, and according to the product information in ID numbering reading second database table read from the first database table, to upgrade the idiographic flow of marketing mail as shown in figure 11, according to the product information in ID numbering reading second database table read from the first database table, to upgrade the idiographic flow step of marketing mail be:
1, the data line (supposing that the data read are " Zhang San, 19, (0001,0002,0003) ") in M ' table is taken out.
2, start circulation, take out the user profile variable (name, age, second) in email template successively.
3, to judge that from M ' table whether each data in the row data that read are the field datas of second.If not, then the 9th step is entered.If so, then the 4th step is entered.
The data of this second field if the data of the second field, are then resolved, are split according to comma by 4, form the list ({ 0001,0002,0003...}) of product IDs.
5, the product IDs (0001) in product IDs list is taken out successively.
6, from P table, corresponding product introduction attribute (suppose that ID is numbered the name of product of 0001 correspondence for blue evil spirit, save as 8G in product) is taken out according to product IDs.
7, the concrete product attribute of other variable of product introduction field level in email template is replaced, such as represent product IDs with PID variable in a template, so just replace PID with 0001 respectively.
8, judge whether that remaining product IDs (0002,0003) in lists in addition.If so, then the 5th step is jumped to, if otherwise enter the 10th step.
9, carry out object and show that other variable of field level replaces (name, age).
10, judged whether that remaining variable is replaced.If so, then jump to the 2nd step, if not, then terminate.
Particularly, be described to reduce by a product, when step S104 minimizing is pushed to the product of first user, the amendment of second field corresponding with first user is comprised: judge whether the information of the product that these needs reduce has been stored in the second field corresponding with user Zhang San in the first database table, when judging that this needs the information of the product reduced to be stored in the first database table, directly the ID corresponding with this minimizing product is numbered in the second field corresponding with user Zhang San from the first database table and delete, afterwards according to step S106, S108 and S110 reads amended first tables of data, and according to the product information in ID numbering reading second database table read from the first database table, to upgrade marketing mail.
When reducing multiple product to certain user, the action of each Executive Module when reducing by a product to certain user only need be repeated; In like manner, when reducing multiple product to multiple user, similar method is adopted.
When mailing system of marketing is judged to need to newly increase the user sending marketing mail, the generation method of the marketing mail of the embodiment of the present application also comprises: preserve in user profile to the first database table Added User, determine to need to be pushed to the product Added User, find the ID numbering of this product from the second database table after, by this ID numbering be saved in the first database table with Add User in the second corresponding field, afterwards according to step S106, S108 and S110 reads amended first tables of data, and according to the product information in ID numbering reading second database table read from the first database table, to upgrade marketing mail.The step newly increasing the user sending marketing mail in the embodiment of the present application can be carried out before marketing mail sends mail to each user, also can carry out after sending mail to certain user or existing whole user at marketing mail.
When mailing system of marketing is judged to need to delete existing user, the generation method of the marketing mail of the embodiment of the present application also comprises: inquire about the first database table, get the ID numbering of product needing the user profile of the user deleted and push to this user, the ID deleted in the information of this user in the first database table and the second field corresponding with this user numbers, afterwards according to step S106, S108 and S110 reads amended first tables of data, and according to the product information in ID numbering reading second database table read from the first database table, to upgrade marketing mail.The step of deleting existing subscriber in the embodiment of the present application can be carried out before marketing mail sends mail to each user, can carrying out after sending mail to certain user at marketing mail, also can carry out after whole user (user except needing to delete) sends mail at marketing mail.
To the description of the generation method of marketing mail as can be seen from above execution mode, no matter be increase or the minimizing of carrying out pushing product to existing user, or increase or delete user, only need to change the content in associated databases table, all do not need the structure of this table database table, reach the effect of reduced data storehouse operation.
The application can describe in the general context of computer executable instructions, such as program module.Usually, program module comprises the routine, program, object, assembly, data structure etc. that perform particular task or realize particular abstract data type.Also can put into practice the application in a distributed computing environment, in these distributed computing environment (DCE), be executed the task by the remote processing devices be connected by communication network.In a distributed computing environment, program module can be arranged in the local and remote computer-readable storage medium comprising memory device.
Although depict the application by embodiment, those of ordinary skill in the art know, the application has many distortion and change and do not depart from the spirit of the application, and the claim appended by wishing comprises these distortion and change and do not depart from the spirit of the application.
Claims (10)
1. to market the generation method of mail, it is characterized in that, comprising:
Judge whether to need renewal first to market and be pushed to the marketing target information of the first user in multiple user in mail;
When judging to need to upgrade described marketing target information, revise the ID numbering of marketing target corresponding to first user described in the first database table, wherein, in described first database table, store the user profile of described multiple user and the ID numbering of the marketing target corresponding with user;
The user profile and the amended ID corresponding with described first user that read the described first user in described first database table number;
Read from the second database table and number with amended ID the marketing target information associated, wherein, in described second database table, store the ID numbering of marketing target and number with ID the marketing target information associated; And
According to described first user user profile and number with described amended ID the marketing target information associated and generate second and to market mail.
2. generation method according to claim 1, it is characterized in that, described first database table comprises the first field and the second field, the user profile of described multiple user is stored in described first field, the ID numbering of the marketing target corresponding with user is stored in described second field, wherein, the step revising the ID numbering of marketing target corresponding to first user described in the first database table comprises:
Judge whether the marketing target information of the first marketing target is stored in described second database table, wherein, described first marketing target is the required marketing target being pushed to described first user increased in described second marketing mail;
When judging that the marketing target information of described first marketing target is stored in described second database table, ID corresponding for target of marketing being numbered be saved in the second field corresponding with described first user in described first database table in described second database table with described first; And
When judging that the marketing target information of described first marketing target is not stored in described second database table, add the ID numbering of described first marketing target and market the marketing target information of target in described second database table with described first, and in extremely corresponding with described first user in described first database table the second field of the ID numbering of preserving described first marketing target.
3. generation method according to claim 1, it is characterized in that, described first database table comprises the first field and the second field, the user profile of described multiple user is stored in described first field, the ID numbering of the marketing target corresponding with user is stored in described second field, wherein, the step revising the ID numbering of marketing target corresponding to first user described in the first database table comprises:
Judge whether the ID numbering of the second marketing target is stored in the second field corresponding with described first user in described first database table, wherein, described second marketing target is that described first marketing mail push is to marketing target of deleting required in the marketing target of described first user; And
When judging that the ID numbering of described second marketing target is stored in the second field corresponding with described first user, the described second ID marketing target deleted in the second field corresponding with described first user numbers.
4. generation method according to claim 1, it is characterized in that, described first database table comprises the first field and the second field, the information of multiple user is stored in described first field, in described second field, store the ID numbering of the marketing target corresponding with user, described method also comprises:
Judge whether the information increasing by the second user to described first database table, wherein, described second user is the user of required increase;
When judging to increase the information of the second user to described first database table, in the first field in the user profile of preserving described second user to described first database table;
Determine the marketing target being pushed to described second user, as the 3rd marketing target;
Search described second database table, obtain the ID numbering of described 3rd marketing target; And
Preserve in the second field corresponding with described second user in the ID numbering to described first database table of described 3rd marketing target.
5. generation method according to claim 1, is characterized in that, described method also comprises:
Search described first database table, the acquisition user profile of the 3rd user and the ID of the marketing target corresponding with described 3rd user number, and wherein, described 3rd user is the user needing to reduce; And
The user profile of described 3rd user that deletion gets and the ID of the marketing target corresponding with described 3rd user number.
6. to market the generating apparatus of mail, it is characterized in that, comprising:
First judge module, markets for judging whether to need renewal first and is pushed to the marketing target information of the first user in multiple user in mail;
Modified module, for when judging to need to upgrade described marketing target information, revise the ID numbering of marketing target corresponding to first user described in the first database table, wherein, in described first database table, store the user profile of described multiple user and the ID numbering of the marketing target corresponding with user;
First read module, numbers for the user profile and the amended ID corresponding with described first user reading the described first user in described first database table;
Second read module, numbers with amended ID the marketing target information associated for reading from the second database table, wherein, stores the ID numbering of marketing target and number with ID the marketing target information associated in described second database table; And
Generation module, for according to described first user user profile and number with described amended ID the marketing target information associated and generate second and to market mail.
7. generating apparatus according to claim 6, it is characterized in that, described first database table comprises the first field and the second field, the user profile of described multiple user is stored in described first field, the ID numbering of the marketing target corresponding with user is stored in described second field, wherein, described modified module comprises:
First judges submodule, and for judging whether the marketing target information of the first marketing target is stored in described second database table, wherein, described first marketing target is the required marketing target being pushed to described first user increased in described second marketing mail;
Add submodule, for when judging that the marketing target information of described first marketing target is not stored in described second database table, adding the ID numbering of described first marketing target and market the marketing target information of target extremely in described second database table with described first; And
Preserve submodule, be saved in the second field corresponding with described first user in described first database table for ID corresponding for target of marketing with described first in described second database table is numbered.
8. generating apparatus according to claim 6, it is characterized in that, described first database table comprises the first field and the second field, the user profile of described multiple user is stored in described first field, the ID numbering of the marketing target corresponding with user is stored in described second field, wherein, described modified module comprises:
Second judges submodule, for judging whether the ID numbering of the second marketing target is stored in the second field corresponding with described first user in described first database table, wherein, described second marketing target is that described first marketing mail push is to marketing target of deleting required in the marketing target of described first user; And
Delete submodule, for when judging that the ID numbering of described second marketing target is stored in the second field corresponding with described first user, the described second ID marketing target deleted in the second field corresponding with described first user numbers.
9. generating apparatus according to claim 6, it is characterized in that, described first database table comprises the first field and the second field, the information of multiple user is stored in described first field, in described second field, store the ID numbering of the marketing target corresponding with user, described generating apparatus also comprises:
Second judge module, for judging whether the information increasing by the second user to described first database table, wherein, described second user is the user of required increase;
First preserves module, for when judging to increase the information of the second user to described first database table, in the first field in the user profile of preserving described second user to described first database table;
Determination module, for determining the marketing target being pushed to described second user, as the 3rd marketing target;
First searches module, for searching described second database table, obtains the ID numbering of described 3rd marketing target; And
Second preserves module, for preserving in the second field corresponding with described second user in the ID numbering to described first database table of described 3rd marketing target.
10. generating apparatus according to claim 6, is characterized in that, described generating apparatus also comprises:
Second searches module, and for searching described first database table, the acquisition user profile of the 3rd user and the ID of the marketing target corresponding with described 3rd user number, and wherein, described 3rd user is the user needing to reduce; And
Removing module, the ID for the user profile and the marketing target corresponding with described 3rd user of deleting described 3rd user got numbers.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210017189.6A CN103220204B (en) | 2012-01-19 | 2012-01-19 | The generation method and apparatus of marketing mail |
| HK13110858.5A HK1183574A1 (en) | 2012-01-19 | 2013-09-24 | Method for generating marketing mailings and device thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210017189.6A CN103220204B (en) | 2012-01-19 | 2012-01-19 | The generation method and apparatus of marketing mail |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103220204A CN103220204A (en) | 2013-07-24 |
| CN103220204B true CN103220204B (en) | 2016-02-03 |
Family
ID=48817686
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210017189.6A Active CN103220204B (en) | 2012-01-19 | 2012-01-19 | The generation method and apparatus of marketing mail |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN103220204B (en) |
| HK (1) | HK1183574A1 (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107146095B (en) * | 2016-03-01 | 2021-03-23 | 创新先进技术有限公司 | Method and device for processing display information of mail and mail system |
| CN106384225A (en) * | 2016-09-20 | 2017-02-08 | 焦点教育科技有限公司 | Method for batch transmission of point-to-point notifications based on customized variable fields |
| CN106921559A (en) * | 2017-02-08 | 2017-07-04 | 网易无尾熊（杭州）科技有限公司 | Method and apparatus for sending Email |
| CN109375919A (en) * | 2018-11-30 | 2019-02-22 | 成都知道创宇信息技术有限公司 | A method of generating and send marketing Mail Contents page |
| CN113221520B (en) * | 2021-05-19 | 2023-08-22 | 广州天源信息科技股份有限公司 | Method, system and storage medium for generating reminding mail |
| CN116308516B (en) * | 2023-05-24 | 2023-08-25 | 广州钛动科技股份有限公司 | E-mail marketing content generation method and system based on public cloud AI technology |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101071437A (en) * | 2007-03-28 | 2007-11-14 | 腾讯科技（深圳）有限公司 | User classifying method, directional advertising launching method, device and system |
| CN101546406A (en) * | 2008-03-25 | 2009-09-30 | 英业达股份有限公司 | Game marketing system and device |
-
2012
- 2012-01-19 CN CN201210017189.6A patent/CN103220204B/en active Active
-
2013
- 2013-09-24 HK HK13110858.5A patent/HK1183574A1/en unknown
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101071437A (en) * | 2007-03-28 | 2007-11-14 | 腾讯科技（深圳）有限公司 | User classifying method, directional advertising launching method, device and system |
| CN101546406A (en) * | 2008-03-25 | 2009-09-30 | 英业达股份有限公司 | Game marketing system and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103220204A (en) | 2013-07-24 |
| HK1183574A1 (en) | 2013-12-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103220204B (en) | The generation method and apparatus of marketing mail | |
| US10699306B2 (en) | Dynamic digital flyer system | |
| CN108804483B (en) | Rendering method of cell page, server and computer-readable storage medium | |
| CN102722563A (en) | Method and device for displaying page | |
| CN103412881A (en) | Method and system for providing search result | |
| US20140067548A1 (en) | Saving on device functionality for business calendar | |
| CN104025083A (en) | Method and apparatus for providing web pages | |
| CN103605848A (en) | Method and device for analyzing paths | |
| CN103336815A (en) | System and method of pushing network advertising | |
| CN108829809A (en) | A kind of information displaying method and its terminal device, the network equipment | |
| US9262489B2 (en) | Repository-based enterprise search with user customizations | |
| US20190095481A1 (en) | Generating a query | |
| CN104702703A (en) | Method and device for updating data | |
| CN104769624A (en) | Entity based advertisement targeting | |
| CN104808995B (en) | A kind of method and apparatus for across application collection application content | |
| US9747295B1 (en) | Updating a large dataset in an enterprise computer system | |
| JP2014174806A (en) | Information distribution device, information distribution method, and information distribution program | |
| CN105718491A (en) | Updating method and device between databases | |
| CN100538706C (en) | A kind of method and apparatus that shows electrical form | |
| CN105512281A (en) | Display method and device for official website type research result page | |
| US8271875B2 (en) | Providing help information | |
| CN111339064A (en) | Data tilt correction method, device and computer readable storage medium | |
| Bae et al. | A time-varying lot sizes approach for the economic lot scheduling problem with returns | |
| CN116186371A (en) | Page display method and device, computer equipment and storage medium | |
| US10884765B1 (en) | Object configuration dynamic graphical user interface |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 1183574 Country of ref document: HK |
|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: GR Ref document number: 1183574 Country of ref document: HK |