Connected devices Europe

Name: Connected devices - - Europe
SKU: c6c322c25d89
Availability: InStock

Market Intelligence Service

Region

The Connected devices market intelligence service offers an in-depth presentation of consumer electronics markets worldwide. Consumer devices regional and country installed base form part of the coverage, with a breakdown provided by platform and technology. The Smart TV consumption outbreak constitutes a key element of the coverage, with indicators including forecasts enabling the projection of market evolutions with precise and accurate manufacturers and OS market shares data points.

This service provides comprehensive coverage of connected devices (TV, tablets, computers, smartphones, game consoles), TV streaming platforms (Chromecast, Roku, Apple TV, Fire TV …) and internet audience by device through a wide range of in-depth financial and operational metrics. Historical and five-year forecasts are provided for each metric, in both dynamic dashboards and source table formats.

This quarterly and annually updated comprehensive database includes detailed figures split by manufacturer, device and country including:

Devices shipments worldwide – Data by manufacturer

Flat TV, tablets, computers, smartphones, game consoles
Total shipments, market share by actor
Quarterly history from 2015
Geography: World

Devices sales – Data by country

TV sets by functionality (4K, HD, Smart TV, Flat TV), computers, tablets, smartphones
Total devices sales, market share by vendor
Yearly history from 2008
Geography: World

Devices revenues forecasts – Data by country

Average selling price (ASP) and revenues
TV sets, tablets, smartphones, computers, game consoles
Yearly history from 2014 with 5-year forecasts
Geography: World

TV Streaming platform – Data by country and manufacturer

TV streaming platforms (Chromecast, Roku, Apple TV, Fire TV…)
Connected Smart TV sets and platform users
Quarterly history from 2014
Geography: Europe, North America, Latin America, Africa, Middle East

Smart TV by OS – Data by country and operating system

Smart TV users by operating system (OS)
Quarterly history from 2014
Geography: Europe, North America, Latin America, Africa, Middle East

Devices forecasts – Data by country

TV sets, tablets, smartphones, computers, game consoles
Households penetration and total installed base
Share of SD, HD, 4K, Smart TV
Share of installed base tablets & smartphone by OS (Android, iOS, others)
Yearly history from 1999 with 5-year forecasts
Geography: World

Any corporate subscription includes unlimited number of users and unlimited usage of the inquiry service – no hidden fees.

