CN115983910A - Method, system, device and medium for realizing comparison of elevator advertisement putting schemes - Google Patents
Method, system, device and medium for realizing comparison of elevator advertisement putting schemes Download PDFInfo
- Publication number
- CN115983910A CN115983910A CN202211685602.6A CN202211685602A CN115983910A CN 115983910 A CN115983910 A CN 115983910A CN 202211685602 A CN202211685602 A CN 202211685602A CN 115983910 A CN115983910 A CN 115983910A
- Authority
- CN
- China
- Prior art keywords
- item
- attribute information
- target point
- point location
- comparison
- 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.)
- Pending
Links
Images
Landscapes
- Indicating And Signalling Devices For Elevators (AREA)
Abstract
A method, a system, a device and a medium for realizing comparison of elevator advertisement putting schemes are provided, the method comprises the following steps: acquiring normalized attribute information of the target point location and storing the normalized attribute information in a database; acquiring position information of the target point location, wherein the position information at least comprises a fence longitude and latitude coordinate set corresponding to the target point location and a center point longitude and latitude coordinate of a project center corresponding to the target point location; outputting a comparison result corresponding to a comparison item through a preset algorithm based on the comparison item input by a user; the comparison item is generated based on the normalized attribute information; and visually displaying the comparison result on a map based on the comparison result and the position information.
Description
Technical Field
The invention relates to the field of elevator advertisement media delivery, in particular to a method, a system, a device and a medium for realizing comparison of elevator advertisement delivery schemes.
Background
At present, a customer generally selects one or more advertising media channels for regional blind selection for elevator advertising, and the problems of overlapping release of the same floors, missing selection of key points, missed brand maximization, reaching the user and waste of budget often occur.
Therefore, it is necessary to provide a method, a system and a medium for implementing comparison of elevator advertisement delivery schemes, which can be established on a unified digital platform and perform multidimensional cross analysis on core indexes on the platform.
Disclosure of Invention
The invention aims to provide a method, a system and a device for realizing comparison of elevator advertisement putting schemes. The elevator advertisement putting is guided through the unique floors of a plurality of putting channels and the cross comparison result of some core indexes of the point positions so as to solve the problem that the plurality of advertisement channels obtain the maximum exposure with the minimum cost in the same putting period.
In order to achieve the purpose, the invention adopts the following technical scheme:
a method for realizing comparison of elevator advertisement putting schemes comprises the following steps:
acquiring normalized attribute information of the target point location and storing the normalized attribute information to a database;
acquiring position information of the target point location, wherein the position information at least comprises a fence longitude and latitude coordinate set corresponding to the target point location and a center point longitude and latitude coordinate of a project center corresponding to the target point location;
outputting a comparison result corresponding to a comparison item through a preset algorithm based on the comparison item input by a user; the comparison item is generated based on the normalized attribute information;
and visually displaying the comparison result on a map based on the comparison result and the position information.
In some embodiments, the normalized attribute information includes at least one of a media channel name, a city of the location, a project name, a property type, a screen type, and a point location number.
In some embodiments, the obtaining and saving normalized attribute information of the target point location to the database includes:
s1: acquiring a name list of the items to be processed;
s2: acquiring an item fence and a central point coordinate of the item to be processed through a map tool based on the name list of the item to be processed;
s3: judging whether the coordinates of the project fence and the central point are correct or not;
s4: in response, saving the project fence and the center point coordinates to a database;
s5: in response to no, determining an abnormal item name manifest;
s6: cleaning the abnormal project name list based on a first preset rule base to obtain a processed project name list; the first preset rule base comprises at least one cleaning rule;
s7: and based on the processed item name list, returning to the step S3 again and repeating the steps until the item fences and the central point coordinates of all the items to be processed are stored in the database.
In some embodiments, the obtaining and saving the normalized attribute information of the target point location to the database further includes:
acquiring attribute information of the target point location;
and carrying out standardization processing on the attribute information of the target point location based on a second preset rule base to obtain the standardized attribute information of the target point location and storing the standardized attribute information of the target point location in a database.
Meanwhile, the invention also discloses a system for realizing the comparison of the elevator advertisement putting schemes, which comprises the following steps:
the first acquisition module is used for acquiring the normalized attribute information of the target point location and storing the normalized attribute information to a database;
a second obtaining module, configured to obtain location information of the target point location, where the location information at least includes a fence longitude and latitude coordinate set corresponding to the target point location and a center point longitude and latitude coordinate of a project center corresponding to the target point location;
the result output module is used for outputting a comparison result corresponding to a comparison item through a preset algorithm based on the comparison item input by a user; the comparison item is generated based on the normalized attribute information;
and the result display module is used for visually displaying the comparison result on a map based on the comparison result and the position information.
In some embodiments, the first acquisition module is configured to perform the following operations:
s1: acquiring a name list of the items to be processed;
s2: acquiring an item fence and a central point coordinate of the item to be processed through a map tool based on the name list of the item to be processed;
s3: judging whether the coordinates of the project fence and the central point are correct or not;
s4: in response, saving the project fence and the center point coordinates to a database;
s5: in response to no, determining an abnormal item name manifest;
s6: cleaning the abnormal project name list based on a first preset rule base to obtain a processed project name list; the first preset rule base comprises at least one cleaning rule;
s7: and based on the processed item name list, returning to the operation S3 again and repeating the steps until the item fences of all the items to be processed and the central point coordinate are stored in the database.
In some embodiments, the first obtaining module is further configured to:
acquiring attribute information of the target point location;
and carrying out standardization processing on the attribute information of the target point location based on a second preset rule base to obtain the standardized attribute information of the target point location and storing the standardized attribute information to a database.
Meanwhile, the invention also discloses a device for realizing the comparison of the elevator advertisement putting schemes, which comprises at least one processor and at least one memory; the at least one memory is for storing computer instructions; the at least one processor is used for executing at least part of the computer instructions to realize the comparison realization method of the elevator advertisement putting scheme.
Meanwhile, the invention also discloses a computer readable storage medium, wherein the storage medium stores a computer instruction, and when the computer reads the computer instruction, the computer executes the comparison implementation method of the elevator advertisement putting scheme.
Advantageous effects
Compared with the prior art, the invention has the following remarkable advantages:
by the method, the point location distribution condition of the delivery channel can be visually displayed, the delivery schemes with different index combinations can be visually established by the client, the delivery range combination of the client can be facilitated, unnecessary reselection and omission can be avoided, the delivery effect can be maximized, and meanwhile, the advertisement delivery attributes of the client can be matched, and the media delivery advantages can be maximized.
Drawings
FIG. 1 is a schematic diagram of a comparison implementation system of an elevator advertisement delivery scheme according to the present embodiment;
fig. 2 is a schematic diagram of a first obtaining module according to the present embodiment;
fig. 3 is another functional diagram of the first obtaining module according to the present embodiment;
fig. 4 is a schematic flow chart of a comparison implementation method of an elevator advertisement delivery scheme according to this embodiment;
FIG. 5 is a schematic diagram of a project name cleaning process according to the present embodiment;
fig. 6 is a flowchart illustrating the process of normalizing the attribute information of the target point location according to this embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
On the contrary, this application is intended to cover any alternatives, modifications, equivalents, and alternatives that may be included within the spirit and scope of the application as defined by the appended claims. Furthermore, in the following detailed description of the present application, certain specific details are set forth in order to provide a better understanding of the present application. It will be apparent to one skilled in the art that the present application may be practiced without these specific details.
A method and a system for implementing the comparison of the elevator advertisement delivery schemes according to the embodiments of the present application will be described in detail below with reference to fig. 1 to 6. It is to be noted that the following examples are only for explaining the present application and do not constitute a limitation to the present application.
Example 1
As shown in fig. 1, a schematic diagram of a comparison implementation system 100 of an elevator advertisement delivery scheme is shown, and the comparison implementation system 100 of the elevator advertisement delivery scheme includes: the system comprises a first obtaining module 110, a second obtaining module 120, a result output module 130 and a result display module 140. The method comprises the following specific steps:
the first obtaining module 110 is configured to obtain normalized attribute information of the target point location and store the normalized attribute information in a database.
In some embodiments, the normalized attribute information includes at least one of a media channel name, a city of the location, a project name, a property type, a screen type, and a point location number. In some embodiments, the normalized attribute information may also contain more detailed information of the target point location, such as a building name, a unit name, an elevator number, etc. that further includes the target point location. In some embodiments, property types may include business, residential, and the like. The screen types may include intra-ladder, extra-ladder, frame, etc. types.
In some embodiments, the first obtaining module 110 may enter multiple media delivery channels into a unified database system according to the point location attribute of the target point location, and normalize the attribute information of the target point location as a core index for subsequent comparison.
In some embodiments, as shown in fig. 2, the first acquisition module is configured to perform the following operations:
s1: acquiring a name list of the items to be processed;
s2: acquiring an item fence and a central point coordinate of the item to be processed through a map tool based on the name list of the item to be processed;
s3: judging whether the coordinates of the project fence and the central point are correct or not;
s4: in response, storing the project fence and the center point coordinate to a database;
s5: in response to no, determining an abnormal item name list;
s6: cleaning the abnormal project name list based on a first preset rule base to obtain a processed project name list; the first preset rule base comprises at least one cleaning rule;
s7: and based on the processed item name list, returning to the operation S3 again and repeating the steps until the item fences and the central point coordinates of all the items to be processed are stored in the database.
In some embodiments, most of the acquired item names in the name list of the items to be processed are correct and complete and can be identified by a third-party map tool such as a hundredth API, but due to the fact that contract identification exists in the actual contract, the problem that the item names are not standardized occurs, for example, a large building with multi-stage construction, when acquiring data, only one or more stages of the acquired data may be acquired, for example, the item name at the time of contract may be the description of a certain item first stage, and a certain item second stage, and the like, then the system performs data cleaning through a first preset rule base which is iterated continuously (as shown in fig. 2), for example, the cleaning process in this example may include removing a suffix behind the building name to achieve the purpose of making the item name usable.
In some embodiments, the data after the cleaning process of the first preset rule base may be further processed by manual verification and check, so as to accurately obtain the coordinates of the item fence and the center point in the subsequent steps.
In some embodiments, as shown in fig. 3, the first obtaining module is further configured to:
acquiring attribute information of the target point location;
and carrying out standardization processing on the attribute information of the target point location based on a second preset rule base to obtain the standardized attribute information of the target point location and storing the standardized attribute information of the target point location in a database.
In some embodiments, although each media channel has the core indexes mentioned above for the convenience of customers, the description of the core indexes on the data is greatly different, and if the description of the media channel on the smart screen is LCD, the description of the media channel on the smart screen is elevator television.
In order to provide a uniform comparison item for the user subsequently, it is necessary to standardize each item of basic data included in the obtained attribute information of the target point location. For example, the first obtaining module performs normalization processing on each item of basic data included in the attribute information of the target point according to the flow shown in fig. 3, so as to obtain normalized attribute information of the target point and store the normalized attribute information in the database. For example, in the attribute information of a target point location corresponding to a media channel, a "high-end house" included in the property type may be standardized as a "house", an "elevator tv" included in the screen type may be standardized as a "smart screen", and the like, based on the first obtaining module.
The second obtaining module 120 is configured to obtain location information of the target point location, where the location information at least includes a fence longitude and latitude coordinate set corresponding to the target point location and a center point longitude and latitude coordinate of a project center corresponding to the target point location.
In some embodiments, the second obtaining module 120 may obtain the fence latitude and longitude coordinates of the project and the longitude and latitude coordinates of the center point of the project by using a map API provided by a third-party map tool, such as a Baidu, obtained by a computer according to the project name of the target point location.
A result output module 130, configured to output, based on a comparison item input by a user, a comparison result corresponding to the comparison item through a preset algorithm; the alignment item is generated based on the normalized attribute information.
In some embodiments, the result output module 130 can output the comparison result according to the dynamically selected comparison strategy based on the comparison item input by the user based on the standard sql algorithm providing a dynamic match.
In some embodiments, in the result output module 130, the channel delivery media performs a pre-processing cross operation between the elevator and the equipment according to the city, the competitive name, and the index (property type index and screen type combination index set by the comparison option), and stores the result in the database, and the result is not directly extracted through operation in the process of selecting the dynamic index on the interface, so that the operation rate can be further improved, and the user experience can be ensured.
A result displaying module 140, configured to perform a visual display of the comparison result on a map based on the comparison result and the location information.
In some embodiments, the result displaying module 140 may display the comparison result graphically in a manner of combining an index with a map in a form of screening for performing point selection coverage.
Example 2
As shown in fig. 4, a comparison implementation method of an elevator advertisement delivery scheme includes:
and step 210, acquiring the normalized attribute information of the target point and storing the normalized attribute information in a database.
In some embodiments, the normalized attribute information includes media channel name, project address, property type (business, residence), building name, unit name, screen type (inside, outside, frame), and point location number, elevator number.
In some embodiments, as shown in fig. 5, step 210 specifically includes the following steps:
step 211: and acquiring a name list of the items to be processed.
In some embodiments, before a new item enters the database, the name of the item may be put into the list of names of pending items for further acquisition of detailed information.
Step 212: and acquiring an item fence and a central point coordinate of the item to be processed through a map tool based on the name list of the item to be processed.
For example, the item fence and center point coordinates of the item to be processed may be obtained based on a third party mapping tool such as a Baidu API.
Step 213: and judging whether the coordinates of the project fence and the center point are correct or not.
Step 214: in response, the project fence and the center point coordinates are saved to a database.
Step 215: in response to no, an exception item name manifest is determined.
In some embodiments, the exception item name may be stored in an exception item name list for uniform subsequent processing.
Step 216: cleaning the abnormal project name list based on a first preset rule base to obtain a processed project name list; the first preset rule base comprises at least one cleaning rule.
Step 217: based on the processed item name list, returning to step 213 again and repeating the above steps until the item fences of all the items to be processed and the coordinates of the central point are stored in the database.
For example, the first preset rule base may be established by performing rule matching of the project names. In some embodiments, the regular expression may be used as a first preset rule base to process the abnormal item name list, until all the rules are processed, the item names enter the to-be-processed item name list again to re-acquire the item fence and the central point coordinate information; the rules in the first preset rule base can be dynamically ordered according to the percentage of matching rules, and the rule with the largest percentage is executed first. Based on the iteration of the rule learning of the first preset rule base, an algorithm basis is provided for the efficiency improvement.
In some embodiments, the information that cannot be cleaned by the rules in the first preset rule base may be processed in a manner of manual modification, so as to improve the processing accuracy.
In some embodiments, the dimension data of the target point location corresponding to each media channel may have various names and calling names, and for comparison, the dimension of the data needs to be unified and standardized. In some embodiments, as shown in FIG. 6, step 210 further comprises the steps of:
step 218: acquiring attribute information of the target point location;
step 219: and carrying out standardization processing on the attribute information of the target point location based on a second preset rule base to obtain the standardized attribute information of the target point location and storing the standardized attribute information to a database.
For example, a data standardized cleansing rule base can be established for each media channel, and various names of single indexes are solidified and completely enumerated and replaced by uniform names. And finally, after all comparison indexes of all media channels are finished, data combination is carried out so as to facilitate subsequent comparison preprocessing and acquisition of visual coordinates.
Step 220, obtaining the position information of the target point location, where the position information at least includes a fence longitude and latitude coordinate set corresponding to the target point location and a center point longitude and latitude coordinate of a project center corresponding to the target point location.
For example, the comparison item may include a media channel name, a city, a project name, a property type, a screen type, a point number, and the like.
And 240, visually displaying the comparison result on a map based on the comparison result and the position information.
In some embodiments, when result display is performed, in order to improve the operation efficiency and ensure the display effect, pretreatment cross operation of the elevator and the equipment can be performed according to cities, competitive names and indexes (property type indexes and screen type combination indexes set by comparison options), and the result is stored in a database and is not directly extracted through operation in the dynamic index selection process of the interface. Meanwhile, during display, millions and even millions of point location operations of nationwide delivery channel merchants can be limited from the city level; performing pre-calculation processing on the core index data operation again to avoid large data quantity operation delay during display so as to improve the response speed of result data; and finally, marking the position of the item by using the item coordinate set and a coordinate set provided by a Baidu API and the like.
Meanwhile, the invention also discloses a device for realizing the comparison of the elevator advertisement putting schemes, which comprises at least one processor and at least one memory; the at least one memory is for storing computer instructions; the at least one processor is used for executing at least part of the computer instructions to realize the comparison realization method of the elevator advertisement putting scheme.
Meanwhile, the invention also discloses a computer readable storage medium, wherein the storage medium stores a computer instruction, and when the computer reads the computer instruction, the computer executes the comparison implementation method of the elevator advertisement putting scheme.
In conclusion, the scheme of the invention can meet the city-level multi-channel and full-coverage delivery visual delivery requirement of the elevator advertiser, can effectively improve the point selection efficiency, and can provide powerful reference on the delivery strategy analysis of competitive media.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents and improvements made within the spirit and principle of the present invention are intended to be included within the scope of the present invention.
Claims (10)
1. A method for realizing comparison of elevator advertisement putting schemes is characterized by comprising the following steps:
acquiring normalized attribute information of the target point location and storing the normalized attribute information to a database;
acquiring position information of the target point location, wherein the position information at least comprises a fence longitude and latitude coordinate set corresponding to the target point location and a center point longitude and latitude coordinate of a project center corresponding to the target point location;
outputting a comparison result corresponding to a comparison item through a preset algorithm based on the comparison item input by a user; the alignment item is generated based on the normalized attribute information;
and visually displaying the comparison result on a map based on the comparison result and the position information.
2. The method of claim 1,
the normalized attribute information comprises at least one of media channel name, city, project name, property type, screen type and point location number.
3. The method of claim 1, wherein obtaining and saving normalized attribute information for the target point location to a database comprises:
s1: acquiring a name list of items to be processed;
s2: acquiring an item fence and a central point coordinate of the item to be processed through a map tool based on the name list of the item to be processed;
s3: judging whether the coordinates of the project fence and the central point are correct or not;
s4: in response, saving the project fence and the center point coordinates to a database;
s5: in response to no, determining an abnormal item name manifest;
s6: cleaning the abnormal project name list based on a first preset rule base to obtain a processed project name list; the first preset rule base comprises at least one cleaning rule;
s7: and returning to the step S3 again based on the processed item name list, and repeating the steps until the item fences of all the items to be processed and the central point coordinate are stored in the database.
4. The method of claim 3, wherein the obtaining and saving the normalized attribute information of the target point location to the database further comprises:
acquiring attribute information of the target point location;
and carrying out standardization processing on the attribute information of the target point location based on a second preset rule base to obtain the standardized attribute information of the target point location and storing the standardized attribute information of the target point location in a database.
5. A comparison implementation system for an elevator advertisement putting scheme is characterized by comprising:
the first acquisition module is used for acquiring the normalized attribute information of the target point location and storing the normalized attribute information to a database;
the second acquisition module is used for acquiring the position information of the target point location, wherein the position information at least comprises a fence longitude and latitude coordinate set corresponding to the target point location and a central point longitude and latitude coordinate of a project center corresponding to the target point location;
the result output module is used for outputting a comparison result corresponding to a comparison item through a preset algorithm based on the comparison item input by a user; the comparison item is generated based on the normalized attribute information;
and the result display module is used for visually displaying the comparison result on a map based on the comparison result and the position information.
6. The system of claim 5, wherein the normalized attribute information comprises at least one of a media channel name, a city, a project name, a property type, a screen type, and a point number.
7. The system of claim 5, wherein the first acquisition module is configured to:
s1: acquiring a name list of the items to be processed;
s2: acquiring an item fence and a central point coordinate of the item to be processed through a map tool based on the name list of the item to be processed;
s3: judging whether the project fence and the center point coordinate are correct or not;
s4: in response, saving the project fence and the center point coordinates to a database;
s5: in response to no, determining an abnormal item name list;
s6: cleaning the abnormal project name list based on a first preset rule base to obtain a processed project name list; the first preset rule base comprises at least one cleaning rule;
s7: and based on the processed item name list, returning to the operation S3 again and repeating the steps until the item fences and the central point coordinates of all the items to be processed are stored in the database.
8. The system of claim 7, wherein the first obtaining module is further configured to:
acquiring attribute information of the target point location;
and carrying out standardization processing on the attribute information of the target point location based on a second preset rule base to obtain the standardized attribute information of the target point location and storing the standardized attribute information to a database.
9. A device for realizing comparison of elevator advertisement putting schemes is characterized by comprising at least one processor and at least one memory;
the at least one memory is for storing computer instructions;
the at least one processor is configured to execute at least some of the computer instructions to implement the method of any one of claims 1-4.
10. A computer-readable storage medium, wherein the storage medium stores computer instructions, and when the computer instructions in the storage medium are read by a computer, the computer performs the method of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211685602.6A CN115983910A (en) | 2022-12-27 | 2022-12-27 | Method, system, device and medium for realizing comparison of elevator advertisement putting schemes |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211685602.6A CN115983910A (en) | 2022-12-27 | 2022-12-27 | Method, system, device and medium for realizing comparison of elevator advertisement putting schemes |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115983910A true CN115983910A (en) | 2023-04-18 |
Family
ID=85975483
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211685602.6A Pending CN115983910A (en) | 2022-12-27 | 2022-12-27 | Method, system, device and medium for realizing comparison of elevator advertisement putting schemes |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115983910A (en) |
-
2022
- 2022-12-27 CN CN202211685602.6A patent/CN115983910A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11977541B2 (en) | Systems and methods for rapid data analysis | |
| TWI772673B (en) | Industry identification model determination method and device | |
| CN109167816B (en) | Information pushing method, device, equipment and storage medium | |
| CN109635276B (en) | Information matching method and terminal | |
| CN111552870A (en) | Object recommendation method, electronic device and storage medium | |
| CN111553137B (en) | Report generation method and device, storage medium and computer equipment | |
| EP3783522A1 (en) | Semantic model instantiation method, system and device | |
| CN112862593B (en) | Credit scoring card model training method, device and system and computer storage medium | |
| CN108876545A (en) | Order recognition methods, device and readable storage medium storing program for executing | |
| CN113205403A (en) | Method and device for calculating enterprise credit level, storage medium and terminal | |
| CN103699544A (en) | Method and system for selecting data by crossing pages | |
| CN116739836A (en) | Restaurant data analysis method and system based on knowledge graph | |
| CN106934679A (en) | information matching method and device | |
| CN110889737A (en) | Method and device for recommending rental roommates, server and storage medium | |
| EP3564833A1 (en) | Method and device for identifying main picture in web page | |
| CN112561636A (en) | Recommendation method, recommendation device, terminal equipment and medium | |
| CN115983910A (en) | Method, system, device and medium for realizing comparison of elevator advertisement putting schemes | |
| CN110825960A (en) | Learning content recommendation method and device | |
| CN116644102A (en) | Intelligent investment object selection method, system terminal and computer readable storage medium | |
| CN108334522B (en) | Method for determining customs code, and method and system for determining type information | |
| CN114756685A (en) | Complaint risk identification method and device for complaint sheet | |
| CN109919811B (en) | Insurance agent culture scheme generation method based on big data and related equipment | |
| CN113672497A (en) | Method, device and equipment for generating non-buried point event and storage medium | |
| CN115470304B (en) | Feature causal warehouse management method and system | |
| CN106202390B (en) | Database improvement system and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |