Fetch raw ad creative, app, ranking, and revenue data from AdMapix as structured JSON.
Documents
IDX CMA Report
Try itGenerate comparative market analysis (CMA) and home valuation reports from IDX listing data and selected comparable properties. Use when a user wants to pick...
What it does
Use this skill to turn subject-property data and IDX comparables into a defensible CMA package with:
The skill document
IDX CMA Report
Use this skill to turn subject-property data and IDX comparables into a defensible CMA package with:
- Structured valuation calculations
- A written report for agent/client review
- An interactive handoff prompt for Google Gemini Canvas / Google AI Studio
Workflow
1. Gather Data Through IDX MCP/CLI
Use the IDX MCP/CLI skill already available in the environment to pull:
- Subject property details
- Candidate comparable listings (closed/pending/active based on user preference)
Ask the user which comps to include when the choice is ambiguous. Keep 3 to 8 comps unless the user requests otherwise.
Normalize data to JSON using the schema in references/cma-input-schema.md.
2. Build CMA Outputs
Run:
python3 scripts/build_cma.py \
--subject subject.json \
--comps comps.json \
--output-dir cma-output
The script produces:
cma-output/cma_report.md(summary report)cma-output/cma_data.json(calculation payload)cma-output/interactive_local.html(local interactive view)cma-output/gemini_canvas_prompt.md(prompt for Google tools)
3. Review and Explain Adjustments
Before final delivery:
- Show the comp set used
- Show estimated range and central estimate
- Explain assumptions and major adjustments in plain language
- Flag missing/low-quality fields that weaken confidence
Use references/valuation-guidelines.md for adjustment defaults and confidence guidance.
4. Publish Interactive Version in Gemini
Use cma-output/gemini_canvas_prompt.md as the base prompt. Then:
- Open Google AI Studio or Gemini Canvas.
- Paste the generated prompt and provide
cma_data.json. - Ask for an interactive CMA web app with:
- Comp table with sorting/filtering
- Map-ready data fields (if lat/lng present)
- Value-range visualization
- Notes panel explaining adjustments
- Request hosted/shareable output if available in the chosen Google tool.
See references/gemini-canvas-publish.md for a copy-ready checklist.
Safety Rules
- Treat outputs as broker/agent CMA support, not a licensed appraisal.
- Surface data gaps, outliers, or stale comps before presenting a valuation.
- Never invent listing attributes; mark missing values as unknown.
- Keep a clear boundary between factual listing data and model assumptions.
References
references/cma-input-schema.mdreferences/valuation-guidelines.mdreferences/gemini-canvas-publish.md
Related skills
Generate and edit Draw.io, Mermaid, and Excalidraw diagrams from natural language using a structured JSON spec.
Stores durable facts in a categorized, plain-markdown vault on disk, alongside your agent's built-in memory.
Join a video meeting as an AI bot with voice, avatar, and screenshare across four operating modes.
Find why your productivity system keeps failing, then apply the smallest fix — capacity math, bottleneck routing, durable local notes.
Site audit, content writing, and competitor analysis for organic search rankings.
More from danielfoch
Browse all skillsSend physical mail from CRM contacts using PostGrid. Use when pulling contacts from GoHighLevel (GHL) or Follow Up Boss (FUB), mapping contact/address fields...
Manage realtor tasks in GoHighLevel CRM including contact search and updates, pipeline tracking, messaging, calendar slots, and workflow enrollment via API v2.
Book real estate showing tours from emailed or pasted listing details, including extracting listing data, preparing outbound call jobs, coordinating a callin...
Command-line tool to manage contacts, tasks, notes, deals, events, and communications via the Follow Up Boss API.
Send Slybroadcast ringless voicemail campaigns from OpenClaw/LLMs using CLI or MCP, including AI voice generation (ElevenLabs or generic HTTP voice API) and...
Manage Pipedrive CRM from OpenClaw using API v1, including people, organizations, deals, leads, activities, notes, pipelines, and custom endpoint actions. Us...