Brand Entity Consistency Audit (Optimization Theory, v3.0, November 2026)
====================================================================

Compare your official brand facts with Wikidata, LinkedIn, GBP, Yelp and more, and log every correction request.

What it decides
  Which third-party profiles state your brand facts incorrectly, and which corrections to request and from whom.

Files
  Brand Entity Consistency Audit.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Brand Entity Consistency Audit - Field Guide.pdf  the illustrated guide
  Input-Template-blank.csv ..... column headers in paste order
  Input-Template-example.csv ... the worked example (Northbeam Outdoor, fictional data)
  HOW-TO-USE-WITH-DATAFORSEO.txt step-by-step: request, save, convert, complete, paste
  Automation/ .................. import script, example request, field mapping (python3 Automation/dataforseo_import.py --help)

Built to run on DataForSEO
  Source: DataForSEO AI Optimization: LLM Mentions
  Fills automatically: Observed source URL
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. Write the official facts: List each entity (company, locations, people) and attribute with the authoritative value.
  2. Collect observed values: Check each source: Google Business Profile, Apple, Bing, Wikidata, Wikipedia, LinkedIn, Crunchbase, Yelp, BBB, industry directories.
  3. Confirm semantic matches: Mark 1 where the wording differs but the fact is the same.
  4. Request corrections: Work the action list. Log the request, the owner and the date; recheck later.

Works in Microsoft Excel, Google Sheets (upload, then open with Sheets) and LibreOffice Calc.
Paste values only at Workspace cell A13. Lime cells are inputs; blue cells are formulas.

Full tutorial: https://optimizationtheory.com/download-view/brand-entity-audit-template/
Part of the AI Visibility & GEO Toolkit: https://optimizationtheory.com/download-view/ai-visibility-toolkit-6-geo-research-and-measurement-workbooks/
All 40 templates: https://optimizationtheory.com/download-view/free-seo-geo-toolkit-40-spreadsheets-and-field-guides/

Free to use in your own and client work. Please don't resell the templates themselves.
Built by Jourdan Rombough, optimizationtheory.com