array(4) {
  ["Devices installed base"]=>
  array(2) {
    ["Connected TV streaming devices"]=>
    string(175) "Connected TV streaming devices (Quarterly) Number of active connected TV streaming devices such as Roku, Apple TV etc."
    ["Game consoles penetration "]=>
    string(141) "Game consoles penetration  (Yearly) Game consoles in use as percentage of households"
  }
  ["Devices sales"]=>
  array(33) {
    ["4K TV ASP"]=>
    string(184) "4K TV ASP (Yearly) The 4K TV ASP (Average Selling Price) is the average retail value of 4K TV sets in the country under review."
    ["4K TV Sales revenues"]=>
    string(121) "4K TV Sales revenues (Yearly) Revenue generated from 4K TV Sales"
    ["4K TV sales"]=>
    string(149) "4K TV sales (Yearly) Number of 4K (or ultra high definition) TV sets sold yearly by country."
    ["4K TV share of TV sales"]=>
    string(144) "4K TV share of TV sales (Yearly) 4K TV sets sold in percentage of yearly flat TV sales."
    ["AR and VR headset shipments"]=>
    string(134) "AR and VR headset shipments (Quarterly) Quarterly shipments of AR/VR Headsets"
    ["Computer ASP"]=>
    string(189) "Computer ASP (Yearly) The computer ASP (Average Selling Price) is the average retail value of computers in the country under review."
    ["Computer sales"]=>
    string(124) "Computer sales (Yearly) Number of computers sold yearly by country."
    ["Computer sales revenues"]=>
    string(127) "Computer sales revenues (Yearly) Revenue generated from Computer sales"
    ["Computer shipments"]=>
    string(147) "Computer shipments (Quarterly) Quarterly shipments of computers in the world, by supplier."
    ["Connected Smart TV sets"]=>
    string(154) "Connected Smart TV sets (Quarterly) Number of connectable TV sets (Smart TVs) actually connected."
    ["Flat TV ASP"]=>
    string(190) "Flat TV ASP (Yearly) The Flat TV ASP (Average Selling Price) is the average retail value of Flat TV sets in the country under review."
    ["Flat TV sales"]=>
    string(126) "Flat TV sales (Yearly) Number of flat TV sets sold yearly by country."
    ["Flat TV sales revenues"]=>
    string(125) "Flat TV sales revenues (Yearly) Revenue generated from Flat TV sales"
    ["Flat TV shipments"]=>
    string(180) "Flat TV shipments (Quarterly) Quarterly shipments of Flat TV in the world, by supplier. Excludes CRT (Cathode Ray Tube TV)."
    ["HD-ready TV ASP"]=>
    string(196) "HD-ready TV ASP (Yearly) The HD-ready TV ASP (Average Selling Price) is the average retail value of HD TV sets in the country under review."
    ["HD-ready TV sales"]=>
    string(128) "HD-ready TV sales (Yearly) Number of HD TV sets sold yearly by country."
    ["HD-ready TV sales revenues"]=>
    string(133) "HD-ready TV sales revenues (Yearly) Revenue generated from HD-ready TV sales"
    ["HD-ready TV share of TV sales"]=>
    string(150) "HD-ready TV share of TV sales (Yearly) HD TV sets sold in percentage of yearly flat TV sales."
    ["Home game console shipments"]=>
    string(165) "Home game console shipments (Quarterly) Quarterly shipments of home game consoles in the world, by supplier."
    ["Portable game console shipments"]=>
    string(173) "Portable game console shipments (Quarterly) Quarterly shipments of portable game consoles in the world, by supplier."
    ["Smart TV ASP"]=>
    string(193) "Smart TV ASP (Yearly) The Smart TV ASP (Average Selling Price) is the average retail value of Smart TV sets in the country under review."
    ["Smart TV sales"]=>
    string(145) "Smart TV sales (Yearly) Number of connectable TV sets (Smart TV) sold yearly by country."
    ["Smart TV sales revenues"]=>
    string(127) "Smart TV sales revenues (Yearly) Revenue generated from Smart TV sales"
    ["Smart TV share of TV sales"]=>
    string(168) "Smart TV share of TV sales (Yearly) Connectable TV sets (Smart TVs) sold in percentage of yearly flat TV sales."
    ["Smart speaker shipments"]=>
    string(126) "Smart speaker shipments (Quarterly) Quarterly sales of smart speakers"
    ["Smartphone ASP"]=>
    string(195) "Smartphone ASP (Yearly) The smartphone ASP (Average Selling Price) is the average retail value of smartphones in the country under review."
    ["Smartphone sales"]=>
    string(128) "Smartphone sales (Yearly) Number of smartphones sold yearly by country."
    ["Smartphone sales revenues"]=>
    string(131) "Smartphone sales revenues (Yearly) Revenue generated from Smartphone sales"
    ["Smartphone shipments"]=>
    string(151) "Smartphone shipments (Quarterly) Quarterly shipments of smartphones in the world, by supplier."
    ["Tablet ASP"]=>
    string(183) "Tablet ASP (Yearly) The tablet ASP (Average Selling Price) is the average retail value of tablets in the country under review."
    ["Tablet sales"]=>
    string(120) "Tablet sales (Yearly) Number of tablets sold yearly by country."
    ["Tablet sales revenues"]=>
    string(123) "Tablet sales revenues (Yearly) Revenue generated from Tablet sales"
    ["Tablet shipments"]=>
    string(143) "Tablet shipments (Quarterly) Quarterly shipments of tablets in the world, by supplier."
  }
  ["xForecast"]=>
  array(39) {
    ["4K TV installed base"]=>
    string(164) "4K TV installed base Total number of 4K TV sets in use in a country, at the end of the period under review."
    ["4K TV sets penetration"]=>
    string(125) "4K TV sets penetration Percentage of TV households that own a 4K TV."
    ["Android smartphone installed base"]=>
    string(133) "Android smartphone installed base Number of smartphones based on Android OS."
    ["Android tablets installed base"]=>
    string(126) "Android tablets installed base Number of tablets based on Android OS."
    ["Average number of TV set per household"]=>
    string(139) "Average number of TV set per household Average number of TV set in each household."
    ["Average number of computer per household"]=>
    string(157) "Average number of computer per household Average number of PC (laptop or desktop) in each household."
    ["Computer household penetration"]=>
    string(155) "Computer household penetration Percentage of households that own a PC at home (laptop or desktop)."
    ["Computers installed base"]=>
    string(128) "Computers installed base Total number of computers in use in a country."
    ["Connected smart TV sets by OS"]=>
    string(171) "Connected smart TV sets by OS Number of smart TV sets actually connected and broken down by operating system (OS)."
    ["Connected smart TV sets by OS forecasts"]=>
    string(223) "Connected smart TV sets by OS forecasts Yearly number of smart TV sets actually connected and broken down by operating system (OS). Yearly data with 5-year forecasts."
    ["Flat TV installed base"]=>
    string(168) "Flat TV installed base Total number of Flat TV sets in use in a country, at the end of the period under review."
    ["Flat TV sets penetration"]=>
    string(129) "Flat TV sets penetration Percentage of TV households that own a flat TV."
    ["Game console installed base"]=>
    string(160) "Game console installed base Total number of game consoles in use in a country for the model considered."
    ["HD TV installed base"]=>
    string(164) "HD TV installed base Total number of HD TV sets in use in a country, at the end of the period under review."
    ["HD TV sets penetration"]=>
    string(125) "HD TV sets penetration Percentage of TV households that own a HD TV."
    ["Other OS smartphones installed base"]=>
    string(154) "Other OS smartphones installed base Number of smartphones based on OS other than Android and iOS."
    ["Other OS tablets installed base"]=>
    string(146) "Other OS tablets installed base Number of tablets based on OS other than Android and iOS."
    ["SD CRT TV installed base"]=>
    string(172) "SD CRT TV installed base Total number of SD CRT TV sets in use in a country, at the end of the period under review."
    ["SD CRT TV sets penetration"]=>
    string(168) "SD CRT TV sets penetration Percentage of TV households that own a Cathode Ray Tube TV (CRT) or analogue TV set."
    ["SD Flat TV installed base"]=>
    string(174) "SD Flat TV installed base Total number of SD Flat TV sets in use in a country, at the end of the period under review."
    ["SD Flat TV sets penetration"]=>
    string(157) "SD Flat TV sets penetration Percentage of TV households that own a Standard Definition (SD) flat TV."
    ["Share of Android smartphones"]=>
    string(151) "Share of Android smartphones Percentage of Android smartphones among the total installed base."
    ["Share of Android tablets"]=>
    string(143) "Share of Android tablets Percentage of Android tablets among the total installed base."
    ["Share of iOS smartphones"]=>
    string(151) "Share of iOS smartphones Percentage of iOS smartphones (Apple) among the total installed base."
    ["Share of iOS tablets"]=>
    string(143) "Share of iOS tablets Percentage of iOS tablets (Apple) among the total installed base."
    ["Share of smartphones using other OS"]=>
    string(228) "Share of smartphones using other OS Percentage of smartphones among the total installed base using Operating Systems other than Android or iOS (windows, Blackberry, etc.)."
    ["Share of tablets using other OS"]=>
    string(207) "Share of tablets using other OS Percentage of tablets among the total installed base using Operating Systems other than Android or iOS (Windows etc.)."
    ["Smart TV installed base"]=>
    string(170) "Smart TV installed base Total number of Smart TV sets in use in a country, at the end of the period under review."
    ["Smart TV sets penetration"]=>
    string(154) "Smart TV sets penetration Percentage of TV households that own a Smart TV, even if not connected."
    ["Smart watch shipments"]=>
    string(110) "Smart watch shipments Quarterly sales of smartwatches"
    ["Smartphones installed base"]=>
    string(132) "Smartphones installed base Total number of smartphones in use in a country."
    ["Smartphones penetration"]=>
    string(125) "Smartphones penetration Percentage of population owning a smartphone"
    ["TV sets installed base"]=>
    string(124) "TV sets installed base Total number of TV sets in use in a country."
    ["TV streaming device household penetration"]=>
    string(279) "TV streaming device household penetration Share of households owning a TV streaming device in a country. A streaming media device is a hardware that allows users to connect their TV sets and stream audio and video content."
    ["TV streaming device installed base"]=>
    string(265) "TV streaming device installed base Total TV streaming devices installed base in a country. A streaming media device is a hardware that allows users to connect their TV sets and stream audio and video content."
    ["Tablets household penetration"]=>
    string(127) "Tablets household penetration Percentage of households owning a tablet"
    ["Tablets installed base"]=>
    string(118) "Tablets installed base Number of tablets in use in a country."
    ["iOS smartphones installed base"]=>
    string(122) "iOS smartphones installed base Number of smartphone based on iOS."
    ["iOS tablets installed base"]=>
    string(115) "iOS tablets installed base Number of tablets based on iOS."
  }
  ["yEnvironmental Data"]=>
  array(28) {
    ["Age group 0 to 4"]=>
    string(123) "Age group 0 to 4 (Forecast) Number of people between 0 and 4 years"
    ["Age group 10 to 14"]=>
    string(127) "Age group 10 to 14 (Forecast) Number of people between 10 and 14 years"
    ["Age group 15 to 19"]=>
    string(127) "Age group 15 to 19 (Forecast) Number of people between 15 and 19 years"
    ["Age group 20 to 24"]=>
    string(127) "Age group 20 to 24 (Forecast) Number of people between 20 and 24 years"
    ["Age group 25 to 29"]=>
    string(127) "Age group 25 to 29 (Forecast) Number of people between 25 and 30 years"
    ["Age group 30 to 34"]=>
    string(127) "Age group 30 to 34 (Forecast) Number of people between 30 and 34 years"
    ["Age group 35 to 39"]=>
    string(127) "Age group 35 to 39 (Forecast) Number of people between 35 and 39 years"
    ["Age group 40 to 44"]=>
    string(127) "Age group 40 to 44 (Forecast) Number of people between 40 and 44 years"
    ["Age group 45 to 49"]=>
    string(127) "Age group 45 to 49 (Forecast) Number of people between 45 and 49 years"
    ["Age group 5 to 9"]=>
    string(123) "Age group 5 to 9 (Forecast) Number of people between 5 and 9 years"
    ["Age group 50 to 54"]=>
    string(127) "Age group 50 to 54 (Forecast) Number of people between 50 and 54 years"
    ["Age group 55 to 59"]=>
    string(127) "Age group 55 to 59 (Forecast) Number of people between 55 and 59 years"
    ["Age group 60 to 64"]=>
    string(127) "Age group 60 to 64 (Forecast) Number of people between 60 and 64 years"
    ["Age group 65 to 69"]=>
    string(127) "Age group 65 to 69 (Forecast) Number of people between 65 and 69 years"
    ["Age group 70 to 74"]=>
    string(127) "Age group 70 to 74 (Forecast) Number of people between 70 and 74 years"
    ["Age group 75 to 79"]=>
    string(127) "Age group 75 to 79 (Forecast) Number of people between 75 and 79 years"
    ["Age group 80 and more"]=>
    string(128) "Age group 80 and more (Forecast) Number of 80 years old people and more"
    ["Average households size"]=>
    string(118) "Average households size (Forecast) Average size of households"
    ["Number of households"]=>
    string(109) "Number of households (Forecast) Number of Households"
    ["Population"]=>
    string(100) "Population (Forecast) Number of inhabitants"
    ["Population density"]=>
    string(131) "Population density (Forecast) Population divided by surface of the country"
    ["Surface area"]=>
    string(125) "Surface area (Forecast) Surface of the country in square kilometers."
    ["Access to electricity"]=>
    string(142) "Access to electricity (Forecast) Share of households that have access to electricity."
    ["Number of electrified households"]=>
    string(148) "Number of electrified households (Forecast) Nomber of households with access to electricity"
    ["TV household penetration"]=>
    string(134) "TV household penetration (Forecast) Percentage of households owning a TV set."
    ["TV households"]=>
    string(173) "TV households (Forecast) Number of households owning a TV set connected to broadcast or to broadband only reception."
    ["GDP"]=>
    string(310) "GDP (Yearly) The Gross domestic product (GDP) measures the value added created through the production of goods and services. It accounts for the total income earned in a country during a certain period. The data displayed is sourced from the World Bank."
    ["GDP per capita"]=>
    string(301) "GDP per capita (Yearly) The GDP per capita is a metric that breaks down a country GDP per citizen. It is calculated by dividing the country total gross domestic product by its total population. The data displayed is sourced from the World Bank."
  }
}

