If you have a blog, surely you have ever asked yourself any of these questions: What is the best time to publish a post? What day of the week? What time? Today we want to help you solve these doubts with the help of analytics. Costa Rica Email List , The first thing we need is to have a history to analyze. If you are starting with your blog and you have little data, or you have not published yet, perhaps the first question you should ask yourself is another, How often do I have to write a post on my blog?
On the contrary, if you have been with your blog for a while, have several publications and of course you have Google Analytics implemented (If you do not have it, run, install it again) we can get a lot of interesting information in a very simple and visual way.
What are they?
They are data graphs where the values are represented by colors. They allow us to know the day of the week and the time when there are more visits. A heat map helps us visualize this information and make decisions.
How are they made? Step by Step.
1. Custom Report
Enter your Analytics account, and in the main menu click Personalization> New Personalized Report .
The first thing you have to do is give the report a title, and then within Report content select the metrics that you are going to measure. In this case, within Metric Groups> Users> Sessions .
Then there are the Dimensions. Dimension breakdowns> Time> Day of the week
As the second dimension we will put the time. Add dimension> Time> Time .
Filters can be added, but this time we are not going to use them.
Finally we click Save.
Once saved, a report appears with a Day of the week column. You will see that there are numbers ordered from 1 to 7. 0 corresponds to Sunday and 6 to Saturday .
Clicking on them shows you the results based on the second dimension, the time.
To see all the results at the same time we choose to show 25 rows and thus we have 24 hours a day .
You can click on the Time column to sort the hours and make it easier for you to export.
2. Prepare your Excel sheet
I recommend that before exporting the data, you prepare an Excel sheet where you will build the heat map.
Create a tab by day of the week and a last one where you will paint the Map .
You can create only one tab and add the data from the different CSVs, but I prefer to create one for each day of the week, USA Business , so I have the information for each day separated by hours and can later use it to make other maps.
In the Heatmap tab, we are going to place the days of the week in the first row and the hours in the first column .