G08: native input mapping
Check original brand and marketing source

Purpose and compatibility
A blank file is an input scaffold, not a native export or completed mapping. Preserve the exact column names/order and input names. Populate only from the documented native acquisition or explicit manual evidence. Stop if a required input, permission, privacy condition or coverage requirement is missing. Do not replace an old prompt until the named inputs and field-level mapping are reviewed. These files do not authorize login, setup, imports, account changes, message sending, publication, test submissions or spending.
Contract status: Requires distinct native-input templates or an explicit reviewed mapping; existing kit is not drop-in compatible
Compatible without mapping: false

Required inputs
Attribution -> native-attribution-template.csv
Exact columns: lead_alias,current_brand,current_source,current_campaign,current_capture_at,original_brand,original_source,original_capture_at,change_evidence_ref,coverage
Populate only from the recipe’s documented export or explicit manual evidence capture. Existing blanks and synthetic fixtures do not supply facts.

SourceHistory -> native-sourcehistory-template.csv
Exact columns: lead_alias,field,old_value,new_value,changed_at,source_ref
Populate only from the recipe’s documented export or explicit manual evidence capture. Existing blanks and synthetic fixtures do not supply facts.

Scope -> native-scope-template.txt
Required content: Full approved scope, source account aliases, date filters, date basis/timezone, as-of capture time, definitions, source-to-alias map provenance, matching rules, inspected/excluded records, permission/privacy limits, missing-data reasons, coverage and responsible reviewer. Include recipe-specific policies, versions and tests. Scope must be inside the AI workbook or pasted packet, not merely a separate unprovided file.
Complete each required field from approved source evidence.

Old files and reviewed mapping
first-touch-policy.txt
Original first line: G08: first-touch-policy.txt

leads.csv
Original first line: lead_alias,brand_id,original_source,later_source,tracking_number_token,utm_source,utm_campaign

source-history.csv
Original first line: lead_alias,field,old_value,new_value,changed_at,source_ref

source-review.csv
Original first line: lead_alias,rule_ids,brand_conflict,original_source_evidence,later_touch_evidence,proposed_rule_test

tracking-rules.csv
Original first line: rule_id,brand_id,number_token,utm_match,priority

leads.csv -> Attribution: only evidence-backed lead_alias and original_source may carry over directly. brand_id does not prove either current_brand or original_brand; later_source is not automatically current_source. Obtain separate current and original capture timestamps, current_campaign, change_evidence_ref and coverage from genuine captures.
source-history.csv -> SourceHistory: the declared headers match, but populated rows still require historical source verification and privacy review. An empty table or old synthetic example does not prove changes occurred.
first-touch-policy.txt and tracking-rules.csv -> Scope: preserve the approved first-touch definitions, dated mapping history and rule versions. Current tracking rules cannot reconstruct old mappings. source-review.csv is an old output, not historical evidence.

How to perform the handoff
1. Keep original exports and raw evidence unchanged in restricted firm storage. Check actual source fields, dates, coverage, privacy and access before mapping.
2. Prepare the distinct native inputs above. Record every mapped field, derived interpretation, missing value and observed source reference in Scope. Identically named columns still require source/evidence validation.
3. Create a separate minimized analysis workbook or text packet. Name tables/sections exactly as listed. A CSV file does not itself create a named Excel table.
4. Include the full completed Scope in the same AI-visible workbook or pasted packet. Verify exclusions, denominator, matching rules and unknowns. Do not hide raw client data on another worksheet.
5. Obtain the responsible reviewer’s approval of the completed mapping and evidence coverage before using the native prompt. Keep all blocked items visible. Any later external action is a separately authorized human step.

