Data translation for video-viewing activity
Methods, systems and apparatuses are described for using Linear, DVR, and VOD video viewing activity data for more efficient downstream processing to create analytical studies of second-by-second viewing activity for program, channel, house, device, viewer, demographic, and geographic attributes. Such attributes may be determined for one or more viewing devices. Attributes associated with different viewing devices may be replaced with a common substitute value. Video viewing metrics associated with a common substitute value may be determined.
1. A method comprising:
determining, by a computing system and based on video-viewing-activity data received from a plurality of video-asset-viewing devices, an attribute for each of the plurality of video-asset-viewing devices;
replacing an attribute associated with a first video-asset-viewing device of the plurality of video-asset-viewing devices and a different attribute associated with a second video-asset-viewing device of the plurality of video-asset-viewing devices with a common substitute value; and
based on a first plurality of time intervals during which the first video-asset-viewing device outputted a video asset and a second plurality of time intervals during which the second video-asset-viewing device outputted the video asset, determining a video-viewing-activity metric associated with the common substitute value.
2. The method of claim 1 , wherein the video asset comprises an advertisement.
3. The method of claim 1 , further comprising:
determining a mapping of a plurality of attributes to the common substitute value.
4. The method of claim 1 , wherein the attribute associated with the first video-asset-viewing device, the different attribute associated with the second video-asset-viewing device, and the common substitute value are associated with a same type of attribute of a plurality of types of attributes.
5. The method of claim 4 , wherein the plurality of types of attributes comprise two or more of a video-content-description type of attribute, a viewer-geographic-location type of attribute, a viewer-demographic type of attribute, or a video-asset-viewing-device-characteristic type of attribute.
6. The method of claim 1 , wherein the common substitute value comprises a shortened version of the attribute associated with the first video-asset-viewing device and the different attribute associated with the second video-asset-viewing device.
7. The method of claim 1 , wherein the common substitute value comprises a descriptor describing the attribute associated with the first video-asset-viewing device and the different attribute associated with the second video-asset-viewing device.
8. The method of claim 1 , further comprising:
associating each time interval of the first plurality of time intervals with the common substitute value.
9. The method of claim 1 , wherein the attribute associated with the first video-asset-viewing device comprises a textual value, and wherein the common substitute value comprises a different textual value.
10. The method of claim 1 , further comprising:
associating each time interval of the first plurality of time intervals with an indication of a computing device that sends the video asset to the plurality of video-asset-viewing devices; and
associating each time interval of the second plurality of time intervals with an indication of the computing device.
11. The method of claim 1 , wherein the replacing the attribute and the different attribute is based on determining that the attribute associated with the first video-asset-viewing device and the different attribute associated with the second video-asset-viewing device satisfy a mapping of attributes to target values.
12. The method of claim 1 , further comprising:
receiving, for a data-translation table, one or more user-defined parameters comprising the attribute associated with the first video-asset-viewing device, the different attribute associated with the second video-asset-viewing device, and the common substitute value; and
generating, by the computing system and based on the one or more user-defined parameters, the data-translation table.
13. An apparatus comprising:
one or more processors;
memory storing instructions that, when executed by the one or more processors, cause the apparatus to:
determine, based on video-viewing-activity data received from a plurality of video-asset-viewing devices, an attribute for each of the plurality of video-asset-viewing devices;
replace an attribute associated with a first video-asset-viewing device of the plurality of video-asset-viewing devices and a different attribute associated with a second video-asset-viewing device of the plurality of video-asset-viewing devices with a common substitute value; and
based on a first plurality of time intervals during which the first video-asset-viewing device outputted a video asset and a second plurality of time intervals during which the second video-asset-viewing device outputted the video asset, determine a video-viewing-activity metric associated with the common substitute value.
14. The apparatus of claim 13 , wherein the video asset comprises an advertisement.
15. The apparatus of claim 13 , wherein the instructions, when executed by the one or more processors, further cause the apparatus to:
determine a mapping of a plurality of attributes to the common substitute value.
16. The apparatus of claim 13 , wherein the common substitute value comprises a shortened version of the attribute associated with the first video-asset-viewing device and the different attribute associated with the second video-asset-viewing device.
17. The apparatus of claim 13 , wherein the common substitute value comprises a descriptor describing the attribute associated with the first video-asset-viewing device and the different attribute associated with the second video-asset-viewing device.
18. The apparatus of claim 13 , wherein the instructions, when executed by the one or more processors, further cause the apparatus to:
associate each time interval of the first plurality of time intervals with the common substitute value.
19. The apparatus of claim 13 , wherein the instructions, when executed by the one or more processors, further cause the apparatus to:
associate each time interval of the first plurality of time intervals with an indication of a computing device that sends the video asset to the plurality of video-asset-viewing devices.
20. The apparatus of claim 13 , wherein the instructions, when executed by the one or more processors, further cause the apparatus to replace the attribute and the different attribute based on determining that the attribute associated with the first video-asset-viewing device and the different attribute associated with the second video-asset-viewing device satisfy a mapping of attributes to target values.
21. The apparatus of claim 13 , wherein the instructions, when executed by the one or more processors, further cause the apparatus to:
receive, for a data-translation table, one or more user-defined parameters comprising the attribute associated with the first video-asset-viewing device, the different attribute associated with the second video-asset-viewing device, and the common substitute value; and
generate, based on the one or more user-defined parameters, the data-translation table.
22. A system comprising:
a computing device comprising:
one or more first processors; and
memory storing instructions that, when executed by the one or more first processors, cause the computing device to:
determine, based on video-viewing-activity data received from a plurality of video-asset-viewing devices, an attribute for each of the plurality of video-asset-viewing devices;
replace an attribute associated with a first video-asset-viewing device of the plurality of video-asset-viewing devices and a different attribute associated with a second video-asset-viewing device of the plurality of video-asset-viewing devices with a common substitute value; and
based on a first plurality of time intervals during which the first video-asset-viewing device outputted a video asset and a second plurality of time intervals during which the second video-asset-viewing device outputted the video asset, determine a video-viewing-activity metric associated with the common substitute value; and
a video-asset-viewing device comprising:
one or more second processors; and
memory storing instructions that, when executed by the one or more second processors, cause the video-asset-viewing device to send at least a portion of the video-viewing-activity data.
23. The system of claim 22 , wherein the video asset comprises an advertisement.
24. The system of claim 22 , wherein the instructions stored in the memory of the computing device, when executed by the one or more first processors of the computing device, further cause the computing device to:
determine a mapping of a plurality of attributes to the common substitute value.
25. The system of claim 22 , wherein the instructions stored in the memory of the computing device, when executed by the one or more first processors of the computing device, further cause the computing device to:
associate each time interval of the first plurality of time intervals with the common substitute value.
26. The system of claim 22 , wherein the instructions stored in the memory of the computing device, when executed by the one or more first processors of the computing device, further cause the computing device to:
associate each time interval of the first plurality of time intervals with an indication of a computing device that sends the video asset to the plurality of video-asset-viewing devices; and
associate each time interval of the second plurality of time intervals with an indication of the computing device.
27. The system of claim 22 , wherein the instructions stored in the memory of the computing device, when executed by the one or more first processors of the computing device, further cause the computing device to replace the attribute and the different attribute based on determining that the attribute associated with the first video-asset-viewing device and the different attribute associated with the second video-asset-viewing device satisfy a mapping of attributes to target values.
28. The system of claim 22 , wherein the instructions stored in the memory of the computing device, when executed by the one or more first processors of the computing device, further cause the computing device to:
receive, for a data-translation table, one or more user-defined parameters comprising the attribute associated with the first video-asset-viewing device, the different attribute associated with the second video-asset-viewing device, and the common substitute value; and
generate, based on the one or more user-defined parameters, the data-translation table.
29. One or more non-transitory computer readable media storing instructions that, when executed cause:
determining, based on video-viewing-activity data received from a plurality of video-asset-viewing devices, an attribute for each of the plurality of video-asset-viewing devices;
replacing an attribute associated with a first video-asset-viewing device of the plurality of video-asset-viewing devices and a different attribute associated with a second video-asset-viewing device of the plurality of video-asset-viewing devices with a common substitute value; and
based on a first plurality of time intervals during which the first video-asset-viewing device outputted a video asset and a second plurality of time intervals during which the second video-asset-viewing device outputted the video asset, determining a video-viewing-activity metric associated with the common substitute value.
30. The one or more non-transitory computer readable media of claim 29 , wherein the video asset comprises an advertisement.
31. The one or more non-transitory computer readable media of claim 29 , wherein the instructions, when executed, further cause:
determining a mapping of a plurality of attributes to the common substitute value.
32. The one or more non-transitory computer readable media of claim 29 , wherein the instructions, when executed, further cause:
associating each time interval of the first plurality of time intervals with the common substitute value.
33. The one or more non-transitory computer readable media of claim 29 , wherein the instructions, when executed, further cause:
associating each time interval of the first plurality of time intervals with an indication of a computing device that sends the video asset to the plurality of video-asset-viewing devices; and
associating each time interval of the second plurality of time intervals with an indication of the computing device.
34. The one or more non-transitory computer readable media of claim 29 , wherein the instructions, when executed, further cause replacing the attribute and the different attribute based on determining that the attribute associated with the first video-asset-viewing device and the different attribute associated with the second video-asset-viewing device satisfy a mapping of attributes to target values.
35. The one or more non-transitory computer readable media of claim 29 , wherein the instructions, when executed, further cause:
receiving, for a data-translation table, one or more user-defined parameters comprising the attribute associated with the first video-asset-viewing device, the different attribute associated with the second video-asset-viewing device, and the common substitute value; and generating, based on the one or more user-defined parameters, the data-translation table.