Find the best converting time with a pivot table

Here’s how to find the best converting time with a pivot table and visualise it with conditional formatting in Excel.

Ok, so we want to find the best time of day for conversion – and those high CPA or low ROI times when you will want to lower bids.

As in the example below, shopping campaigns perform best at the start of the week around noon and 5pm.