Property data fields for direct marketing campaigns
Specific BrightCat fields and products relevant to this vertical. Every field listed below is queryable through Snowflake SQL, MCP natural language, or available in the weekly flat-file delivery.
| Signal | Product | Field / Logic | What it tells you |
|---|---|---|---|
| Pre-mover signal | Listings | listing_status = NEW | Address-level targeting at peak intent |
| Property address | Listings | Full parsed address components | Direct mail and email campaign targeting |
| Property value | Listings | asking_price | Segmentation by household value |
| Property type | Listings | property_type, bedrooms, sqft | Household profiling for offer matching |
| Geographic targeting | Listings | postal_code, city, province | Campaign geo-targeting and regional segmentation |
| Timing signal | Listings | days_on_market | Optimal campaign window based on listing age |
Sample query
-- Direct marketing: this week's mover signals by postal code
SELECT postal_code, city, province,
COUNT(*) AS mover_signals,
ROUND(AVG(asking_price), 0) AS avg_value,
STRING_AGG(DISTINCT property_type, ', ') AS property_types
FROM BRIGHTCAT_LISTINGS.PRODUCT.listings_weekly
WHERE listing_status = 'NEW'
AND file_date = (SELECT MAX(file_date)
FROM BRIGHTCAT_LISTINGS.PRODUCT.listings_weekly)
GROUP BY postal_code, city, province
HAVING COUNT(*) >= 3
ORDER BY mover_signals DESC;Abstract example. Exact column names provided with access provisioning.