Connected TV streaming devices (Quarterly) Number of active connected TV streaming devices such as Roku, Apple TV etc. Game consoles penetration (Yearly) Game consoles in use as percentage of households

4K TV ASP (Yearly) The 4K TV ASP (Average Selling Price) is the average retail value of 4K TV sets in the country under review. 4K TV Sales revenues (Yearly) Revenue generated from 4K TV Sales 4K TV sales (Yearly) Number of 4K (or ultra high definition) TV sets sold yearly by country. 4K TV share of TV sales (Yearly) 4K TV sets sold in percentage of yearly flat TV sales. AR and VR headset shipments (Quarterly) Quarterly shipments of AR/VR Headsets Computer ASP (Yearly) The computer ASP (Average Selling Price) is the average retail value of computers in the country under review. Computer sales (Yearly) Number of computers sold yearly by country. Computer sales revenues (Yearly) Revenue generated from Computer sales Computer shipments (Quarterly) Quarterly shipments of computers in the world, by supplier. Connected Smart TV sets (Quarterly) Number of connectable TV sets (Smart TVs) actually connected. Flat TV ASP (Yearly) The Flat TV ASP (Average Selling Price) is the average retail value of Flat TV sets in the country under review. Flat TV sales (Yearly) Number of flat TV sets sold yearly by country. Flat TV sales revenues (Yearly) Revenue generated from Flat TV sales Flat TV shipments (Quarterly) Quarterly shipments of Flat TV in the world, by supplier. Excludes CRT (Cathode Ray Tube TV). HD-ready TV ASP (Yearly) The HD-ready TV ASP (Average Selling Price) is the average retail value of HD TV sets in the country under review. HD-ready TV sales (Yearly) Number of HD TV sets sold yearly by country. HD-ready TV sales revenues (Yearly) Revenue generated from HD-ready TV sales HD-ready TV share of TV sales (Yearly) HD TV sets sold in percentage of yearly flat TV sales. Home game console shipments (Quarterly) Quarterly shipments of home game consoles in the world, by supplier. Portable game console shipments (Quarterly) Quarterly shipments of portable game consoles in the world, by supplier. Smart TV ASP (Yearly) The Smart TV ASP (Average Selling Price) is the average retail value of Smart TV sets in the country under review. Smart TV sales (Yearly) Number of connectable TV sets (Smart TV) sold yearly by country. Smart TV sales revenues (Yearly) Revenue generated from Smart TV sales Smart TV share of TV sales (Yearly) Connectable TV sets (Smart TVs) sold in percentage of yearly flat TV sales. Smart speaker shipments (Quarterly) Quarterly sales of smart speakers Smartphone ASP (Yearly) The smartphone ASP (Average Selling Price) is the average retail value of smartphones in the country under review. Smartphone sales (Yearly) Number of smartphones sold yearly by country. Smartphone sales revenues (Yearly) Revenue generated from Smartphone sales Smartphone shipments (Quarterly) Quarterly shipments of smartphones in the world, by supplier. Tablet ASP (Yearly) The tablet ASP (Average Selling Price) is the average retail value of tablets in the country under review. Tablet sales (Yearly) Number of tablets sold yearly by country. Tablet sales revenues (Yearly) Revenue generated from Tablet sales Tablet shipments (Quarterly) Quarterly shipments of tablets in the world, by supplier.

