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

New Ranked Keywords to Slack

RobomotionтАв3 рдорд╛рд╣ рдкрд╣рд▓реЗ рдЕрдкрдбреЗрдЯ рдХрд┐рдпрд╛ рдЧрдпрд╛
New Ranked Keywords to Slack

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

Each week, pulls every keyword your target domains rank for, compares it against last week's snapshot, and posts whatever is new to Slack.

New Ranked Keywords to Slack

Each week, pulls every keyword your target domains rank for, compares it against last week's snapshot, and posts whatever is new to Slack.

How it works

  1. Weekly тАФ an Inject trigger repeating every 604,800 seconds.
  2. Get Previous Keywords тЖТ Index Previous Keywords тЖТ Clear Keywords Sheet тАФ the previous snapshot is read and indexed by target|keyword, then wiped. That index is the diff baseline.
  3. Get Targets / Collect Targets тАФ one entry per row of the Targets sheet: domain, location, language.
  4. For Each Target тЖТ Get Ranked Keywords тЖТ Accumulate Page тЖТ Go To Next Page тАФ a nested Label/GoTo loop pages 1000 keywords at a time until total_count is exhausted.
  5. Find New Keywords тАФ builds the full current snapshot and, separately, the rows whose key was absent from the previous one.
  6. Append Current Snapshot тЖТ Post To Slack.

The sheet always holds the present; Slack always holds the change.

Setup

  • DataForSEO credential тАФ API login and password from https://app.dataforseo.com/api-access.
  • Google credential тАФ Service Account or OAuth2 with access to the spreadsheet.
  • Slack credential тАФ a bot token with chat:write on the target channel.
  • Two sheets: Targets (Target, Location, Language) and Keywords (Target, Keyword, Date, Rank, Search Volume, URL, SERP Item Types).

First run

With an empty Keywords sheet every keyword counts as new, so the first Slack message is the whole list. That is the baseline; subsequent runs are the interesting ones.

Ported from

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

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