Excel by itself can be a beast to tame, but add that to needing to use it to prepare uploads for the AdWords Editor, and you've got Cerberus on your hands if you don't know what you're doing. This week, Dave Rosborough shows us by example three easy tips in preparing an Excel worksheet for uploading to the AdWords editor. https://www.youtube.com/watch?v=hk9maHj_EX4 … [Read more...] about 3 Easy Ways To Prep Excel Worksheets For The AdWords Editor
Search Results for: excel
The Complete Guide To Taking The Microsoft adExcellence Exam
Back in March, I wrote a post about passing the Microsoft adExcellence Exam. One of the study materials I used was a series of blog posts written by Elizabeth Marsten of Portent Interactive who watched and summarized all of the study videos. Well now she has compiled all of her posts into an ebook, The Complete Guide To Taking The Microsoft adExcellence Exam. The ebook is free … [Read more...] about The Complete Guide To Taking The Microsoft adExcellence Exam
EXCELlent Series: Making Excel Subtotals Work For You
This week, we have been discussing a few of the ways in which Excel, that terrible and wonderful entity which tends to find its way into every search marketer’s daily life, can be harnessed to help you boost PPC performance. On Tuesday, Jessica C expanded on her list of Excel Tips for PPC Managers. Yesterday Bethany described how to use Excel to project PPC account … [Read more...] about EXCELlent Series: Making Excel Subtotals Work For You
EXCELlent Series: Projecting PPC Account Performance In Excel
This is part two of our three part EXCELlent series, showing you how to boost PPC performance with Excel. Yesterday, Jessica expanded on her list of Excel Tips for PPC Managers. Today we'll be looking at how to use excel to project PPC account performance. If there was one tool I wouldn't want to do PPC without it's the Projection Worksheet (PW), lovingly referred to here as … [Read more...] about EXCELlent Series: Projecting PPC Account Performance In Excel
EXCELlent Series: 5 MORE Top Excel Tips for PPC Managers
After realizing how popular a topic Excel turned out to be on PPC Hero, I’ve decided to expand my top 5 Excel tips for PPC managers for our week-long series on Excel! Excel is an invaluable tool for PPC management, and everyone ends up developing a personal style and tricks. If you haven’t read the original post, here are my top 5 tips for PPC managers. It included … [Read more...] about EXCELlent Series: 5 MORE Top Excel Tips for PPC Managers
EXCELlent Series: Using Excel To Boost PPC Performance
Love and marriage, love and marriage, goes together like Excel and pay-per-click... ok so maybe that's not exactly how the song goes, but if Excel was around in 1950's I'm sure 'Ol Blue Eyes would have been singing those words. As PPC account managers, we spend most of our day in Excel sorting and summing and doing just about anything else we can to PPC data. You truly can't … [Read more...] about EXCELlent Series: Using Excel To Boost PPC Performance
My Top 5 Excel Tips for PPC Managers
This post is in response to you, our readers! In case you haven’t noticed, we’ve added a box at the bottom of the page where you can write to the PPC Hero team with ideas for us to write about next. This is great as it allows us to give the people what they want and learn things that maybe we hadn’t thought of visiting before. Thanks for all your responses! Now on to my … [Read more...] about My Top 5 Excel Tips for PPC Managers
Everything You Need To Ace Microsoft’s adExcellence Exam
I detest taking tests. So when I learned I would have to take the Microsoft adExcellence exam, it was enough to make me want to fake sick, convince my best friend to let me take his father’s prized Ferrari convertible on a joyride to downtown Chicago, and inevitably end up on lip synching twist and shout on top a float in the Von Steuben Day Parade. My main area of concern was … [Read more...] about Everything You Need To Ace Microsoft’s adExcellence Exam
Align your bids with your CPA within 5 minutes using AdWords Editor and Excel
That’s right, changing your bids isn’t something you want to spend a lot of time on, and if your goal is to reach a certain CPA (or CPL, CPS, CPO, etc.) it doesn’t have to take you much more than a couple of minutes, even for large accounts. But before giving you the theory and step by step instructions, there are a few things we should agree on about the kind of bid … [Read more...] about Align your bids with your CPA within 5 minutes using AdWords Editor and Excel
Win One of These Excellent Books in Our Awesome SEM Giveaway!
As part of our $16,000 Search Engine Marketing Giveaway, we’re giving away 100 free copies of some great SEM books by excellent industry authors. We wanted to introduce the books to our readers in case you haven’t heard about some of them! If you find one (or two! or three!) you'd like, enter our free contest- you can specify which book you’d like to receive if you’re randomly … [Read more...] about Win One of These Excellent Books in Our Awesome SEM Giveaway!
10 Things I Wish I Knew Before Starting In PPC
I’ve been working at a digital marketing agency for nine years, the last three focusing specifically on PPC. I still have plenty to learn, but over that time I’ve picked up a lot about this industry. My goal here is to provide some early lessons, so you don’t have to make the same mistakes I did! 1. Learn About The Business First If you don’t understand the company you’re … [Read more...] about 10 Things I Wish I Knew Before Starting In PPC
The Ultimate Campaign Quality Assurance Checklist for 2024
Quality assurance is a large part of running PPC initiatives. When new campaigns are built for an account, it is of utmost importance to to conduct a thorough quality assurance (QA) process to ensure that everything is set up for success. Below is a comprehensive guide to all the boxes you need to tick before setting your campaigns live. Campaign Settings Quality … [Read more...] about The Ultimate Campaign Quality Assurance Checklist for 2024
