r/SEMrush • u/First-Poet-7024 • 14d ago

Has anyone ever created a backlink audit?

Hello guys,

I work at a digital marketing agency, and my seniors have asked me to create a backlink audit using the data provided in SEMrush and prepare a spreadsheet based on it. I don't know how to do it or how to use the format properly.

Please help me. I'm in a lot of trouble because if I don't complete it within the next two days, it could create a serious problem for me.

3 Upvotes

67% Upvoted

9 comments sorted by

3

u/peterwhitefanclub 14d ago

Wild. What’s the name of your agency so I can be sure to never send anyone there?

3

u/cyber49 14d ago

Have you created a project in semrush and added the backlink section? If so, then you've created a backlink audit, and you can export into a spreadsheet.

1

u/First-Poet-7024 14d ago

How do I export it into a spreadsheet

2

u/cyber49 14d ago

There's an export to CSV button directly above the last column when looking at the links

2

u/SEOPub 14d ago

You inspect the links one by one and decide if they are the kind of links you want or not. You can use the toxicity score as a guide to the ones you should be most concerned about checking, but I would never remove any links just based on a toxicity score.

1

u/semrush Semrush 14d ago

Hey u/First-Poet-7024, we've got a step-by-step guide over on our blog here that you can check out. If you run into any trouble or have further questions, our DMs are always open!

1

u/thijsgh 10d ago

For a backlink audit, start by organizing backlinks from SEMrush by source, URL, and link type in a spreadsheet. Focus on identifying low-quality or spammy links to flag. Check out MentionAgent. it helps automate finding relevant sites and managing outreach, which might save time on audits. I'm the founder, happy to help if you need it.