Attribution ReconcilerSAFE

120 marketing skills as an AI marketing staff — plugin, portable skills, or an 8-bot team across 7 disciplines (narrative, SEO/GEO, social, email, paid, influencer, launch) on one contract, with 8 auditor gates: TALE · CORE-EEAT · CITE · ECHO · SEND · ROAS · STAR · RAMP.

The instruction file, verbatim from the audited commit — this is the text the model reads, and the surface the audit's instruction layer examines. Quoted here so you can judge it without cloning anything.

---
name: attribution-reconciler
slug: aaron-attribution-reconciler
displayName: "Attribution Reconciler · 付费广告归因对账"
summary: "付费广告归因对账/去重/增量"
description: 'Use when platform-reported conversions disagree with GA4/ecommerce, when you suspect Meta and Google are double-counting the same sales, or for a standing (monthly) reconciliation workbook that de-dups stacked credit against an order-ID truth set, normalizes attribution windows and currency, compares attribution models, and reads incrementality from a geo/holdout test. Not for the point-in-time R2 veto or RQS gate — use ad-account-auditor; not for the ROI/ROAS ratio math itself — use roi-calculator; not for organic dark-social share attribution or GA4 direct-traffic decomposition — use dark-social-attributor. 付费广告归因对账/去重/增量'
version: "20.1.0"
license: Apache-2.0
compatibility: "Claude Code and compatible agent-skill hosts"
homepage: "https://github.com/aaron-he-zhu/aaron-marketing-skills"
when_to_use: "Use when running a standing reconciliation of platform-reported conversions against the GA4/ecommerce order-ID truth set: de-dup stacked credit across Meta + Google, normalize differing attribution windows and currency, compare attribution models side by side, and read incrementality where a geo/holdout test exists. Activate when the user has each platform's conversion export plus an order-ID export and wants to know which conversions are real and not double-counted."
argument-hint: "<GA4/ecommerce order-ID export> [platform conversion exports] [goal: DR|prospecting]"
metadata: {"author": "aaron-he-zhu", "version": "20.1.0", "discipline": "ad", "phase": "scale", "geo-relevance": "low", "hermes": {"tags": ["marketing", "ad", "scale"], "category": "ad"}, "openclaw": {"emoji": "🎯", "homepage": "https://github.com/aaron-he-zhu/aaron-marketing-skills"}}
---

# Attribution Reconciler

> Based on the ROAS dimension **R** (attribution integrity) in the [ROAS Benchmark](../../../references/roas-benchmark.md). This is the **standing de-dup / incrementality workbook**: it reconciles platform-reported conversions against the GA4/ecommerce order-ID truth set on a recurring cadence. It delegates **all** ratio/ROAS math to [roi-calculator](../../../influencer/report/roi-calculator/SKILL.md) and does **not** re-run the R2 veto — [ad-account-auditor](../../activate/ad-account-auditor/SKILL.md) judges R2 once, point-in-time. This workbook just keeps the truth set clean between audits. Upstream, [conversion-signal-qa](../../activate/conversion-signal-qa/SKILL.md) is the **pre-launch** instrumentation pass that makes the signal trustworthy and only *gates* that a dedup rule exists; this skill is the recurring reconciliation that runs **on** that signal — match, de-dup, quantify, read incrementality.

The single rule: the truth set is the **order IDs** from GA4/ecommerce, **never** any platform's reported-conversion count. This workbook reconciles **paid** channels only — decomposing GA4 direct traffic and estimating organic dark-social share attribution belongs to [dark-social-attributor](../../../social/observe/dark-social-attributor/SKILL.md).

## Quick Start

```
Reconcile my paid conversions for May. Truth set is this GA4 order-ID export. Here are the Meta and Google conversion exports. Find the double-counting.
```

```
Build the monthly attribution workbook: normalize Meta's 7-day-click window and Google's 30-day window to a common window, convert currencies, then show de-duped conversions per platform against my Shopify order export.
```

```
I ran a geo holdout for two weeks. Here's the test-region and control-region order export plus the platform spend. Read the incrementality and compare it to last-click.
```

## Skill Contract

- **Expected output**: a reconciliation workbook that maps every platform-reported conversion to (or away from) an order in the truth set, a de-duped conversion count per platform, a normalized-window/currency view, an attribution-model comparison table, and an incrementality read if a holdout exists.
- **Reads**: the GA4/ecommerce **order-ID export** (truth set), each platform's **conversion export** (reported conversions with claimed order IDs/timestamps/windows), the stated attribution window per platform, currency per export, and any geo/holdout test export (test vs control orders + spend). The ROAS profile (`direct-response|prospecting|incremental-profit`) is context only.
- **Writes**: a reconciliation workbook at `memory/ad/attribution-reconciler/YYYY-MM-DD-<topic>.md` — match table, de-duped counts, normalized view, model-comparison table, incrementality read, and a handoff summary.
- **Promotes**: the de-duped conversion count, the double-count rate, and the incrementality result (if any) to `memory/hot-cache.md`. Unresolved gaps (orders with no platform claim, or platform claims with no matching order) to `memory/open-loops.md`.
- **Done when**: every platform conversion is reconciled to the order-ID truth set (matched / double-counted / unmatched), windows and currency are normalized to a common basis, at least one attribution-model comparison is shown, incrementality is read where a holdout exists (or marked N/A), and the ratio/ROAS math is handed to `roi-calculator` rather than computed here.
- **Primary next skill**: [roi-calculator](../../../influencer/report/roi-calculator/SKILL.md).

### Handoff Summary

> Emit the standard shape from [skill-contract.md §Handoff Summary Format](../../../references/skill-contract.md).

## Data Sources

> See [CONNECTORS.md](../../../CONNECTORS.md) for tool category placeholders. Every input is the user's **own account data, manually exported**. Keyed ad-platform APIs (Google Ads SDK, Meta Marketing API) are an optional Tier-2/3 MCP convenience — never required.

| Need | Source export (own data) | Category |
|------|--------------------------|----------|
| Truth set (order IDs, timestamps, value, currency) | GA4 / ecommerce order export | `~~web analytics`, `~~ecommerce` 

SAFEgrade B · trust 89/100 Nothing in the source contradicts what it says it does. Grade A is reserved for packages that have also passed the behavioural sandbox.

What the source does

Filesystem

none-observed

Network

none-observed

Shell

none-observed

Dependencies

pinned

Secrets in source

none-found

Findings (0)

No findings outside the package's declared scope.

Gates applied: no_behavioural_pass.

[![ModelsAtlas audit: Attribution Reconciler](https://modelsatlas.com/skills/aaron-he-zhu/attribution-reconciler/badge.svg)](https://modelsatlas.com/skills/aaron-he-zhu/attribution-reconciler/)

Not your listing, or something out of date? Claim or update your listing.