Backlink Workflow

Backlink Workflow




- Copy the first competitors for a Specific page


2. Go to Semrush and select Backlinks Analytics


- Paste the link you copied from the doc sheet and select analyze


3. Navigate to Referring domains


- Add the Filters
- Active, Follow and autority score Range 30-100 and apply


- Select Export


4. Then navigate to Backlinks


- Add the Filters
- Active, Follow and Links per ref. domain and apply


- Select Export


5. You should have 2 sets of excel files for each competitor URL


6. Combine files

- Combine All "backlinks" files
- Combine All "refdomain" files


7. Open combined "Backlinks"  files 
- Move "Source url" column to Column A


- Move data to "Backlinks" sheet

8. Merge the ref domains files of the competitors into one and then Merge the backlink files of the competitors into one.

- Open template file "Backlink Scrub & upload" -> Template in Google Drive


- Add Manually
Client Target URL -  EX. "RTPWebsiteSolution.com"
Identifier2 - Ex. "RTP Website Solution"

- Add from RAW SEMRUSH file to template file "Backlink Scrub & upload" 

AFTER ALL FILES ADDED
- Activate table & Click Remove Duplicates


- Click on "Unselect All", select "Domain" and press Ok


- Sort A-> Z
- Unselect values "us" & "blank" and press ok. 


- Delete remaining records


9. Copy all of the contents of the de-duplicated Ref Domain file and go into the backlinks doc sheet
- Paste all the contents into the “Master Sheet”.
Please Note: The Master Sheet is pre-configured to find any duplicates domain we might have after adding the contents of the files to let us know what links we already have verified and don’t have to work on it again.
Please Note: In The Master Sheet the duplicates will be highlighted
- Use CRT + SHT + V

Filter 
- Start Date - TODAY
- Identifier - Select identifier
- Domain - Filter by color "Yellow"
  

- Copy and paste back to template file "Backlink Scrub & upload" sheet "Referring Domains - Data Upload"


- Sort by Source Title A -> Z


- Delete non english and #N/A
- DELETE WHOLE ROW
 

- Save file as "Excel Workbook" & "CSV" Backlink - "Identifier"- "todays date" (ex. Backlink - RTP Website Solution - 12.28.22)


REPEAT FOR ALL FILES

- We are going to repeat this process from 1-8 every time we are working on a new page.
Please Note: We will only work on unique links and avoid duplicated links

10. Navigate to Zoho projects, backlinks


- Select other actions and from the dropdown select Import tasks


11. Attach CSV file, Select CSV option and select Import


- Most fields should AUTOMATICALLY assign. 

- The RED text below have to done MANUALLY


TASK NAME
BACKLINK DOMAIN
TASK ID
None
PARENT TASK ID
None
PARENT TASK NAME
None
PREDECESSORS
None
TASK COMMENT
None
TASK DESCRIPTION
None
TASK LIST ID
None
TASK LIST NAME
Identifier
ASSOCIATED TEAM
None
TASK OWNER
None
TAGS
None
CREATED BY
None
START DATE
Start Date
DUE DATE DURATION
None
% COMPLETED
None
PRIORITY
None
BILLING TYPE
None
CUSTOM STATUS
None
WORK HOURS PER OWNER
None
WORK HOURS UNIT
None
FOLLOW
None
ANCHOR TEXT
ANCHOR TEXT
FIRST SEEN
First seen
COST
None
PAGE SCORE
PAGE SCORE
NEED ACCOUNT?
None
LOST LINK
Lost link
AVAILBLE FOR?
None
CONTACT - EMAIL
None
CATEGORY
None
BACKLINK TYPE
None
CLIENT TARGET URL
Client Target URL
SITEWIDE
Sitewide
AMOUNT
None
IMAGE
Image
LAST SEEN
Last seen
CLIENT URL
None
CONTACT SUBMITTED VIA
None
BACKLINK DOMAIN
BACKLINK DOMAIN
TEXT
Text
DOMAIN SCORE
Domain ascore
FORM
Form
RELATED PROJECT
Identifier
FRAME
Frame
UGC
Ugc
IDENTIFIER
Identifier
SOURCE URL
Source URL
COMP TARGET URL (SOURCE URL)
Comp Target Url (Source URL)
BACKLINK COUNT (DOMAIN)
BACKLINK COUNT (DOMAIN)
SPONSORED
Sponsored
MULTIPLE LISTINGS?
None
CONTACT - PHONE
None
ASSIGNEE
None
SOURCE TITLE
Source title
COMP TARGET URL (SOURCE URL)
Comp Target Url (Source URL)
NO FOLLOW
NO FOLLOW
NEW LINK
New link
COUNTRY (DOMAIN)
COUNTRY (DOMAIN)
EXTERNAL LINKS
External links
COMPLETION DATE
None
MILESTONE NAME
None
MILESTONE START DATE
None
MILESTONE END DATE
None


Please Note: When selecting the Start date at the end of the import, look for the select date format and select the date that mentions the month. If the month does not match the current month please change your date formation inside the file you are trying to upload.
- Select Continue after mapping is completed


- Wait 5 mins for the file to get imported

12. This is how the view will look like


Please note: When you import a large dataset into Zoho, it imports it into chunks. All tasks are not under one task list.

- Move tasks IF current task list already exists.
 

Please Note : Repeat this process until all the tasks from different chunks are under one.
- Some info will get pre-populated from the excel


Please Note: The start date will be from the time when the Files were uploaded in Zoho, and don't touch or change the Start date 

Follow the steps for Verification onwards 


    • Related Articles

    • Backlink Verification Process - Directory Listings

      1. Start the verification process - Select the Domain  - Assign yourself as the owner and start the timer - Update the status to in progress Please Note: Start a timer for each backlink task you are working on after you are done with the previous one ...

    • Backlink Verification Process - Blogs (Guest Post/Sponsored Link/Affiliation/ News Portal)

      1. Start the verification process - Select the Domain  - Assign yourself as the owner and start the timer - Update the status to in progress Please Note: Start a timer for each backlink task you are working on after you are done with the previous one ...

    • Semrush Verification

      1. Navigate to Semrush again and select Link building tool - select prospect & upload - Select Add - After the link gets added in Prospects - From Prospects update the status to In Progress - From the progress window, select the tick mark and Monitor ...