Are we seeking out as much volume from paid search as we should be? Why is cost per click and cost per acquisition increasing? At what point are we just spending more money for the same number of sales? Everyone is telling me that competition has increased. Where’s the proof? How do I know you don’t just have a bad bidding strategy? These are common questions that I … [Read more...] about Using Auction Competitors To Tell a Business Story
Search Results for: pivot tables
Save Time On Tactical PPC Work
After you do all of the hard work analyzing your account, you’re going to need to implement some changes. Whether it’s bid changes, new campaigns, or pausing keywords; getting into your account and optimizing can be a time suck. Tasks To Do Yourself Excel Templates - Excel is a huge part of our day-to-day tasks when it comes to PPC, so you might as well accept it and become … [Read more...] about Save Time On Tactical PPC Work
Webinar: 11 Excel Tricks To Improve Your PPC Life
More about this Webinar PPC and excel are like peanut butter and jelly or macaroni and cheese, you really can't have one without the other (or at least its not as good a combination!). By becoming super savvy with excel, you'll save a lot of precious time doing your PPC tasks and overall, become better at analyzing account performance. We cover a variety of tricks that can … [Read more...] about Webinar: 11 Excel Tricks To Improve Your PPC Life
Don’t Forget The Basics! Audit Your Account – A New Case Study
As an Account Analyst, Account Managers usually come to me with some sort of problem. Sometimes it’s “I’d like to brainstorm strategy” and other times it’s “we need to improve ROAS as quickly as possible.” Not being the Account Manager gives me a fresh set of eyes on an account. I found in the past that when I was struggling with a problem on my own account, it was mainly … [Read more...] about Don’t Forget The Basics! Audit Your Account – A New Case Study
How Bing Ads Tablet Bid Modifiers Helped Reduce CPA by 47%
The PPC industry is always evolving and changing. One of the biggest changes to impact the PPC community was the roll-out of AdWords enhanced campaigns and Bing Ads compatibility with AdWords enhanced campaigns. While some great features have been made available by enhanced campaigns, one of the biggest pain points for ppc managers was, and continues to be, the lack of control … [Read more...] about How Bing Ads Tablet Bid Modifiers Helped Reduce CPA by 47%
Punch AdWords In The Face With These 5 Easy Scripts
If you have been running AdWords for more than 5 minutes it’s safe to say you have some pent up feelings of aggression. It’s completely normal to get curse at inanimate objects like a computer, right? Instead of spending a ton of time and brain power pulling data and manipulating pivot tables we’ve come up with a few scripts that will help you to minimize frustrations and … [Read more...] about Punch AdWords In The Face With These 5 Easy Scripts
Simple Tips To Enhance Your Excel Spreadsheets
Every now and then you stumble across an Excel tip or trick that blows your mind. However, this won’t always be the case and as your skills progress these insights are harder and harder to discover or take more effort than they are worth. Rather than going bigger, it is often much easier to take a step back and recognize little tricks you could try, or actions that lead to … [Read more...] about Simple Tips To Enhance Your Excel Spreadsheets
Account Structure and Reporting in Excel
In late October I wrote an article about a template I created in Excel for account build outs and creating an organized paid search account. I emphasized that building out accounts in an organized manner helps with reporting and ease of optimizations. How does this organization help with reporting? Let's dig back into Excel to show how reporting can be done easily with a … [Read more...] about Account Structure and Reporting in Excel
Turn A Lazy AdWords Report Into A Money Making Tool – New Whitepaper!
How do you determine if you have keyword cross-pollution in your account? You use the Search Query Report in Google AdWords and a pivot table, However, the Search Query Report is one of the most overused reports out there and causes for a "lazy" AdWords Report. Don't make a decision on a whim - learn how to turn that lazy Adwords report into a fantastic money making tool! In … [Read more...] about Turn A Lazy AdWords Report Into A Money Making Tool – New Whitepaper!
Excel Correlation, Causation, and Optimization
Figuring out the "why" behind account performance issues can be a very tricky proposition. At best, it's a quick dive in to the change history and noticing that someone added 500,000 negative phrase match keywords. At worst, though? Well, the worst-case scenario is that there may not be an easy answer, and you'll need to get creative to figure it out. Recently, I was faced … [Read more...] about Excel Correlation, Causation, and Optimization
When PPC Help Never Comes
Luck doesn’t begin to describe my circumstances growing up. Great parents, financial stability, fell into the right crowds; basically, I always had people I could count on. Later in life these circumstances have led me to naturally connect with people whom I trust. I always know that if I find myself in a tough spot someone will be there to help get me out of it. There is a … [Read more...] about When PPC Help Never Comes
Put AdWords In Its Place – Scripts for Changes in CTR and Geo and Device Data
You don’t have time to fumble through filters in excel pivot tables and your client (or boss) needed to know performance data 10 minutes ago. With these two Hero Pro scripts Increase/Decrease in CTR and Geo / Device Data, you can keep the information you need right at your finger tips and easily keep track of ad metrics – so you can react in real-time. See increases or … [Read more...] about Put AdWords In Its Place – Scripts for Changes in CTR and Geo and Device Data
