One of the most important things in a Google AdWords account is structure. It is incredible what a simple, clean structure can do for an account. A clean structure can help you with reporting, optimizing, quality scores, and build outs. In this whitepaper, we focus on build outs and have included an example excel sheet to get you started! In this Whitepaper we'll … [Read more...] about Secrets To Clever And Efficient PPC Campaign Build Outs In Excel – New Whitepaper!
Search Results for: excel
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
Win the Mobile Bid Battle with 3 Easy Excel Reports
Of all the issues we deal with in PPC, the question of what to do with mobile traffic seems to come up more often than the rest. In many ways, it's the next big problem we have to face (alongside attribution in general)- is there any value to this traffic? If so, how do we properly account for its value? And what role does it play in our marketing efforts as a whole? While … [Read more...] about Win the Mobile Bid Battle with 3 Easy Excel Reports
PPC Account Structuring and Campaign Building in Excel
For me, the most important thing when looking into a Google AdWords account is structure. It is incredible what a simple, clean structure can do for an account. A clean structure can help you with: Reporting (You can report on different levels more easily) Optimizing (Optimizations become easier with a clean account structure) Quality Scores (Ad copy to keyword … [Read more...] about PPC Account Structuring and Campaign Building in Excel
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
PPC Nation Excel Download
Please be sure to bookmark this page for future access to this file. … [Read more...] about PPC Nation Excel Download
Morning Clicks: Clueless Corporations, Beautiful Excel, and More
Morning Clicks is your mid-week roundup of digital advertising news and notes. We're your one-stop shop for the most relevant and important news in the PPC world. Grab your cup of joe and come see us every Wednesday morning. Hey, alright! Google finally introduced website click-to-call conversion tracking. [PPC Hero, Inside AdWords] It's a prudent marketer who learns from … [Read more...] about Morning Clicks: Clueless Corporations, Beautiful Excel, and More
Excel PPC Heat Mapping 101
Spreadsheets are hard. For the uninitiated, diving in to an AdWords or Bing-generated Excel file can be an incredibly daunting task. With the number of potential rows and columns in play, you might have to dig through hundreds, thousands, or even millions of cells to find actionable insights in these reports. I mean, you can... but why would you want to? There's an easier way … [Read more...] about Excel PPC Heat Mapping 101
Dynamic Data and Presentation Pizzazz With Excel PowerMap
When it comes to analyzing and optimizing search advertising campaigns, Microsoft Excel is one of the most powerful tools available, and can be found pinned to just about every search marketer’s taskbar or even home screen. When it comes to visualizing certain complex datasets, however, traditional Excel displays such as graphs, conditional formatting tricks and even pivot … [Read more...] about Dynamic Data and Presentation Pizzazz With Excel PowerMap
Excel Tips for Working With Modified Broad Keywords
We’ve mentioned it before, but Excel can be a lifesaver when working in PPC. If you know the right tips and tricks, Excel can not only save time, but help you be more accurate. I always create an Excel file to document any changes, or new campaign structure, that I want to implement in the AdWords Editor. Creating an Excel file with my changes helps me back-up updates I am … [Read more...] about Excel Tips for Working With Modified Broad Keywords
A Crash Course in Excel URL Generation
Generating destination URLs can be a pain. Depending on your tracking requirements, a destination URL can be as simple as copying your display URL... or it can stretch on in an unending parade of UTM parameters, category IDs, and referral identifiers. Today, we're going to talk about a few easy tricks you can use to streamline your own URL generation efforts. This is a pretty … [Read more...] about A Crash Course in Excel URL Generation