When you’re working with enormous amounts of data in Excel all day long, you’re constantly thinking of ways you can speed up your work without sacrificing quality. When you’re performing routine reporting and budgeting, or data analysis and data visualization, your time is valuable. Let’s spend less time and gain more results. Who’s with us? In this webinar, … [Read more...] about Excel Tips for the Time-Crunched Marketer
Search Results for: supermetrics
Update Bids and Monitor Changes with AdWords Scripts
AdWords scripts are a great tool for managing bid adjustments. In previous articles, such as Automating Bidding with Google Sheets and AdWords Scripts, we’ve covered different ways to change bids and handle uploads. This article will take those ideas and combine them into your own bidding system! We’ll still keep a high-level approach in this article to keep is accessible or … [Read more...] about Update Bids and Monitor Changes with AdWords Scripts
Spend Smarter: Identifying Account Opportunities
Budgeting can be a tricky thing. Oftentimes we run into one of the following situations: Performance has been steady, but we’re limited in what we can spend. Wow we want to grow the account. The client comes to us asking if we could spend more, if so, how much more? What will the outcome be? The client comes to us saying that they have additional $X to spend, but their … [Read more...] about Spend Smarter: Identifying Account Opportunities
Up and Running with AdWords Add-on for Google Sheets
We can all agree that having data is good. Having data stuck behind an interface is not good. Data in the interface isn’t easy to manipulate. This makes more difficult to analyze and incorporate your data into a tool or template. Thankfully a new add-in has come along to save the day and directly export data from AdWords into Google Sheets. Of course you could have pulled this … [Read more...] about Up and Running with AdWords Add-on for Google Sheets
Competitive Device Trends: An In-Depth Analysis
Competitor analysis is something clients and bosses love. Over the years, we have gotten better at formatting and presenting auction insights data, but it was lacking in both device specific data as well as recommendations. In this new templated report we pull in the best of both worlds - device analysis and auction insights competitor data. In this post we’ll walk through what … [Read more...] about Competitive Device Trends: An In-Depth Analysis
How To Avoid Overlap Between Multiple Similar PPC Accounts
Avoiding keyword and targeting overlap is a difficult process even when working within the constraints of a single account. Success hinges on Search Query Analysis, and issues are likely if any of these 4 Red Flags Of Ineffective PPC Account Structure are present. The process becomes much more complicated when working on a series of related brands or company divisions. If not … [Read more...] about How To Avoid Overlap Between Multiple Similar PPC Accounts
3 Essential Excel Formulas to Automate PPC Reports
This guest post is brought to you by Jason Pellissier, Paid Media Manager at Nebo. See Jason live at Hero Conf Austin, April 16-18. The daily life of a PPC manager can be summed up with one word: Reports. Day of week reports, hour of day reports, keyword reports, the number seems to always be increasing with less and less time in the day to actually do them. Because time … [Read more...] about 3 Essential Excel Formulas to Automate PPC Reports
5 Things to Make You Better at PPC Marketing
I Love Us I love the PPC community. We are funny, smart, and, for the most part, do our work without much hubris. And one of the greatest things about PPC Hero is this: we are dedicated to making the funny, smart, humble PPC community better. PPCers are very much interested in knowledge-sharing and the old adage “a rising tide lifts all boats”. So in this post, I am going to … [Read more...] about 5 Things to Make You Better at PPC Marketing
PPC Chores: A Mid-Winter Cleaning
Spring cleaning. Every time Spring rolls around, all you hear is “it’s time for a little ‘spring cleaning’”. I don’t know about you, but when the weather finally does turn pleasant, I do not want to spend my time indoors cleaning. Which is why I am a huge fan of “Dead of Winter Cleaning”. A little elbow grease and organization now means you will be reaping the benefits by MLB’s … [Read more...] about PPC Chores: A Mid-Winter Cleaning
Automating Bidding with Google Sheets and AdWords Scripts
Bid changes are vital in steering your account towards performance goals. While the process is important, making the changes and implementing them adds little value. In this article, we’ll cover setting up an automated bidding system using both Google Sheets and AdWords scripts. Specifically, we’ll utilize the bulk upload functionality to format and post the changes directly … [Read more...] about Automating Bidding with Google Sheets and AdWords Scripts
6 Bottom Line Boosting Tips for Paid Search
"It depends". In my 2+ years at Hanapin Marketing, I've come to learn that this is a universal truth across the industry. There is no shared magic number for ROI or CPA. There is no perfect CTR or CVR. And there most certainly isn't a singular strategic approach that can navigate across all industries and account types. That said, I do think there is a handful of search … [Read more...] about 6 Bottom Line Boosting Tips for Paid Search
Stop Using Google’s First Page Estimates to Set Your Bids
Within the Google Interface there’s a super helpful piece of information called the First Page Bid Estimate. This metric tells you, based on both quality score and competition for the exact match of your keyword (even for broad and phrase keywords), an approximation of where you should set your bid to ensure that you win as many auctions as possible to appear on the first page … [Read more...] about Stop Using Google’s First Page Estimates to Set Your Bids
