I’m looking to generate a comprehensive report consolidating data from the Keyword Planner within Google Ads across multiple accounts. Specifically, the report should focus on search volumes for specific keywords.

For context, I work within a central team that manages ten distinct brands, each with its own Google Ads account. I have access to all these accounts and aim to create a process to log into each account, input predefined keywords into the search bar, and retrieve the search volume data. The goal is to compile this information into a consolidated table, presenting the search volumes for each keyword across all ten brands.