This is not a post on how to use the CONCAT function or how to make a pivot table. There has been plenty written about those useful Excel features....

We recently shared our favorite PPC tools for campaign management and reporting. Aside from those tools that we use frequently, we are also...

Search Term Reports.  In many ways, they are the backbone to the life and health of a PPC account.  They reveal to you how Google is interpreting...

Although I surely love coffee, I hope you don't use “coffee filters” more than data sorting filters.  My personal favorite filters in PPC are Excel...

Have you discovered the magic of Excel pivot tables? As PPC managers, we are up to our elbows in data, and pivot tables are an excellent tool for...

All of PPC is very detail-intensive. For me, tracking codes and tagging URLs can be  one of the most time consuming details. Make a mistake and you...

To manage PPC accounts, excel is a must and something we use every single day to manage data. Excel helps to cut through the exuberant amount of...

Happy holidays ...err.. happy holiday season! If you're reading this, it means you've already made it through Black Friday and you are about...

  Happy Thanksgiving! Here at Clix, we are thankful for so many different tools and features that make our life easier and more productive...

Lately when I have been pulling down my normal PPC reports from AdWords, I have been trying out different ways to finagle the data in the...

I love shortcuts when pulling reports and sorting data. I really dislike being inefficient with my time, so when learning something new or pulling...

Excel is your window to a more productive world. The more formulas, hacks, and shortcuts you can learn – the better. But you already knew that! We...

Last week, I had the opportunity to speak about optimizing for geography at HeroConf. In case you missed my panel, or would like to reference it,...

You know those accounts. The ones with tons of Campaigns, hundreds of Ad Groups, and ads with Destination URLs specific to one of those levels. Oh,...

"Can't we just pause anything under our goal CPA?" Sometimes it's hard to explain what an ecosystem a paid search account actually is. All these...

‘Twas the night before Christmas and all through the house, people were stirring - some with a mouse… The beauty of paid search is that it’s always...

Last week, the #PPC Chat topic was "Using Excel for PPC", and I've got to be honest, it was one of my favorite chats we've ever had. There were so...