Today, I’m absolutely delighted to announce we’re releasing the SEOgadget Links API Extension for Excel. With it, you can build reports and cobble together quick applications to fetch valuable link data from all 4 Mozscape API flavours.
If there’s one task most marketers share — whether their focus is SEO, paid search, or social media — it’s collecting and interpreting data. Being able to slice and dice the data to find actionable insights is key to effective analysis.
Choosing which SEO-tools to use can be hard, both for beginners and professional SEO’s. If you rely on the wrong ones, you might lose money and be forced to redo much of your SEO-work. So how should you know which tools to pick?
Big data is all the rage right now. If you search Google News for the term, there are 53,500 thousand results. And that’s just the news. Most of us in Internet marketing aren’t truly working with big data, in the truest sense of the word.
With Microsoft Excel, we can create a report with all the keyword data you will need, all in one place, and fairly easy to update on a weekly or monthly basis. Then with all this data we can easily categorize segments of it to more quickly determine the better performing sets of keywords.
What we will need to do is push Google Analytics, Webmaster Tools, Adwords, Ranking data, and Revenue data all into one excel spreadsheet. Then we will put it all together into one master report and one categorized pivot table report.
Since no one has time to spend ages mining for Excel answers from mountains of text, so I came up with my own cheat sheet for Excel.
What I am going to present to you is actually a worksheet (we use internally for training purpose and quick reference) in the form of a blog post which i thought will be useful to share with the community. This cheatsheet is for Excel 2007.
We’ve been using Screaming Frog’s SEO Spider in the office for a few months now and, along with other spider software, it provides a great means of identifying technical and on-page issues quickly and easily.
My personal preference is to export the data to Excel where you can manipulate it however you like. In addition, you can then email the spreadsheet to a client, development team etc. once you’ve highlighted the problem you’re trying to fix.
Here are some of the Excel features and formulas that I’ve been using to generate meaningful, actionable reports.