Weekly Cohort report for beauty and health industry

Weekly cohort analysis is the thing we are used to, because the most common one is a monthly cohort. However, I believe that particularly weekly cohort analysis may be incredibly useful in certain cases. For example, food delivery, taxi services, businesses with subscriptions like gyms or any other services in the beauty and health industry – the directors of these kinds of businesses definitely need this weekly cohort analysis report.

Therefore, we have created a Weekly Cohort analysis report template in Looker Studio that may help many beauty, healthcare and delivery services directors with their analytics, so check it out by the link. In case you liked this report but you would love it to be a monthly cohort analysis, it’s quite easy to update it. 

Don’t forget to keep up with a video overview:

Let’s start with a dashboard overview.

Looker Studio

This is a one page report. In the heading, there is some information for your better understanding of the tables and charts. I decided to split this dashboard by districts – the first section is a general one, the second is filtered by districts. Surely, you can change it up to your needs – any dimension you like. 

Weekly Cohort analysis. All districts. 

As you can see, before the table we have a cohort period of time. You can set it up manually.

In the table we have a week start column – I have set it up for Mondays but it’s changeable. Then we have an “all users” column. It shows how many customers we had a certain week. For example, on November 6th we got a user who came back two weeks later. Or users that we got on the week of October 16th – one user came two weeks later and two users came back on the fifth week. This way we can see how long users stay with us. 

In the next chart in this section we can see the number and the percentage of users that came back to us. Owing to this chart, it becomes clear that we lose our customers from week 10 to week 13. Consequently, we can send some emails to the cohorts of customers that are about to quit using our services or create some marketing campaigns for them. In a nutshell, this table needs to be paid attention to. 

Weekly Cohort analysis. Divided by districts.

The second section of the dashboard with a division by districts is exactly the same but, obviously, we have a district filter. Again, it can be any dimension you can split your customers by. 

When you buy the report template, you will also have an additional page with instructions. After the purchase, I recommend you to remove my logo and change my company colors to yours in the Theme and Layout menu.

Google Sheets

Let’s peek into the back-end of the report and its data sources. This report is based on two tabs of one Google Sheets. 

The first page of the report is a “Help” page that contains all the instructions about the setup. Which data you need to update, what fields to leave as they are or change – everything you can find here. 

There is only one page where you need to fill in all the yellow cells with your data. All the other pages contain transformations that will be made to your data automatically after you insert it and there are two pages that are connected to Looker Studio.

If you don’t need this dashboard frequently, you can input the data manually by downloading and copy-pasting the data from an .csv file from your CRM system. If you need the data to be updated more often, I recommend you to use connector services. They will pull up your data automatically. 

You can buy this report template for beauty, delivery services and healthcare in my store by the link. Also, we provide services of individual design and branding as well as report customization up to your needs. Just contact us, purchase the service, tell us how you want this dashboard to be and that’s it – we will do everything you want!

Hope you enjoyed this template overview! Share your impressions in the comments section!