# US 2016/0366455 A1 · Database driven computer systems and computer-implemented methods for processing real-time attribution of web originated activities to media agency records and tracking thereof > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2016/0366455 A1 - Document ID: US20160366455A1 - Status: Published application - Kind: A1 - Application number: 15/012,595 - Filed: 2016-02-01 - Published: 2016-12-15 - Earliest claimed: 2015-06-10 - Inventors: Monica C. Smith - Web page: https://patentgrep.com/patent/US20160366455A1 ## CPC - H04N 21/812: {involving advertisement data (advertising per se G06Q30/02)} - G06Q 30/0201: Market modelling; Market analysis; Collecting market data - G06Q 30/0246: {Traffic} - H04N 21/23424: {involving splicing one content stream with another content stream, e.g. for inserting or substituting an advertisement} - H04N 21/2407: {Monitoring of transmitted content, e.g. distribution time, number of downloads (arrangements for monitoring programmes for broadcast or for distribution combined with broadcast H04H20/14)} - H04N 21/252: {Processing of multiple end-users' preferences to derive collaborative data} - H04N 21/2543: Billing {, e.g. for subscription services (payment schemes, architectures or protocols G06Q20/00; e-commerce G06Q30/00; arrangements for billing for the use of broadcast information or broadcast-related information H04H60/21)} - H04N 21/25841: {involving the geographical location of the client (retrieval from the Internet by querying based on geographical locations G06F16/9537; arrangements for identifying locations of receiving stations in broadcast systems H04H60/51; location of the user terminal in data switching networks H04L67/52; services making use of the location of users or terminals in wireless networks H04W4/02; locating users or terminals in wireless networks H04W64/00)} - H04N 21/25891: {being end-user preferences (retrieval of video data in a video database based on user preferences G06F16/739; arrangements for recognizing users' preferences H04H60/46; user profiles in network data switching protocols H04L67/306; processing of user preferences or user profiles in wireless networks H04W8/18)} - H04N 21/4108: {characterised by an identification number or address, e.g. local network address (protecting specific internal or external computer components using identification number G06F21/73; network arrangements, protocols or services for addressing or naming H04L61/00)} - H04N 21/44226: {on social networks} - H04N 21/4532: {involving end-user characteristics, e.g. viewer profile, preferences (monitoring of user activities for profile generation for accessing a video database G06F16/739; user profiles in network data switching protocols H04L67/306; processing of user preferences or user profiles in wireless networks H04W8/18)} - H04N 21/4663: {involving probabilistic networks, e.g. Bayesian networks} - H04N 21/47815: {Electronic shopping (payment schemes, payment architectures or payment protocols for electronic shopping systems G06Q20/12)} - H04N 21/84: Generation or processing of descriptive data, e.g. content descriptors {(systems specially adapted for using meta-information in broadcast systems H04H60/73)} - H04N: PICTORIAL COMMUNICATION, e.g. TELEVISION - G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR ## Abstract In some embodiments, the present invention is directed to a computer system which includes: a specifically programmed server, where the server includes a plurality of modules configured to perform at least: electronically and periodically obtaining, over a computer network, 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 web tracking transaction data from a computer system of a web tracking electronic source; where the web tracking transaction data including web tracking metrics for web originated activities; where web originated activities include web orders placed in response to the offer associated with the creative; for each web order record in the transactional web data: attributing, by the specifically programmed server, a particular web order to a particular media airing; and displaying a real time updatable web attribution report. ## Claims ### Claim 1 A computer system, comprising: at least one specifically programmed server; at least one non-transitory web attribution database accessible by the at least one specifically programmed server, wherein the at least one web attribution database is specifically programmed to be dedicated for use by the at least one specifically programmed server; wherein 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 agency data from a plurality of computer systems of media agency data sources, wherein the media agency data is associated with a plurality of media events related to a plurality of 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; wherein the web tracking transaction data comprising web tracking metrics for web originated activities for at least one website associated with at least one offer of at least one creative; wherein 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 agency data which are potentially attributable to such particular web order; adjusting, the at least one specifically programmed server, a time of events 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 particular 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, wherein the length of the creative corresponds to a predetermine time window, wherein the predetermined time window ends at the time of the web order, and continues in the past for a predetermined time duration; based on an IP address of the 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, wherein the second subgroup of media agency records correspond to media events shown in a geographic locality of the particular web order; determining, by the at least one specifically programmed server, for each media events of the second subgroup, a probability of attribution based on cost of such particular media events or viewership rating; based on the probability of attribution, duplicating, by the at least one specifically programmed server, a particular media event record of the second subgroup X times in the dedicated database to obtain a third subgroup, wherein 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, wherein 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 event 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 event 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. ### Claim 2 (depends on 1) The computer system of claim 1, wherein 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; wherein the fulfillment transaction data comprising a plurality of at least thousand fulfillment records associated a plurality of at least thousand fulfillment transactions for the web orders; wherein 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 Zip code, iii) a last name, iv) an order amount, and v) optionally, a street name. ### Claim 3 (depends on 1) The computer system of claim 1, wherein the at least one web tracking electronic source is selected from the group consisting of: Piwik, Google Analytics, and Omniture. ### Claim 4 (depends on 1) The computer system of claim 1, wherein 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 Z1 value; ii) when the length of the creative is between 60 and 120 seconds, the predetermined time window is Z2 value; iii) when the length of the creative is 5 minutes, the predetermined time window is Z3 value; iv) when the length of the creative is 28 minutes and 30 seconds, the predetermined time window is Z4 value; v) wherein the Z1 value is distinct from at least one of the Z2 value, the Z3 value, and the Z4 value; vi) wherein the Z2 value is distinct from at least one of the Z1 value, the Z3 value, and the Z4 value; vii) wherein the Z3 value is distinct from at least one of the Z1 value, the Z2 value, and the Z4 value; and viii) wherein the Z4 value is distinct from at least one of the Z1 value, the Z2 value, and the Z3 value. ### Claim 5 (depends on 1) The computer system of claim 1, wherein Y1 is 0, and Y2 is 1. ### Claim 6 (depends on 1) The computer system of claim 1, wherein the random value is generated by a random value generator. ### Claim 7 (depends on 1) The computer system of claim 1, wherein 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. ### Claim 8 (depends on 1) The computer system of claim 1, wherein the particular media event 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. ### Claim 9 (depends on 8) The computer system of claim 8, wherein the viewership rating is Nielsen rating. ### Claim 10 A computer-implemented method, comprising: electronically and periodically obtaining, over a computer network, by a media agency data programmed computer interface module of at least one specifically programmed server, media agency data from a plurality of computer systems of media agency data sources, wherein the media agency data is associated with a plurality of media events related to a plurality of creatives; electronically and periodically obtaining, over the 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; wherein the web tracking transaction data comprising web tracking metrics for web originated activities for at least one website associated with at least one offer of at least one creative; wherein 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 at least one particular offer, identifying, the at least one specifically programmed server, a subset of media agency records in the media agency data which are potentially attributable to the particular web order; adjusting, the at least one specifically programmed server, a time of event 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, wherein the length of the creative corresponds to a predetermine time window, wherein 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, wherein the second subgroup of media agency records correspond to media events shown in a geographic locality of the particular web order; determining, by the at least one specifically programmed server, for each media event of the second subgroup, a probability of attribution based on cost of such media event or viewership rating; based on the probability of attribution, duplicating, by the at least one specifically programmed server, a particular media event record of the second subgroup X times in the dedicated database to obtain a third subgroup, wherein 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, wherein 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 event 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 web order to the particular media event 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. ### Claim 11 (depends on 10) The method of claim 10, further comprising: electronically and real-time obtaining, 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; wherein the fulfillment transaction data comprising a plurality of at least thousand fulfillment records associated a plurality of at least thousand fulfillment transactions for the web orders; wherein 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 Zip code, iii) a last name, iv) an order amount, and v) optionally, a street name. ### Claim 12 (depends on 10) The method of claim 10, wherein the at least one web tracking electronic source is selected from the group consisting of: Piwik, Google Analytics, and Omniture. ### Claim 13 (depends on 10) The method of claim 10, wherein 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 Z1 value; ii) when the length of the creative is between 60 and 120 seconds, the predetermined time window is Z2 value; iii) when the length of the creative is 5 minutes, the predetermined time window is Z3 value; iv) when the length of the creative is 28 minutes and 30 seconds, the predetermined time window is Z4 value; v) wherein the Z1 value is distinct from at least one of the Z2 value, the Z3 value, and the Z4 value; vi) wherein the Z2 value is distinct from at least one of the Z1 value, the Z3 value, and the Z4 value; vii) wherein the Z3 value is distinct from at least one of the Z1 value, the Z2 value, and the Z4 value; and viii) wherein the Z4 value is distinct from at least one of the Z1 value, the Z2 value, and the Z3 value. ### Claim 14 (depends on 10) The method of claim 10, wherein Y1 is 0, and Y2 is 1. ### Claim 15 (depends on 10) The method of claim 10, wherein the random value is generated by a random value generator. ### Claim 16 (depends on 10) The method of claim 10, wherein 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. ### Claim 17 (depends on 10) The method of claim 10, wherein the particular media event 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. ### Claim 18 (depends on 17) The method of claim 17, wherein the viewership rating is Nielsen rating.