07-25-2019, 03:38 AM
I was wondering whether it is possible to do this in Scrapebox? And if not, can a portion of this process be simplified with the help of Automator plugin?
Step 1: Scrape competition for a given keyword (eg. Goat cheese, Cow Cheese). By competition, I mean the number of search results.
Step 2: Scrape competition for allinanchor:keyword (eg. allinanchor: Goat cheese, allinanchor:Cow Cheese). By competition, I mean the number of search results.
Step 3: Take the results of Step 1 and divide it by Step 2.
Step 4: For all page 1 results in Google for a given keyword, return the list of them accompanied by their DA, PA and number of backlinks
Step 5: Export Step 3 and Step 4 to Excel for easy viewing
Ideally, the results will look like this:
Goat Cheese (Show results of Step 3)
Google SERP website 1 (DA / PA / number of backlinks)
Google SERP website 2 (DA / PA / number of backlinks)
Google SERP website 3 (DA / PA / number of backlinks)
Google SERP website 4 (DA / PA / number of backlinks)
Google SERP website 5 (DA / PA / number of backlinks)
Cow Cheese (Show results of Step 3)
Google SERP website 1 (DA / PA / number of backlinks)
Google SERP website 2 (DA / PA / number of backlinks)
Google SERP website 3 (DA / PA / number of backlinks)
Google SERP website 4 (DA / PA / number of backlinks)
Google SERP website 5 (DA / PA / number of backlinks)
My thoughts:
Step A: Buy Scrapebox Automator and Metrics Checker
Step B: Enter keywords into Scrapebox Google Competition Finder for the Keyword
Step C: Enter allinanchor: keyword into Scrapebox Google Competition Finder for the Keyword
Step D: Not sure how to proceed after this.
Can someone please help me out?
Step 1: Scrape competition for a given keyword (eg. Goat cheese, Cow Cheese). By competition, I mean the number of search results.
Step 2: Scrape competition for allinanchor:keyword (eg. allinanchor: Goat cheese, allinanchor:Cow Cheese). By competition, I mean the number of search results.
Step 3: Take the results of Step 1 and divide it by Step 2.
Step 4: For all page 1 results in Google for a given keyword, return the list of them accompanied by their DA, PA and number of backlinks
Step 5: Export Step 3 and Step 4 to Excel for easy viewing
Ideally, the results will look like this:
Goat Cheese (Show results of Step 3)
Google SERP website 1 (DA / PA / number of backlinks)
Google SERP website 2 (DA / PA / number of backlinks)
Google SERP website 3 (DA / PA / number of backlinks)
Google SERP website 4 (DA / PA / number of backlinks)
Google SERP website 5 (DA / PA / number of backlinks)
Cow Cheese (Show results of Step 3)
Google SERP website 1 (DA / PA / number of backlinks)
Google SERP website 2 (DA / PA / number of backlinks)
Google SERP website 3 (DA / PA / number of backlinks)
Google SERP website 4 (DA / PA / number of backlinks)
Google SERP website 5 (DA / PA / number of backlinks)
My thoughts:
Step A: Buy Scrapebox Automator and Metrics Checker
Step B: Enter keywords into Scrapebox Google Competition Finder for the Keyword
Step C: Enter allinanchor: keyword into Scrapebox Google Competition Finder for the Keyword
Step D: Not sure how to proceed after this.
Can someone please help me out?