Google Ads Day and Hour Heatmap

Drop your day and hour report here, or choose a file A CSV or TSV from Google Ads with the Day of the week and Hour of day segments. You can also choose two files: one by day and one by hour.

Runs in your browser. Your report is not uploaded.

Getting the report

In Google Ads, select Campaigns, then Insights and reports › Report editor, and choose Custom › Table. Pick a date range with a few weeks of data, such as the last 90 days.
Drag Day of the week and Hour of day (under Time) into Rows, and Clicks, Impr., Cost, Conversions and, for ROAS, Conv. value into Columns. Add Campaign too if you want to filter by campaign.
Download it as CSV and drop it here. Or segment a campaigns table by Time › Day of the week and download it, then by Hour of day, and upload both files.

Or paste the table

Report table, including the header row

Settings

Judge hours by

Cost per conversion ROAS

ROAS needs a Conv. value column in the report.

Target cost per conversion (₹)

Optional. Marks the best and worst slots that miss it.

Minimum clicks per slot

Largest bid change

Slots with fewer clicks get no bid change (our measure). Google allows −90% to +900%; we suggest smaller steps.

Campaign bid strategy

Suggest pausing hours with no conversions that spent at least twice the average cost per conversion

Your heatmap appears here

Upload a report, paste it, or try the example: 90 days of a made-up gym in Baner, Pune, where early mornings and evenings convert.

Free Google Ads Day and Hour Heatmap. Runs in your browser, no sign-up. Open the full tool on DigitalSnot →