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
Search Results for: pivot table
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!
Making Good Use Of Those Location Extensions
When the time comes to really push your accounts, it’s helpful to know where to push and what will help connect users to your product or service. This can be especially vital when you have both online retail business as well as brick & mortar locations. Sure you have location extensions enabled (you do, right??) but do you simply bid up all of those locations with bid … [Read more...] about Making Good Use Of Those Location Extensions
Leverage Paid & Organic Results to Boost Traffic to Your Site
We all know that paid ads appear above, to the right, and at the bottom of organic listings, and that the two most likely have an effect on each other. We also know that paid ads have the advantage of appearing at the top of the SERP, and we can easily measure performance by average position. In the PPC world we like to measure and analyze everything, but comparing organic … [Read more...] about Leverage Paid & Organic Results to Boost Traffic to Your Site
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
Avoid A GDN Disaster With One Simple Optimization
This week we’ve focused on PPC issues that we have faced and triumphantly overcome. The most memorable key learning that has stuck with me over the years is the importance of monitoring display placements - in particular Mobile App placements. Earlier this year I wrote a post about how the Mobile App: Flappy Birds almost destroyed my account. Since then, I’ve gathered even more … [Read more...] about Avoid A GDN Disaster With One Simple 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
The Argument For Match Type Segmentation
There have been many debates recently in our agency and here on PPC Hero over match type segmentation. It’s not surprising that people get heated when hearing that their way isn’t best. I suggest that every Account Manager should do what they feel works best, but there are many factors to consider when deciding the best option. There is often a good reason that advertisers … [Read more...] about The Argument For Match Type Segmentation
The Real Impact of AdWords Close Variant Changes
Last week AdWords announced it would be removing the option to select whether we include or exclude close variants in our campaign settings. The justification is that those typing in search queries aren't perfect spellers. The intent behind a misspelled and correctly spelled keyword is the same. This is the same logic Google uses to tell us Tablet and Desktop are the same thing … [Read more...] about The Real Impact of AdWords Close Variant Changes
