Conversion Adjustments CSV Builder for Google Ads

How to use the conversion adjustments builder

When an order is refunded or canceled, Google Ads still counts the original sale unless you tell it otherwise. Google Ads conversion adjustments fix that: a RETRACT row removes the conversion and a RESTATE row changes its value. This tool turns the refunds report you already have into the adjustments file described in Google's How to adjust your conversions guide, and checks every row first.

1. Export your refunds. From your store, CRM or payment system, export refunded and canceled orders. The order ID and refund date are enough; the order date, order total, refund amount and status make the checks smarter.
2. Load the file. Drop in a CSV or Excel file, or paste rows from a spreadsheet. Click Try sample data to see a store export with common mistakes.
3. Check the matched columns. Headers such as Order ID, Shopify's Name, Refund Date and Refunded Amount are recognized. Shopify's orders export has no refund date, only Cancelled at, so choose the current time for empty dates.
4. Type the conversion name. Use the exact name of the conversion action in Google Ads, then choose the time zone your dates are in.
5. Download two files. The upload file holds only the rows Google should accept. A second file lists every row left out, with the reason and the fix.

How the tool chooses RETRACT or RESTATE

• Full refund, cancellation, void or chargeback becomes RETRACT.
• Partial refunds become RESTATE with the order total minus every refund so far, so 500 becomes 400, then 350.
• Paid or pending orders are skipped, so you can load a full orders export without filtering it first.

What it checks before you upload

• The 54-day limit from the original conversion, and the 24-hour wait Google recommends after a new conversion.
• That each refund comes after its order and before the upload, in your time zone.
• Duplicates by Order ID, conversion name and adjustment time, the key Google uses.
• Changes that come after a retraction, which Google ignores without an error.

Upload the adjustments file in Google Ads

1. Open the uploads page. In Google Ads, click the Goals icon, open the Conversions menu and click Uploads. If a manager account tracks your conversions, do this from the manager account.
2. Add the file. Click the plus button, choose Upload a file as the source and select the CSV you downloaded. Keep it separate from any new conversions.
3. Preview, then apply. Preview the file to see errors before they count, then click Apply. Adjustments can't be edited after the import, so read the preview.
4. Fix the rows left out. Correct them in your source system and run them through the tool again tomorrow, together with the next day's refunds.

Before your first upload, compare the header row with Google's own template under Uploads › + › View templates › Conversions adjustments, especially in GCLID mode.

Common conversion adjustment errors and fixes

The conversion couldn't be found

Google can only adjust a conversion it recorded. Orders that did not come from a Google Ads click were never conversions in your account, so they return this error. Google suggests uploading all your refunds anyway; the errors for those rows are harmless.

Adjustment time before the conversion time

The adjustment must happen after the conversion and before the upload. A refund dated in another time zone often looks earlier than the order. Pick the right time zone in the options, or check that the refund date column is not the order date.

Adjustments that seem to do nothing

A conversion less than a day old may not be recorded yet, so upload a day later. And once a conversion is retracted or restated to 0, Google silently ignores every later adjustment for it.

Duplicate adjustments are not counted

Google treats rows with the same Order ID, conversion name and adjustment time as one adjustment. This tool adds two refunds made at the same time into one row.

Wrong conversion name

The name must match the conversion action letter for letter, including capitals. Copy it from Goals › Conversions › Summary.

Adjusted value in the wrong currency

Leave Adjusted Value Currency empty and Google uses the conversion action's currency. If you enter a different currency than the original conversion, Google converts it with daily exchange rates, so a missing or wrong code quietly changes your numbers. Use 3-letter codes like USD or EUR.