Gbp Local SEO Intent

module: gbp-local-seo-intent
intent: null            # set up | fix | review | report | import
scale: null             # Starter | Growth | Scale, only if the answer changes it
areas:
  "Location": null
  "What It Does": null
  "Current State": null
  "Proof": null
  "Engagement": null
requested_outputs: []
confirmed_facts: []
open_questions: []

Row ID,Row Type,GBP Element,Value,Primary Keyword,Supporting Keywords,Search Intent,Landing Page URL,Media Attached,Post Type,Call To Action,Publish Date,Expiry Date,Review Rating,Review Date,Review Reply Status,Reviewer Response,Category Role,Visibility,Action Type,Data Quality Status,Verified,Owner,Review Date Check,Status,Notes
,Profile,Business description,"Example Retail is a home and kitchen goods shop in Example City selling cookware, storage and small appliances, with same-day local delivery across Example City and the surrounding area. Walk in for advice, order online, or call the shop.",example retail example city,"home and kitchen goods shop; small appliance shop",Local intent,https://example.com/,None,None,Visit the shop,2026-09-27,,0.0,2026-09-27,Not applicable,Not applicable,Primary,Public,Set up,Incomplete,false,Unknown,2026-10-27,Draft,"Example row - replace every value before use."

-- Engine assumption: PostgreSQL. For another engine use the engine's auto-increment
-- equivalent and keep the rest portable.
CREATE TABLE gbp_record (
  row_id BIGINT PRIMARY KEY,
  row_type VARCHAR(100) NOT NULL,
  gbp_element VARCHAR(255) NOT NULL,
  value TEXT,
  primary_keyword VARCHAR(255),
  supporting_keywords TEXT,
  search_intent VARCHAR(100) NOT NULL,
  landing_page_url TEXT,
  media_attached VARCHAR(100) NOT NULL,
  post_type VARCHAR(100) NOT NULL,
  call_to_action VARCHAR(100),
  publish_date DATE,
  expiry_date DATE,
  review_rating NUMERIC(2,1),
  review_date DATE,
  review_reply_status VARCHAR(100) NOT NULL,
  reviewer_response TEXT,
  category_role VARCHAR(50) NOT NULL,
  visibility VARCHAR(50) NOT NULL,
  action_type VARCHAR(100) NOT NULL,
  data_quality_status VARCHAR(100) NOT NULL,
  verified BOOLEAN NOT NULL,
  owner VARCHAR(255),
  review_date_check DATE,
  status VARCHAR(50) NOT NULL,
  notes TEXT,
  created_at TIMESTAMP DEFAULT NOW(),
  updated_at TIMESTAMP DEFAULT NOW(),
  CONSTRAINT gbp_row_type CHECK (row_type IN ('Profile','Service','Category','Attribute','Post','Review','Question','Photo','Product')),
  CONSTRAINT gbp_rating_range CHECK (review_rating IS NULL OR (review_rating >= 1 AND review_rating <= 5)),
  CONSTRAINT gbp_data_quality CHECK (data_quality_status IN ('Complete','Incomplete','Needs Review','Blocked')),
  CONSTRAINT gbp_category_role CHECK (category_role IN ('Primary','Secondary','Not applicable')),
  CONSTRAINT gbp_expiry_after_publish CHECK (expiry_date IS NULL OR publish_date IS NULL OR expiry_date >= publish_date)
);

