Excel Fuzzy Lookup for SEO: Effortless 404 and site migration redirects
Fuzzy Lookup is an Excel add-in that can be a clever solution for automating SEO tasks. Here’s how you can use it for 404 and site migration redirects.
The post Excel Fuzzy Lookup for SEO: Effortless 404 and site migration redirects appeared first on Search Engine Watch.
Top skills for PPC, Paid Search, and SEM Specialists in 2019
A new SEMrush study analyzed more than 4,500 PPC job listings around the world. Here were the top skills for PPC, paid search, and SEM for 2019.
The post Top skills for PPC, Paid Search, and SEM Specialists in 2019 appeared first on Search Engine Watch.
How to: Add and improve related products in WooCommerce
WooCommerce is an exceptionally powerful, customisable retail CMS plugin for WordPress. As it’s WordPress, some organisations tend to reject it in favour of more complex platforms like Magento. While that’s probably a better choice for larger enterprise retailers, you’d be surprised by how much WooCommerce has to offer, especially for start-up retailers. With that said, […]
The post How to: Add and improve related products in WooCommerce appeared first on Builtvisible.
Prototyping automated product feeds for retailers
I was recently faced with the problem of creating a series of automated product feeds for a retail client. The requirement – deliver a feed in .csv format that contains updated stock and pricing information from 3rd party sites. In this case, from a group of supplier websites for items that aren’t held in the […]
The post Prototyping automated product feeds for retailers appeared first on Builtvisible.
4 modern uses for keyword counting and how you can automate it
Not interested in the story or example scenarios? Jump to the heading starting with ‘Screaming Frog Custom Extraction’. As an SEO, chances are you’ve worked with a WordPress CMS and installed the Yoast plugin. One of its best features is the ability to generate an SEO ‘score’ for each of your pages based on occurrences […]
The post 4 modern uses for keyword counting and how you can automate it appeared first on Builtvisible.
No Exact Match? How to Match Similar Data Tables in Excel with Fuzzy Lookup
What do you do when you have two or more data sets that need merging, but don’t have a single set of data column values that match? VLOOKUP becomes a bit useless, or at least you need to execute some wild Excel-fu to be able to consolidate your data. I faced this problem when dealing […]
The post No Exact Match? How to Match Similar Data Tables in Excel with Fuzzy Lookup appeared first on Builtvisible.
Visualising geographic data in Excel 2016: move over GeoFlow, 3D maps are now built-in!
Back in 2013 John Gagnon continued his popular series of posts about powerful spreadsheet use with a handy how-to guide for using the add-in GeoFlow for Excel.
Guide to Excel VLOOKUP basics and top five rookie mistakes
An Excel VLOOKUP can be a marketer’s best friend because it can save you hours of work.
13 time-saving Excel shortcuts & tips for marketers
Here’s an update of our classic Excel tips and shortcuts list with a few that reflect some new functionality in Excel 2016.
Lifting the lid of the search box: Excel tips for search marketers
There’s so much data available to us as marketers, but sometimes it can be difficult to make sense of large amounts of data. Here’s some Excel tips to help you take your data analysis to the next level.
Post from Cedric Chambaz
My Favourite Queries: SEOgadget for Excel
SEOgadget for Excel got a little update this week with better documentation to help you learn how to use the extension. I thought I’d share the few queries that I use in Excel most heavily: All the URL Metrics from Moz Sometimes you need all the URL Metrics data, and, if you have a paid […]
The post My Favourite Queries: SEOgadget for Excel appeared first on Builtvisible – A Creative Digital Agency.
Quick and Easy: Embeddable Highcharts Code Generator
Last week’s post “On Link Volume” used a nifty interactive Highcharts.js embed, and a few of you noticed that we have Highcharts “working” in WordPress. I’m a big fan of Highcharts – they can look lovely in a blog post, with the only barrier to using the library is the initial complexity of learning “the […]
The post Quick and Easy: Embeddable Highcharts Code Generator appeared first on Builtvisible – A Creative Digital Agency.
An Introduction to Pivot Tables for PPC Analysis
As recent convert to pivot tables for analysis of your PPC Account and the fact that it has been the most requested guide after the training course at Biddable World, I thought I’d write a post to explain what they are, how they work and how to use them to analyse your PPC Data. I […]
Post from Jackie Hole on State of Digital
An Introduction to Pivot Tables for PPC Analysis
Excelling (Again) At Excel For Search Engine Marketers
On Thursday, March 13th, I will be presenting on the Extreme Excel Excellence panel at SMX West with John Gagnon and Brett Snyder (moderated by Chris Sherman). In the session, we will be delivering power-user tips for marketers using Excel, and Chris has raised the bar very high for us to deliver…
Please visit Search Engine Land for the full article.
How to Build the Moz Keyword Difficulty Tool in Excel with Moz and SEMrush
How exciting is that? By combining SEMrush’s “phrase_organic” with Moz’s URL Metrics API call, you can cobble together a prototype keyword difficulty tool. My example in this video is a bit scrappy, but I’m sure you get the point: Check out the rest of our instructional videos on your Youtube channel: http://www.youtube.com/user/SEOgadget No SEMrush Account? If […]
The post How to Build the Moz Keyword Difficulty Tool in Excel with Moz and SEMrush appeared first on SEOgadget.
Find New and Lost Back Links with MajesticSEO and SEOgadget for Excel
One of the most pressing issues in current SEO strategy is developing your ability to monitor new links, and track lost links. It’s a sad fact of our day to day lives as marketers in search. Some of our time doesn’t get spent on marketing at all, it gets spent on undoing bad marketing through […]
The post Find New and Lost Back Links with MajesticSEO and SEOgadget for Excel appeared first on SEOgadget.
Grepwords – Powerful Keyword Research without Adwords
Google took away the Keyword Tool, and pretty much every SEO Agency’s API access earlier this year. Let’s not hold it against them, though, because Grepwords is amazing and it’s available in SEOgadget for Excel. You’ll remember that for the longest time, I’ve taught keyword research and categorisation methodologies using our Adwords API Extension for Excel. […]
The post Grepwords – Powerful Keyword Research without Adwords appeared first on SEOgadget.
SEOgadget for Excel: How to Get Your Back Link Data with MajesticSEO’s API
One of the biggest problems we’ve always had with our new users getting to a confident user level with SEOgadget for Excel is simply put, the level of accessibility of the documentation. Learning a completely new syntax for 6 different API services is, hard. I really hope we’re helping there with the instruction manual, but […]
The post SEOgadget for Excel: How to Get Your Back Link Data with MajesticSEO’s API appeared first on SEOgadget.
Creating Efficient Data Collection Systems for SEO and Social
As marketers we only have so many hours in the day. Nothing is worse than having your team spend time on menial tasks (like data entry) when there’s real work to do. That’s why it’s crucial for managers to create efficient systems – so teams can get more accomplished and make a bigger impact. Most data […]
The post Creating Efficient Data Collection Systems for SEO and Social appeared first on SEOgadget.
Dashboard Series: Update An Entire Excel Dashboard With One Radio Button
In this month’s installment of my Excel dashboard series, I’m going to show you a trick that will give you the ability to control an entire dashboard with one menu — in this example, a radio button menu. For my example, I’ve put “months” in the menu at the top of…
Please visit Search Engine Land for the full article.