Lonta AI · Offline working tool

Review a job’s correction before you send it

Reconcile canceled jobs, refunds and later value corrections against the original Google Ads import. Keep uncertain records visible.

Runs entirely in this browser. Input stays in memory until you reset or close the page. Downloaded review files include your supplied data. This tool sends nothing to Google.

Drafts need an account check. The CSVs use six fields documented by Google for Order ID adjustments. Compare them with your current Google Ads template before upload. GCLID rows stay in the review JSON. A successful local review proves neither attribution nor Google acceptance.

1. Load the original imports and dated events

Start with the synthetic eight-job example, or load your ledger JSON. For CSV, load both supplied schemas. Use IDs rather than customer names, emails or phone numbers.

Use the intended upload cutoff. The sample uses a fixed teaching date.
Original imports remain unchanged. Append each correction to events. Money is an absolute final value, with at most two decimals.
Load originals and events from CSV instead

CSV fields are this tool’s input schema, separate from Google’s adjustment template. See the included README and originals / events examples.

Review rules and supported scope
  • Original status must be imported. Each proposed event must be approved and repeat the original action, identity and conversion time.
  • A missing amount is unknown. Zero is valid. More than two decimals are held; choose your accounting rounding rule before entering the amount.
  • Supported currencies: USD, EUR, GBP, CAD, AUD, NZD. Each has separate totals. Currency changes are held for a separate FX review.
  • Whole-job safety rule: any bad event holds all proposed adjustments for that original. Exact retries are suppressed; conflicting retries are held.
  • Events are sorted by actual time. Retraction or a zero restatement is terminal. The original import is never overwritten.
  • Local safety holds: less than 24 hours since supplied import time, or at least 54 days since conversion. Confirm the actual current limits in Google; local eligibility is not checked.
  • GCLID without an Order ID works only for the matching offline review path. It produces review JSON, not a CSV. WBRAID, unsupported action types and missing required Order IDs are held.