4K TV installed base Total number of 4K TV sets in use in a country, at the end of the period under review. 4K TV sets penetration Percentage of TV households that own a 4K TV. Android smartphone installed base Number of smartphones based on Android OS. Android tablets installed base Number of tablets based on Android OS. Average number of TV set per household Average number of TV set in each household. Average number of computer per household Average number of PC (laptop or desktop) in each household. Computer household penetration Percentage of households that own a PC at home (laptop or desktop). Computers installed base Total number of computers in use in a country. Connected smart TV sets by OS Number of smart TV sets actually connected and broken down by operating system (OS). Connected smart TV sets by OS forecasts Yearly number of smart TV sets actually connected and broken down by operating system (OS). Yearly data with 5-year forecasts. Flat TV installed base Total number of Flat TV sets in use in a country, at the end of the period under review. Flat TV sets penetration Percentage of TV households that own a flat TV. Game console installed base Total number of game consoles in use in a country for the model considered. HD TV installed base Total number of HD TV sets in use in a country, at the end of the period under review. HD TV sets penetration Percentage of TV households that own a HD TV. Other OS smartphones installed base Number of smartphones based on OS other than Android and iOS. Other OS tablets installed base Number of tablets based on OS other than Android and iOS. SD CRT TV installed base Total number of SD CRT TV sets in use in a country, at the end of the period under review. SD CRT TV sets penetration Percentage of TV households that own a Cathode Ray Tube TV (CRT) or analogue TV set. SD Flat TV installed base Total number of SD Flat TV sets in use in a country, at the end of the period under review. SD Flat TV sets penetration Percentage of TV households that own a Standard Definition (SD) flat TV. Share of Android smartphones Percentage of Android smartphones among the total installed base. Share of Android tablets Percentage of Android tablets among the total installed base. Share of iOS smartphones Percentage of iOS smartphones (Apple) among the total installed base. Share of iOS tablets Percentage of iOS tablets (Apple) among the total installed base. Share of smartphones using other OS Percentage of smartphones among the total installed base using Operating Systems other than Android or iOS (windows, Blackberry, etc.). Share of tablets using other OS Percentage of tablets among the total installed base using Operating Systems other than Android or iOS (Windows etc.). Smart TV installed base Total number of Smart TV sets in use in a country, at the end of the period under review. Smart TV sets penetration Percentage of TV households that own a Smart TV, even if not connected. Smart watch shipments Quarterly sales of smartwatches Smartphones installed base Total number of smartphones in use in a country. Smartphones penetration Percentage of population owning a smartphone TV sets installed base Total number of TV sets in use in a country. TV streaming device household penetration Share of households owning a TV streaming device in a country. A streaming media device is a hardware that allows users to connect their TV sets and stream audio and video content. TV streaming device installed base Total TV streaming devices installed base in a country. A streaming media device is a hardware that allows users to connect their TV sets and stream audio and video content. Tablets household penetration Percentage of households owning a tablet Tablets installed base Number of tablets in use in a country. iOS smartphones installed base Number of smartphone based on iOS. iOS tablets installed base Number of tablets based on iOS.

