Free tool

Google Ads Dayparting Heatmap By Day And Hour

Paste a Google Ads report segmented by day of the week and hour of day: the tool adds up the rows for each time slot and colors a 7-day by 24-hour grid by CPA, conversion rate index, conversions or cost. You see at a glance when your campaigns convert and when they spend with no conversions.

In Google Ads, the ad schedule lets you pick the days and hours your ads can show and set bid adjustments for specific days and times; by default, a campaign shows ads “All day”. Google lists time of day among the signals Smart Bidding evaluates, and notes that with a strategy such as Target CPA or Target ROAS, bid modifiers behave differently or may be ignored depending on the strategy type.

Fictitious example

Color by

Hover over the cells or move through them with the arrow keys to see the details. The Total column and row add up each day and each hour.

The tool describes, it prescribes no adjustment. Google lists time of day among Smart Bidding signals, and notes that with Target CPA or Target ROAS, bid modifiers behave differently or may be ignored. To pick a strategy: Smart Bidding simulator.

Sources read on November 6, 2026: Google Ads Help, segments, Google Ads Help, ad scheduling, Google Ads Help, Smart Bidding, Google Ads API, bid modifiers and Google Ads API, metrics.

Are Your Campaigns Spending At Hours When Nothing Converts?

In a Google Ads audit, I cross these time slots with your bids, budget and conversions, then tell you what to change first.

20 minutes · No commitment · 100% confidential

Step 1 Of 2 · Your Project

Step 2 Of 2 · Your Details

Who are these campaigns for? *
What are you looking for in our collaboration? * You can pick several
Where do your ad campaigns stand today? *
When would you ideally like to start? *

How the tool works out each time slot

Index = (conversions ÷ clicks in the slot) ÷ (conversions ÷ clicks in the report)

The tool recognizes the Day of the week and Hour of day columns, then clicks, impressions, cost and conversions. Rows for the same slot are added together, and total rows are skipped. CPA follows Google’s definition: cost ÷ conversions. The conversion rate is worked out on clicks, while Google divides by interactions, which are views for video ads. For a single figure, the conversion rate calculator is enough.

Example: on Monday at 9:00, two rows add up to 15 clicks, $20 in cost and 1 conversion, a CPA of $20. On Tuesday at 14:00, 20 clicks, $30 and 3 conversions give a CPA of $10. Across the report, 4 conversions from 35 clicks make an average rate of 11.43 %: the index is 0.58 on Monday at 9:00 and 1.31 on Tuesday at 14:00. Above 1, the slot converts better than the report average; below 1, less well.

A cell with no row stays gray: no data. A cell with cost and no conversions has no CPA: it is hatched in pink, and the tool does not invent one. The summary names the highest and lowest slots for the chosen metric without recommending any adjustment: with Smart Bidding, time of day is already among the signals, and bid modifiers may be ignored. To see how each strategy bids, open the Smart Bidding simulator.

What the heatmap gives you

  • Find the hours that convert: switch to the conversion rate index, and slots above 1 stand out in a darker shade. You see where your budget works hardest.
  • Spot cost with no conversions: on CPA, hatched cells show the slots that spent without converting, and the summary gives their total cost. You know where to start your analysis.
  • Prepare an ad schedule: before you limit your ad hours or set a bid adjustment, check that the gap holds over several weeks of data. You decide on numbers, not on a hunch.

Frequently asked questions

Which Google Ads report should I paste?

A report that combines the Day of the week and Hour of day segments, with at least cost and conversions, or clicks and conversions. Download it as a CSV or copy it from a spreadsheet, headers included: the tool reads column names in English, French and Spanish, skips title and total rows, and adds up rows for the same slot, for example when your report also splits by campaign.

Should I change my bids based on the heatmap?

The tool does not recommend it: it describes your numbers. Google lists time of day among Smart Bidding signals, and notes that with a strategy such as Target CPA or Target ROAS, bid modifiers behave differently or may be ignored. The ad schedule lets you limit the hours your ads show and set bid adjustments by day and hour.

Why are some cells gray or hatched?

Gray: no row in the report for that slot, or a zero divisor (no clicks for the index). Hatched in pink, on CPA: cost with no conversions, so no CPA to work out. Hover over a cell, or reach it with the keyboard, to see the clicks, conversions and cost behind its value.

Is my report sent anywhere?

No. The analysis runs in your browser: nothing is uploaded or stored, and the report is gone when you close the page.

Théo Maupilé

Growth partner

Positioning, acquisition, innovation: together we build a lasting growth system.

Théo MaupiléFreelance Paid Media

Google PartnerSuperMalter

◉ Certifications

Official Google Partner
& SuperMalter