If have a 1000 backlinks, 100 for each client. How to manage this easilyWhat do you mean exactly with "managing backlinks"
Traxr if you want to know which links are indexing (for example, although you can do this with other free tools like greenlane)
Which other aspects are you thinking on?
But what I don't understand what do you want to manage?If have a 1000 backlinks, 100 for each client. How to manage this easily
if they er still up, indexed, easily attach each backlink to the proper clientBut what I don't understand what do you want to manage?
What to send a list to each customer of the backlinks you created?
Elaborate more.
if they er still up, indexed, easily attach each backlink to the proper client
How do I check on a weekly base if they are still up with a spreadsheet?Sounds like a simple spreadsheet?
Consider that most a agencies use Ahrefs that gives all this functionality but is not cheapHow do I check on a weekly base if they are still up with a spreadsheet?
function isIndexed(page,ignoreCase) {
var urls=[],RETRIES=5;
if(!page)return;
if(page.indexOf("://")!==-1)page=page.split("://")[1].trim();
var url='https://www.google.com/search?q='+encodeURIComponent(page)+'&fp=1&dpr=2&sns=1&pf=p&tch=1&filter=0';
if(page.slice(-1)=="/")page=page.slice(0,-1);
try {
var serp=UrlFetchApp.fetch(url,{muteHttpExceptions:true,method:"GET",followRedirects:true});
var result=serp.getContentText().split('/*""*/');
var searchResults,serpResults,isIndexed=false;
for(var i=2;i<result.length-1;i++) { //loop through where result might be in various permutations of SERP
searchResults=JSON.parse(result[i]);
serpResults=searchResults.d.split('<h3 class="r"><a href="/url?q=');
isIndexed=findIndexedURL(serpResults, page, ignoreCase);
if(isIndexed) return "Yes";
}
return "No";
} catch(e) { return "No"; }
}
function findIndexedURL(serpResults, page, ignoreCase) {
for(var i=1;i<serpResults.length;i++) {
var resultURL=decodeURIComponent(serpResults[i].split('&sa=U')[0]);
if(resultURL.indexOf("://")!==-1)resultURL=resultURL.split("://")[1];
if(resultURL.slice(-1)=="/")resultURL=resultURL.slice(0,-1);
//*debug*/urls.push(resultURL);
if(resultURL==page) return true;
}
//*debug*/return urls;
return false;
}
In this case you would need some script designed which will be hosted with you and will do that task.How do I check on a weekly base if they are still up with a spreadsheet?
How do I check on a weekly base if they are still up with a spreadsheet?
How do I do this in spreadsheet?Consider that most a agencies use Ahrefs that gives all this functionality but is not cheap
If you want to do it with excel, there is SEOTools for Excel
Also if you know how to use Google Spreadsheets you can add and use this function to check this in Google Scripts
JavaScript:function isIndexed(page,ignoreCase) { var urls=[],RETRIES=5; if(!page)return; if(page.indexOf("://")!==-1)page=page.split("://")[1].trim(); var url='https://www.google.com/search?q='+encodeURIComponent(page)+'&fp=1&dpr=2&sns=1&pf=p&tch=1&filter=0'; if(page.slice(-1)=="/")page=page.slice(0,-1); try { var serp=UrlFetchApp.fetch(url,{muteHttpExceptions:true,method:"GET",followRedirects:true}); var result=serp.getContentText().split('/*""*/'); var searchResults,serpResults,isIndexed=false; for(var i=2;i<result.length-1;i++) { //loop through where result might be in various permutations of SERP searchResults=JSON.parse(result[i]); serpResults=searchResults.d.split('<h3 class="r"><a href="/url?q='); isIndexed=findIndexedURL(serpResults, page, ignoreCase); if(isIndexed) return "Yes"; } return "No"; } catch(e) { return "No"; } } function findIndexedURL(serpResults, page, ignoreCase) { for(var i=1;i<serpResults.length;i++) { var resultURL=decodeURIComponent(serpResults[i].split('&sa=U')[0]); if(resultURL.indexOf("://")!==-1)resultURL=resultURL.split("://")[1]; if(resultURL.slice(-1)=="/")resultURL=resultURL.slice(0,-1); //*debug*/urls.push(resultURL); if(resultURL==page) return true; } //*debug*/return urls; return false; }
Google Scripts.How do I do this in spreadsheet?