1 of 8

Data Analyst Work Experience-ACUK�

Google Advert (Ad) Performance and Customer Generation annual Report 2021

2 of 8

Project Team

  1. Iloh Pascal Ugochukwu
  2. Oluchi Anayibe
  3. Adekunle Oyekunle

3 of 8

Google Ad Team Customer Presentation

KPI’s

​

    • Monthly Student Enrolment for 2021 business year (NOTE: Use a Trend diagram for your visualization)
    • Rate of Enrolment on monthly bases
    • Monthly Average Enrolment of Students

​

4 of 8

Monthly Student Enrolment for 2021 business year

Month

Number of Customers

Jan

2

Feb

5

Mar

5

Apr

2

Jul

1

Aug

13

Sep

16

Oct

13

Nov

22

Dec

7

Grand Total

86

  • The months with the highest enrolments were August through December 2021 which are within the 3rd and 4th Quarters of the year.
  • The months with the least customer enrolments were January, April, May and July.

5 of 8

Rate of Enrolment on monthly bases �

Month

Rate of Enrolment

Jan

2.33%

Feb

5.81%

Mar

5.81%

Apr

2.33%

Jul

1.16%

Aug

15.12%

Sep

18.60%

Oct

15.12%

Nov

25.58%

Dec

8.14%

Grand Total

100.00%

  • The Month of November represents the highest enrolment rate at 26% approx.
  • The months of January and July represent a meager enrolment rate of less than 5% each.
  • No enrolment was recorded in the month of May 2021.

6 of 8

Monthly Average Enrolment of Students �

Month

Average of Enrolment

Jan

2.33%

Feb

5.81%

Mar

5.81%

Apr

2.33%

Jul

1.16%

Aug

15.12%

Sep

18.60%

Oct

15.12%

Nov

25.58%

Dec

8.14%

Grand Total

100.00%

  • The total Number of customer enrolments in 2021 was 86.
  • Over 80% of the enrolments took place between August and December 2021.
  • Less than 20% of the annual enrolments were between January and July 2021.

7 of 8

Recommendations

  1. Based on our analysis we discovered that over 80% of 2021 annual enrolments by customers took place between August through December, we, therefore, recommend a closer look to be paid to what was done during that period, to note the points, actions, and decisions so we can replicate same earlier in the year.
  2. We noticed that there were no enrolments in the month of May 2021, whilst we recommend careful observation of the same month in 2022, we suggest that staff members take their leave within the month of May, to rest adequately, plan their affairs and prepare for the later part of the year which we expect to be more engaging.
  3. Based on our findings we suggest the marketing team consider some promotional initiatives early in the year to encourage enrolments and upscale the numbers.
  4. We believe a study of this trend over the next few years will give us a better perspective to make more accurate predictions.

8 of 8

Thanks