Ppc Excel Tips

  • Your Facebook Ads Are Working – Here’s How To Prove It

    … of those speak more from a qualitative perspective. In this post, I’m going to show how to use Google Analytics to make a better, more quantitative case for paid Facebook efforts. Everything You Need Before we begin, here is a quick disclaimer. For this process to work (at least this way), you must have your Facebook and GA accounts linked…

    PPC Heroin Social Facebook How To's- 16 readers -
  • 4 Forgotten Excel Tricks For PPC

    … May 10, 2017 If you are reading this post, it’s because you know that Excel saves precious time when analyzing PPC data and you want to stay up-to-date on the latest and greatest Excel tricks. I feel the same way! The problem is that we often forget to surf the digital marketing blogs for new Excel tips because we end up spending any…

    PPC Heroin Paid Search- 19 readers -
  • 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…

    Jacob Brown/ PPC Heroin Paid Search- 15 readers -
  • Excel Correlation, Causation, and Optimization

    … Excel. I graphed out the campaign metrics by month for 18 months, going from January 2013 – June 2014, and you’ll find them below in the order I looked at them. We’ll start with Impressions: I should *probably* focus my attention on the two outliers. Immediately, our attention is drawn to the two high-Impression campaigns. The red line…

    PPC Heroin Paid Search- 11 readers -
  • Low Keyword Search Volume? No Problem!

    … with the creative application of concatenate to match with campaigns and ad groups exactly. I'd recommend the following posts if you're looking to brush up on your VLOOKUP and concatenate skills: A Crash Course in Excel URL Generation 6 Excel Tricks to Save Your PPC Life Have any other tactics worth mentioning when dealing with the dreaded "low search volume" label? Any unintended consequences of a well-thought-out campaign structure come back to bite you? Let us know in the comments and, as always, thanks for reading! …

    PPC Hero- 28 readers -
  • Excel PPC Heat Mapping 101

    … you want to? There's an easier way to analyze that kind of data. Best of all is that it's fast, it's simple to use, and it's informative- it's an Excel feature called conditional formatting. And today, I'm going to use it to make a PPC heat map with just a few clicks. What is Conditional Formatting? Conditional formatting allows you to format…

    PPC Heroin Paid Search- 14 readers -