CREATE INDEX idx_gbp_record_row_type ON gbp_record (row_type);
CREATE INDEX idx_gbp_record_status ON gbp_record (status);
CREATE INDEX idx_gbp_record_reply ON gbp_record (review_reply_status);

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "GBP & Local SEO Intent",
  "type": "object",
  "additionalProperties": false,
  "properties": {
      "Row ID": { "type": "integer" },
      "Row Type": { "type": "string" },
      "GBP Element": { "type": "string" },
      "Value": { "type": "string" },
      "Primary Keyword": { "type": "string" },
      "Supporting Keywords": { "type": "string" },
      "Search Intent": { "type": "string" },
      "Landing Page URL": { "type": "string", "format": "uri" },
      "Media Attached": { "type": "string" },
      "Post Type": { "type": "string" },
      "Call To Action": { "type": "string" },
      "Publish Date": { "type": "string", "format": "date" },
      "Expiry Date": { "type": "string", "format": "date" },
      "Review Rating": { "type": "number" },
      "Review Date": { "type": "string", "format": "date" },
      "Review Reply Status": { "type": "string" },
      "Reviewer Response": { "type": "string" },
      "Category Role": { "type": "string" },
      "Visibility": { "type": "string" },
      "Action Type": { "type": "string" },
      "Data Quality Status": { "type": "string" },
      "Verified": { "type": "boolean" },
      "Owner": { "type": "string" },
      "Review Date Check": { "type": "string", "format": "date" },
      "Status": { "type": "string" },
      "Notes": { "type": "string" }
  },
  "required": [
      "Row Type",
      "GBP Element",
      "Search Intent",
      "Media Attached",
      "Post Type",
      "Review Reply Status",
      "Category Role",
      "Visibility",
      "Action Type",
      "Data Quality Status",
      "Verified",
      "Status"
  ]
}

| CSV column | Notion property | Set after import |
|---|---|---|
| Row ID | Text (preserve source ID) | Keep imported IDs as Text; optionally add a separate Unique ID property |
| Row Type | Select (add options after import) | Convert to Select, add options: "Profile", "Service", "Category", "Attribute", "Post", "Review", "Question", "Photo", "Product" |
| GBP Element | Text | Leave as Text. The field being set, e.g. "Business description", "Opening hours" |
| Value | Text | Leave as Text. The actual text or value. The longest cell on this table |
| Primary Keyword | Text | Leave as Text. The term this row is meant to answer |
| Supporting Keywords | Title | Use as the database title |
| Search Intent | Select (add options after import) | Convert to Select, add options: "Informational", "Commercial investigation", "Transactional", "Navigational", "Local intent" |
| Landing Page URL | URL | Convert to URL. Every post and service points at a real page on the site |
| Media Attached | Select (add options after import) | Convert to Select, add options: "None", "Photo", "Photo set", "Video" |
| Post Type | Select (add options after import) | Convert to Select, add options: "None", "Update", "Offer", "Event", "Product" |
| Call To Action | Select (add options after import) | Convert to Select, add options: "None", "Learn more", "Call now", "Book", "Get offer", "Sign up", "Shop", "Order" |
| Publish Date | Date | Convert to Date. Blank for a profile field that is not scheduled |
| Expiry Date | Date | Convert to Date. An offer post must have one or it stays up for ever |
| Review Rating | Number | Convert to Number, one decimal place, digits only. Never entered by hand for someone else's review - copied from the profile |
| Review Date | Date | Convert to Date |
| Review Reply Status | Select (add options after import) | Convert to Select, add options: "Not applicable", "Replied", "Reply pending", "Reply overdue" |
| Reviewer Response | Text | Leave as Text. What was actually said, in full |
| Category Role | Select (add options after import) | Convert to Select, add options: "Primary", "Secondary", "Not applicable" |
| Visibility | Select (add options after import) | Convert to Select, add options: "Public", "Public and managed", "Hidden - see Notes" |
| Action Type | Select (add options after import) | Convert to Select, add options: "None", "Set up", "Edit", "Reply", "Request", "Verify", "Mirror", "Suspend", "Escalate" |
| Data Quality Status | Select (add options after import) | Convert to Select, add options: "Complete", "Incomplete", "Needs Review", "Blocked" |
| Verified | Checkbox | Convert to Checkbox. False until verification has actually completed |
| Owner | Text | Leave as Text |
| Review Date Check | Date | Convert to Date. Named "Check" so it cannot be confused with a review's own date |
| Status | Select (add options after import) | Convert to Select, add options: "Planned", "In progress", "Live", "Needs update", "Retired" |
| Notes | Text | Leave as Text |