рд╕рднреА рдЯреЗрдореНрдкрд▓реЗрдЯ
SEOIntermediate
Keyword Cluster by URL
RobomotionтАв3 рдорд╛рд╣ рдкрд╣рд▓реЗ рдЕрдкрдбреЗрдЯ рдХрд┐рдпрд╛ рдЧрдпрд╛

рдУрд╡рд░рд╡реНрдпреВ
Every two weeks, takes a list of URLs from an input sheet and, for each one, pulls the full set of keywords that URL ranks for into its own tab of an output spreadsheet - keyword, position, volume, difficulty, CPC, competition, intent, SERP feature type and estimated traffic.
Keyword Cluster by URL
Every two weeks, takes a list of URLs from an input sheet and, for each one, pulls the full set of keywords that URL ranks for into its own tab of an output spreadsheet - keyword, position, volume, difficulty, CPC, competition, intent, SERP feature type and estimated traffic.
How it works
- Every Two Weeks тАФ an Inject trigger repeating every 1,209,600 seconds.
- Get URLs тЖТ Collect Active URLs тАФ rows whose
Activecolumn is falsy (blank, FALSE, 0, no) are parked without being deleted. - For Each URL тЖТ Sheet Name For URL тАФ the URL is flattened into a legal tab name (Sheets forbids
: \ / ? * [ ]and caps at 100 characters). - Add Tab For URL тАФ set to continue on error, so a tab left over from a previous run is reused rather than failing the run.
- Get Ranked Keywords тЖТ Build Cluster Table тЖТ Write Cluster.
The set of keywords one URL ranks for is the cluster. Reading it back tells you what Google thinks the page is about, which is usually more useful than what you intended it to be about.
Setup
- DataForSEO credential тАФ API login and password from https://app.dataforseo.com/api-access.
- Google credential тАФ Service Account or OAuth2 able to create sheet tabs in the output spreadsheet.
- An input sheet with
TargetandActivecolumns.
Ported from
- Collect keyword cluster by URL in Google Sheets with DataForSEO тАФ DataForSEO template
SEO рдХреЗ рдФрд░ рдЯреЗрдореНрдкрд▓реЗрдЯ
рд╕рднреА 53 рджреЗрдЦреЗрдВ тЖТ- ActiveCampaign Lead Business DataEvery 15 minutes, takes the leads ActiveCampaign has touched most recently, turns each website into a bare domain, looks the company up in the Google Business listings database, and writes the name, description, categories, address, rating and price level back onto the ActiveCampaign record.
- ActiveCampaign Lead Traffic StatsEvery 15 minutes, takes the leads ActiveCampaign has touched most recently, turns each website into a bare domain, estimates how much organic search traffic that domain gets, and writes the numbers back onto the ActiveCampaign record.
- Add Backlinks to Google SheetsPulls the live backlinks pointing at a domain every 15 minutes and appends them to a Google Sheet, one row per link, with the source page, anchor text, follow status, ranks and first/last seen dates.
- AI Mode References to SheetsTracks which websites Google's AI Mode cites when it answers a question. Every 7 days it queries the AI Mode SERP for a keyword, flattens the references of every answer block, de-duplicates them by URL and appends them to a Google Sheet.
- AI Overview Citations to SheetsTracks which websites Google's AI Overview cites for a keyword. Every 7 days it pulls the Google SERP with the AI Overview block loaded, collects every source the answer references, de-duplicates them by URL and appends them to a Google Sheet.
- AI Overview Keyword Wins by EmailEach week, finds the keywords where your domains are newly cited inside Google's AI Overview, saves the full picture to Google Sheets, and emails the new placements.