# Marketing Reporting Automation — SOP

## Purpose and scope

Prepare a recurring marketing report from approved source exports while preserving metric definitions, scope, attribution settings and unresolved exceptions. This procedure automates collection checks, reconciliation and draft assembly. A named marketing owner approves interpretation and actions. It does not claim causal attribution or authorize spend changes.

## Owner, trigger and output

- **Owner:** marketing operations or campaign reporting owner.
- **Trigger:** reporting cut-off plus the approved campaign register and source exports.
- **Output:** reviewed report pack, source manifest, exception ledger and next-decision owner.

## Prerequisites

1. Metric dictionary with scope, formula, time zone and source.
2. Campaign ID and UTM naming convention.
3. Approved attribution model and a plain-language limitation note.
4. Source access and export method tested for the reporting period.
5. Review owner and fallback for unavailable or late sources.

## Procedure

1. Freeze the report period, source list and prior approved report version.
2. Collect source exports and record source, retrieval time, scope and row count.
3. Validate campaign identifiers, required fields, currency/time-zone assumptions and duplicates.
4. Reconcile totals at the declared scope; never compare user-, session- and event-scoped values as if they were the same metric.
5. Route missing, late or mismatched data to the named owner. Preserve source values.
6. Assemble tables and draft notes that distinguish observed values from interpretation.
7. Show attribution model, modeled or unavailable data, cut-off and corrections beside the result.
8. Obtain human approval for conclusions and actions.
9. Publish the approved version and retain the manifest, exceptions and correction history.

## Exceptions and approvals

Stop automatic completion for identifier mismatches, changed metric definitions, material source gaps, unexpected attribution settings, personal information or a proposed budget/external action. The marketing owner decides whether to delay, qualify or exclude a result.

## Audit record

Retain report ID, period, source manifest, definitions version, attribution note, validation results, exceptions, approver, published version and later corrections. Recheck platform documentation when the source behavior or settings change.