To get more data you can use the API, but I use another method. To get all the search queries, let's get the Google Sheets add-on called Search Analytics for Sheets. We connect it to our Google Search Console account and we can request all the queries for the last 12 months.
Better: instead of 999 I retrieved 18,295 search queries. We download the data into an Excel file. Since we want the current ranking, we need to fetch a second set of data from Google Search Console, where we fetch the same data as before.
The new ranking dataset contains 16,727 of the 18,295 keywords detected in the first Google Search Console dataset. Not bad. Now we have all the necessary data.
Before moving on to phase 2, I would self employed phone number list like to briefly summarize what happened: A. We got the last 12 months of Google Ads search query data. In this example, we identified 2,000 queries that generated revenue for us during the period.
B. We retrieved the full list of search queries we rank for in organic search through Google Search Console. In this case +18K search queries. C. We got the current ranking for +16K keywords via Google Search Console.
The only difference is that the date range is today
-
- Posts: 158
- Joined: Sat Dec 21, 2024 3:21 am