{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/a291813d0c644d1586c662120e875506\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/a291813d0c644d1586c662120e875506-879d1fc993d83200.gif","duration":256.064,"title":"Mappings for Historical Data Migration - Example - Google Sheets - 9 June 2026","description":"This Loom explains how to complete a Google Sheet mapping file during a migration so old PMS data lands in the correct areas of the new profile. It highlights that without assigning destinations, data like rate plans and channels can end up duplicated or only retained as past data without forward looking impact. The sheet requires mapping old member rate and complimentary rate plan IDs to the new profile, copying inventory apartment to apartment when layouts match, and filling in other mappings such as channels. Once completed, the file should be sent back to the team for loading and any follow up discussions."}