Ppc Excel Tips

  • 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- 14 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!

    … Over the years, I've discovered that one of my favorite account structure strategies involves the use of two specific tactics: ad group segmentation by match type and embedded negatives. It allows for a level of control in your matched queries that a tiered bidding strategy simply can't match (as proven by Rachael in the linked article above…

    PPC Hero- 25 readers -
  • 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…

    PPC Heroin Paid Search- 11 readers -