When trying to determine the best day of the week or hour of the day to plan digital marketing activity, setting up day and hour reports in Google Analytics can really help focus on the best times for maximum impact.
This could include when to dispatch email marketing campaigns or when to up-weight your bids in Google Ads. In addition to tracking user sessions you can also specify conversions/goals in order to confirm if the converting peaks match the session peaks (or not) helping you do better planning.
To set up a day and Hour Report in Google Analytics, click on ‘Customization’ and then select ‘New Custom Report’. Name the report and then name the first report content tabs ‘Days of the Week’. Choose ‘Explorer’ as the type and then click on ‘Add Metric’ and type ‘Sessions’ and select it. You will also need to select another metric as ‘Conversions’ or ‘Goals’ depending on what you track. For dimension type ‘Day of Week Name’ and click ‘Save’.
To create the second report click on ‘Add Report Tab’ and name it ‘Hour of the Day’. As before we will choose ‘Explorer’ type and add the metrics ‘Sessions’ and the same Conversion/Goal metric as we did before. For the Dimension type ‘Hour’ then click ‘Save’.
You can now see the report with the 2 report tabs – the first for days of the week and the second for hours of the day. The chart shows the progression of days or hours and the table below gives specific information on day/hour and session and conversion/goal. By default you will see the ‘Sessions’ metric on its own, but you can add the conversion/goal metric by clicking on the ‘Select a Metric’ dropdown that appears after the ‘Sessions vs’ just below the tab name. This will add the conversion/goal line to the chart and information to the tables.
Segmenting Report Audience
You can now confirm the best days and best hours of the day to target your digital channel promotions. For even better targeting you can add Segments to isolate the desired channels and compare those previous users against all users. To do that click ‘Add Segment’ and either choose from one of the default segment names or create a custom segment to add your required group. This will allow you to determine your peak days/hours more accurately.
Click on ‘Save’ in the option panel in the upper right corner so you can use the day and hour reports in Google Analytics again to confirm changes.