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 Import from other workbooks Check for … [Read more...] about 6 Things You Didn’t Know You Could Do In Google Sheets
Search Results for: supermetrics
Getting To The Point – How To Create Actionable PPC Reports
While PPC nerds certainly love their data, sometimes we can (admittedly) go overboard. We throw every metric, dimension, and number we can think of into a report, maybe add in some notes, sometimes changing the formatting, and call it done. Some clients like this strategy as they want to be able to see every single piece of the data. Others, not so much. In today’s post, … [Read more...] about Getting To The Point – How To Create Actionable PPC Reports
Decoding The PPC Bid Management Technology Matrix
When it comes to evaluating which PPC bid management tool is right for your business, it can be difficult. Most of the tools offer similar features, making it challenging to compare platforms. Even after learning about all the cool features, you still find yourself asking, “Would this task just be easier to manage directly through the interface or editor?” In some cases, yes, … [Read more...] about Decoding The PPC Bid Management Technology Matrix
How To Use Historical AdWords Data To Create Your Own Bid Simulator
Within AdWords, there is a tool called Bid Simulator where you can review potential keyword bids to project what type of performance changes various bid changes would make. The simulator is meant to help guide your bidding by projecting volume and efficiency as you raise your bid. While this is a great tool to get some estimates, Google's algorithm is fairly unknown and … [Read more...] about How To Use Historical AdWords Data To Create Your Own Bid Simulator
Time Saving Automation: Search Query Edition
Search Query Reports (SQRs) - you either love them or hate them. Nonetheless, they are an extremely important component of a PPC campaign. While you probably pull these semi-regularly (or maybe you don’t do them at all), are you getting the most out of them? With a little bit of work on the front end, you can save time by automating these reports. Once you get it all set up, … [Read more...] about Time Saving Automation: Search Query Edition
Save Your Precious Time: Quality, Fast Reporting DOES Exist!
We’re all constantly trying to speed up our reporting…but of course, without losing quality. It can be really difficult to discern which metrics you need, what data you should spend your precious time pulling, and how to compare data ranges. Luckily, we have some experts who are pumped to talk to you about how to make your reporting more efficient. In this new webinar, … [Read more...] about Save Your Precious Time: Quality, Fast Reporting DOES Exist!
Building An Automated PPC Spend Tracker In Google Sheets
With yesterday’s webinar on efficient data analysis through Google Sheets, as well as Tuesday’s post pitting Excel features in their very own March Madness tournament, this week on PPC Hero we’ve highlighted one of the most important pieces of the digital marketer’s toolbox: spreadsheets! Today, we’ll continue the trend by showcasing an application of Google Sheets, utilizing … [Read more...] about Building An Automated PPC Spend Tracker In Google Sheets
March Madness Continues: What Excel Tool/Function Rules Them All?
In light of the March Madness season it was thought that we could have some fun and review some of the previous PPC Hero articles on the best ways to utilize Excel in order to more efficiently and effectively manage PPC accounts. First, let's choose the seeds for the respective functions. There are four regions just like in the real tournament for the Excel Tools/Functions … [Read more...] about March Madness Continues: What Excel Tool/Function Rules Them All?
Paid Search Marketing Automation: Embracing The Machine
This post is part of the Hero Conf Los Angeles Speaker Blog Series. Megan Taggart will join 50+ PPC experts sharing their paid search and social expertise at the World’s Largest All-PPC Event, April 18-20 in Los Angeles, CA. Like what you read? Find out more about Hero Conf. These days automation is synonymous to account optimization. eMarketer recently reported two-thirds … [Read more...] about Paid Search Marketing Automation: Embracing The Machine
Google Data Studio: Revisited
Last year Google launched Data Studio in beta. We did a write up of our initial thoughts of the platform. While the idea behind it was good, there were some bugs that popped up here and there, especially when it came to adding data sources. You were also limited to only five reports with the free version. If you have more than a couple accounts to work with, this isn’t ideal. … [Read more...] about Google Data Studio: Revisited
Work Smarter, Not Harder – Using Google Sheets for PPC
Between reporting, analysis, dashboards, and action item lists, we use Excel a lot for PPC. Recently, our team has begun to rely on Google Sheets for items like reporting, dashboards, and even to-do lists and status docs. We’ll go through how to get your data into Google Sheets and how to manipulate it once it’s there. Supermetrics Want an easy way to get all your PPC data … [Read more...] about Work Smarter, Not Harder – Using Google Sheets for PPC
15 Incredible Facebook Ad Tools We Love
Who doesn’t love a good marketing tool? Utilizing tools can: Save you time Provide quick insights Improve campaign performance Automate repetitive tasks While we haven’t found the ultimate Facebook advertising tool that meets all of our needs and desires, we do have a solid list of tools that we keep handy. This is by no means a complete list, but rather a roundup of … [Read more...] about 15 Incredible Facebook Ad Tools We Love
