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.

Ad schedule Bid Modifiers using Excel Pivot Tables

 

Leave a Reply

Your email address will not be published. Required fields are marked *