Excel

Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office.
Posts about Excel
  • RStudio for PPC: A Beginner’s Intro

    … which is great for developing projects and working through a new analysis. But I like Excel! RStudio Pros and Cons Pros: Pulls data quickly (can pull large quantities of data) Can link directly to Google Analytics and AdWords Can pull directly from Google Sheets, or an Excel / CSV file Generate graphs with simple lines of code Repeatable…

    Rachael Law/ PPC Heroin Paid Search- 11 readers -
  • Troubleshooting Lookup Functions in Excel

    … Last week, Hanapin hosted an Excel Extravaganza, which was a compilation of 3 Excel for PPC webinars in 3 days. On day 3, Lara and I discussed bidding methods with Excel. I specifically discussed bid tables and how to use Lookup functions to automatically pull bid changes from a bid table. We discussed how to write lookup functions, specifically…

    PPC Heroin Paid Search- 9 readers -
  • Projecting Future Trends In Your PPC Account

    … can’t expect something like conversion rate to increase every period and you’ll hit some maximum sooner rather than later. Resources Easily Project the Future Performance of Your PPC Account Five Steps to Master FaceBook Projections Not Predictions Regression Regression can be challenging in PPC due to the general noise in the data…

    Jacob Fairclough/ PPC Hero- 15 readers -
  • EXCEL-eralte Your Learning with Hanapin’s PPC Library

    … Next week, Hanapin kicks off a week long celebration of Excel in the Excel Extravaganza. The whole thing includes 3 webinars and handy resources on the most essential tool in PPC. It’s definitely something you don’t want to miss. DID YOU KNOW YOU CAN SEARCH FOR ALL THINGS EXCEL IN HANAPIN’S PPC LIBRARY?? It’s true, Hanapin Marketing has…

    Jamie Newton/ PPC Heroin Paid Search- 15 readers -
  • 6 Things You Didn’t Know You Could Do In Google Sheets

    … formatting that Excel does, so this is a workaround if you want to show bar coloring. 4. Import From Other Sheets Function Used =IMPORTRANGE() Syntax IMPORTRANGE(spreadsheet_key, range_string) spreadsheet_key – The URL of the spreadsheet from where data will be imported. The value for spreadsheet_key must either be enclosed in quotation…

    Rachael Law/ PPC Heroin Paid Search Google- 17 readers -
  • Extracting Text in Excel for PPC

    … October 19, 2017 Working with text data is a necessary part of analysis but often overlooked in skill development. This leaves gaps in analysis and adds time and tedium to common tasks. Your ability to work and manipulate text greatly enhances your workflow and effectiveness. Splitting keyword, ad text, or campaign structure allows you…

    Jacob Fairclough/ PPC Heroin Paid Search- 19 readers -
  • Your Facebook Ads Are Working – Here’s How To Prove It

    …. Furthermore, having an organized GA account is always a plus. Other than that, it is fairly straightforward. You’ll need access to the Facebook data, Google Analytics data, and excel. Plus, you should have a certain time period in mind. In this example, I’m using a client’s busy season, which is around five months worth of data. Step 1 – The Download…

    PPC Heroin Social Facebook How To's- 17 readers -
  • PPC Excel Shortcuts You’ll Never Want to Forget

    … July 3, 2017 We all know that Excel can save you valuable time in your PPC. The latest and greatest Excel tricks are just out there waiting for you to grab a hold of and run with. What’s the problem? The problem is you barely have enough time to breathe, let alone do hours of research on the updates that could save you time. Ironic, right…

    PPC Heroin Paid Search- 14 readers -
  • Using Excel Regressions To Better Understand KPIs

    … is, the process for setting up and determining the value of your regression model is the same. Step 1: Prepare Your Data As with any analysis, a good result requires quality data that has been correctly prepped. For good regression results, you need a sufficient amount of data (at least as many data points as the number of independent variables…

    PPC Heroin Affiliate Paid Search- 21 readers -
  • FAME: Exploring Facebook’s Ads Manager for Excel

    … ways? Fortunately, there are a plethora of reporting or analysis tools available for this purpose, with the number of options growing with time. If you’re one who relies heavily on spreadsheets for your data management needs (a common trend in PPC as hinted at by the volume of our articles detailing Excel or Google Sheets alone) then you’re…

    PPC Heroin Paid Search Facebook- 19 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- 20 readers -
  • Building An Automated PPC Spend Tracker In Google Sheets

    … March 24, 2017 With yesterday’s webinar on efficient data analysis through Google Sheets, as well as Tuesday’s post pitting Excel features in their very own March Madness tournament, this week on PPC Hero we’ve highlighted one of the most important pieces of the digital marketer’s toolbox: spreadsheets! Today, we’ll continue the trend…

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

    … March 21, 2017 In light of the March Madness season it was thought that we could have some fun and review some of the previous PPC Hero articles on the best ways to utilize Excel in order to more efficiently and effectively manage PPC accounts. First, let’s choose the seeds for the respective functions. Their are four regions just like…

    Jacob Brown/ PPC Heroin Paid Search- 28 readers -
  • The Simple Beauty Of A PPC Bid Template

    … the other platforms I had at my disposal for this account. Back to square one. Here is the truth: sometimes the best answer is not only the simplest but also staring you in the face like, “I’m right here, numskull!” Enter the Excel Template. No, this is not something you have to download. This is not an Add-On. This is simply creating…

    PPC Heroin Paid Search- 37 readers -
Get the top posts daily into your mailbox!