Upload List of Emails for Domains Buzzstream

Today'southward post on keeping runway of disavowed and blacklisted domains comes from BuzzStream customer and friend, Martin Woods of salt.agency.

It's blindingly obvious that y'all shouldn't make the same mistakes twice, especially when it comes to a Google penalty. According to Matt Cutts, the consequences for the 2nd breach of their terms & weather condition are fifty-fifty more severe than the first.

But how do you keep a rail of all the websites and contacts which you don't desire to work with? Information technology's especially hard when you are a large outreach team working on multiple campaigns at the same time, as it's vital to proceed everyone working holistically.

Typically if you have completed one or more than Google Disavow files, you will take a long list of sites which at best will offering no link value and at worst could land you with another Google penalty. This guide will show yous how to shop, manage and use a list of websites and people whom yous do non desire to be affiliated with in any manner.

This information can and then be used with the new BuzzMarker Chrome Extension to quickly place blacklisted domains that shouldn't exist contacted when you and your squad are browsing websites.

Eliminate chance using BuzzStream to flag blacklisted domains

BuzzStream to the rescue!

One of our biggest challenges and our biggest opportunities is to brand data more accessible across our business organisation. That's why we at WMG use BuzzStream to record and store our contacts, making the data more accessible across our teams and easier to employ to inform campaigns and decision making.

Keeping things structured and tidy in BuzzStream

Earlier I explain how you tin can employ Buzzstream to flag/blacklist domains and contacts with whom y'all exercise not want to work with, I will explain how our team structures our BuzzStream account. (Editor's annotation: Since BuzzStream is so customizable, your business relationship and project setup may be structured differently than WMG'due south.)

Every bit a large SEO bureau such every bit ours with hundreds of clients and thousands of projects, we need to keep BuzzStream obsessively tidy. I personally recommend the following construction to keep things easy to detect:

Orange indicates a folder and blue indicates a project.

Archived (Onetime Clients)

• %customer name%
  • %project url%
    • %customer name%-%project url%-%appointment created%-%project number%-%project proper noun%

Clients

• BuzzStream
  • Buzzstream.com
    • BuzzStream-buzzstream.com-2014-05-#4-Existing Customers

Prospect Lists by Niche
Internal Projects
z Domain Blacklist/ Approved List (I apply a-z to sort this binder to the bottom)

• BLACKLIST OF DOMAINS
• Approved LIST OF DOMAINS

The advantage of using this structure is that information technology's easy to move clients and projects effectually, and information technology's dainty and simple for our outreach team to understand which project they're working on. We also use a campaign planner that generates binder and project names based on strict naming conventions; this ensures that law and society are maintained within our BuzzStream business relationship.

BuzzStream filter arrangement

Create custom fields for websites to record why a domain has been blacklisted or whitelisted

We apply custom fields in BuzzStream to create checkboxes that depict the reason why a person or domain has been either blacklisted or whitelisted. This ensures everyone in the futurity will know exactly why the site does or doesn't meet our quality standards and why they should or shouldn't brand contact.

Customize fields settings

For clarity, I have two split up custom fields. The offset is for why the domain was flagged under a blacklist, and the second for if the team have reviewed a flagged domain, but only plant something small (like some annotate spam). Afterwards all, we wouldn't want to not work with someone like the BBC because of a link disavowed at the URL level.

Blacklist Custom Field – "Does the Domain Suspension Our Link Quality Guideline Bug?"

A custom checkbox field for use in clarifying why a site hasn't passed our quality control settings

Whitelist Custom Field – "Passed Quality Command"

– A custom field for when (date) the site passed a quality command review

Create two separate projects for the blacklist & white listed domains

I recommend creating two split projects;

1. 'APPROVED List OF DOMAINS' (previously flagged in a blacklist for some reason).
2. 'BLACKLIST OF DOMAINS' (if you proper name your folder starting with a 'z' it volition filter to the bottom of the list keeping information technology out of the way).

Blacklist/whitelist projects

Create website type & human relationship stage – "Previously Blacklisted"

I like to flag a domain in as many ways as possible to reduce the run a risk of mistakes when it comes to domains which interruption our quality guidelines. Therefore I also create a custom Human relationship Phase -"Rejected / Blacklisted Domain" and a new Website Type – "Previously Blacklisted/Disavowed" to make it crystal clear to anyone looking in the projection in the future.

Custom Website Types

A domain can simply have one relationship stage and one website type (via Dropdown) at any ane time, so there is no defoliation. Then, if the domain is cleared in the future it can then be inverse to the correct 'Website Type' global identifier.

