getAllPagesFromSERP

Overview

Get all the all pages (organic & paid ones) ranking on the SERP for a given keyword

Credits cost per execution

This function spends 10 credits per execution

Video example

Arguments

  • keyword: The keyword to get the position
  • languageCode: The language code where to do the search (i.e. en for English)
  • locationName: The location where to do the search (i.e. United States).
    • Check the full list of locations available downloading the CSV depending on the Search Engine

Optional arguments

  • skipHeader: If true, the first row of the results will be skipped
  • searchEngine: The search engine to use (By default is used Google)
  • device: The device to use (By default is used mobile)
  • depth: The depth of the SERP to search (By default is 100)
  • seDomain: The domain of the search engine to use (By default is used google.com)

Expected output

  • Array: The absolute position, the relative to the all group and the URLs ranking for that keyword in the search engine

Text example

getAllPagesFromSERP("seo", "es", "Spain", true, "google", "mobile", 10, "google.com")
// all, absolute, url, type
// 1 1 https://neoattack.com/agencia-de-seo/ paid
// 2 2 https://www.beedigital.es/analisis-seo-gratuito/ paid
// 3 3 https://www.soloseoysem.es/ paid
// 4 4 https://posicionamientoseo.guru/ paid
// 1 9 https://agenciaseo.eu/ organic
// 2 10 https://rodanet.com/posicionamiento-seo/ organic
// 3 11 https://www.dobuss.es/agencia-seo/ organic
// 4 12 https://marketing4ecommerce.net/mejores-agencias-seo-espana-top/amp/ organic
// 5 14 https://promentconsulting.com/agencia-seo-barcelona-2/ organic
// 6 15 https://www.softalian.com/ organic
// 7 16 https://www.sedigital.es/ organic
// 8 17 https://www.latevaweb.com/posicionamiento-web-seo-barcelona organic
// 9 18 https://top-seo.es/ organic
// 10 19 https://www.estudio34.com/ organic

Use cases

  • Benchmark of who's ranking for specific queries & who's paying to stay there
  • Check competition on SERPs for a given query
  • Assess keyword difficulty to rank
  • Fix the migration of websites using sheets: find your old URLs and match them with your new ones
  • Check if your URL is ranking for a specific query in Sheets
  • Check the position of a keyword in Google Sheets
  • Build your own keyword tracker in Google Sheets