📊 SERP AnalysisPro Plan

GET_SEARCH_VOLUME_FROM_GOOGLE

Get Google Ads keyword data: search volume, competition, and CPC.

Formula Signature
=GET_SEARCH_VOLUME_FROM_GOOGLE(keywords, [location], [language])

Returns: 2D array with columns: Keyword, Search Volume, Competition, CPC

Overview

GET_SEARCH_VOLUME_FROM_GOOGLE retrieves keyword metrics directly from Google's Keyword Planner data, including monthly search volume, competition level, and cost-per-click (CPC) estimates. This is the same data that advertisers use to plan Google Ads campaigns, now available directly in your Google Sheets without needing a Google Ads account.

Parameters

ParameterTypeRequiredDescription
keywordsstring or rangeYesA single keyword string or a range of cells containing keywords to look up.
locationstringNo (United States)The geographic location for volume data.
languagestringNo (English)The language for keyword data.

Examples

1

Check volume for a single keyword

Get search volume, competition, and CPC for a single keyword.

fx
=GET_SEARCH_VOLUME_FROM_GOOGLE("project management software")

Output

KeywordSearch VolumeCompetitionCPC
project management software33100High$12.50
2

Bulk keyword research from a range

Pass a range of cells containing multiple keywords to get data for all of them in one call.

fx
=GET_SEARCH_VOLUME_FROM_GOOGLE(A2:A10)

Input

email marketing
email marketing software
email marketing tools
best email marketing platform
email automation

Output

KeywordSearch VolumeCompetitionCPC
email marketing40500High$8.20
email marketing software12100High$15.30
email marketing tools8100High$11.75
best email marketing platform2900High$14.00
email automation6600Medium$9.50
3

Get volume for a specific country

Check search volume for an auto insurance keyword in the Mexican market.

fx
=GET_SEARCH_VOLUME_FROM_GOOGLE("seguros de auto", "Mexico", "Spanish")

Output

KeywordSearch VolumeCompetitionCPC
seguros de auto49500High$2.80
4

Research low-competition long-tail keywords

Analyze long-tail keyword variations to find opportunities with lower competition.

fx
=GET_SEARCH_VOLUME_FROM_GOOGLE(A2:A6)

Input

how to start a podcast
how to start a podcast on spotify
how to start a podcast for free
podcast equipment for beginners
podcast hosting platforms

Output

KeywordSearch VolumeCompetitionCPC
how to start a podcast27100Medium$2.10
how to start a podcast on spotify8100Low$1.50
how to start a podcast for free4400Low$1.80
podcast equipment for beginners6600Medium$3.20
podcast hosting platforms3600Medium$5.40
5

Compare keyword volumes across markets

Check the search demand for fintech keywords in the Indian market.

fx
=GET_SEARCH_VOLUME_FROM_GOOGLE("online banking", "India", "English")

Output

KeywordSearch VolumeCompetitionCPC
online banking135000High$0.85

Use Cases

Content Marketing

Keyword research and content planning

Analyze search volumes for hundreds of potential blog post topics. Prioritize content creation based on search demand, competition level, and the commercial value indicated by CPC. Build a data-driven editorial calendar.

Digital Advertising

PPC campaign planning and budgeting

Estimate campaign costs by multiplying search volume by CPC for target keywords. Identify high-volume, low-CPC keywords for efficient ad spend. Compare keyword costs across different markets to optimize budget allocation.

Business Strategy / VC

Market sizing and demand analysis

Use search volume as a proxy for market demand. Analyze total search volume across a keyword cluster to estimate market size. Compare volumes across countries to identify the largest addressable markets for a product category.

SEO Agency

SEO opportunity scoring

Create keyword opportunity scores by combining search volume with competition data. High-volume, low-competition keywords represent the best opportunities. Score and rank hundreds of keywords to prioritize SEO efforts.

Product Management

Product naming and positioning research

Compare search volumes for different ways people describe your product category. Choose product naming and messaging that aligns with how your target audience actually searches.

E-commerce / Retail

Seasonal trend analysis

Track search volumes for seasonal keywords across different months. Plan inventory, marketing campaigns, and content releases around periods of peak search demand.

Pro Tips

TIP

Always pass keywords as a range (e.g., A2:A100) rather than individual cells with separate formulas. This uses a single SERP credit for all keywords instead of one credit per keyword, saving you hundreds of credits.

TIP

Sort results by Search Volume descending and then filter by Competition = "Low" to quickly find high-potential keyword opportunities that are easier to rank for.