Upload a single domain which yous would like to blacklist

The reason for adding but one domain at this stage is that we are going to exist uploading potentially several thousand domains (depending on your Disavow/blacklist), and information technology's all-time to upload it equally a CSV rather than trying to import via copy & paste.

Select "Add from List of URLS" and enter one of your domains which you would like to blacklist.

Select "Add together from List of URLs" to import a domain to blacklist

Make sure that you select the relevant information (see below), at this stage it is also possible to add a Tag to the website which we're importing. You tin do this now, or at a subsequently stage. I suggest tagging it in capitals to make information technology stand out from your other tags used to identify a domain. E.g. PREVIOUSLY DISAVOWED/BLACKLISTED DOMAIN.

Marker the domain with any relevant information

If you have forgotten to categorise anything don't worry, that is the beauty of BuzzStream, we tin can practice it afterward!

Export the BLACKLIST OF DOMAINS projection

Exporting websites from a project in BuzzStream

At the moment there is currently only one domain to export, but in the hereafter if you wanted to export all the domains then you can do this past clicking the check box above the one highlighted in cherry-red and clicking the 'Select all' link.

Select the following columns to export:

• Website Domain
• Website Type
• Tags
• Relationship Stage
• Does The Domain Break Our Link Quality Guideline Issues?

Add a list of all the domains which you want to blacklist

Add the rest of your disavowed domains to your database export

Be careful to only add domains you want to blacklist and not URLs of particular pages, if you take whatever of these in your Disavow file.

Free Excel Tool – Disavow file to whitelist cross-checked blacklist

The majority of people volition near likelyuse a Disavow file as a source for their BuzzStream blacklist. I have created a small Excel tool which automatically convert your disavow file into a BuzzStream friendly list of domains which you can re-create straight into your exported BuzzStream (Figure 10). This will stop whatever chance of disavowing domains which you lot have in a white list, or that you haven't disavowed at domain level.

Disavow list to blacklist tool

To apply this tool, paste the listing of rows from your disavow file into the red cells, copy all the rows in the green cells so paste these into the A Cavalcade of your BuzzStream export.

Flag the added domains

At present information technology'southward fourth dimension to flag the new domains which nosotros've just added from our cleaned Disavow list. Duplicate the cells from row B2 to the stop of the named columns (highlighted in Orangish) down the folio for all the domains which y'all've added.

Finished populated BuzzStream blacklist database ready re-import

Re-upload the blacklisted domains project dorsum to BuzzStream

Now it's fourth dimension to let BuzzStream practise all the hard work. Nosotros re-upload the file using the 'Import from Existing File' option from the 'Add Websites' dropdown within the websites tab. Making sure that you take selected the correct projection (top left), you lot don't want to mix up your list and brand it segmented.

Import back to project

In the box that pops up select Lucifer My CSV (below) and upload the file.

Select the type of template to upload

Select'Machine-Update Existing Contacts' and make a final check that you are uploading to the correct projection – 'BLACKLIST OF DOMAINS'

Configure the upload

Let'due south have a cuppa

Now this is the near of import scrap, make sure not to miss it out…

Sit dorsum and take a lovely cup of tea, I would personally recommend Yorkshire Tea. This is perchance one of the best things nigh working at WMG; nosotros but always buy Taylors of Harrogate tea! Information technology would exist incorrect to buy anything else when we're based in Harrogate with the world famous Betty's just downward the route.

Once BuzzStream has does all the difficult work processing the data, you can go in and see the fruits of your labour.

And that's information technology

Now you can identify a blacklisted domain in any new project quickly and easily from either within BuzzStream, or using the new and improved BuzzMarker Chrome Extension.

How to identify a previously blacklist domain in BuzzStream

How to identify a blacklisted domain in BuzzMarker. *please note I chose the domain 0000web.com to utilize as an instance because information technology no longer exists, I am not implying that this domain should be blacklisted.

Conclusion

If you discover a domain in your blacklist that shouldn't be there subsequently reviewing the website again in more depth, you can easily move the domain from your global BLACKLIST project to the Canonical LIST OF DOMAINS project which we created at the offset.

If you do this, remove the tags/fields assigned to it that flag it, and populate the custom field which we created called 'Passed Quality Control' with a engagement. This ensures that in future, you'll know when the domain was whitelisted; domains can change and what was once a good domain tin easily become a bad domain…

Happy Outreach!

stringernalkents.blogspot.com

Source: https://www.buzzstream.com/blog/avoid-disavowed-or-blacklisted-domains.html

Share this post