Excel for SEOs

Excel is unavoidable for SEOs. There are many excellent keyword research tools and data sources available, but eventually you’ll find yourself exporting something into Excel or using it to fine tune your dataset. With this in mind, it’s beneficial to spend some time learning the most practical and commonly used formulas for SEO. We’ll walk you through some of our favorites and how we use them below. 

Formulas 

Concatenate

This allows you to combine two things, whether it be two cells or 1 cell + words. 

We use it the most when exporting data from Google Analytics. Google Analytics doesn’t export the domain name with the landing page slug, so sometimes we need to add the domain to the slug. read more

SEO Guide to Discontinued Products

E-commerce sites need to deal with turnover of products in their catalogs all the time. One common scenario is that products are discontinued. For many consumer electronics products, this can happen on a yearly cycle as the new models with upgraded features replace the existing products. For fashion brands, this is typically a quarterly thing to keep up with seasonal trends, but for ultra fast fashion brands, product turnover can be a constant process.

Regardless of the timing or regularity, any SEO for an e-commerce brand has surely been asked what should be done with discontinued products. As with virtually everything in SEO, there’s no one answer for every scenario. This guide is meant to help you come to the right answer and cover the vast majority of circumstances you’ll encounter. read more

Hi Annie, Welcome to the Team!

We’re excited to be adding another member to our Transistor team. Meet Annie Rauch!

Annie joins Transistor Digital as a SEM Strategist. She has a background  in business and journalism along with professional experience managing the build and launch of client websites. Her past experience provides her with exceptional client management skills and the natural ability to connect business goals with digital strategy. The Transistor team can’t wait to see her excel in her new role!

We’ve asked Annie a few questions to help everyone get to know her a little better. Make sure to connect with Annie on LinkedIn and send her a note to say Congrats! read more

A Look Into InLinks’ Updated Keyword Research Tool

Keyword research tools – what would an SEO do without them? We all have our favorites, but I think we can all agree that it’s never fun sifting through junk keywords to find ones that match user intent. Well, now there may be a tool that can help you skip that step in the keyword research process. 

InLinks recently launched a new version of their keyword research tool. They already had a lot of great tools for structuring content when you already had a keyword in mind, but now you can blend the keyword research process with the content optimization process. We’ll run you through how we used the tool on one of our own pages below.  read more

Summer Intern Highlight 2022

We love spreading knowledge about all things SEO and PPC with the next generation of marketers. One way we do this is with our internship program, which brings college students into the team and trains them on the basics of search marketing and gets them hands-on experience with search optimization. This summer we are welcoming the newest Transistor Intern, Andrea!

Andrea is a student at Cornell University pursuing her BA in Economics and Information Science. She is interested in the world of financial technology and is looking forward to merging her interests and experience into the world of search marketing. read more

Hi Claire, Welcome to the Team!

The Search Engine Optimization (SEO) team is growing once more. Meet our newest team member, Claire Popp!

Claire joins Transistor Digital as an SEO Analyst. She has a marketing background with a specific interest in digital marketing. Her experience in marketing development provides her a keen eye for research and an ability to look for new opportunities. The Transistor team is really excited to see her passion hard at work for our clients!

We’ve asked Claire a few questions to help everyone get to know her a little better. Make sure to connect with Claire on LinkedIn and send her a note to say Congrats! read more

5 SEO Mistakes to Avoid in 2022

On April Fools’ Day we thought it would be fun to make an infographic showing previous SEO strategies that have now turned into SEO mistakes. Today, SEO is more than just keywords. You can’t just buy an AOL keyword anymore.

We want to make it VERY clear that the infographic you saw on our social media accounts and below is a funny SEO joke with a few mistakes that you can make. We repeat, do NOT follow those tips and tricks. Instead, take a look at how those SEO mistakes can actually be very harmful to your website’s success. read more

Data Driven Decision Making: The Power of Online Data

Search Engine Optimization (SEO) is a powerful tool to gain more traffic to your website, but did you know that we also have access to a wealth of data that could help you make better business decisions? It’s true! This powerful data can help your business:

  1. Discover new product or service opportunities based on trending or increasing search volume
  2. Explore your competitors’ strengths and weaknesses
  3. Understand your current or new target market’s search behaviors
  4. Maintain a positive brand image through monitoring of branded terms and questions in search

How do we find this information? What tools and resources do we use to develop answers to the topics mentioned above? How can you use this information to propel your business forward? We have developed a four part blog series to answer these questions and arm you with information you need to use real data to make better decisions. read more

How Does SEO Interact With Other Marketing Channels?

With the recent stay-at-home orders, working online becoming the norm and the closings of brick and mortar stores, digital marketing strategies have become more important than ever. Search marketing is a huge part of that digital marketing strategy. However, when people think of SEO, organic traffic is usually top of mind. The reality is that it is just one piece of the pie. There are many different digital marketing channels that need SEO love and attention. Here are a few ways to integrate SEO into your different digital marketing channels. read more

Bulk Radius Targeting in Google Ads

Google Ads can be weird about location targeting. You can bulk add cities/states/countries/etc via the web interface. But radius targeting? You can only do one at a time. What happens if you’ve got a large number of locations you’d like to radius target? Say, every university campus in the US. Or the 250 largest companies. These would be more ideal for true geo-fencing, but that’s not an option with Google Ads. You can, however, layer the smallest radius option (1km) with additional targeting like audiences to get fairly close. In smaller cities or rural areas, it’s a solid enough system. In Manhattan it could really fail. read more