TIP

Calculate an "opportunity score" by dividing Search Volume by CPC. Keywords with high volume and low CPC often represent underserved niches where you can capture valuable traffic efficiently.

TIP

Combine with AI_KEYWORDS or SUGGEST_QUERIES to first generate keyword ideas, then pass them to GET_SEARCH_VOLUME_FROM_GOOGLE to validate which ideas have actual search demand.

TIP

When comparing markets, run the same keyword set for different locations. This reveals which markets have the highest demand for your product or service category.

Search volume represents the average monthly number of searches for a keyword on Google. This metric is essential for keyword research, content prioritization, and market sizing. High-volume keywords indicate strong demand, while low-volume keywords may represent niche opportunities with less competition.

The competition metric shows how competitive the paid advertising landscape is for each keyword, rated as Low, Medium, or High. While this reflects ad competition rather than organic SEO difficulty, it correlates with commercial intent. Keywords with high competition tend to be more commercially valuable and harder to rank for organically as well.

CPC (cost-per-click) shows the estimated cost an advertiser would pay for a click on a Google Ad for that keyword. This metric is useful even for SEO-focused teams because it indicates the monetary value of ranking organically. A keyword with a $50 CPC represents significant value if you can capture that traffic through organic rankings instead of paid ads.

One of the most powerful features of this function is its ability to accept multiple keywords at once. You can pass a range of cells containing keywords, and the function will return data for all of them in a single call using just one SERP credit. This makes it extremely efficient for bulk keyword research, allowing you to analyze hundreds of keywords quickly.

The location and language parameters let you get volume data for specific markets. Search volume varies dramatically by country, so specifying the correct market is crucial for accurate data.

Common Errors

#REF! - Spill error

Cause: The output array cannot expand because adjacent cells contain data.

Fix: Clear the cells below and to the right of the formula. For N keywords, you need N+1 rows (header + one row per keyword) and 4 columns (Keyword, Search Volume, Competition, CPC).

#ERROR - SERP credit limit reached

Cause: Your monthly SERP credit balance has been exhausted.

Fix: Upgrade to Business for 10,000 monthly credits. Since bulk lookups use only one credit, this function is rarely the cause of credit exhaustion. Check if other SERP functions are consuming your credits.

#ERROR - Invalid keyword range

Cause: The range reference contains empty cells or non-text values mixed with keywords.

Fix: Ensure the range contains only text values (keywords) without empty rows or numeric values. Remove any blank cells from the middle of the range, or use a filtered range that excludes blanks.

Frequently Asked Questions

You can pass a range of cells containing up to several hundred keywords in a single call. The function processes all keywords in the range and returns data for each one. This bulk capability uses only one SERP credit regardless of the number of keywords, making it very efficient for large-scale keyword research.

The data comes from Google's Keyword Planner, the same source that Google Ads advertisers use to plan campaigns. This ensures the search volume, competition, and CPC figures are as accurate as Google's own data.

The function returns Google's estimated average monthly search volume. Google provides rounded figures (e.g., 1000, 1300, 1600, 2400, 2900) rather than precise numbers. For most use cases, these estimates are sufficiently accurate for keyword comparison and prioritization.

Competition (Low, Medium, or High) reflects how many advertisers are bidding on the keyword in Google Ads. It does not directly measure SEO difficulty. However, high advertising competition often correlates with keywords that are also competitive in organic search because they have clear commercial value.

CPC represents the estimated cost-per-click for a Google Ads top-of-page bid. It is the approximate amount an advertiser would need to bid to appear at the top of paid results. This value fluctuates based on auction dynamics but provides a useful benchmark for keyword value.

GET_SEARCH_VOLUME_FROM_GOOGLE returns current average monthly volumes. It does not provide historical trend data or month-by-month breakdowns. For trend analysis, you would need to log the data periodically in your spreadsheet or use complementary tools.

No. Whether you pass a single keyword or a range of 200 keywords, the function uses just one SERP credit. This makes bulk lookups extremely cost-effective compared to checking keywords one at a time.

Keywords with very low or no measurable search volume will return a search volume of 0. This does not necessarily mean nobody searches for the term. It may mean the volume is too low for Google to provide a reliable estimate (typically under 10 searches per month).

Related Functions

Start using GET_SEARCH_VOLUME_FROM_GOOGLE today

Install Unlimited Sheets to get GET_SEARCH_VOLUME_FROM_GOOGLE and 41 other powerful functions in Google Sheets.