From Matthew

• Essentially just trying to pull move in counts both by facility and by marketing source for a specific time period
• not urgent, move ins report from StorEdge gets us what we need, more so thinking in future for like RCC as we link it up with warehouse data i think this will be important to get a breakdown on what move ins come from organic marketing, cpc marketing, sparefoot, etc.
• But i would like to know how to pull it separately as well for some scorecards i'm thinking about for my team for the future

--SELECT * FROM RENTALS LIMIT 100
--SELECT * FROM LEADS LIMIT 100  --THIS IS WHERE THE MARKETING SOURCE LIVES
--SELECT * FROM RATE_ACTIONS LIMIT 100

--Matthew's Query
SELECT facilities.name, rentals.start_time::DATE, rentals.source
FROM rentals
LEFT JOIN units on units.id = rentals.unit_id
LEFT JOIN facilities on facilities.id = units.facility_id
where start_time::DATE >= '2026-08-26'
and start_time::DATE <= '2026-08-30'
and transfer = 'false'

--=============================================================================
--NEED ORIGINAL MARKETING SOURCE (LEADS TABLE), ORIGINAL MARKETING SOURCE DATE (LEADS TABLE), CURRENT MARKETING SOURCE (LEAD EVENTS?), MOVE IN DATE (RATE ACTIONS), MOVE IN PLATFORM (RATE ACTIONS), FACILITY (LEADS) 

/*
SELECT * FROM LEADS LIMIT 100  --THIS IS WHERE THE MARKETING SOURCE LIVES
SELECT * FROM LEAD_EVENTS
SELECT * FROM RATE_ACTIONS LIMIT 100
*/

SELECT
FROM RATE_ACTIONS
JOIN LEADS
JOIN LEAD_EVENTS
JOIN LEAD_EVENT_CHANGES

select * from analytics.facility_performance