Already a client?

New to Dataxis? Register now!

have a question?

We will help you find what you are looking for.

Research Plan

Explore our other market intelligence services

string(157) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'TV distribution' and region = 'Europe' and market = ''"

TV distribution

string(414) "SELECT DISTINCT(submodule) FROM `qttowunitary_posts` WHERE module LIKE '{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}TV distribution{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}' and submodule NOT LIKE '{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}|{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}' ORDER BY module ASC, submodule ASC"

TV distribution

string(173) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'TV distribution' and market = 'Multiplay' and region = 'Latin America'"

string(178) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'TV distribution' and market = 'Pay and FTA TV' and region = 'Latin America'"

string(153) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'TV networks' and region = 'Europe' and market = ''"

TV networks

string(410) "SELECT DISTINCT(submodule) FROM `qttowunitary_posts` WHERE module LIKE '{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}TV networks{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}' and submodule NOT LIKE '{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}|{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}' ORDER BY module ASC, submodule ASC"

TV networks

string(168) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'TV networks' and market = 'TV broadcasters' and region = 'Europe'"

TV broadcasters

string(164) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'TV networks' and market = 'TV Channels' and region = 'Europe'"

TV Channels

string(155) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'OTT and video' and region = 'Europe' and market = ''"

OTT and video

string(412) "SELECT DISTINCT(submodule) FROM `qttowunitary_posts` WHERE module LIKE '{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}OTT and video{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}' and submodule NOT LIKE '{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}|{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}' ORDER BY module ASC, submodule ASC"

OTT and video

string(166) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'OTT and video' and market = 'AVOD' and region = 'Latin America'"

string(174) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'OTT and video' and market = 'OTT services' and region = 'Latin America'"

string(189) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'OTT and video' and market = 'SVOD and Streaming Services' and region = 'Latin America'"

string(174) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'OTT and video' and market = 'TVOD and EST' and region = 'Latin America'"

string(177) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'OTT and video' and market = 'Video forecasts' and region = 'Latin America'"

string(149) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Content' and region = 'Europe' and market = ''"

Content

string(406) "SELECT DISTINCT(submodule) FROM `qttowunitary_posts` WHERE module LIKE '{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}Content{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}' and submodule NOT LIKE '{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}|{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}' ORDER BY module ASC, submodule ASC"

Content

string(155) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Content' and market = 'Cinema' and region = 'Europe'"

Cinema

string(169) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Content' and market = 'Content spend' and region = 'Latin America'"

string(160) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Content' and market = 'Video Games' and region = 'Europe'"

Video Games

string(170) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Online media and advertising' and region = 'Europe' and market = ''"

Online media and advertising

string(427) "SELECT DISTINCT(submodule) FROM `qttowunitary_posts` WHERE module LIKE '{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}Online media and advertising{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}' and submodule NOT LIKE '{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}|{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}' ORDER BY module ASC, submodule ASC"

Online media and advertising

string(190) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Online media and advertising' and market = 'Adressable TV' and region = 'Latin America'"

string(181) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Online media and advertising' and market = 'Advertising' and region = 'Europe'"

Advertising

string(201) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Online media and advertising' and market = 'Advertising expenditures' and region = 'Latin America'"

string(194) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Online media and advertising' and market = 'Newspapers and Magazines' and region = 'Europe'"

Newspapers and Magazines

string(176) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Online media and advertising' and market = 'Online' and region = 'Europe'"

Online

string(149) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Telecom' and region = 'Europe' and market = ''"

Telecom

string(406) "SELECT DISTINCT(submodule) FROM `qttowunitary_posts` WHERE module LIKE '{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}Telecom{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}' and submodule NOT LIKE '{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}|{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}' ORDER BY module ASC, submodule ASC"

Telecom

string(158) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Telecom' and market = 'Broadband' and region = 'Europe'"

Broadband

string(171) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Telecom' and market = 'Cloud computing' and region = 'Latin America'"

string(155) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Telecom' and market = 'Mobile' and region = 'Europe'"

Mobile

string(147) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Audio' and region = 'Europe' and market = ''"

Audio

string(404) "SELECT DISTINCT(submodule) FROM `qttowunitary_posts` WHERE module LIKE '{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}Audio{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}' and submodule NOT LIKE '{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}|{80acce26f8b37f028aa891e2a51d1192365c04772e827046b036504446dec0f8}' ORDER BY module ASC, submodule ASC"

Audio

string(152) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Audio' and market = 'Music' and region = 'Europe'"

Music

string(162) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Audio' and market = 'Podcasts' and region = 'Latin America'"

string(152) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Audio' and market = 'Radio' and region = 'Europe'"

Radio

string(159) "SELECT id FROM `qttowunitary_products` WHERE category = 'Market Intelligence Services' and industry = 'Connected devices' and region = 'Europe' and market = ''"