Systems and methods for extracting data views from heterogeneous sources

A non-transitory computer-readable medium having stored thereon instructions executable by one or more processors to cause a computing system to perform functions comprising:

• receiving, from a first playback device running a first software application, first log data corresponding to a first playback event, wherein:
• the first log data comprises a first data field identifier corresponding to a first data field;
• and
• the first data field corresponds to a particular playback event characteristic and is populated with a first value corresponding to the first playback event;
• receiving, from a second playback device running a second software application, second log data corresponding to a second playback event, wherein:
• the second log data comprises a second data field identifier corresponding to a second data field;
• the second data field corresponds to the particular playback event characteristic and is populated with a second value corresponding to the second playback event;
• and
• the second data field identifier is different from the first data field identifier;
• and
• generating a query to obtain, using the first log data and the second log data:
• a list of playback events comprising the first playback event and the second playback event;
• and
• respective values for the particular playback event characteristic comprising the first value corresponding to the first playback event and the second value corresponding to the second playback event, wherein, in the query:
• the first value and the second value are both associated with a common data field identifier;
• the common data field identifier corresponds to the first data field identifier for the first software application and to the second data field identifier for the second software application;
• and
• the common data field identifier is different from at least one of the first data field identifier or the second data field identifier.

A method to be performed by a computing device, the method comprising:

• receiving, from a first playback device running a first software application, first log data corresponding to a first playback event, wherein:
• the first log data comprises a first data field identifier corresponding to a first data field;
• and
• the first data field corresponds to a particular playback event characteristic and is populated with a first value corresponding to the first playback event;
• receiving, from a second playback device running a second software application, second log data corresponding to a second playback event, wherein:
• the second log data comprises a second data field identifier corresponding to a second data field;
• the second data field corresponds to the particular playback event characteristic and is populated with a second value corresponding to the second playback event;
• and
• the second data field identifier is different from the first data field identifier;
• and
• generating a query to obtain, using the first log data and the second log data:
• a list of playback events comprising the first playback event and the second playback event;
• and
• respective values for the particular playback event characteristic comprising the first value corresponding to the first playback event and the second value corresponding to the second playback event, wherein, in the query:
• the first value and the second value are both associated with a common data field identifier;
• the common data field identifier corresponds to the first data field identifier for the first software application and to the second data field identifier for the second software application;
• and
• the common data field identifier is different from at least one of the first data field identifier or the second data field identifier.