You are tasked with presenting a cost and estimated budget analysis to investors, requiring an estimation of cloud costs for the next six months. This involves analyzing Google Cloud Platform service costs across multiple projects and creating projections by service type, both daily and monthly. Your team is proficient in standard query syntax. What is the best approach to achieve this?