getSearchVolumeFromGoogle
Get the monthly search volume and the seasonality per month of a keyword directly from Google Ads Keyword Planner.
This function accepts 1000 keywords per request, so it is recommended to split the keywords in groups of 1000.
DON'T execute this function cell by cell or you'll consume your API credits very fast.
This function spends 200 credits per execution
- keywords: The list of keywords to get the search volume for
- languageCode: The language code where to do the search (i.e.
enfor English) - locationName: The location where to do the search (i.e.
United States). Check the full list of locations availables here
- skipHeader: If true, the first row of the results will be skipped
- skipMonthlySearches: If true, the monthly searches (seasonality) will be skipped
- searchEngine: The search engine to use (By default is used
Google) - searchPartners: If true, the search will be done with the partners search engines
- dateFrom: The date from where to do the search. (By default is the
last 12 months) - dateTo: The date to where to do the search. (By default is
yesterday) - sortBy: use these parameters to sort the results b:
- relevance (By default is used relevance)
- searchvolume
- competitionindex
- lowtopofpagebid
- hightopofpagebid
- Array: The list of keywords with their search volume and seasonality
getSearchVolumeFromGoogle(A1:A3, "ES", "Spain", false, true")
// keyword search volume high top of page bid low top of page bid 11/2021 10/2021 9/2021 8/2021 7/2021 6/2021 5/2021 4/2021 3/2021 2/2021 1/2021 12/2020
// seo 22200 3,08 0,63 33100 27100 27100 27100 27100 22200 18100 14800 22200 22200 27100 22200
// link building 1000 6,86 1,36 1300 1300 1300 1000 1000 1000 1000 720 880 1000 1000 1300
// seo agency 170 6,21 2,14 170 90 110 260 390 260 210 140 110 170 170 140
- Improve your keyword research using Google Sheets
- Get keyword search volume in Google Spreadsheets
- Get keyword seasonality per month in Sheets
Last modified 8mo ago