November 28, 2017 Google Sheets is a versatile tool for PPC marketers. Whether you’re using it build reports for your clients, analyze data, or other miscellaneous PPC tasks, getting familiar with some of the lesser known functions can be beneficial. Here are the features we’ll cover in this post: Import Sitemaps Currency Conversions Sparklines […]
6 Google Sheets Functions Useful For PPC Reporting & Analysis Read More »
October 19, 2017 Working with text data is a necessary part of analysis but often overlooked in skill development. This leaves gaps in analysis and adds time and tedium to common tasks. Your ability to work and manipulate text greatly enhances your workflow and effectiveness. Splitting keyword, ad text, or campaign structure allows you
Extracting Text in Excel for PPC Read More »
1. Recommended Set of Tools You can do all of your work manually, but it’s very time-consuming, so I wouldn’t recommend this to anyone since you’ll probably get lost in the piles of links. Since we are doing penalty recoveries on a daily basis, we are using the below-mentioned tools. If you are doing a
Unnatural Links Manual Action Removal Guide Read More »
July 18, 2017 To online advertisers, it has become very clear that Facebook (more often than not) needs to be a part of every digital strategy. Whether it is brand awareness, dynamic remarketing, or a basic static ad, Facebook Ads can be a key element in driving traffic and increasing conversions. However, if you have
Your Facebook Ads Are Working – Here’s How To Prove It Read More »
July 3, 2017 We all know that Excel can save you valuable time in your PPC. The latest and greatest Excel tricks are just out there waiting for you to grab a hold of and run with. What’s the problem? The problem is you barely have enough time to breathe, let alone do hours of
PPC Excel Shortcuts You’ll Never Want to Forget Read More »
June 19, 2017 A group of us here at Hanapin recently participated in a free 21-Day Excel Course directed by renowned Microsoft Excel expert Dr. Wayne Winston. The course itself felt slow at first, but ultimately revealed several Excel capabilities I’d never known. Most exciting of these, to me, is the capacity to regress multiple
Using Excel Regressions To Better Understand KPIs Read More »
