Growth & Employment Program - Insourcing and Outsourcing Impact Evaluation Data 2016-2019

Nigeria, 2016 - 2019

Get Microdata

Reference ID

NGA_2016-2019_GEMIE-IO_v01_M

Producer(s)

David McKenzie, Stephen Anderson

Metadata

DDI/XML JSON

Created on

Oct 14, 2021

Last modified

Oct 14, 2021

Page views

44060

Downloads

332

Data file: CleanedFU2.dta

Constructed Data - Cleaned data from the baseline and two follow-up surveys used for main analysis:- round 2 outcomes from Second follow-up survey

Cases:	753
Variables:	835

Variables

interview__key

Interview key (identifier in XX-XX-XX-XX format)

interview__id

Unique 32-character long identifier of the interview

entrep_id

ID Number [Entreprenuer Identification Number]

Int_ID

Interviewer Identification Number

stat

State of Business

attempt

Record number of Interview attempt An interview attempt consists of a phone cal

operate

Do you currently operate a business

emp_num

If yes, how many paid employees do you have (excluding yourself)_____________

avail

Respondent availability

gender

Gender of person being interviewed

age

Age of Person being interviewed:

state_id

Location of the interview: State__________________

date

Date&time

time

Start time

time_cat

Time

A1. Do you currently operate the business [%biz_name%]?

A2. What is the current status of the business [%biz_name%]?

A3_month

A3. When was the last time you made a sale in business [%biz_name%]? ______Month

A3_year

A3. When was the last time you made a sale in business [%biz_name%]? ______Year

A3b

A3b. If the firm was open at any time during 2018, then can you tell me the tota

A3b_cat

A.3b. If the firm was open at any time during 2018, then can you tell me the tot

A3b_word

WRITE THE AMOUNT IN WORDS (E.G. 5.5 MILLION NAIRA)

A3c

A3c. If the firm was open at any time during 2018, then can you tell me the tota

A3c_cat

A3c. If the firm was open at any time during 2018, then can you tell me the tota

A3c_word

WRITE THE AMOUNT IN WORDS (E.G. 5.5 MILLION NAIRA)

A4. What is the main reason you are not operating [%biz_name%]?

A5. Do you currently operate a different firm?

A7. What is the industry of this other firm?

A7_other

Please specify other

A8a

A8. When did you start this firm? ______Month

A8b

A8. When did you start this firm? ______Year

A9. In the last month did you work at all for pay as a wage or salary earner, ca

A10

A10 . What was this job? (e.g. bank teller, farm worker, etc.)

A10b

A10 . What was this INDUSTRY? (e.g. Banking, Agriculture etc.)

A11

A11. How many hours did you work in a typical week last month in this job?

A12

A12. How much did you earn last month working in this job?

A12_word

A12. Please, write the amount in word E.g One hundred thousand naira

FN1

FN1. Confirm the name of the owner {%res_name%}

FN2

FN2. Confirm the name of the firm{%biz_name%}

FN2A

FN2a. Is the firm named after the owner?

FN2b

FN2b. Is the firm named after a family member of the owner?

FN2c

