ABCDEFGHIJKLMNOPQRSTUV
1
2
3
4
5
6
7
8
9
Today I'm going to help create briefs and accelerate existing blogs, in turn, skyrocketing your traffic 👉
10
11
As you can see, this technique was done with two separate blogs at the same time, it's no fluke!
12
13
First of all, a big thank you to the folks at Digital Asset Builders for laying the groundwork for this sheet, you can learn more about them here: https://www.digitalassetbuilders.io
14
15
Why this sheet is different: I've added external links and improved some of the encoding errors.
16
17
A few housekeeping items. You will need to allow a bunch of access for the sheet to work, it will need to edit this sheet, that's why it asks for those permissions
18
19
How to use this sheet:
20
21
In Sheets, go to "tools" >> click "scripts." this will open a new window, but when you go back, you will now see the menu item "Scripts" next to "Help" now follow the instructions below:
22
23
Go to GSC: https://search.google.com/search-console/
24
25
Find a blog that is ranking in the top 20 that's ranking for a valuble keyword.
26
27
Google that same keyword and use:
28
29
30
👉 Link Clump (use this to open multiple links from the SERP at the same time, just watch out for site links):

https://chrome.google.com/webstore/detail/linkclump/lfpjkncokllnfokkgpkobnkbkmelfefj?hl=en		Learn how to do this to your blogs ☝️
31
32
👉 Copy all URLs (once you've opened up all the URLs, close down the SERP and use this tool to copy all the URLs that are in your tabs):

https://chrome.google.com/webstore/detail/copy-all-urls/djdmadneanknadilpjiknlnanaolmbfk?hl=en
33
34
Once you have all the URLs copied, past them into the "🏎️ 🏁 Blog Accelerator" tab of this spreadsheet: cell A1
35
36
Now you'll want to go to the menu and click "Scripts" >> "Accelerate Blog" this will initiate a crawl of all the URLs you pasted into cell A1
37
38
From here, you want to browse through mostly the H2s and H3s of the competitors and select topics/headings that are not covered in your blog post.
39
40
Start with 3-5 new topics/headings and write 200 words of useful content under each one. Once you're done, head over the GSC and request indexing and watch it go 📈
41
42
Bonus tip #1: pepper in some of the external links they have to add value.
43
44
Bonus tip #2: plug your new content brief into Surfer's Content Editor make sure you hit all the right entities: https://get.surferseo.com/zvlddcwjxiha
45
46
Final bonus tip: see if you can add some value that's not contained in any of the blogs. This sheet will help you get the perfect bird's eye view of the SERP. Good luck!
47
48
49
Troubleshooting: if you run into problems. Refresh the sheet and run the script again. If it stops at a certain column, remove the corrsponding URL and run the script again.
50
as much as I would love to provide support, this is a free sheet and I won't be able to help everyone. You are able to edit the script as you see fit.
51
52
53
54
55
56
57
58
59
60