Patent Application
20180139514
In some embodiments, the present invention generally relates to database driven computer systems and computer-implemented methods for processing real-time attribution of web originated activities to airings and tracking thereof.
For example, in the realm of Direct Response Television (DRTV), a marketer makes an offer to the viewer to purchase or to inquire about a package of products or services, or to pledge a donation, by visiting a specific URL through individual broadcast airings of a paid commercial program of 28:30 in length (infomercial) or a commercial message of varying lengths equal to or less than five minutes.
In some embodiments, the present invention is directed to a computer system which includes at least the following components: at least one specifically programmed server; at least one non-transitory web attribution database accessible by the at least one specifically programmed server, where the at least one web attribution database is specifically programmed to be dedicated for use by the at least one specifically programmed server; where the at least one specifically programmed server comprises a plurality of modules configured to perform at least the following operations: electronically and periodically obtaining, over the computer network, by a media data programmed computer interface module of the at least one specifically programmed server, media data from a plurality of computer systems of media data sources, where the media data is associated with a plurality of media airings of a plurality creatives; electronically and periodically obtaining, over a computer network, by a web data programmed computer interface module of the at least one specifically programmed server, web tracking transaction data from a computer system of at least one web tracking electronic source; where the web tracking transaction data including web tracking metrics for web originated activities for at least one website associated with at least one offer of at least one creative; where web originated activities comprise web orders placed in response to the at least one offer associated with the at least one creative; for each web order record in the transactional web data: based on an item identifier of at least one item and a price of the at least one item corresponding to a particular web order corresponding to such web order record, determining, the at least one specifically programmed server, at least one particular offer associated with the particular web order, based on the at least one particular offer, determining, the at least one specifically programmed server, a length of a creative which has used for promoting the at least one item; based on the particular offer, identifying, the at least one specifically programmed server, a subset of media agency records in the media data which are potentially attributable to such particular web order; adjusting, the at least one specifically programmed server, a time of airing for each record in the subset of media agency records based on at least one of: i) a predetermined uniform time zone, and ii) an IP address associated with the web order, and iii) a geographic location of a web host at which the particular web order was placed; based on the length of the creative, selecting, the at least one specifically programmed server, a first subgroup of media agency records from the subset of media agency records, where the length of the creative corresponds to a predetermine time window, where the predetermined time window ends at the time of the particular web order, and continues in the past for a predetermined time duration; based on an IP address of the particular web order from the transactional web data, selecting, the at least one specifically programmed server, a second subgroup of media agency records from the first subgroup of media agency records, where the second subgroup of media agency records correspond to media airings shown in a geographic locality of the particular web order; determining, by the at least one specifically programmed server, for each media airing of the second subgroup, a probability of attribution based on cost of such media airing or viewership rating; based on the probability of attribution, duplicating, by the at least one specifically programmed server, a particular media airing record of the second subgroup X times in the dedicated database to obtain a third subgroup, where X is a whole number based on rounding the probability of attribution; assigning, by the at least one specifically programmed server, to each record in the third subgroup a random value within a predetermined number range between Y1 and Y2, where Y2 is larger than Y1; based on the random value, ranking, by the at least one specifically programmed server, each record in the third subgroup so that a particular media airing having the random value which is the closest to Y2 is assigned the highest rank; attributing, by the at least one specifically programmed server, the particular web order to the particular media airing having the highest rank; and displaying, the at least one specifically programmed server, utilizing at least one graphical user interface, a real time updatable web attribution report.
In some embodiments, the at least one specifically programmed server is further configured to: electronically and real-time obtain, by a fulfillment data programmed computer interface module of the at least one specifically programmed server, from a computer system of at least one fulfillment electronic source, fulfillment transaction data; where the fulfillment transaction data including a plurality of at least thousand fulfillment records associated a plurality of at least thousand fulfillment transactions for the web orders; where each fulfillment record identifies each fulfillment transaction being associated with a particular web order; and matching, in real-time, records between web records and fulfillment records based, at least in part, on: i) an order date, ii) a 5 digit Zip code, iii) a last name, iv) an order amount, and v) optionally, a street name.
In some embodiments, the at least one web tracking electronic source is selected from the group consisting of: Piwik, Google Analytics, and Omniture.
In some embodiments, the length of the creative corresponds to the predetermine time window based on the following rules: i) when the length of the creative is between 15 and 30 seconds, the predetermined time window is 30 minutes, ii) when the length of the creative is between 60 and 120 seconds, the predetermined time window is 2 hours, iii) when the length of the creative is 5 minutes, the predetermined time window is 4 hours, and iv) when the length of the creative is 28 minutes and 30 seconds, the predetermined time window is 8 hours. In some embodiments, Y1 is 0, and Y2 is 1. In some embodiments, the random value is generated by a random value generator. In some embodiments, the predetermined time zone is selected from the group consisting of: U.S. Eastern time zone, U.S. Central time zone, and U.S. Western time zone.
In some embodiments, the media airing is an airing which is selected from the group consisting of: a television station airing, a radio station airing, a video-on-demand airing, a web-promoted offer airing, and a mobile message airing. In some embodiments, the viewership rating is Nielsen rating.
In some embodiments, the present invention is directed to a computer-implemented method which includes at least the following steps: electronically and periodically obtaining, over the computer network, by a media data programmed computer interface module of the at least one specifically programmed server, media data from a plurality of computer systems of media data sources, where the media data is associated with a plurality of media airings of a plurality creatives; electronically and periodically obtaining, over a computer network, by a web data programmed computer interface module of the at least one specifically programmed server, web tracking transaction data from a computer system of at least one web tracking electronic source; where the web tracking transaction data including web tracking metrics for web originated activities for at least one website associated with at least one offer of at least one creative; where web originated activities comprise web orders placed in response to the at least one offer associated with the at least one creative; for each web order record in the transactional web data: based on an item identifier of at least one item and a price of the at least one item corresponding to a particular web order corresponding to such web order record, determining, the at least one specifically programmed server, at least one particular offer associated with the particular web order, based on the at least one particular offer, determining, the at least one specifically programmed server, a length of a creative which has used for promoting the at least one item; based on the particular offer, identifying, the at least one specifically programmed server, a subset of media agency records in the media data which are potentially attributable to such particular web order; adjusting, the at least one specifically programmed server, a time of airing for each record in the subset of media agency records based on at least one of: i) a predetermined uniform time zone, and ii) an IP address associated with the web order, and iii) a geographic location of a web host at which the particular web order was placed; based on the length of the creative, selecting, the at least one specifically programmed server, a first subgroup of media agency records from the subset of media agency records, where the length of the creative corresponds to a predetermine time window, where the predetermined time window ends at the time of the particular web order, and continues in the past for a predetermined time duration; based on an IP address of the particular web order from the transactional web data, selecting, the at least one specifically programmed server, a second subgroup of media agency records from the first subgroup of media agency records, where the second subgroup of media agency records correspond to media airings shown in a geographic locality of the particular web order; determining, by the at least one specifically programmed server, for each media airing of the second subgroup, a probability of attribution based on cost of such media airing or viewership rating; based on the probability of attribution, duplicating, by the at least one specifically programmed server, a particular media airing record of the second subgroup X times in the dedicated database to obtain a third subgroup, where X is a whole number based on rounding the probability of attribution; assigning, by the at least one specifically programmed server, to each record in the third subgroup a random value within a predetermined number range between Y1 and Y2, where Y2 is larger than Y1; based on the random value, ranking, by the at least one specifically programmed server, each record in the third subgroup so that a particular media airing having the random value which is the closest to Y2 is assigned the highest rank; attributing, by the at least one specifically programmed server, the particular web order to the particular media airing having the highest rank; and displaying, the at least one specifically programmed server, utilizing at least one graphical user interface, a real time updatable web attribution report.
The present invention can be further explained with reference to the attached drawings, wherein like structures are referred to by like numerals throughout the several views. The drawings shown are not necessarily to scale, with emphasis instead generally being placed upon illustrating the principles of the present invention. Further, some features may be exaggerated to show details of particular components. In addition, any measurements, specifications and the like shown in the figures are intended to be illustrative, and not restrictive. Therefore, specific structural and functional details disclosed herein are not to be interpreted as limiting, but merely as a representative basis for teaching one skilled in the art to variously employ the present invention.
Among those benefits and improvements that have been disclosed, other objects and advantages of this invention will become apparent from the following description taken in conjunction with the accompanying figures. Detailed embodiments of the present invention are disclosed herein; however, it is to be understood that the disclosed embodiments are merely illustrative of the invention that may be embodied in various forms. In addition, each of the examples given in connection with the various embodiments of the invention which are intended to be illustrative, and not restrictive.
Throughout the description, the following terms take the meanings explicitly associated herein, unless the context clearly dictates otherwise. The phrases “in one embodiment” and “in some embodiments” as used herein do not necessarily refer to the same embodiment(s), though it may. Furthermore, the phrases “in another embodiment” and “in some other embodiments” as used herein do not necessarily refer to a different embodiment, although it may. Thus, as described below, various embodiments of the invention may be readily combined, without departing from the scope or spirit of the invention.
In addition, as used herein, the term “or” is an inclusive “or” operator, and is equivalent to the term “and/or,” unless the context clearly dictates otherwise. The term “based on” is not exclusive and allows for being based on additional factors not described, unless the context clearly dictates otherwise. In addition, throughout the specification, the meaning of “a,” “an,” and “the” include plural references. The meaning of “in” includes “in” and “on.”
It is understood that at least one aspect/functionality of various embodiments described herein can be performed in real-time and dynamically. As used herein, the term “real-time” means that an event/action can occur instantaneously or almost instantaneously in time when another event/action has occurred.
As used herein, the terms “dynamic(ly)” and “automatic(ly)” mean that an event/action that can occur without any human intervention. In some embodiments, the event/action may be in real-time and/or hourly, daily, weekly, monthly, annually, etc.
In describing and illustrating the exemplary embodiments, specific terminology is employed for the sake of clarity. However, the embodiments are not intended to be limited to the specific terminology so selected. A person skilled in the relevant art will recognize that other components and configurations may be used without parting from the spirit and scope of the embodiments. It is to be understood that each specific element includes all technical equivalents that operate in a similar manner to accomplish a similar purpose. The examples and embodiments described herein are non-limiting examples.
As used herein, the term “creative” means a commercial, published element, display, link and/or advertisement that a consumer sees. For example, for TV, the creative can be an Infomercial or Short Form spots, format lengths (:30/:60/:120) could be interchangeable as a singular creative or they could be separate creatives.
As used herein, the term “offer” represents a particular Product/Service configuration or a package of Products/Services, and/or pricing scheme relative to a specific creative, media agency and/or upsell configuration strategy.
As used herein, the terms “web originated activity” and “web originated activities” represent including, but not limited to, calls, leads, orders, SMS texts, visits, votes, pledges, emails, mail, etc.
As used herein, the term “media source” represents a source, host and/or provider of electronic data regarding an airing (also referenced here as a media airing) which is a media event involving a creative which has been shown/distributed via one or more media outlets, including, but not limited to, TV Stations, Radio Stations, Web Channels/Sites (e.g., youtube.com's channels(s)), Social Sites, Internet streaming (such as service provided by Roku), Satellite, On Demand, emails, mail, publications, inserts, circulars, etc. For example, Roku utilizes a streaming player (or simply Roku) which is a set-top box manufactured by Roku, Inc. Typically, Roku partners provide over-the-top content in the form of channels. As used herein, a particular media event corresponding to a particular airing/media airing is an event that can be defined by time, date, and length parameters. In some embodiments, the media airing is an airing which is selected from the group consisting of: a television station airing, a radio station airing, a video-on-demand airing, a web-promoted offer airing (e.g., banner ads), a mobile message airing (e.g., mobile SMS, email, etc.).
As used herein, the term “campaign” is directed to a set and/or grouping of Creatives targeting a particular marketing effort and/or event. For example, creatives within a campaign can be single or omni-channel.
In some embodiments, an advertisement, creative, is designed to induce consumers to engage in web originated activity(ies).
In some embodiments, a unique airing can be recorded in a database as a record identifying a network or station, day of week and local time.
In some embodiments, the inventive computer systems of the present invention are configured to continuously attribute, in real-time, web originated activities to airings via Direct Response Television (DRTV) (e.g., individual broadcast airings (such as a paid commercial program of 28:30 in length (infomercial)); a series of airings between one and five minutes in which a marketer makes an offer to the viewer to purchase a product, a package of products, a service, or both; 30 seconds commercials, etc.) which asks viewers to visit a specific internet address (e.g., URL, URL encoded 3D barcode, etc.). In some embodiments, the inventive computer systems of the present invention are configured to receive data regarding every airing that is tracked, for example but not limited to, in terms of the TV network/station it ran, day, time, calls, orders, and/or revenue it produced.
In some embodiments, the media data is media agency data and at least one media source is an electronic computer system of a particular media agency. In some embodiments, the media agency can be an advertising agency, a network, a station, or any other suitable entity that places, distributes, and/or publishes creatives.
In some embodiments, the inventive computer systems of the present invention are configured to receive, from various media sources, contracted by or on behalf of a marketer (e.g., producer of products or provider of services), media data regarding airings. In some embodiments, the inventive computer systems of the present invention are configured to verify the incoming data and to populate a media data table in a non-transitory database. In some embodiments, the inventive computer systems of the present invention are, similarly, configured to receive and process web data regarding web originated activities (e.g., orders placed on the internet).
In some embodiments, the inventive systems of present invention are configured to process records associated with at least 1 to 1,000 marketers. In some embodiments, the inventive systems of present invention are configured to process records associated with at least 1,000 to 10,000 marketers. In some embodiments, the inventive systems of present invention are configured to process records associated with at least 10,000 to 100,000 marketers. In some embodiments, the inventive systems of present invention are configured to process records associated with at least 100,000 marketers.
In some embodiments, the inventive systems of present invention are configured to process records associated with at least 1 to 1,000 creatives. In some embodiments, the inventive systems of present invention are configured to process records associated with at least 1,000 to 10,000 creatives. In some embodiments, the inventive systems of present invention are configured to process records associated with at least 10,000 to 1,000,000 creatives. In some embodiments, the inventive systems of present invention are configured to process records associated with at least 1,000,000 to 1,000,000,000 creatives. In some embodiments, the inventive systems of present invention are configured to process records associated with at least 1,000,000,000 creatives.
In some embodiments, the inventive systems of present invention are configured to process records associated with at least 1 to 1,000 media outlets. In some embodiments, the inventive systems of present invention are configured to process records associated with at least 1,000 to 10,000 media outlets. In some embodiments, the inventive systems of present invention are configured to process records associated with at least 10,000 to 1,000,000 media outlets. In some embodiments, the inventive systems of present invention are configured to process records associated with at least 1,000,000 media outlets.
Exemplary Web Tracking/Analytics Databases (Piwik, GA, Omniture, Etc.)
In some embodiments, the inventive systems of the present invention combine and validate data for web originated activity records (e.g., records of web placed orders) from a plurality of web tracking sources via, for example, ETL (Extract, Transform, Load)-type processes on, for example, a periodical basis (e.g., Daily Transactional File—24 Hrs.). In some embodiments, the web data is processed in real time through an attribution process that matches web originated activity records to active offers based on a particular SKU (i.e., a stock identification unit such as product or service identification code) and/or a combination of a pre-determined number of SKUs associated with each web originated activity record (e.g., a single item web order record would include a single SKU code). For example, a unique KitCode identifier for a particular active offer is recorded in a particular field in a database table and represents two or more SKUs based on an association table between the unique KitCode identifier and the two or more SKUs.
Exemplary Web Attribution Data Processing Based, at Least in Part, at Least One Source of Web Originated Activity Data Analytics
In some embodiments, the inventive systems of the present invention performs web attribution processing utilizing a single electronic data source for web originated activity data analytics. In some embodiments, the single electronic data source for web originated activity data analytics can be selected from the group of Piwik (www.piwik.org), Omniture/Adobe Marketing Cloud (http://www.adobe.com/marketing-cloud.html), Premium Google Analytics (http://www.google.com/analytics/premium/), and any other similarly suitable electronic data source for web originated activity data analytics. The specific web tracking protocols and corresponding specific data structures of each of the above identified electronic data sources, including any of their future modifications, as at least described at identified web locations, are hereby incorporated by references in their entirety for such purpose.
In some embodiments, an exemplary data structure for web originated activity data analytics of a particular electronic data source can have the following fields: Data Provider, Client, Landing Page URL, Order Number, Order Date, Order Time, Time zone, Disposition, Referral Type, Referral URL, # of Pages Viewed, Time On Website, Bounce Rate, Shopping Cart Status, Max Items in Shopping Cart, Email Address, Date of Landing, Time of Landing, Browser, Device Name, Webuser Country, Webuser State, Webuser City, Items in Cart at Checkout, # of Unique Visits in the Past, Billing Name First, Billing Name Last, Billing Address 1, Billing Address 2, Billing City, Billing State/Province, Billing Country, Billing ZIP/Postal Code, Billing Phone Number, Offer Code, Shipping Price, Merchandise Price, Order Tax, Order Discount, Order Total, Payment Method, Age, Gender, Shipping Name First, Shipping Name Last, Shipping Address 1, Shipping Address 2, Shipping City, Shipping State/Province, Shipping ZIP/Postal Code, Shipping Country, Shipping Phone Number, Shipping Method, Currency, IP Address, Custom String, Web Analytic Provider, Item 1 SKU, Item 1 Price, Item 1 Quantity, Item 1 Shipping price, Item 1 Indicator Code, Item 1 Discount.
In some embodiments, the inventive systems of the present invention electronically receives web originated activity tracking data from a particular electronic data source (e.g., Piwik). In some embodiments, the inventive systems of the present invention can utilize, for example, a value in a field of “Order ID” to automatically, in real time, verify that the associated web originated activity record is valid. In some embodiments, if the inventive systems of the present invention determines that the Order ID is valid, the inventive systems of the present invention then accepts such web originated activity record for further processing. In some embodiments, any unmatched records can be separately stored in a database until the matching failure is resolved.
In some embodiments, the inventive systems of the present invention can utilize data of a particular web order to match such record to a particular active offer (e.g., a creative identifies a website on which customers can order product(s)/service(s) based on the particular active offer). In some embodiments, the inventive systems of the present invention can utilize a value for the matched web offer to identify product(s)/service(s) (e.g., based on SKU code(s)), and a media length (e.g., a length of creative/commercial). For instance, in some embodiments, the inventive systems of the present invention can utilize automatic lookup from a list of offers to identify the particular active offer.
In some embodiments, the inventive systems of the present invention then tags/flags each record of web originated activity records as being: attributable or non-attributable. In some embodiments, the inventive systems of the present invention can then generate a report (e.g., an electronic output) of non-attributable web originated activity records for further actions such as automatic discovery and correction of errors.
In some embodiments, if needed, the inventive systems of the present invention then performs time adjusting to a particular single uniform time zone.
For example, if the attributably tagged records obtained from a web originated activity data analytics source are already time stamped based on the desired single uniform time zone, then no further time adjustment is needed.
In other scenarios, for example, if the desired single uniform time zone is the U.S. Eastern time zone and the attributably tagged records obtained from a web originated activity data analytics source whose servers log transactions based on the Western time zone in respect to the main time zones of the U.S., or log records in two or more different time zones, then the inventive systems of the present invention would process the attributable web records to be adjusted to the desired single uniform time zone. In some embodiments, the inventive systems of the present invention can use geographic location(s) of where the web data analytics source is located to, automatically and in real time, determine the particular single uniform time zone to which all attributable records need to be adjusted. In some embodiments, the inventive systems of the present invention can utilize one or more of the following parameters to synchronize/adjust to a single uniform time zone (e.g., the U.S. Eastern time zone) airing records, the attributable web originated activity records, or both.
Media Airing Time & Local Time Parameters
In some embodiments, the inventive systems of the present invention can, for example, adjust the airing records (e.g., media agency response records (MARs)) based on a time zone in which a particular airing of the particular creative associated with the particular offer was shown/distributed. For instance, if the desired uniform time zone for synchronizing the airing records and the web originated activity records is the U.S. Eastern time zone, and the airing was shown at 9 A.M. Western Standard Time (WST), the airing time is adjusted to 12 P.M. Eastern Standard Time (EST) in the airing record. If there are two airings in two different time zones (e.g., a 1st airing at 9 AM EST and a 2nd airing at 9 AM WST), the inventive systems of the present invention can generate a secondary host airing record having the airing time based on the first airing (e.g., 9 AM EST) and the secondary host airing (12 PM EST).
IP Address of a Computer Device Associated with the Web Originated Activity (e.g., Order)
In some embodiments, the inventive systems of the present invention can utilize IP addresses from the web originated activity records to determine if there is a need for time adjustment of the airing records, the web originated activity records (e.g., web order records), or both. In some embodiments, the inventive systems of the present invention can utilize a suitable IP address mapping tool to determine a time zone associated with the particular IP address.
Web Host Location
In some embodiments, the inventive systems of the present invention can identify a geographic location of a web host that is hosting a webpage to which customers are directed by the campaign's airings for placing their orders to determine if there is a need for time adjustment of the airing records, the web originated activity records (e.g., web order records), or both.
After the time adjustment operation(s), if such is needed, in some embodiments, the inventive systems of the present invention would have a dataset of all media airings associated with the particular offer where all times are adjusted to the same time zone. In some embodiments, the inventive systems of the present invention then selects a particular pre-determined time reference window (i.e., a time period ending at the time of the web order and starting at a pre-determined time prior to the web order time) to identify media airings based on length, such as, but is not limited to:
:15/:30—30 Minute Window
:60/:120—2 Hour Window
5 Min—4 Hour Window
28:30—8 Hour Window.
In some embodiments, the inventive systems of the present invention can automatically and in real time select the particular time window and/or a user can utilize at a specifically programmed user graphical interface to select/adjust particular time window. For instance,
In some embodiments, the inventive systems of the present invention can select the particular time window and/or a user can utilize at a specifically programmed user graphical interface to select/adjust particular time window. For instance,
After the group(s) of media airings is/are identified, in some embodiments, the inventive systems of the present invention would utilize an IP address of the web order to determine which area(s) of media coverage to associate with a customer who placed the particular order. In some embodiments, the inventive systems of the present invention can utilize the area groupings such as DMA (Designated Market Area) regions which are the geographic areas in the United States in which local television viewing is measured by The Nielsen Company. For example, a DMA region can be a group of counties that form an exclusive geographic area in which the home market television stations hold a dominance of total hours viewed. In the Nielsen′ example, there are 210 DMA regions, covering the entire continental United States, Hawaii, and parts of Alaska.
In some embodiments, the inventive systems of the present invention can then use the particular geographic area(s) associated with the customer of the web order to further select for a potential match to media airings within particular time window(s). For example, in case of using DMA regions, in some embodiments, the inventive systems of the present invention can be configured to select media airings which are (1) local to the customer's local DMA and/or (2) national based airings covering all or a few DMA regions which includes the customer's local DMA. For example,
National Cable airings
Satellite airings
Local airings within the New York DMA.
After the potential media airings are selected based on geographic areas, in some embodiments, as shown in
After the statistical measure has been applied, in some embodiments, as shown in
In some embodiments, the inventive systems of the present invention can continuously re-run the attribution processes if particular condition(s)/trigger(s) is/are met. For example, if a web order is attributed to an airing, which is then removed from the database of MARs in a future update from a media agency, any order(s) which matched the removed airing previously are re-run through the web attribution process to be assigned to a new airing. For example, an airing may be removed from the database of MARs because it did not clear, or did not run, or the offer was decided in future to be non-attributable.
In some embodiments, after the particular web originated activity (e.g., web order) has been attributed to a particular media airing, the inventive systems of the present invention can utilize the attributed transaction for further analysis by systems such as described in the U.S. patent application Ser. No. 14/455,826, entitled “METHODS AND SYSTEMS FOR ANALYZING KEY PERFORMANCE METRICS,” whose specific disclosures are hereby incorporated herein by reference in their entirety.
In some embodiments, after the particular web order has been attributed to the particular media airing, the inventive systems of the present invention stores this transaction into a specialized database for further references and data analysis.
In some embodiments, the inventive systems of the present invention can generate various visual real-time updatable reports showing the status of web attribution process on a periodic basis (e.g., day, week, month, etc.).
In some embodiments, the inventive systems of the present invention can generate a cost to acquire, by DMA-based, validation model interactive report and analysis.
In some embodiments, after the particular web order has been attributed to the particular media airing and when Fulfillment data is available, the inventive systems of the present invention matches/identifies at least one fulfillment record matching the web attributed order based, at least in part, on MAR/airing and IP address, and updates its database with URL, Customer Name and Address. In some embodiments, the inventive systems of the present invention, can update the web attributed data based on fulfillment data and utilize the matched record for tracking fulfillment events (e.g., cancellation, future orders, installment payment, etc.).
In some embodiments, the inventive systems of the present invention utilize machine learning feedback to build offer(s) based on web and MAR data.
In some embodiments, the inventive systems of the present invention utilizes two or more web data sources to attribute the particular web order to the particular media airing. In some embodiments, the inventive systems of the present invention utilizes two or more web data sources and fulfillment data to attribute the particular web order to the particular media airing.
Fulfillment Data Feed
In some embodiments, fulfillment data feeds are matched to call center data, web data, media data, based on a plurality of fields such as Order ID, Offer ID, Name & Address, and Order Amount. In some embodiments, the fulfillment data is received with a time delay such as 3-5 business days behind the call center and/or web data. In some embodiments, to match the Call Center Database Record to the Fulfillment Data Feed, the inventive systems of the present invention utilize the match logic that can be based on a plurality of the following fields:
Order Date
Zip (e.g., 5 Digits, 9 digits, 11 digits)
Last Name (e.g., first 5 letters)
Order Amount
Street Name (e.g., first 5 characters).
In some embodiments, once Call Center Data and fulfillment data are matched, the inventive systems of the instant invention automatically assign tags and create master records in the tagging database.
In some embodiments, the inventive computer systems can host a large number of users (e.g., at least 10, at least 100, at least 1,000, at least 10,000; at least 100,000; at least 1,000,000) and perform a large number of concurrent transactions (e.g., at least 1,000, at least 10,000; at least 100,000; at least 1,000,000).
In some embodiments, the inventive computer systems are based on a scalable computer and network architecture that incorporates various strategies for assessing the data, caching, searching, and database connection pooling. An example of the scalable architecture is an architecture that is capable of operating multiple servers. In embodiments, the computing system in accordance with the instant invention may include, but not limiting to, one or more programmed computers, systems employing distributed networking, or other type of system that might be used to transmit and process electronic data.
The one or more user devices, e.g. user device 120-1, user device 120-2, and user device 120-3, may any type of computing device, including a mobile telephone, a laptop, tablet, or desktop computer having, a netbook, a video game device, a pager, a smart phone, an ultra-mobile personal computer (UMPC), or a personal data assistant (PDA). The one or more user devices may run one or more applications, such as Internet browsers, mobile applications, voice calls, video games, videoconferencing, and email, among others. The one or more user devices may be any combination of computing devices. These devices may be coupled to network 130. Network 130 may provide network access, data transport and other services to the devices coupled to it. In general, network 130 may include and implement any commonly defined network architectures including those defined by standards bodies, such as the Global System for Mobile communication (GSM) Association, the Internet Engineering Task Force (IETF), and the Worldwide Interoperability for Microwave Access (WiMAX) forum. For example, network 130 may implement one or more of a GSM architecture, a General Packet Radio Service (GPRS) architecture, a Universal Mobile Telecommunications System (UMTS) architecture, and an evolution of UMTS referred to as Long Term Evolution (LTE). Network 130 may, again as an alternative or in conjunction with one or more of the above, implement a WiMAX architecture defined by the WiMAX forum. Network 130 may also comprise, for instance, a local area network (LAN), a wide area network (WAN), the Internet, a virtual LAN (VLAN), an enterprise LAN, a layer 3 virtual private network (VPN), an enterprise IP network, or any combination thereof.
Server 150 or server 180 may also be any type of computing device coupled to network 130, including but not limited to a personal computer, a server computer, a series of server computers, a mini computer, and a mainframe computer, or combinations thereof. Server 150 or server 180 may be a web server (or a series of servers) running a network operating system, examples of which may include but are not limited to Microsoft Windows Server, Novell NetWare, or Linux. Server 150 or server 180 may be used for and/or provide cloud and/or network computing. Although not shown in
Database 155 may be any type of database, including a database managed by a database management system (DBMS). A DBMS is typically implemented as an engine that controls organization, storage, management, and retrieval of data in a database. DBMSs frequently provide the ability to query, backup and replicate, enforce rules, provide security, do computation, perform change and access logging, and automate optimization. Examples of DBMSs include Oracle database, IBM DB2, Adaptive Server Enterprise, FileMaker, Microsoft Access, Microsoft SQL Server, MySQL, PostgreSQL, and a NoSQL implementation. A DBMS typically includes a modeling language, data structure, database query language, and transaction mechanism. The modeling language is used to define the schema of each database in the DBMS, according to the database model, which may include a hierarchical model, network model, relational model, object model, or some other applicable known or convenient organization. Data structures can include fields, records, files, objects, and any other applicable known or convenient structures for storing data. A DBMS may also include metadata about the data that is stored.
Software module 165 may be a module that is configured to send, process, and receive information at server 150. Software module 165 may provide another mechanism for sending and receiving data at server 150 besides handling requests through web server functionalities. Software module 165 may send and receive information using any technique for sending and receiving information between processes or devices including but not limited to using a scripting language, a remote procedure call, an email, a tweet, an application programming interface, Simple Object Access Protocol (SOAP) methods, Common Object Request Broker Architecture (CORBA), HTTP (Hypertext Transfer Protocol), REST (Representational State Transfer), any interface for software components to communicate with each other, using any other known technique for sending information from a one device to another, or any combination thereof.
Although software module 165 may be described in relation to server 150, software module 165 may reside on any other device. Further, the functionality of software module 165 may be duplicated on, distributed across, and/or performed by one or more other devices, either in whole or in part.
ROM 440 may include a ROM device and/or another type of static storage device that may store static information and instructions for processor 420. Storage device 450 may include a magnetic disk and/or optical disk and its corresponding drive for storing information and/or instructions. Storage device 450 may include a single storage device or multiple storage devices, such as multiple storage devices operating in parallel. Moreover, storage device 450 may reside locally on the computing device 400 and/or may be remote with respect to a server and connected thereto via network and/or another type of connection, such as a dedicated link or channel.
Input device 460 may include any mechanism or combination of mechanisms that permit an operator to input information to computing device 400, such as a keyboard, a mouse, a touch sensitive display device, a microphone, a pen-based pointing device, and/or a biometric input device, such as a voice recognition device and/or a finger print scanning device. Output device 470 may include any mechanism or combination of mechanisms that outputs information to the operator, including a display, a printer, a speaker, etc.
Communication interface 480 may include any transceiver-like mechanism that enables computing device 400 to communicate with other devices and/or systems, such as a client, a server, a license manager, a vendor, etc. For example, communication interface 480 may include one or more interfaces, such as a first interface coupled to a network and/or a second interface coupled to a license manager. Alternatively, communication interface 480 may include other mechanisms (e.g., a wireless interface) for communicating via a network, such as a wireless network. In one implementation, communication interface 480 may include logic to send code to a destination device, such as a target device that can include general purpose hardware (e.g., a personal computer form factor), dedicated hardware (e.g., a digital signal processing (DSP) device adapted to execute a compiled version of a model or a part of a model), etc.
Computing device 400 may perform certain functions in response to processor 420 executing software instructions contained in a computer-readable medium, such as memory 430. In alternative embodiments, hardwired circuitry may be used in place of or in combination with software instructions to implement features consistent with principles of the disclosure. Thus, implementations consistent with principles of the disclosure are not limited to any specific combination of hardware circuitry and software.
Exemplary embodiments may be embodied in many different ways as a software component. For example, it may be a stand-alone software package, a combination of software packages, or it may be a software package incorporated as a “tool” in a larger software product. It may be downloadable from a network, for example, a website, as a stand-alone product or as an add-in package for installation in an existing software application. It may also be available as a client-server software application, or as a web-enabled software application. It may also be embodied as a software package installed on a hardware device.
Numerous specific details have been set forth to provide a thorough understanding of the embodiments. It will be understood, however, that the embodiments may be practiced without these specific details. In other instances, well-known operations, components and circuits have not been described in detail so as not to obscure the embodiments. It can be appreciated that the specific structural and functional details are representative and do not necessarily limit the scope of the embodiments. It is worthy to note that any reference to “one embodiment” or “an embodiment” means that a particular feature, structure, or characteristic described in connection with the embodiment is included in at least one embodiment. The appearances of the phrases “in one embodiment” or “in some embodiments” in the specification are not necessarily all referring to the same embodiment.
Although some embodiments may be illustrated and described as comprising exemplary functional components or modules performing various operations, it can be appreciated that such components or modules may be implemented by one or more hardware components, software components, and/or combination thereof. The functional components and/or modules may be implemented, for example, by logic (e.g., instructions, data, and/or code) to be executed by a logic device (e.g., processor). Such logic may be stored internally or externally to a logic device on one or more types of computer-readable storage media.
Some embodiments may comprise an article of manufacture. An article of manufacture may comprise a storage medium to store logic. Examples of a storage medium may include one or more types of computer-readable storage media capable of storing electronic data, including volatile memory or non-volatile memory, removable or non-removable memory, erasable or non-erasable memory, writeable or re-writeable memory, and so forth. Examples of storage media include hard drives, disk drives, solid state drives, and any other tangible storage media.
In some embodiments, the present invention is directed to a computer system which includes at least the following components: at least one specifically programmed server; at least one non-transitory web attribution database accessible by the at least one specifically programmed server, where the at least one web attribution database is specifically programmed to be dedicated for use by the at least one specifically programmed server; where the at least one specifically programmed server comprises a plurality of modules configured to perform at least the following operations: electronically and periodically obtaining, over the computer network, by a media data programmed computer interface module of the at least one specifically programmed server, media data from a plurality of computer systems of media data sources, where the media data is associated with a plurality of media airings of a plurality creatives; electronically and periodically obtaining, over a computer network, by a web data programmed computer interface module of the at least one specifically programmed server, web tracking transaction data from a computer system of at least one web tracking electronic source; where the web tracking transaction data including web tracking metrics for web originated activities for at least one website associated with at least one offer of at least one creative; where web originated activities comprise web orders placed in response to the at least one offer associated with the at least one creative; for each web order record in the transactional web data: based on an item identifier of at least one item and a price of the at least one item corresponding to a particular web order corresponding to such web order record, determining, the at least one specifically programmed server, at least one particular offer associated with the particular web order, based on the at least one particular offer, determining, the at least one specifically programmed server, a length of a creative which has used for promoting the at least one item; based on the particular offer, identifying, the at least one specifically programmed server, a subset of media agency records in the media data which are potentially attributable to such particular web order; adjusting, the at least one specifically programmed server, a time of airing for each record in the subset of media agency records based on at least one of: i) a predetermined uniform time zone, and ii) an IP address associated with the web order, and iii) a geographic location of a web host at which the particular web order was placed; based on the length of the creative, selecting, the at least one specifically programmed server, a first subgroup of media agency records from the subset of media agency records, where the length of the creative corresponds to a predetermine time window, where the predetermined time window ends at the time of the particular web order, and continues in the past for a predetermined time duration; based on an IP address of the particular web order from the transactional web data, selecting, the at least one specifically programmed server, a second subgroup of media agency records from the first subgroup of media agency records, where the second subgroup of media agency records correspond to media airings shown in a geographic locality of the particular web order; determining, by the at least one specifically programmed server, for each media airing of the second subgroup, a probability of attribution based on cost of such media airing or viewership rating; based on the probability of attribution, duplicating, by the at least one specifically programmed server, a particular media airing record of the second subgroup X times in the dedicated database to obtain a third subgroup, where X is a whole number based on rounding the probability of attribution; assigning, by the at least one specifically programmed server, to each record in the third subgroup a random value within a predetermined number range between Y1 and Y2, where Y2 is larger than Y1; based on the random value, ranking, by the at least one specifically programmed server, each record in the third subgroup so that a particular media airing having the random value which is the closest to Y2 is assigned the highest rank; attributing, by the at least one specifically programmed server, the particular web order to the particular media airing having the highest rank; and displaying, the at least one specifically programmed server, utilizing at least one graphical user interface, a real time updatable web attribution report.
In some embodiments, the at least one specifically programmed server is further configured to: electronically and real-time obtain, by a fulfillment data programmed computer interface module of the at least one specifically programmed server, from a computer system of at least one fulfillment electronic source, fulfillment transaction data; where the fulfillment transaction data including a plurality of at least thousand fulfillment records associated a plurality of at least thousand fulfillment transactions for the web orders; where each fulfillment record identifies each fulfillment transaction being associated with a particular web order; and matching, in real-time, records between web records and fulfillment records based, at least in part, on: i) an order date, ii) a 5 digit Zip code, iii) a last name, iv) an order amount, and v) optionally, a street name.
In some embodiments, the at least one web tracking electronic source is selected from the group consisting of: Piwik, Google Analytics, and Omniture.
In some embodiments, the length of the creative corresponds to the predetermine time window based on the following rules: i) when the length of the creative is between 15 and 30 seconds, the predetermined time window is 30 minutes, ii) when the length of the creative is between 60 and 120 seconds, the predetermined time window is 2 hours, iii) when the length of the creative is 5 minutes, the predetermined time window is 4 hours, and iv) when the length of the creative is 28 minutes and 30 seconds, the predetermined time window is 8 hours. In some embodiments, Y1 is 0, and Y2 is 1. In some embodiments, the random value is generated by a random value generator. In some embodiments, the predetermined time zone is selected from the group consisting of: U.S. Eastern time zone, U.S. Central time zone, and U.S. Western time zone.
In some embodiments, the media airing is an airing which is selected from the group consisting of: a television station airing, a radio station airing, a video-on-demand airing, a web-promoted offer airing, and a mobile message airing. In some embodiments, the viewership rating is Nielsen rating.
In some embodiments, the present invention is directed to a computer-implemented method which includes at least the following steps: electronically and periodically obtaining, over the computer network, by a media data programmed computer interface module of the at least one specifically programmed server, media data from a plurality of computer systems of media data sources, where the media data is associated with a plurality of media airings of a plurality creatives; electronically and periodically obtaining, over a computer network, by a web data programmed computer interface module of the at least one specifically programmed server, web tracking transaction data from a computer system of at least one web tracking electronic source; where the web tracking transaction data including web tracking metrics for web originated activities for at least one website associated with at least one offer of at least one creative; where web originated activities comprise web orders placed in response to the at least one offer associated with the at least one creative; for each web order record in the transactional web data: based on an item identifier of at least one item and a price of the at least one item corresponding to a particular web order corresponding to such web order record, determining, the at least one specifically programmed server, at least one particular offer associated with the particular web order, based on the at least one particular offer, determining, the at least one specifically programmed server, a length of a creative which has used for promoting the at least one item; based on the particular offer, identifying, the at least one specifically programmed server, a subset of media agency records in the media data which are potentially attributable to such particular web order; adjusting, the at least one specifically programmed server, a time of airing for each record in the subset of media agency records based on at least one of: i) a predetermined uniform time zone, and ii) an IP address associated with the web order, and iii) a geographic location of a web host at which the particular web order was placed; based on the length of the creative, selecting, the at least one specifically programmed server, a first subgroup of media agency records from the subset of media agency records, where the length of the creative corresponds to a predetermine time window, where the predetermined time window ends at the time of the particular web order, and continues in the past for a predetermined time duration; based on an IP address of the particular web order from the transactional web data, selecting, the at least one specifically programmed server, a second subgroup of media agency records from the first subgroup of media agency records, where the second subgroup of media agency records correspond to media airings shown in a geographic locality of the particular web order; determining, by the at least one specifically programmed server, for each media airing of the second subgroup, a probability of attribution based on cost of such media airing or viewership rating; based on the probability of attribution, duplicating, by the at least one specifically programmed server, a particular media airing record of the second subgroup X times in the dedicated database to obtain a third subgroup, where X is a whole number based on rounding the probability of attribution; assigning, by the at least one specifically programmed server, to each record in the third subgroup a random value within a predetermined number range between Y1 and Y2, where Y2 is larger than Y1; based on the random value, ranking, by the at least one specifically programmed server, each record in the third subgroup so that a particular media airing having the random value which is the closest to Y2 is assigned the highest rank; attributing, by the at least one specifically programmed server, the particular web order to the particular media airing having the highest rank; and displaying, the at least one specifically programmed server, utilizing at least one graphical user interface, a real time updatable web attribution report.
It also is to be appreciated that the described embodiments illustrate exemplary implementations, and that the functional components and/or modules may be implemented in various other ways which are consistent with the described embodiments. Furthermore, the operations performed by such components or modules may be combined and/or separated for a given implementation and may be performed by a greater number or fewer number of components or modules.
While various exemplary embodiments have been described above, it should be understood that they have been presented by way of example only, and not limitation. Thus, the breadth and scope of the present disclosure should not be limited by any of the above-described exemplary embodiments.
This application is a continuation of U.S. patent application Ser. No. 15/395,535, entitled “DATABASE DRIVEN COMPUTER SYSTEMS AND COMPUTER-IMPLEMENTED METHODS FOR ATTRIBUTING IN REAL-TIME WEB ORIGINATED ACTIVITIES TO MEDIA EVENTS AND TRACKING THE PERFORMANCE THEREOF”, filed Dec. 30, 2016, which is a continuation of U.S. patent application Ser. No. 15/012,595, entitled “DATABASE DRIVEN COMPUTER SYSTEMS AND COMPUTER-IMPLEMENTED METHODS FOR PROCESSING REAL-TIME ATTRIBUTION OF WEB ORIGINATED ACTIVITIES TO MEDIA AGENCY RECORDS AND TRACKING THEREOF”, filed Feb. 1, 2016 which is a continuation of U.S. patent application Ser. No. 14/736,017, entitled “DATABASE DRIVEN COMPUTER SYSTEMS AND COMPUTER-IMPLEMENTED METHODS FOR PROCESSING REAL-TIME ATTRIBUTION OF WEB ORIGINATED ACTIVITIES TO AIRINGS AND TRACKING THEREOF”, filed Jun. 10, 2015, which is incorporated herein by reference in its entirety for all purposes.
| Number | Date | Country | |
|---|---|---|---|
| Parent | 15395535 | Dec 2016 | US |
| Child | 15870358 | US | |
| Parent | 15012595 | Feb 2016 | US |
| Child | 15395535 | US | |
| Parent | 14736017 | Jun 2015 | US |
| Child | 15012595 | US |
