Transcript ONLINE DATA COLLECTION AND RESULTS THE FRENCH EXPERIENCE ON BUSINESS SURVEYS SCHERRER Philippe, INSEE, France.

ONLINE DATA COLLECTION AND
RESULTS
THE FRENCH EXPERIENCE ON
BUSINESS SURVEYS
SCHERRER Philippe, INSEE, France
Plan
1.
The online collection and results program
2.
An external protected web site
3.
Information feedback
4.
An internal validation tool
5.
May I help you?
6.
We need your e-mail!
7.
Internet response rate is growing, … month after month
The online collection and results program
Done:
January 2004: Whole sale trade survey
November 2005: Industry survey
May 2006: Service survey
To come:
Begin 2007: Construction survey
End 2007: Investment survey
2008: Retail trade survey
An external high-security web site
The online collection is accessible directly via:
http://conjoncture.entreprises.insee.fr.
It is composed of a protected application:
- of collection of the answers on line
- of consultation of the return of personalized results
and of nonprotected links allowing the consultation:
- of public results and general information on business surveys
An external high-security web site
Same web site
Data Collection
User-only results
• a unique application
• inter-connection of
two systems (statistical
and internet)
Back office
treatments
An external high-security web site
• an external
application for data
Data Collection
Back office
treatments
collection
• an internal
application for data
Data editing
editing
• connection with the
back office via XML
An external high-security web site
1. Data to prepare each
XML file
Businesses
questionnaire at the
beginning of a
Usual
application
campaign
2. Response of the
firms every night
Data editing tool
XML file
XML file
3. Validated
questionnaires twice
a day
An external high-security web site


High level of security outside:
 special internet zone at INSEE
 Only authorized servers can dialog
High level of security inside:
 Codes and passwords
 Passwords only by mail
 Locking after ten attempts
An external high-security web site
Major principles for respondents




Nothing is written on the distant computer
Total confidentiality
Same possibilities with the internet as with the paper
Attention paid to ergonomics
An external high-security web site
Translated into IT specs






No software needed (light client)
SSL encryption
Identification through LDAP
Possibility to add / delete some products,
comments
Save & send actions
Easy to read and to fill in
Information feedback


Personnal feedback with login/password
Public feedback (public results, information about the
survey…)
A view of the online questionnaire
Some personnal feedback
An internal validation tool
Between the Web and the data processing application, an
internal validation tool: micro-analysis of all answers to control
them and classify them in 3 groups (green, orange, red).
Green questionnaire: all is well.
Orange questionnaire: at least a weak criterion of control not
passed.
Red questionnaires: at least a criterion of strong level not
passed.
These questionnaires are then treated within the team.
May I help you?
Hotline


By phone: working days from 7h30 to 18h15
uninterrupted.
By mail: [email protected]
We need your e-mail!
Need the e-mail of the respondent to send a message:
- to inform them of the opening of a new collection campaign,
- to recall them to answer,
- to inform them of the publication of the results.
Collect e-mail on paper and online form.
Definition of regular firms that will no more receive paper
forms.
E-mail: is essential to increase the internet response rate.
A personalized message of access to the website
Internet response rate is growing,
…month after month
Beginning of sending of personalized e-mail message
%
30
25
20
15
10
5
0
4
5
4
5
4
5
6
5
6
5
6
5
6
04
04
04
00
00
00
00
00
00
00
00
00
00
00
00
00
2
2
2
2
20
2
2
20
2
2
20
2
2
2
2
2
r
r
r
r
y
y
h
h
ly
ry
ch
ay
ay
ay
uly
uly
be
be
be
be
ar
a
ar
rc
r
rc
J
J
Ju
M
M
M
u
u
u
a
a
a
m
m
m
m
n
n
n
e
e
M
M
M
ve
ve
pt
pt
Ja
Ja
Ja
No
No
Se
Se
Wholesale trade
Industry
Service
Internet response rate is growing,
…month after month
Profits: - earlier answer (not-dependent on the postal times,
internet respondents answer faster)
- reduction of the overhead: impression, sending,
keyboarding of data.
- regular respondents
Costs: - data-processing development, computer equipement
- hot-mail, communication
… developing this system of collection requires constant efforts
which bear progressively return!
ONLINE DATA COLLECTION AND
RESULTS
THE FRENCH EXPERIENCE ON
BUSINESS SURVEYS
SCHERRER Philippe, INSEE, France