How to Find and Remove Duplicates in Excel

“I’ve never been a natural, all I do is try, try, try.” These Taylor Swift lyrics, in the song “mirrorball”, perfectly explain my relationship with numbers, math, and anything concerning data analytics. However, as a marketer, data analysis is one of the most important aspects of my job. But like most marketers, who prefer strategy and creativity, numbers and Excel reports don’t come naturally to me. That’s why it’s important to know how to work in Excel and find shortcuts to help make the process easier. Today, we’ll dive into one of those processes — how to find and remove…

The 9 Best Ways to Send Large Files

We all know the frustrating feeling — maybe you’ve finally finished the script for your next marketing video, or you’ve collected all the images you need for your next campaign. But when you go to press “Send” you’re told, “Sorry. File too large.” Unfortunately, our email accounts can’t carry as much storage as you might think. Gmail, for instance, can only hold files up to 25 MB. Additionally, large files can eat at your storage space, even if it’s just sitting in your Sent folder. If you’ve got a file you can’t send the traditional way, don’t worry — we’ve…

The 12 Best Free Graphic Design Software for Marketers and Beginners

When it comes to website success, what you see is what you get. While compelling text, blog, and social media content can help set your brand apart from the competition, the visual appeal of your site is the first thing users see when they follow backlinks or click through search engine results. Recent research found that it takes just 2.6 seconds for users’ eyes to focus on a specific area of your website. What’s more, it takes just 0.05 seconds for visitors to form a general first impression of your site — meaning you’ve got just one opportunity to change…

Robots.txt: The Deceptively Important File All Websites Need

The robots.txt file helps major search engines understand where they’re allowed to go on your website. But, while the major search engines do support the robots.txt file, they may not all adhere to the rules the same way. Below, let’s break down what a robots.txt file is, and how you can use it. What is a robots.txt file? Every day, there are visits to your website from bots — also known as robots or spiders. Search engines like Google, Yahoo, and Bing send these bots to your site so your content can be crawled and indexed and appear in search…

How to Write a Cover Letter for an Internship [Examples & Template]

Writing a cover letter can feel like a daunting task, particularly if you don’t have a lot of real-world experience. Fortunately, a cover letter is actually a chance to explain how your extracurriculars and classes have taught you exceptional leadership and time management skills. To really stand out, it’s important to personalize your cover letter for each internship application you plan to submit. Your cover letter isn’t an opportunity to reiterate your whole resume, though. This is your chance to pick out a few accomplishments from the position description and dive into examples showing how you’ve exhibited these skills. We’ve…

Steal This Content Marketing Template

Starting with a blank document? That’s hard. Starting with a content marketing template? Much easier! A good content template will force you to plan for promotion. It pushes you to plan for (or at least consider) the various content promotion channels: SEO, social media, email marketing and influencer collaboration. Promotion needs to be a forethought, not an afterthought. The best content doesn’t win. The best promoted content wins. An article is built to perform in a channel or it isn’t. This free Google Doc template will help. Steal Orbit’s content template Just click File > Make a Copy. (You can…

What Domain Authority Is (and Isn’t), and How to Increase It

Some companies and brands use Domain Authority (DA) to study and evaluate the results of their digital strategies. But what does this metric really mean? Should we really strive to improve it? Will a high domain authority help us rank better on Google?  Domain authority can be a very useful metric to know the status of a website in relation to similar competitors, but we must emphasize that it is not a ranking factor for Google.  In this post, we’re going to define what domain authority is — and what it isn’t — and what you’ll want to take into…

Ultimate Guide to Hero Images [Best Practices + Examples]

Whether or not you realize it, you judge every website by its visual appeal. And it only takes about 0.05 seconds to form an opinion. That means the hero image (the first photo, graphic, or video people see) has to be eye-catching enough to keep people scrolling the site. High-quality hero images are the key to a great first impression. If done well, they represent the essence of your brand identity and the overall theme of your web page. Yes, it’s a lot of weight for one piece of visual content. That’s why it’s the most heroic of all. This…