Visual advertisement management platform, and implementation method thereof

A management platform and implementation method technology, applied in the field of mobile Internet, can solve the problems of temporary manual construction of query scripts, inconvenient, unintuitive, etc.

Inactive Publication Date: 2016-07-06
BEIJING ZHANGKUO MOBILE MEDIA TECH
View PDF3 Cites 30 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] This method has the following disadvantages: first, it is inconvenient, that is, it is necessary to temporarily manually build query scripts for each business; second, it is

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Visual advertisement management platform, and implementation method thereof
  • Visual advertisement management platform, and implementation method thereof
  • Visual advertisement management platform, and implementation method thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0043] The present invention is mainly based on the existing advertising query platform, which needs to be manually searched. For this reason, it mainly wants to achieve the following results:

[0044] a. Data modeling:

[0045] That is, through the semantic mapping of the data tables and data columns of the advertising data warehouse in advance, a business-oriented and user-friendly business model is constructed. Therefore, business personnel no longer need to understand the data structure of the data warehouse, but only need to understand the data that is closer to the business. data model.

[0046] b. Query visualization:

[0047] That is, by analyzing the data model query object, the query sql query data is automatically constructed. Business personnel only need to simply drag and drop the measurement, dimension and input filter conditions of the business model to quickly and conveniently query and analyze the advertising data.

[0048] c. Graphical results

[0049] Th...

Embodiment 2

[0059] Based on the first embodiment above, a detailed description will be given. In one embodiment, preferably, a data model definition unit is also provided for storing the data model in xml format;

[0060] And semantically map the data tables and data columns of the advertising data warehouse, and build an advertising data model with measurement and dimension attributes.

[0061] Preferably, the query object generation unit further includes a query object block definition subunit, configured to construct an attribute block according to the query object, wherein the query object attribute block includes a query block, a filter block, a group filter block, and a sort block and number of records to define blocks.

[0062] Preferably, the query processing unit further includes a query sql construction subunit, and the sql construction subunit constructs sql query statements related to the advertisement data warehouse by analyzing each attribute block of the query object.

[...

Embodiment 3

[0065] Such as figure 2 As shown, the data model is mainly defined in the form of an xml document, which includes measures, dimensions and / or groups.

[0066] When in use, it is presented to the user in the form of a model tree, such as image 3 .

[0067] Among them, measurement is a practical data indicator that business personnel pay attention to. It generally corresponds to a certain column in the fact table, and is usually a number, such as "request", "display", "click" and other indicators in advertising data.

[0068] In addition, the measurement can also be derived from the existing measurement besides the fact table, for example, the "click-through rate" in the advertising data is actually "click / impression * 100%".

[0069] Dimension: It is the angle from which business personnel analyze data, and generally corresponds to a certain column in the dimension data table. For example, "city", "advertisement", "media" in advertisement data.

[0070] Grouping: It is a ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a visual advertisement management platform, and an implementation method thereof. The platform comprises an inquiry area unit, and an inquiry object generation unit, wherein the inquiry area unit is used for the display of a model tree to a user and the input of data inquiry items at the front end of a page; the model tree is corresponding to a preset data model in the xml format and comprises measurements, dimensions and groups, and the data inquiry items comprise inquiry fields and relevant filtering conditions; the measurements are practical data indicators that business personnel are concerned about, and each measurement is corresponding to a certain column of a fact datasheet; the dimensions are data analysis perspectives of the business personnel, and each dimension is corresponding to a certain column of a dimension datasheet; each group is a combination of the dimensions and the measurements in a same category as required by businesses; the inquiry object generation unit is used for accepting the dragging of the measurements and the dimensions on the model tree by the user, as well as the filtering conditions and inquiry conditions set by the user in a selection box, so that corresponding inquiry objects can be constructed.

Description

technical field [0001] The invention belongs to the field of mobile Internet and relates to a visualized advertisement management platform. Background technique [0002] At present, the advertising platforms of most companies generate hundreds of millions of advertising log data every day. Among them, in order to facilitate statistics and analyze advertising data, different data warehouses are built according to different business needs. When business personnel obtain data from the data warehouse and make statistical analysis charts, they need to hand-write SQL query scripts according to business needs, and export the query results as data files for use in making charts. [0003] This method has the following disadvantages: first, it is inconvenient, that is, it is necessary to temporarily manually build query scripts for each business; second, it is not intuitive, that is, only data files can be seen each time, and if you need to view charts, you need to manually productio...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30G06Q30/02
CPCG06F16/2457G06Q30/0241
Inventor 李春辉
Owner BEIJING ZHANGKUO MOBILE MEDIA TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap