← all writing

· 6 min read

The 7-day offline conversion upload rule, for people who upload spreadsheets

Google Ads now ignores offline conversions uploaded more than seven days late. Who the rule bites, what to change, and how a small test skips attribution.

If your sales close on the phone, in a demo, or in a CRM three weeks after the click, you have probably done an offline conversion upload: a spreadsheet of click IDs and close dates sent back to Google Ads so the campaign can learn which clicks became customers. This September, as Two Octobers' round-up of the month's changes reports, Google added a seven-day limit, and uploads that arrive later are ignored by attribution. This post is for the people who do the uploading: who the rule bites, what to change, and when it is more honest to stop attributing at all.

How the upload works, for those who never had to

When somebody clicks a Google ad, the URL they land on carries a click identifier. If your site stores that identifier in the form they fill in, it ends up in your CRM next to the lead. Weeks later, when the lead becomes a customer, you export a row with the click identifier, the time the deal closed and its value, and upload it. Google matches the row back to the click and credits the campaign, the keyword and the ad. The mechanism is documented in the Google Ads help pages; the short version is that it is how a campaign finds out that the cheap clicks were worthless and the expensive ones paid the quarter.

The upload is the only way a Search campaign learns about revenue that happens outside a browser. Without it, the campaign optimises towards the thing it can see, which is usually a form submission.

What the seven-day rule changes

As reported, a conversion uploaded more than seven days late no longer counts for attribution. We have not been able to confirm from public documentation exactly which moment the seven days run from, so check the wording in your own account before rebuilding anything. But whichever clock it is, the effect is the same: the window in which your business can tell the campaign what happened has shrunk to a week.

Who that bites:

  • Anyone with a sales cycle longer than a week. B2B demos, quotes, anything with a procurement step. A trial that converts in week three is invisible.
  • Anyone who uploads monthly. A great many small companies export the CRM on the first of the month and upload the lot. From now on most of those rows do nothing.
  • Agencies batching for several clients. Same problem, multiplied.
  • Anyone whose "conversion" is a signed contract. The signature is real; it is also late.

The people it does not bite are the ones whose conversions happen in the browser within the session. They were never uploading anything.

Three ways to live with it

Upload daily, automatically. If you have a CRM with a Google Ads connector, turn it on and let it push closes as they happen. If you do not, a scheduled export that runs every morning is a few hours of work once. This is the fix Google presumably wants, and for a company with steady conversion volume it is the right one.

Move the conversion earlier. Define a "qualified lead" event that happens within a week of the click — a booked call, a completed onboarding step, a first payment on a trial — and upload that as the primary conversion. Keep uploading the closes too, for your own records, but stop expecting them to steer the campaign. This works, with one cost: the campaign is now optimising towards qualified leads, not revenue, and those are different things. A campaign that is very good at producing calls that go nowhere will look excellent.

Accept that the campaign optimises to what it can see within a week, and measure revenue yourself. Keep the click identifier in the CRM, do the join in a spreadsheet at month end, and treat the platform's conversion column as what it is: an early proxy. We sorted the numbers that predict revenue from the numbers that flatter dashboards in vanity metrics vs real clicks, and the rule of thumb holds here. A conversion the platform can count within seven days is a proxy. Revenue is revenue.

For a small test, stop attributing

Here is the part that applies to most readers of this blog, who are not running a CRM connector because they are spending $200 to find out whether a channel works at all.

Attribution machinery — click identifiers, uploads, modelled conversions, windows — is built for accounts where it is worth arguing about which of twelve touches deserves credit. For a single small test it costs more than the test, and the seven-day rule makes it less accurate on top. The alternative is older and simpler.

  1. Give the placement its own tagged link, so its visits are separable in whatever analytics you already have.
  2. Write down the visits it sent, by day.
  3. Write down signups (or purchases, or whatever your one real event is) by day, for the week before and the week of the test.
  4. Compare the test days against the baseline. If the channel moved the number, you will see it; if it did not, no attribution model would have saved it.
  5. Divide what you spent by the visits. That is your cost per visit, and it is portable across every channel you will ever try.

Some placements do the counting for you: a newsletter with a click report, or a time-boxed slot like ours, which publishes card opens and click-throughs per slot on the brand's page — ours, so weigh it accordingly, and small, as the front page will show you. But a tagged link and a spreadsheet work everywhere, cost nothing, and belong to you rather than to the platform. We compared what each kind of channel reports, and what it withholds, in AI Max vs a fixed-price slot.

The rule is a symptom

The seven-day limit is a small change and it will be fixed by most affected accounts with a scheduled export. The reason it is worth a post is what it reveals. An automated campaign wants fast feedback; the faster the loop, the better it performs on its own terms. Your business's truth arrives on its own timetable, and for most businesses that sell anything more considered than a T-shirt, that timetable is longer than a week.

Every attribution setting is a choice about which of those two clocks to believe. Make the choice deliberately, write down which one you chose, and do not let a modelled column persuade you that a campaign paid for itself when your bank account says otherwise.


Sources. The seven-day upload limit: Two Octobers, September 2026 updates. Offline conversion imports: Google Ads Help.

BidSurvivor sells advertising in twelve-hour blocks, at auction. The first brand into an empty slot pays nothing, every account starts with $100 of house credit, and every brand's click-throughs are public before you bid.

See the board

Read next