Match reported refund events to supplied transaction IDs before comparing net campaign revenue. The download provides a specific review process. It does not make decisions or act in an account.
Download the free skill
One complete Markdown file. No subscription, checkout or fabricated setup files.
Download SKILL.mdWhat to provide
Approved purchase and refund exports, transaction IDs, currencies, refund dates and report basis.
How it works
- Join explicit transaction IDs and preserve separate purchase and refund events.
- Distinguish partial, full, unmatched and duplicate candidate refunds. Similar amounts alone are not a match.
- Calculate a supported net amount only when currency and included items agree; show unmatched refunds separately.
- Return an event reconciliation and missing fields. Do not issue refunds, change tracking or alter finance records.
The output
transaction ID | purchase | linked refund | currency | net | unmatched | review question
Worked fictional example
Fictional purchase T1=100 with linked refund30 gives supported net70. Refund T9=20 has no supplied purchase and remains unmatched, not deducted from T1.
Checks and limits
Preserve source versions and original values. Unknowns stay unknown. Use a qualified reviewer for regulated, legal or hiring decisions. No send, share, account change, schedule, ledger update or payment is authorized. No live account test is claimed.
More marketing workflows · How-to guides
Method: reviewed source. Demand lead: Oct4 GSC campaign/report clusters; ecommerce method demand, exact intent volume unmeasured. These are site-query cluster impressions and method evidence, not exact new-topic monthly search volume or a traffic promise. Checked October 4, 2026.