FN2c. Does the firm name include a religious meaning (e.g. reference to God, or

FN3_1

FN3: Enumerator - Record which of the following is closest to the reason the res

FN4a

FN4. Compared to giving your business another name, how do you think naming your

FN4b

FN4. Compared to giving your business another name, how do you think naming your

FN4c

FN4. Compared to giving your business another name, how do you think naming your

FN4d

FN4. Compared to giving your business another name, how do you think naming your

FN4e

FN4. Compared to giving your business another name, how do you think naming your

FN5a

FN5. Imagine that you had instead named your business after yourself. Compared t

FN5b

FN5. Imagine that you had instead named your business after yourself. Compared t

FN5c

FN5. Imagine that you had instead named your business after yourself. Compared t

FN5d

FN5. Imagine that you had instead named your business after yourself. Compared t

FN5e

FN5. Imagine that you had instead named your business after yourself. Compared t

B2(a).What is the nature of your business or what does your activity consist of?

B2__1

2. Which of the following forms of business registration does your business have

B2__2

2. Which of the following forms of business registration does your business have

B2__3

2. Which of the following forms of business registration does your business have

B2__4

2. Which of the following forms of business registration does your business have

B2__5

2. Which of the following forms of business registration does your business have

4. Has your business been operating in the same location for the last year?

5. What was the change in business location you made?

b5_oth

Please specify other

CN1

1. Approximately how many paying customers did your business have in the last mo

CN2a

2. In the city where your business operates

CN2b

2. In the state (excluded your city) where your business operates

CN2c

2. In another state of Nigeria

CN2d

2. Outside Nigeria (sales abroad and/or export)

CN3

3. During the past twelve months, for how many months was your business running,

CN4

C4. In the past two years (since JAN 2017), how many new regions have you expand

CN5a_1

First Region

CN5a_2

Is the first region in same state, different state or different country?

CN5b_1

Second Region

CN5b_2

Is the second region in same state, different state or different country?

CN5c_1

Third Region

CN5c_2

Is the third region in same state, different state or different country?

CN5d_1

Fourth Region

CN5d_2

Is the fourth region in same state, different state or different country?

CN5e_1

Fifth Region

CN5e_2

Is the fifth region in same state, different state or different country?

C6 What percent of your total revenues now comes from these new regions?

CN7

7. In the past two years (since JAN 2017), how many new channels have you expand

CN8a_1

First Channel

CN8a_2

Is this first channel Online, Phone, Direct Sales, Distributor or any other?

CN8a_1_oth

Please specify other

CN8b_1

Second Channel

CN8b_2

Is this second channel Online, Phone, Direct Sales, Distributor or any other?

CN8a_2_oth

Please specify other

CN8c_1

Third Channel

CN8c_2

Is this third channel Online, Phone, Direct Sales, Distributor or any other?

CN8c_2_oth

Please specify other

CN8d_1

Fourth Channel

CN8d_2

Is this fourth channel Online, Phone, Direct Sales, Distributor or any other?

CN8d_2_oth

Please specify other

CN8e_1

Fifth Channel

CN8e_2

Is this fifth channel Online, Phone, Direct Sales, Distributor or any other?

CN8e_2_oth

Please specify other

CN9

C9 What percent of your total revenues now comes from these new channels

CN10

C10. In the past two years (since JAN 2017), how many new customer segments have

C11__0

11. For each of these new customer segment, list the new segment (2-3 word descr

C11__1

11. For each of these new customer segment, list the new segment (2-3 word descr

C11__2

11. For each of these new customer segment, list the new segment (2-3 word descr

C11__3

11. For each of these new customer segment, list the new segment (2-3 word descr

C11__4

11. For each of these new customer segment, list the new segment (2-3 word descr

C12

12 What percent of your total revenues now comes from these new segments?

C1a

C1. How many hours per week do you personally spend working in your business? a

C1b

C1. How many hours per week do you personally spend working in your business? b

C2a

2a. Aside from this business........... In a normal week, how many hours do you

C2b

2b. Aside from this business........... In a normal week, how many hours do you

C3A_1

1. PRODUCTION: the buying/sourcing of inputs, manufacturing of goods, making/ass

C3A_2

2. HUMAN RESOURCES: the management, monitoring, payroll, or training of employee

C3A_3

3. LOOKING AFTER PHYSICAL ASSETS: the maintenance, repair, or replacement of phy

C3A_4

4. ACCOUNTING: the daily book-keeping (e.g. recording sales, purchases, expendit

C3A_5

5. FINANCE: the analyzing and planning of finances (e.g. performance ratios, cas

C3A_6

6. MARKETING: the market research, advertising (e.g. tv, radio, flyers), promoti

C3A_7

7. SALES: the management of customer relationships, generating leads and closing

C3A_8

8. INNOVATIONS: the research and development of new products/services to improve

C3A_9

9. INVESTMENTS: the pursuit of external funding sources (e.g. loans, grants, equ

C3A_10

10. PARTNERSHIPS: the development of strategic partnerships (e.g. trade associat

C3A_11

11. SLACK TIME: time spent waiting around for customers to come to the firm, tim

C3A_12

12. TRAVEL: time spent sitting in traffic, commuting to/from your business, or t

C3A_13

13. OTHER: (specify)_________________________ Hours spent: ____ [between 0-100

C13A_oth

Please specify other

sum

Total Hours

C3B

3B. In the last two weeks, what percentage of your time was spent on EXTERNALLY

Q3C

3C. In the last two weeks, what percentage of your time was spent on FUTURE focu

C4. Do you have a written schedule for your activities each day? In other words

C5a

1 = PRODUCTION: the buying/sourcing of inputs, manufacturing of goods, making/as

C5b

2 = HUMAN RESOURCES: the management, monitoring, payroll, or training of employe

C5c

3 = LOOKING AFTER PHYSICAL ASSETS: the maintenance, repair, or replacement of ph

C5d

4 = ACCOUNTING: the daily book-keeping (e.g. recording sales, purchases, expendi

C5e

5 = FINANCE: the analyzing and planning of finances (e.g. performance ratios, ca

C5f

6 = MARKETING: the market research, advertising (e.g. tv, radio, flyers), promot

C5g

7 = SALES: the management of customer relationships, generating leads and closin

C5h

8 = INNOVATIONS: the research and development of new products/services to improv

C5i

9 = INVESTMENTS: the pursuit of external funding sources (e.g. loans, grants, eq

C5j

10 = PARTNERSHIPS: the development of strategic partnerships (e.g. trade associa

C5k

11 = SLACK TIME: time spent waiting around for customers to come to the firm, ti

C5l

12 = TRAVEL: time spent sitting in traffic, commuting to/from your business, or

C11A

C11A. Over the last 3 months, how often did you let someone else (e.g. employees

C11B

C11B. Over the last 3 months, how often did you give up CONTROL over a certain d

C11C

C11C. Over the last 3 months, how often did you EMPOWER someone in your business

C11D

C11D. Over the last 3 months, how often did you DELEGATE a job (that you used to

C11E

C11E. Over the last 3 months, how often did you get someone to HELP YOU reach a

D1A

1A. Over the last 3 months, did the firm record all MONEY IN to the business (sa

D1B

1B. ENUMERATOR: For verification, please take a photo of the system used by the

D1B_pic1

1B. ENUMERATOR: First Picture

D1B_pic2

1B. ENUMERATOR: Second Picture

D1C

1C: ENUMERATOR: Why was evidence not provided?

D1C_oth

Please specify other

D2A

2A. Over the last 3 months, did the firm record all MONEY OUT of the business (p

D2B

2B. ENUMERATOR: For verification, please take a photo of the system used by the

D2B_pic1

2B. ENUMERATOR: First Picture

D2B_pic2

2B. ENUMERATOR: Second Picture

D2C

2C: ENUMERATOR: Why was evidence not provided?

D2C_oth

Please specify other

D3A

3A. Over the last 3 months, did the firm prepare an INCOME STATEMENT (also calle

D3B

3B. ENUMERATOR: For verification, please take a photo of the SME’s most recentl

D3B_pic1

3B. ENUMERATOR: First Picture

D3B_pic2

3B. ENUMERATOR: Second Picture

D3C

3C: ENUMERATOR: Why was evidence not provided?

D3C_oth

Please specify other

D4A

4A. Over the last year, did the firm prepare a BALANCE SHEET that reports the bu

D4B

4B. ENUMERATOR: For verification, please take a photo of the SME’s most recentl

D4B_pic1

4B. ENUMERATOR: First Picture

D4B_pic2

4B. ENUMERATOR: Second Picture

D4C

4C: ENUMERATOR: Why was evidence not provided?

D4C_oth

Please specify other

D5A

5A. Over the last 3 months, did the firm analyze a STATEMENT OF CASH FLOW to und

D6A

6A. Over the last 3 months, did the firm analyze which products/services are the

D7A

7A. Over the last 3 months, did the firm use COST CONTROL mechanisms in the busi

D8A

8A. Over the last 3 months, did the firm prepare and use a BUDGET that states ho

D8B

8B. ENUMERATOR: For verification, please take a photo of the SME’s most recentl

D8B_pic1

8B. ENUMERATOR: First Picture

D8B_pic2

8B. ENUMERATOR: Second Picture

D8B_1

Describe the evidence verified_____________

D8C

8C: ENUMERATOR: Why was evidence not provided?

D8C_oth

Please specify other

D9A

9A. Over the last year, did the firm set PERFORMANCE TARGETS (or financial goals

D10A

10A. Over the last 6 months, did the firm conduct FEASIBILITY STUDIES before sta

D11A

11A. Over the last 3 months, did the firm carry out structured research on CUSTO

D12A

12A. Over the last 3 months, did the firm carry out structured research on COMPE

D13A

13A. Over the last 3 months, did the firm carry out structured research on the M

D14A

14A. Over the last 3 months, did the SME PROMOTE your products/services to attra

D14B

14B. ENUMERATOR: For verification, please take a photo of the SME’s most recent

D16B_pic1

14B. ENUMERATOR: First Picture

D16B_pic2

14B. ENUMERATOR: Second Picture

D14C

14C: ENUMERATOR: Why was evidence not provided?

D16C_oth

Please specify other

D15A

15A. Over the last 3 months, did the SME change the PRICES of its products/servi

D16A

16A. Over the last 3 months, did the SME use a BRANDING strategy for its busines

D17A

17A. Over the last 3 months, did the SME use a CUSTOMER RELATIONSHIP MANAGEMENT

D17B

17B. ENUMERATOR: For verification, please take a photo of the SME’s most recent

D17B_pic1

17B. ENUMERATOR: First Picture

D17B_pic2

17B. ENUMERATOR: Second Picture

D17B_1

Describe the evidence verified_____________

D17C

17C: ENUMERATOR: Why was evidence not provided?

D17C_oth

Please specify other

D18A

18A. Over the last 3 months, did the SME use any post-purchase LOYALTY PROGRAMS

D18B

18B. ENUMERATOR: For verification, please take a photo of the SME’s most recent

D18B_pic1

18B. ENUMERATOR: First Picture

D18B_pic2

18B. ENUMERATOR: Second Picture

D18B_1

Describe the evidence verified_____________

D18C

18C: ENUMERATOR: Why was evidence not provided?

D18C_oth

Please specify other

D19A

19A. Over the last 3 months, did the SME have a professional SALESFORCE – led by

D20A

20A. Does the SME currently have a functioning WEBSITE for its business? e.g ww

D21A

21A. Over the last 3 months, did the SME use any SEARCH ENGINE marketing tools t

D22A

22A. Over the last 3 months, did the SME use any E-COMMERCE platforms to sell it

D23

23. Over the last 3 months, did the SME use any SOCIAL MEDIA platforms to market

D24A

24A. Did you use a FACEBOOK profile/account that is dedicated to your business?

D24C

24C. Did you use a TWITTER profile/account that is dedicated to your business?

D24E

24E. Did you use a INSTAGRAM profile/account that is dedicated to your business?

D24G

24G. Did you use a SNAPCHAT profile/account that is dedicated to your business?

D24I

24I. Did you use a TUMBLR profile/account that is dedicated to your business?

D24K

24K. Did you use a WHATSAPP profile/account that is dedicated to your business?

D24M

24M. Did you use a YOUTUBE profile/account that is dedicated to your business?

D24S

24S. Did you use a PINTEREST profile/account that is dedicated to your business?

D25A

25A. Over the last 3 months, did the SME use a formal system to carry out MAINTE

D26A

26A. Over the last 3 months, did the SME use a formal system to ORGANIZE AND CLE

D27A

27A. Over the last 3 months, did the SME use a formal system to carry out QUALIT

D28A

28A. Over the last 3 months, did the SME use any type of ELECTRONIC PAYMENTS sys

D28B

28B ENUMERATOR: For verification, please take a photo of the SME’s Electronic P

D28B_pic1

28B ENUMERATOR: First Picture

D28B_pic2

28B ENUMERATOR: Second Picture

D28B_1

Describe the evidence verified_____________

D28C

28C: ENUMERATOR: Why was evidence not provided?

D28C_oth

Please specify other

D29A

29A. Over the last 3 months, did the SME compare the prices and quality offered

D30A

30A. Over the last 3 months, did the SME use a formal system to MANAGE INVENTORY

d5e1

D.5e1. Are you using a computer at your office for your day to day operations?

d5e2

D.5e2. Are you using internet for your day to day operations?

d5e3__1

D.5e3. If yes, how do you access the internet?:On office computer

d5e3__2

D.5e3. If yes, how do you access the internet?:On my phone

d5e3__3

D.5e3. If yes, how do you access the internet?:At internet cafe

d5e3__999

D.5e3. If yes, how do you access the internet?:Do not know (or does not apply)

d5f_a

Are you using an IT solution for: a. Financial Management (accounting, budgetin

d5f_b

Are you using an IT solution for: b. Enterprise Resource Planning (A process by

d5f_c

Are you using an IT solution for: c. Order Planning

d5f_d

Are you using an IT solution for: d. Payroll management (The salaries and wages

d5f_e

Are you using an IT solution for: e. Customer Relation Management

d5f_f

Are you using an IT solution for Any other activity?

d5f_oth

Please specify other

D31A

31A. Over the last 3 months, did the SME use a formal system to measure the indi

D31B

31B. ENUMERATOR: For verification, please take a photo of the SME’s most recent

D31B_pic1

31B. ENUMERATOR: First Picture

D31B_pic2

31B. ENUMERATOR: Second Picture

D31B_1

Describe the evidence verified_____________

D31C

31C: ENUMERATOR: Why was evidence not provided?

D31C_oth

Please specify other

D32A

32A. Over the last 3 months, did the SME provide any TRAINING to employees so th

D33A

33A. Over the last 3 months, did the SME use a formal PAYROLL system for making

d6c

D.6c. Over the last 3 months, for the top 3 performers of your company, what was

d6e

D.6e. In the last past 6 months, did you recruit any new employee?

d6e2

D.6e. How did you find the last employee you hired? Please choose the most appr

E1__1

1. In the last 12 months, how did you find your new employees? Please choose

E1__2

1. In the last 12 months, how did you find your new employees? Please choose

E1__3

1. In the last 12 months, how did you find your new employees? Please choose

E1__4

1. In the last 12 months, how did you find your new employees? Please choose

E1__5

1. In the last 12 months, how did you find your new employees? Please choose

E1__6

1. In the last 12 months, how did you find your new employees? Please choose

2. What was the main reason you decided to use an HR Specialist?

E2_oth

Please specify other

3. In the last 12 months, how many different “employee positions” did you fill u

E4A_1

4A. How much did the HR Specialist charge you for this service? Naira

E4B_1

4B. What was the position you filled using the HR Specialist (e.g. accountant, e

E4A_1_oth

Please specify other

E4C_1

4C. What was this employee’s monthly salary (i.e. gross pay each month)? _____

E4D_1

4D. Is this person still employed at your business?

E4E_1_month

4E. If the person is no longer employed at the business What MONTH did they sto

E4E_1_year

4E. If the person is no longer employed at the business What YEAR did they sto

E4E_1_ii

4E_ii) What was the main reason he/she stopped working for the business? (open-

E4A_2

4A. How much did the HR Specialist charge you for this service? Naira

E4B_2

4B. What was the position you filled using the HR Specialist (e.g. accountant, e

E4A_2_oth

Please specify other

E4C_2

4C. What was this employee’s monthly salary (i.e. gross pay each month)? _____

E4D_2

4D. Is this person still employed at your business?

E4E_2_month

4E. If the person is no longer employed at the business What MONTH did they sto

E4E_2_year

4E. If the person is no longer employed at the business What YEAR did they sto

E4E_2_ii

4E_ii) What was the main reason he/she stopped working for the business? (open-

E4A_3

4A. How much did the HR Specialist charge you for this service? Naira

E4b_3

4B. What was the position you filled using the HR Specialist (e.g. accountant, e

E4A_3_oth

Please specify other

E4C_3

4C. What was this employee’s monthly salary (i.e. gross pay each month)? _____

E4D_3

4D. Is this person still employed at your business?

E4E_3_month

4E. If the person is no longer employed at the business What MONTH did they sto

E4E_3_year

4E. If the person is no longer employed at the business What YEAR did they sto

E4E_3_ii

4E_ii) What was the main reason he/she stopped working for the business? (open-

6. Over the last 6 months, who was the main person or entity that managed the re

7. How much do you pay this employee per month (i.e. gross salary)? ___________

E8A

8A. What was the main reason you decided to use an outside Accounting agency?

E8A_oth

Please specify other

E8B

8B. How frequently does this outside accountant visit your business or meet with

E8B_oth

Please specify other

E8C

8C. How much does the Accounting agency charge you for this service? If you do

Q8C_1

8C_1. Do you still use this outside accounting agency

E8D_month

8D. If you used an accounting agency in the past 6 months, but have now stopped

E8D_year

8D. If you used an accounting agency in the past 6 months, but have now stopped

E8E

8E: what was the main reason you stopped using this agency (open-ended)_________

E10

10. Over the last 6 months, who was the main person or entity that managed the m

E11

11. How much do you pay this employee per month (i.e. gross salary)? __________

Total: 835

1 2 3 >

Back to Catalog