Lead Funnel & Sources
Big Value
error
Binder Error: No function matches the given name and argument types 'date_trunc(STRING_LITERAL, DOUBLE)'. You might need to add explicit type casts.
Candidate functions:
date_trunc(VARCHAR, DATE) -> TIMESTAMP
date_trunc(VARCHAR, INTERVAL) -> INTERVAL
date_trunc(VARCHAR, TIMESTAMP) -> TIMESTAMP
date_trunc(VARCHAR, TIMESTAMP WITH TIME ZONE) -> TIMESTAMP WITH TIME ZONE
LINE 26: where date_trunc('month', snapshot_date)::date = (
^
Big Value
error
Binder Error: No function matches the given name and argument types 'date_trunc(STRING_LITERAL, DOUBLE)'. You might need to add explicit type casts.
Candidate functions:
date_trunc(VARCHAR, DATE) -> TIMESTAMP
date_trunc(VARCHAR, INTERVAL) -> INTERVAL
date_trunc(VARCHAR, TIMESTAMP) -> TIMESTAMP
date_trunc(VARCHAR, TIMESTAMP WITH TIME ZONE) -> TIMESTAMP WITH TIME ZONE
LINE 26: where date_trunc('month', snapshot_date)::date = (
^
Big Value
error
Binder Error: No function matches the given name and argument types 'date_trunc(STRING_LITERAL, DOUBLE)'. You might need to add explicit type casts.
Candidate functions:
date_trunc(VARCHAR, DATE) -> TIMESTAMP
date_trunc(VARCHAR, INTERVAL) -> INTERVAL
date_trunc(VARCHAR, TIMESTAMP) -> TIMESTAMP
date_trunc(VARCHAR, TIMESTAMP WITH TIME ZONE) -> TIMESTAMP WITH TIME ZONE
LINE 26: where date_trunc('month', snapshot_date)::date = (
^
Big Value
error
Binder Error: No function matches the given name and argument types 'date_trunc(STRING_LITERAL, DOUBLE)'. You might need to add explicit type casts.
Candidate functions:
date_trunc(VARCHAR, DATE) -> TIMESTAMP
date_trunc(VARCHAR, INTERVAL) -> INTERVAL
date_trunc(VARCHAR, TIMESTAMP) -> TIMESTAMP
date_trunc(VARCHAR, TIMESTAMP WITH TIME ZONE) -> TIMESTAMP WITH TIME ZONE
LINE 26: where date_trunc('month', snapshot_date)::date = (
^
Big Value
error
Binder Error: No function matches the given name and argument types 'date_trunc(STRING_LITERAL, DOUBLE)'. You might need to add explicit type casts.
Candidate functions:
date_trunc(VARCHAR, DATE) -> TIMESTAMP
date_trunc(VARCHAR, INTERVAL) -> INTERVAL
date_trunc(VARCHAR, TIMESTAMP) -> TIMESTAMP
date_trunc(VARCHAR, TIMESTAMP WITH TIME ZONE) -> TIMESTAMP WITH TIME ZONE
LINE 26: where date_trunc('month', snapshot_date)::date = (
^
Lead Conversion Funnel
How effectively are prospects converting to leases? Each column shows the cumulative count of new-lease leads that reached that stage. Only new-lease prospects are counted here — renewals, transfers, and lease modifications are excluded.
Data Table
Dataset is empty - query ran successfully, but no data was returned from the database
Where in the pipeline are prospects dropping off? Large drop-off percentages highlight the stage that needs the most attention.
Big Value
error
Dataset is empty
Big Value
error
Dataset is empty
Lead Sources
Where are leads coming from? ILS = Internet Listing Services (Apartments.com, Zillow, etc.). Understanding channel mix helps allocate marketing spend.
Bar Chart
Dataset is empty - query ran successfully, but no data was returned from the database
Lead Status Distribution
What's the current state of the new-lease pipeline? This shows all new-lease leads by their current funnel stage. "Leased" means a lease was approved. "Cancelled" and "Archived" represent drop-offs.
Bar Chart
Dataset is empty - query ran successfully, but no data was returned from the database