VLOOKUP is one of those functions that make Excel great. Although many may not find it intuitive at first, it soon becomes second nature and indispensable. Some even find is life-changing. VLOOKUP has its issues though, for one, it only reads from left to right. If you need to look up a value to the left of a reference column, you’ll have to rearrange your worksheet to use the … [Read more...] about Index Match: The Better Alternative to Vlookup
Search Results for: excel
Lean Six Sigma for Digital Marketing Managers
If you read much about startup culture or business management, you’ve no doubt come across the terms “Lean,” “Six Sigma,” and maybe even “Design Thinking.” These are concepts integral to operations management and concerned with reducing both the amount of variability and the amount of error or waste that takes place within a given process or set of procedures. I recently had … [Read more...] about Lean Six Sigma for Digital Marketing Managers
[Hero Academy Video] Overview of Frequency Capping
At one point or another, we all have browsed the internet, Facebook, or any other online source and have been pelted with digital advertisements whether we wanted them or not. Most of us have been hit with certain ads so many times that we become numb to the company serving those ads. This is where frequency capping comes in. Ad frequency is the number of times your … [Read more...] about [Hero Academy Video] Overview of Frequency Capping
[Hero Academy Video] A Breakdown of Ad Extensions for Google Ads
Google Ad extensions are all about helping the advertiser provide more information to people searching on Google. The number of relevant extensions you’re running can greatly affect the appeal of your ads. The more appealing the ad, the more likely it is to receive clicks. As we know, clicks help lead to sales, leads, conversions, bookings, or whatever you are offering. If you … [Read more...] about [Hero Academy Video] A Breakdown of Ad Extensions for Google Ads
[Hero Academy Video] How to Turn Ad Copy Brainstorming Into a Science
Writing ad copy isn’t the most thrilling thing to do. While almost any ad copy you write will be ok and do ok, that’s not what you want to settle for. Great ad copy will not only help you stand out amongst your competitors, but will get you the performance you’re looking for out of your paid search campaigns. In this new, short video on Hero Academy, the Senior Manager … [Read more...] about [Hero Academy Video] How to Turn Ad Copy Brainstorming Into a Science
New Releases on Hero Academy! Starting Pinterest & Apple Search Ads
Hero Academy is Hanapin's newest initiative featuring short and basic how-tos on paid advertising in a variety of platforms. Current topics include the basics of Google Ads, Microsoft Ads, Facebook, Quora, Excel, + more. AND NOW, we've released 2 BRAND NEW videos! Along with videos that show you the basics of getting started in different platforms, Hero Academy will … [Read more...] about New Releases on Hero Academy! Starting Pinterest & Apple Search Ads
Creating Successful PPC Ad Copy for B2B and B2C
While no one denies the importance and affect organic SEO and search ranking can have on a brand, pay-per-click (PPC) advertisement is arguably faster and more efficient. Whether you aim to attract local B2C clients or international B2B partners to collaborate with, PPC ads can help you on both fronts and then some. According to 99 Firms, PPC visitors are 50% more likely to … [Read more...] about Creating Successful PPC Ad Copy for B2B and B2C
Robust Reporting with Google Sheets Query Function
As you work with spreadsheets you pick up formulas, tricks, and formatting lessons to make reporting easier. I often see users get stuck when it comes to combining these pieces into a complete report. We recently onboarded a client and needed to replicate one of their old reports. Most of the report created manually, updating a row at a time, every day. This is not a … [Read more...] about Robust Reporting with Google Sheets Query Function
Lessons Learned as a PPC Analyst
My six year Hanaversary is coming up, so I’ve been doing a bit of reflecting on what I’ve learned working as a PPC Analyst. I didn’t start out as an analyst, and didn’t always know this is where I would be at 6 years, but I’m grateful for the journey that brought me here. So whether you are just starting out in PPC, whether you are a seasoned account manager, or whether you … [Read more...] about Lessons Learned as a PPC Analyst
How to Exclude Mobile Apps in Google Ads
In a previous article, I discussed how to target and exclude mobile apps in Google Ads Display. This initial approached seemed to work, but then the mobile app spend began to increase sharply for several accounts. Honestly, my opinion about mobile app traffic has not improved. Mobile app traffic may have low CPCs, but the costs add up quickly with few tangible results. In fact, … [Read more...] about How to Exclude Mobile Apps in Google Ads
Paid Search Audience Testing: Zero Cost Testing
In Paid Search, testing is crucial in our industry. We are always looking for new testing opportunities such as ad copy to improve user engagement and other tactics to bring down cost-per-click while also trying to achieve more leads or revenue. Sometimes clients can be hesitant to test because if a test loses they might feel like it was a waste of time or even resources. If … [Read more...] about Paid Search Audience Testing: Zero Cost Testing
Hero Conf Austin: Registration is open at 50% off
From knowledge and networking to techniques and tools, Hero Conf exists to take your career further in digital marketing. We've launched Hero Conf Austin with the first 50 tickets at nearly 50% off and they are going fast! Join your PPC peers at a mega discount for 2 impactful days of all-things-paid advertising. What's professional development without action to follow? We … [Read more...] about Hero Conf Austin: Registration is open at 50% off
