Google Analytics - Website Ranking Analysis

I'm seeking an expert in Google Analytics to analyze the trends of my website's ranking over a specific time period.

For 7 years an Agency has managed the Car Care company website Search Engine Optimisation / Page Rankings

The Project is

Identify www.carcare.net.au Search Engine page Rankings for both
Organic Search
Paid Search
For 12 locations in Australia
For period Jan 2018 - May2024

Melbourne - Victoria
Geelong - Victoria
Dandenong - Victoria
Sydney - New South Wales
Newcastle - New South Wales
Wollongong - New South Wales
Canberra - Australian Capital Territory
Brisbane - Queensland
Gold Coast - Queensland
Adelaide - South Australia
Perth - Western Australia
Hobart - Tasmania
Darwin

1 - Enter Page Rank for each Location into a Template Google Sheet in 6 Month increments

2 - Create a Trend Line Graph for each location

2024 Jan May
2023 Jan Jul
2022 Jan Jul
2021 Jan Jul
2020 Jan Jul
2019 Jan Jul
2018 Jan Jul

Google Sheet link will be provided


Key Requirements:
- Analyze website ranking trends from 2018 to 2024.
- Provide insights and recommendations based on the analysis.

Ideal Candidate:
- Proficient in using Google Analytics for in-depth website analysis.
- Experience in tracking website ranking trends.
- Ability to derive actionable insights from data.
- Strong analytical and problem-solving skills.