Ppc Excel Tips

  • 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- 18 readers -
  • Account Structure and Reporting in Excel

    … already have an account set up? You can see if your campaigns are laid out in this way but with an unorganized naming convention. Sometimes all it takes is renaming of campaigns in order to make reporting easier. Renaming of campaigns will not impact current Quality Scores, so there is no true risk there. The great thing about this campaign structure…

    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!

    …). However, this strategy does have one hidden downside: "low search volume" keywords. Before we get to that, it'll probably be useful to explain how embedded negatives work. To that end, I present exhibit A: In our sample campaign (aptly titled "Sample Campaign") we've got three ad groups segmented by match type. In each ad group, we've got…

    PPC Hero- 27 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- 12 readers -
Get the top posts daily into your mailbox!