Social media as a data source for official statistics; the Dutch Consumer Confidence Index
Section 2. Data
2.1 Dutch Consumer Confidence Survey
The Consumer Confidence Index (CCI) is based on a monthly survey, called the Consumer Confidence Survey (CCS), and measures the opinion of households residing in the Netherlands about the economic climate in general and their own financial situation. The CCS is a continuous survey. Each month a self-weighted sample of approximately 2,500 households is drawn by stratified two-stage sampling from a sample frame derived from the Dutch Municipal Register. Households for which a known telephone number is available are contacted by an interviewer who completes the questionnaire by computer assisted telephone interviewing during the first ten working days of the month. On average a net sample of about 1,000 responding households is obtained, which comes down to a response rate of about 40%. A major part of the nonresponse are households for which no known telephone number of a land-line connection is available. The response among households for which a known telephone number is available is about 60%.
The CCI is based on five questions that can be answered positively, neutral or negatively. The questions refer to the economic or financial situation in the last 12 month or the respondents expectations in the future 12 months. Let and denote the percentage of respondents that answered question in month positively, neutral or negatively, respectively. Now the CCI is defined as the difference between the percentage of positive and negative respondents, averaged over the five questions:
Since the sample is self-weighted, and no auxiliary information is used in the estimation procedure, the percentages are estimated with the sample mean, i.e.,
for question and answer category In (2.2) is the net sample size in month and is a dummy indicator that is equal to one if respondent chose category to question Assuming simple random sampling without replacement for the households, it can be proved that the variance of (2.1) can be estimated by
with
Figure 2.1 shows the CCI with a 95% confidence interval calculated using the approach described in this section, observed during the period December 2000 through March 2015. In October 2013, the official publication of the CCI is missing.

