Excel Tools

  • Using Excel Regressions To Better Understand KPIs

    … without an advanced statistical software (such as STATA). In this post, I’ll share the step-by-step for setting up and running regressions in Excel, and how this tool can help in your PPC analyses and account management. Excuse Me, I Regress Before we dig into the technical implementation, you might be wondering to yourself, “What in the world…

    PPC Heroin Affiliate Paid Search- 20 readers -
  • March Madness Continues: What Excel Tool/Function Rules Them All?

    … in the real tournament for the Excel Tools/Functions tournament. Regions Data Tools Advanced Functions & Formatting Simple Functions IF Functions Data Tools Seeding Pivot Tables – Seemingly the king of Excel, Pivot Tables had to get the one seed here. Reporting is probably the top reason to utilize a Pivot Table, but there are many different ways…

    Jacob Brown/ PPC Heroin Paid Search- 21 readers -
  • Quick Keyword Tool In Excel

    … Do you have an idea as to what your keywords should entail for you AdWords account, but want a quick way to come up with your list? A simple Excel formula can help with that. The first step is getting a grasp on what keywords will garner quality traffic. There are multiple keyword tools available to help with this type of research. Below…

    Jacob Brown/ PPC Heroin Paid Search- 5 readers -
  • 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…

    Jacob Brown/ PPC Heroin Paid Search- 15 readers -
Get the top posts daily into your mailbox!