Acquisition and privacy requirements
Use approved minimized administrative metadata and aliases only. Aliases alone do not guarantee anonymity. Keep untouched exports/screenshots, identifying source maps, full documents and sensitive narratives in restricted firm storage. A hidden worksheet is not a privacy boundary. Do not insert credentials, payment/tax identifiers, raw client documents or unsanitized review text. Unknown is not zero, false, completed or absent.
Existing authorized access to the correct source account and records; no new login, credentials, installation or permission grant is included.
Responsible lawyer/operations reviewer approves scope, definitions and any later action.
AI optional; use only approved minimized data and retain originals separately.
No universal brand field or export of full old/new field history was verified. CallRail first-touch data depends on tracking actually installed.
The live account, entitlement, exact headers, records and field coverage have not been observed.

Recipe acquisition / manual mapping instructions
Get the actual Lawmatics rows
Location: Reports > Custom Reports > existing matter report > eye/view icon > Export
Use an existing authorized report, or have its owner prepare a targeted report with Source, Campaign, Created At and exact existing original-brand/original-source fields. Record the agreed review period and matter scope, including which date field sets the range. Export the viewed report to CSV; large exports may arrive by email. Preserve headers and file unchanged. A report creation/save is a separate account write, not performed here. If no suitable report exists, use the documented Settings > Export > Export Matters route only in restricted storage, then minimize locally.
Verification: A matter report may contain contact and matter fields. A contacts-only export omits matter fields. Date-created and date-converted scopes differ; exported grouping is not preserved.
https://help.lawmatics.com/en/articles/10699961-exporting-custom-reports
https://help.lawmatics.com/en/articles/10699766-exporting-data
https://help.lawmatics.com/en/articles/10699953-custom-reporting-using-filters
https://help.lawmatics.com/en/articles/10699957-custom-reporting-columns-grouping

Capture the source evidence and present mapping
Location: CallRail Analytics > Activity > Call log > Timeline; Lawmatics phone icon > Assigned / Unassigned / All Callers; Settings > Marketing Sources
Manually capture the relevant first-touch/call source evidence and the existing mapping values. Inspect source and campaign settings without saving. Separately collect retained historical form/call captures or logged field-change evidence showing original value, later value and timestamp.
Verification: Lawmatics CallRail matching uses phone numbers; later calls do not overwrite existing source/campaign. Settings changes affect subsequent calls. Current rules cannot prove past configuration.
https://support.callrail.com/hc/en-us/articles/5711366294285-Viewing-caller-timelines-with-visitor-tracking
https://help.lawmatics.com/en/articles/10699987-callrail-integration

Make the checked, minimized handoff
Location: Restricted original workbook > separate analysis workbook > Scope worksheet
Keep current_field, original_capture and change_evidence separate. Do not reconstruct first brand from the latest landing page. Keep untouched original exports/screenshots and the identifying source map in restricted firm storage. Build a separate minimized analysis file; do not hide raw client data on another tab. Include the complete Scope/coverage note in the AI-visible workbook or prompt. Use aliases and administrative metadata only. Unknown is not zero, false, completed or absent.
Verification: Every field has an observed source or an explicit missing reason; staff assignments are marked editorial, not native.
https://support.microsoft.com/en-us/excel/merge-queries-power-query
https://help.lawmatics.com/en/articles/10699825-matter-profile-overview


Do not proceed when
- Missing original capture, historical mapping, timestamps or unambiguous cross-tool identity.

Scope template requirements
Full approved scope, source account aliases, date filters, date basis/timezone, as-of capture time, definitions, source-to-alias map provenance, matching rules, inspected/excluded records, permission/privacy limits, missing-data reasons, coverage and responsible reviewer. Include recipe-specific policies, versions and tests. Scope must be inside the AI workbook or pasted packet, not merely a separate unprovided file.

Old examples and validation limits
Legacy synthetic examples and negative cases belong to their old prompts. They do not automatically test the native route and must not be fed into a new prompt without an explicit reviewed mapping and separately approved test design. These new files contain no synthetic values, source exports, account results or live-test evidence.
Documentation-checked component path; proposed workflow, not tested
Public official documentation checked 2026-10-15; no login, export, live query, import, installation, configuration, message or client workflow was executed.
Local validation covers only exact scaffold schemas, placeholder presence, blank CSV rows and required warnings. It does not establish live account coverage, native export validity, successful integration or completed workflow tests.
