Conversion Lag Calculator for Google Ads

How to measure conversion lag in Google Ads with your CRM data

Conversion lag in Google Ads is the gap between a click and the conversion it leads to. Google's own report only sees conversions it already counted. If your deals close weeks later in a CRM, the real lag is hidden. This calculator measures it from your own rows and compares it with the limits on Google's About conversion windows page: 1 to 90 days, 30 by default.

1. Export your closed deals. You need two dates per deal: the ad click (or the date the lead came in) and the date it became a sale. Add the GCLID, campaign and deal value if your CRM stores them.
2. Load the file. Drop it here, paste the rows, or click Try sample data to see a remodeling company's pipeline.
3. Enter your current window. Type the click-through window your conversion action uses, and choose how many of your sales the suggested window should count.
4. Read the results. You get the median days to a sale, the day by which 90% of sales happen, a chart in Google's lag buckets, and a table of how many sales a 7, 14, 30, 60 or 90-day window would count.
5. Download. Save the results with the lag on every row, plus a file of the sales you can still upload to Google Ads.

How the suggested window works

The suggestion is our own calculation, not a Google rule. We sort your measured sales by lag and pick the shortest window you can choose in Google Ads (1 to 30, 60 or 90 days) that counts the share you picked. If that is under 7 days, we use 7, because Google recommends at least that. If even 90 days isn't enough, the tool tells you how many sales come too late to count at all.

What to do next in Google Ads

1. Change the window if it's too short. Go to Goals > Conversions > Summary, click the conversion action, then Edit settings and set the click-through conversion window.
2. Give it time. The new window only counts conversions from that day on, so compare results a full window later.
3. Upload the sales you still can. Take the upload-ready file to the offline conversion builder, and upload every few days from now on.
4. Read reports with the lag in mind. Check campaigns on date ranges that ended at least as long ago as your median lag.
5. Long cycles: count an earlier step too. If many sales take more than 90 days, think about also importing an earlier stage, such as a qualified lead, that happens inside the window.

Conversion lag problems and upload errors

“Conversion date precedes click date”

Google's upload error when the sale is dated before the click. It usually means the two dates are in different time zones, or the columns are swapped. The calculator flags these rows and leaves them out of the analysis.

“This click is too old for its conversion to be imported”

The GCLID is older than 90 days or older than the conversion window. In the results, the Status and Note columns mark rows past either limit, and the problem list shows the deadline for clicks that expire within a week.

Why recent days show fewer conversions in Google Ads

Last week's clicks haven't finished converting. With a median lag of 30 days, a week-old campaign has seen only a small part of its sales.

The Days to conversion segment looks empty

Google advises ending the date range at least 30 days ago, or longer with a longer window, before you read this segment. Recent ranges are still filling in.

Only a lead date in the CRM

Many CRMs store when the lead was created, not when the ad was clicked. Using it is fine, as long as you read the result as lead-to-sale time.

Dates read the wrong way round

“03/04/2026” is March 4 in the US and 3 April in the UK. The tool detects the order from dates like 16/09/2026, and you can set it yourself in the options.