Property data fields for telecom acquisition and retention
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 | Household about to change address — acquire before competitors |
| Lifecycle state | Listings | listing_status transitions | Track progression from listed to sold to moved |
| Property location | Listings | postal_code, city, province, lat/long | Geographic targeting for service area campaigns |
| Property type | Listings | property_type, bedrooms, sqft | Household segmentation for product matching |
| Price bracket | Listings | asking_price | Value segmentation for premium vs standard offers |
| Days on market | Listings | days_on_market | Timing signal — shorter DOM = faster move |
Sample query
-- Telecom acquisition: new listings in service area this week
SELECT postal_code, city, province,
COUNT(*) AS new_listings,
ROUND(AVG(asking_price), 0) AS avg_price,
ROUND(AVG(days_on_market), 0) AS avg_dom
FROM BRIGHTCAT_LISTINGS.PRODUCT.listings_weekly
WHERE listing_status = 'NEW'
AND province IN ('ON', 'BC', 'AB')
AND file_date = (SELECT MAX(file_date)
FROM BRIGHTCAT_LISTINGS.PRODUCT.listings_weekly)
GROUP BY postal_code, city, province
ORDER BY new_listings DESC
LIMIT 50;Abstract example. Exact column names provided with access provisioning.