рд╕рднреА рдЯреЗрдореНрдкрд▓реЗрдЯ
SEOBeginner

SERP Position for Airtable Records

RobomotionтАв3 рдорд╛рд╣ рдкрд╣рд▓реЗ рдЕрдкрдбреЗрдЯ рдХрд┐рдпрд╛ рдЧрдпрд╛
SERP Position for Airtable Records

рдУрд╡рд░рд╡реНрдпреВ

Watches an Airtable table for keyword/domain pairs that have not been checked yet, looks up where the domain ranks for that keyword on Google, and writes the position back onto the record.

SERP Position for Airtable Records

Watches an Airtable table for keyword/domain pairs that have not been checked yet, looks up where the domain ranks for that keyword on Google, and writes the position back onto the record.

How it works

  1. Every 15 Minutes тАФ an Inject trigger repeating every 900 seconds.
  2. List Unchecked Records тАФ filterByFormula=NOT({Processed}), ten at a time.
  3. For Each Record тЖТ Build SERP Request тЖТ Get SERP Position.
  4. Build Record Update тЖТ Write Position Back тАФ sets Position, URL, Checked and Processed.

The lookup passes target through Extra Parameters, so DataForSEO filters the SERP to that domain server-side and the first item is the position тАФ which is why the depth can stay at 1.

Setup

  • DataForSEO credential тАФ API login and password from https://app.dataforseo.com/api-access.
  • Airtable credential тАФ a personal access token with access to the base.
  • A table with Keyword, Target, optional Location and Language, plus Position, URL, Checked and Processed (checkbox).

Ported from

SEO рдХреЗ рдФрд░ рдЯреЗрдореНрдкрд▓реЗрдЯ

рд╕рднреА 53 рджреЗрдЦреЗрдВ тЖТ