Hello Alyx Bond,
Thanks for your questions:
Storage tier depends on your access requirements: If you need your data accessed frequently, use hot tier, cold for infrequent (least 30 days) and archive for rarely accessed (180 days)
See: https://learn.microsoft.com/en-us/azure/storage/blobs/access-tiers-overview
For recommended data retention practices: https://learn.microsoft.com/en-us/azure/well-architected/cost-optimization/optimize-data-costs
With automation, you can use Azure Automation or PowerShell scripts.
You can mark it 'Accept Answer' and 'Upvote' if this helped you
Regards,
Abiola