Description for Figure 2.1
This is a line chart presenting the Consumer confidence index (CCI) with a 95% confidence interval. The horizontal axis is the time. The vertical axis is the CCI. The data are in the following table:
| Time | CCI | 95% confidence interval - Upper bound | 95% confidence interval - Lower bound |
|---|---|---|---|
| 2000(12) | 18.60515 | 20.98683067 | 16.22346933 |
| 2001(1) | 15.220126 | 17.52466013 | 12.91559187 |
| 2001(2) | 10.709812 | 12.87976747 | 8.539856529 |
| 2001(3) | 5.310275 | 7.662633489 | 2.957916511 |
| 2001(4) | -0.432099 | 1.777024469 | -2.641222469 |
| 2001(5) | 2.560484 | 4.852671948 | 0.268296052 |
| 2001(6) | -3.640167 | -1.348208669 | -5.932125331 |
| 2001(7) | -2.430108 | -0.214388899 | -4.645827101 |
| 2001(8) | -5.372168 | -3.175640152 | -7.568695848 |
| 2001(9) | -4.604013 | -2.371115312 | -6.836910688 |
| 2001(10) | -9.511942 | -7.375674169 | -11.64820983 |
| 2001(11) | -11.446154 | -9.385605711 | -13.50670229 |
| 2001(12) | -7.101449 | -5.111300865 | -9.091597135 |
| 2002(1) | -1.362229 | 0.744300547 | -3.468758547 |
| 2002(2) | -4.49348 | -2.502704613 | -6.484255387 |
| 2002(3) | -8.548707753 | -6.560972036 | -10.53644347 |
| 2002(4) | -13.959184 | -11.84235769 | -16.07601031 |
| 2002(5) | -16.52445369 | -14.36524258 | -18.68366481 |
| 2002(6) | -21.22751323 | -19.1187026 | -23.33632385 |
| 2002(7) | -24.308682 | -22.21732342 | -26.40004058 |
| 2002(8) | -26.65929204 | -24.56491762 | -28.75366645 |
| 2002(9) | -31.027467 | -28.97262876 | -33.08230524 |
| 2002(10) | -33.06370071 | -31.08267682 | -35.04472459 |
| 2002(11) | -31.9581749 | -30.08950737 | -33.82684244 |
| 2002(12) | -30.42198234 | -28.40600538 | -32.43795929 |
| 2003(1) | -33.83123181 | -31.77529458 | -35.88716905 |
| 2003(2) | -36.48915187 | -34.61799027 | -38.36031348 |
| 2003(3) | -37.62105263 | -35.66396147 | -39.57814379 |
| 2003(4) | -38.14556331 | -36.26699661 | -40.02413001 |
| 2003(5) | -34.57457457 | -32.54643859 | -36.60271056 |
| 2003(6) | -36.09805924 | -33.27760971 | -38.91850878 |
| 2003(7) | -38.78151261 | -36.60559214 | -40.95743307 |
| 2003(8) | -32.39828694 | -30.2320196 | -34.56455427 |
| 2003(9) | -33.90593047 | -31.72112382 | -36.09073712 |
| 2003(10) | -35.82995951 | -33.66877709 | -37.99114194 |
| 2003(11) | -32.0854527 | -29.84551225 | -34.32539314 |
| 2003(12) | -30.8997955 | -28.70130971 | -33.09828129 |
| 2004(1) | -30 | -27.8070429 | -32.1929571 |
| 2004(2) | -21.740851 | -19.42080288 | -24.06089912 |
| 2004(3) | -26.05237633 | -23.75858841 | -28.34616426 |
| 2004(4) | -26.056475 | -23.67132169 | -28.44162831 |
| 2004(5) | -26.45731109 | -24.24449366 | -28.67012852 |
| 2004(6) | -25.17412935 | -22.79875005 | -27.54950866 |
| 2004(7) | -20.52580331 | -18.09602933 | -22.95557729 |
| 2004(8) | -18.174442 | -15.671423 | -20.677461 |
| 2004(9) | -21.34371957 | -18.85000717 | -23.83743197 |
| 2004(10) | -27.41444867 | -24.89726149 | -29.93163585 |
| 2004(11) | -28.2421875 | -25.86194039 | -30.62243461 |
| 2004(12) | -31.58699809 | -29.27593035 | -33.89806583 |
| 2005(1) | -23.95014382 | -21.44769045 | -26.45259718 |
| 2005(2) | -20.552908 | -18.04439895 | -23.06141705 |
| 2005(3) | -20.57915058 | -18.09359623 | -23.06470493 |
| 2005(4) | -16.41176471 | -13.97563766 | -18.84789175 |
| 2005(5) | -20.4950495 | -18.0711301 | -22.91896891 |
| 2005(6) | -26.47953216 | -23.89846815 | -29.06059618 |
| 2005(7) | -22.3853211 | -19.94910417 | -24.82153803 |
| 2005(8) | -26.106106 | -23.64249359 | -28.56971841 |
| 2005(9) | -27.31662024 | -24.85182458 | -29.7814159 |
| 2005(10) | -25.4459203 | -22.94193841 | -27.94990219 |
| 2005(11) | -21.23275069 | -18.8187483 | -23.64675308 |
| 2005(12) | -17.556391 | -14.91244254 | -20.20033946 |
| 2006(1) | -12.0450281 | -9.429914305 | -14.6601419 |
| 2006(2) | -11.62313433 | -8.97840573 | -14.26786293 |
| 2006(3) | -8.088803 | -5.53494782 | -10.64265818 |
| 2006(4) | -5.8689456 | -3.31509042 | -8.42280078 |
| 2006(5) | -2.343595 | 0.373582203 | -5.060772203 |
| 2006(6) | 4.080808 | 6.797985203 | 1.363630797 |
| 2006(7) | 3.039514 | 5.494613317 | 0.584414683 |
| 2006(8) | 4.823410696 | 7.964925085 | 1.681896307 |
| 2006(9) | 7.598843 | 11.30164095 | 3.89604505 |
| 2006(10) | 5.431373 | 8.017372221 | 2.845373779 |
| 2006(11) | 2.913776 | 6.158616824 | -0.331064824 |
| 2006(12) | 5.702891326 | 9.49374769 | 1.912034962 |
| 2007(1) | 15.21988528 | 17.67685688 | 12.76291368 |
| 2007(2) | 12.27016886 | 14.61003045 | 9.930307261 |
| 2007(3) | 10.86065574 | 13.21708199 | 8.504229486 |
| 2007(4) | 12.282497 | 14.77577648 | 9.789217524 |
| 2007(5) | 13.509514 | 15.98447873 | 11.03454927 |
| 2007(6) | 17.68984 | 20.1543551 | 15.2253249 |
| 2007(7) | 15.12765957 | 17.5468189 | 12.70850025 |
| 2007(8) | 15.624333 | 18.17464324 | 13.07402276 |
| 2007(9) | -0.504202 | 2.097223829 | -3.105627829 |
| 2007(10) | -4.556452 | -2.040260825 | -7.072643175 |
| 2007(11) | -5.924453 | -3.301901222 | -8.547004778 |
| 2007(12) | -5.08 | -2.47106845 | -7.68893155 |
| 2008(1) | -2.111675 | 0.45237959 | -4.67572959 |
| 2008(2) | -8.870466 | -6.483726751 | -11.25720525 |
| 2008(3) | -9.15736 | -6.729256181 | -11.58546382 |
| 2008(4) | -11.930541 | -9.555734275 | -14.30534772 |
| 2008(5) | -16.162047 | -13.66314539 | -18.66094861 |
| 2008(6) | -19.115044 | -16.45483802 | -21.77524998 |
| 2008(7) | -30.306122 | -27.99899552 | -32.61324848 |
| 2008(8) | -25.741525 | -23.43351702 | -28.04953298 |
| 2008(9) | -22.342733 | -20.01971457 | -24.66575143 |
| 2008(10) | -30.807975 | -28.64673836 | -32.96921164 |
| 2008(11) | -32.830579 | -30.66013231 | -35.00102569 |
| 2008(12) | -30.590717 | -28.45319794 | -32.72823606 |
| 2009(1) | -26.927966 | -24.87687587 | -28.97905613 |
| 2009(2) | -28.680089 | -26.54203533 | -30.81814267 |
| 2009(3) | -33.17697228 | -31.16716167 | -35.18678289 |
| 2009(4) | -27.3354232 | -25.21876294 | -29.45208345 |
| 2009(5) | -21.90163934 | -19.71935735 | -24.08392134 |
| 2009(6) | -22.57297297 | -20.40558073 | -24.74036522 |
| 2009(7) | -22.68558952 | -20.48239346 | -24.88878558 |
| 2009(8) | -14.803695 | -12.51138639 | -17.09600361 |
| 2009(9) | -15.28888889 | -13.06454189 | -17.51323589 |
| 2009(10) | -23.529412 | -21.45928268 | -25.59954132 |
| 2009(11) | -17.82327586 | -15.46153035 | -20.18502137 |
| 2009(12) | -13.59916055 | -11.26382404 | -15.93449705 |
| 2010(1) | -7.135778 | -4.919075189 | -9.352480811 |
| 2010(2) | -12.434692 | -10.15882308 | -14.71056092 |
| 2010(3) | -12.348718 | -10.0327128 | -14.6647232 |
| 2010(4) | -15.060976 | -12.54238591 | -17.57956609 |
| 2010(5) | -15.788423 | -13.47376092 | -18.10308508 |
| 2010(6) | -16.791444 | -14.47380056 | -19.10908744 |
| 2010(7) | -12.888889 | -10.52144671 | -15.25633129 |
| 2010(8) | -8.068182 | -5.507771501 | -10.6285925 |
| 2010(9) | -12.631579 | -10.14785914 | -15.11529886 |
| 2010(10) | -13.378773 | -10.86786306 | -15.88968294 |
| 2010(11) | -10.63788 | -8.195255213 | -13.08050479 |
| 2010(12) | -16.132167 | -13.72627438 | -18.53805962 |
| 2011(1) | -4.695305 | -2.186616784 | -7.203993216 |
| 2011(2) | -3.373016 | -0.921680428 | -5.824351572 |
| 2011(3) | -6.808511 | -4.201189368 | -9.415832632 |
| 2011(4) | -9.849785 | -7.105562409 | -12.59400759 |
| 2011(5) | -9.803536 | -7.209989375 | -12.39708262 |
| 2011(6) | -10.962513 | -8.523121536 | -13.40190446 |
| 2011(7) | -11.292929 | -8.893086079 | -13.69277192 |
| 2011(8) | -18.92857143 | -16.54854382 | -21.30859903 |
| 2011(9) | -29.94012 | -27.73381546 | -32.14642454 |
| 2011(10) | -38.063158 | -35.84141781 | -40.28489819 |
| 2011(11) | -35.96039604 | -33.87869057 | -38.04210151 |
| 2011(12) | -39.529873 | -37.43347822 | -41.62626778 |
| 2012(1) | -34.161009 | -32.04027632 | -36.28174168 |
| 2012(2) | -34.827925 | -32.658097 | -36.997753 |
| 2012(3) | -38.13676908 | -35.91813132 | -40.35540683 |
| 2012(4) | -31.654822 | -29.37646553 | -33.93317847 |
| 2012(5) | -37.242757 | -35.10034251 | -39.38517149 |
| 2012(6) | -39.220513 | -37.00794471 | -41.43308129 |
| 2012(7) | -30.714286 | -28.43845759 | -32.99011441 |
| 2012(8) | -29.729167 | -27.4682299 | -31.9901041 |
| 2012(9) | -29.04 | -26.70712405 | -31.37287595 |
| 2012(10) | -36.300578 | -34.0534895 | -38.5476665 |
| 2012(11) | -41.464789 | -39.30651037 | -43.62306763 |
| 2012(12) | -42.033898 | -39.99438638 | -44.07340962 |
| 2013(1) | -32.677903 | -30.50960788 | -34.84619812 |
| 2013(2) | -43.048544 | -40.79664388 | -45.30044412 |
| 2013(3) | -40.820313 | -38.63986784 | -43.00075816 |
| 2013(4) | -34.383562 | -32.07504225 | -36.69208175 |
| 2013(5) | -31.756624 | -29.4565425 | -34.0567055 |
| 2013(6) | -35.818744 | -33.45143396 | -38.18605404 |
| 2013(7) | -36.666667 | -34.26169748 | -39.07163652 |
| 2013(8) | -29.738503 | -27.48484475 | -31.99216125 |
| 2013(9) | -31.9663512 | -29.52640074 | -34.40630166 |
| 2013(10) | This is an empty cell | This is an empty cell | This is an empty cell |
| 2013(11) | -21.14594595 | -18.53729492 | -23.75459697 |
| 2013(12) | -18.83064516 | -16.27485727 | -21.38643306 |
| 2014(1) | -8.52557673 | -5.961361083 | -11.08979238 |
| 2014(2) | -8.1041667 | -5.567006697 | -10.6413267 |
| 2014(3) | -5.750528541 | -3.227163888 | -8.273893194 |
| 2014(4) | -3.8824764 | -1.322819205 | -6.442133595 |
| 2014(5) | -1.360255048 | 1.309967177 | -4.030477273 |
| 2014(6) | -1.889400922 | 0.677027649 | -4.455829492 |
| 2014(7) | -0.997782705 | 1.590076078 | -3.585641488 |
| 2014(8) | -3.573543929 | -1.124308083 | -6.022779775 |
| 2014(9) | -7.7122877 | -5.062543744 | -10.36203166 |
| 2014(10) | -6.442687747 | -3.819586958 | -9.065788536 |
| 2014(11) | -11.38728324 | -8.785424113 | -13.98914236 |
| 2014(12) | -10.70787637 | -8.125190716 | -13.29056203 |
| 2015(1) | -3.247524752 | -0.612450141 | -5.882599364 |
| 2015(2) | -5.756097561 | -3.156297299 | -8.355897823 |
2.2 Social media sentiment
In an attempt to reduce administration costs and response burden, Daas and Puts (2014b) developed a sentiment index from social media sources that could be used as an alternative indicator for the CCI. They used messages posted on the most popular social media platforms in the Netherlands, written in the Dutch language. These messages are classified as containing positive, neutral, or negative messages using a variant of sentence-level based classification (Pang and Lee, 2008). An index is calculated by taking the difference between the percentage of positive and negative messages.
Combinations of all Facebook and Twitter messages with and without certain filters on phrases were compared with the CCI. The combination of all publicly available Facebook messages together with filtered Twitter messages containing personal pronouns had the highest correlation with the CCI. The Twitter messages had to be filtered due to the fact that a lot of Twitter messages are not very informative. See Daas and Puts (2014b) for further details. In their research Daas and Puts (2014b) also found that major changes in the behaviour of the public on social media, such as those caused by huge events and changes in the number of messages posted on each platform, have a disturbing effect on the series. The final indicator proposed is the average of the sentiment in the Facebook and Twitter messages during each period.
In Figure 2.2, the Social Media Index (SMI) is compared with the CCI for the period June 2010 until March 2015. Both series are clearly on a different level but show a more or less similar evolution. During the presented period, the CCI is always negative, while the SMI is always positive. The size or amplitude of the movements of the CCI are also considerably larger compared to the SMI. Many factors are responsible for this difference since the CCI is based on a survey where data collection is conducted by telephone and the SMI is based on classifying messages on Twitter and Facebook. The interesting question is to which extent the evolution of both series is similar.

