Wednesday, January 22, 2014

When Egyptians Search for Doctors?

Well, with the launch of the new Ekshef, we wanted to know when exactly Egyptians look for doctors online, so we decided to play with our Google Analytics to try to find out.

Disclaimer: We are not data scientists or statisticians, so if you find the way a bit flawed feel free to help us on how to make it better.

What we did is we pulled traffic data on Ekshef website for 3 months starting from the 25th of August till the 25th of November, the data represents the unique site visitors for each day.

Google Analytics exported the table below with 3 columns (Day Index, Visits, Unique Visitors)




Then using Excel PowerPivot, we summarized the table above by adding the number of unique visitors for each day of the week, to get a somehow aggregated view of each day of the week during the 3 months, we plotted the data on a histogram and we got the chart:


For us, it wasn't very surprising, Egyptians search for a doctor the most on Sundays, then Mondays. What was a bit surprising is the fact that Saturday -the first day of the week for doctors- was the third, and of course no surprise the traffic dropped significantly on Thursday and Friday because there are no clinics available.

We didn't stop there, we wanted to know when during the day Egyptians start searching for doctor information, so we pulled the daily traffic for the same 3 months, but this time the data was split by hour so we can get a view of Ekshef traffic during each hour of the day. I aggregated the numbers again using PowerPivot and plotted the result on the chart below.


I personally didn't have any expectations for this chart because it is the first time I think about it, yet the results make sense to me. The peak is at 3PM which if we relate to the majority of Ekshef's visitors who are between 25 - 30 years old so they fall in the working professionals class, so 3 PM is a logical time to search for doctors to visit after work, or even after the people going with the us to the doctor is free. Yet if we look at the hours, 3, 7, 6, 2, 4, 1, 5PM, which means between 1 - 7PM. Expect many people are searching for doctors and their info. Add this to Saturday, Sunday and Monday from the previous chart. Egyptians search for doctors the most on Sunday, Monday, and Saturday between 1:00PM -7:00PM. Bingo!


The post ends here, but the analysis will stay. If you liked the post please help us by sharing it to your circles, and if you can support us by any suggestions or how to do deeper analysis, don't hesitate to talk to us on contact@ekshef.com. We will keep analyzing the data, to understand more about the Egyptian behavior in dealing with health and doctors.

Until next time...
Ekshef Team

11 comments:

  1. There are lots of information about latest technology, like Hadoop cluster is a special type of computational cluster designed specifically for storing and analyzing huge amounts of unstructured data in a distributed computing environment. This information seems to be more unique and interesting. Thanks for sharing.
    Big Data Training | Big Data Hadoop Training in Chennai | Big Data Course in Chennai

    ReplyDelete
  2. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
    Best Java Training Institute Chennai



    ReplyDelete
  3. I am really enjoying reading your well written articles.
    It looks like you spend a lot of effort and time on your blog.
    I have bookmarked it and I am looking forward to reading new articles.Keep up the good work..
    Selenium Training in Chennai
    Digital Marketing Course in Chennai
    JAVA Training in Chennai
    Java training institute in chennai

    ReplyDelete
  4. In the beginning, I would like to thank you much about this great post. Its very useful and helpful for anyone looking for tips. I like your writing style and I hope you will keep doing this good working.
    Hacking Course in Chennai
    Hacking Classes in Chennai
    AWS Training in Chennai
    Data Science Course in Chennai
    Digital Marketing Course in Chennai
    Hacking Training in Tambaram
    Hacking Training in Velachery
    Hacking Training in OMR

    ReplyDelete
  5. Online Casino Super Earnings top 10 online casinos here Win online casinos and live like a king in the world.

    ReplyDelete
  6. Write more; that’s all I have to say. It seems as though you relied on the video to make your point.
    occupational health and safety course in chennai

    ReplyDelete
  7. Я могу расскзать где купить светодиодную ленту в Украине конечно же в ekodio отличный выбор тут

    ReplyDelete