Description for Figure 2.2
Figure made of two line charts comparing the Consumer confidence index (CCI) with the Social media index (SMI). The horizontal axis is the time. The vertical axis is the SMI for the upper panel and the CCI for the lower panel. The data for both panels are in the following table:
| Time | CCI | SMI |
|---|---|---|
| 2010(6) | -16.791444 | 15.30384496 |
| 2010(7) | -12.888889 | 16.58411767 |
| 2010(8) | -8.068182 | 16.77676065 |
| 2010(9) | -12.631579 | 15.47512784 |
| 2010(10) | -13.378773 | 15.22714727 |
| 2010(11) | -10.63788 | 14.54033413 |
| 2010(12) | -16.132167 | 16.18539362 |
| 2011(1) | -4.695305 | 16.0512751 |
| 2011(2) | -3.373016 | 15.49453571 |
| 2011(3) | -6.808511 | 15.39946481 |
| 2011(4) | -9.849785 | 15.06097212 |
| 2011(5) | -9.803536 | 15.91396731 |
| 2011(6) | -10.962513 | 14.42418499 |
| 2011(7) | -11.292929 | 13.28988926 |
| 2011(8) | -18.92857143 | 13.33079628 |
| 2011(9) | -29.94012 | 12.98973986 |
| 2011(10) | -38.063158 | 12.56599237 |
| 2011(11) | -35.96039604 | 12.66574494 |
| 2011(12) | -39.529873 | 11.85642712 |
| 2012(1) | -34.161009 | 10.35519848 |
| 2012(2) | -34.827925 | 10.15178214 |
| 2012(3) | -38.13676908 | 10.0424324 |
| 2012(4) | -31.654822 | 9.769898189 |
| 2012(5) | -37.242757 | 11.32084701 |
| 2012(6) | -39.220513 | 10.94443693 |
| 2012(7) | -30.714286 | 10.77387436 |
| 2012(8) | -29.729167 | 12.0248074 |
| 2012(9) | -29.04 | 10.12049336 |
| 2012(10) | -36.300578 | 10.07120218 |
| 2012(11) | -41.464789 | 9.824297203 |
| 2012(12) | -42.033898 | 7.406068397 |
| 2013(1) | -32.677903 | 8.589600823 |
| 2013(2) | -43.048544 | 8.072290528 |
| 2013(3) | -40.820313 | 7.941400194 |
| 2013(4) | -34.383562 | 7.787310433 |
| 2013(5) | -31.756624 | 8.256423667 |
| 2013(6) | -35.818744 | 9.876198134 |
| 2013(7) | -36.666667 | 8.432835843 |
| 2013(8) | -29.738503 | 8.468574946 |
| 2013(9) | -31.9663512 | 8.546455804 |
| 2013(10) | This is an empty cell | 9.356503552 |
| 2013(11) | -21.14594595 | 9.949872274 |
| 2013(12) | -18.83064516 | 11.06607585 |
| 2014(1) | -8.52557673 | 12.2675916 |
| 2014(2) | -8.1041667 | 14.58321232 |
| 2014(3) | -5.750528541 | 15.88653807 |
| 2014(4) | -3.8824764 | 14.2331505 |
| 2014(5) | -1.360255048 | 13.57201336 |
| 2014(6) | -1.889400922 | 12.95986247 |
| 2014(7) | -0.997782705 | 12.49552003 |
| 2014(8) | -3.573543929 | 14.43251733 |
| 2014(9) | -7.7122877 | 14.26019577 |
| 2014(10) | -6.442687747 | 14.95163281 |
| 2014(11) | -11.38728324 | 15.44711837 |
| 2014(12) | -10.70787637 | 18.03234244 |
| 2015(1) | -3.247524752 | 15.79634647 |
| 2015(2) | -5.756097561 | 18.28698631 |
| 2015(3) | This is an empty cell | 21.66064321 |
2.3 Quality aspects of the CCI and the SMI
The accuracy of statistics are measured with its variance and bias. For simplicity we only distinguish between selection bias and measurement bias. The variance of survey sample statistics, like the CCI, depends on the sample size and will typically constitute a substantial part of the uncertainty of sample statistics. In big data sources the concept of sampling variance is meaningless since the data generating process is not a probability sample from a finite target population. Variance components of the model used to describe the assumed data generating process could be used as an accuracy measure instead. The model-based variance of statistics obtained with time series models applied to series obtained from internet or social media will always be positive depending of the volatility of the series, which predominantly depends on the frequency of the observed series and the dynamics of the stochastic process instead of the volume of the data.
The selection bias of sample survey statistics is approximately zero under complete response. In practice however, selection bias arises due to selective nonresponse, under coverage of the sample frame and to which extend with the field work strategy the target population is successfully reached. In the case of the CCI, only the population with a known telephone number of a land-line connection is reached and the response among this subpopulation is about 60%. The selection bias of big data sources is generally unknown. In this paper, we apply the concept of cointegration to evaluate to which extend the SMI measures the same concept as the CCI. Note, however, that in the case of cointegration, the SMI might reflect a similar nonresponse and coverage selection bias as the CCI. Baker et al. (2013) pointed out that there are similarities between selection bias in probability samples and the non-probabilistic approach followed with data sources like social media.
The measurement bias in sample statistics typically depends on the extend that the conceptual variables to be measured, are implemented in the questionnaire, but also on data collection mode and the quality of the interviewers. Problems with measurement bias in surveys arises, since measurements of the variables of interest are indirect in that respondents are asked to report about their behaviour, introducing all kind of measurement errors. In the case of the CCI the question can be raised to which extend respondents are capable to express their long-term confidence in the economy and to which extend it is influenced by short-term emotions. These problems do not arise with big data if they contain direct measurements of people behaviour. With an index derived from social media like the SMI the question can be raised to which extend it measures a similar concept as the CCI. In Subsection 2.2, it was already mentioned that major changes in the behaviour of the public on social media have a disturbing effect on the series. Particularly at the end of the series, a sudden change in behaviour on social media will be very hard to distinguish from a real turning point. For example, a Google-trend series on search related to vacancies might track an official series on unemployment. It does measure unemployment, however, search behaviour before the start of the financial crisis in 2009 might be completely different compared to the period directly after the financial crisis, invalidating the concept intended to be measured.
- Date modified: