Excel Mastery

  • Mastering Excel For PPC: An Advanced Series for Better Marketing Results in 2017

    … Fix These 5 Common Excel Issues To Achieve Pro Status 1:00pm – 1:30pm EST Excel, while a fabulous tool for PPC, is not without its occasional hang-ups – as PPC thought-leaders, who would we be if we didn’t address them? In this live webinar, Account Analyst Rachael Law will ease your mind with solutions to all the common Excel issues, so…

    PPC Heroin Paid Search- 15 readers -
  • Simple Tips To Enhance Your Excel Spreadsheets

    … Every now and then you stumble across an Excel tip or trick that blows your mind. However, this won’t always be the case and as your skills progress these insights are harder and harder to discover or take more effort than they are worth. Rather than going bigger, it is often much easier to take a step back and recognize little tricks you…

    Jacob Fairclough/ PPC Heroin Paid Search Twitter- 6 readers -
  • Win the Mobile Bid Battle with 3 Easy Excel Reports

    … that you pulled your Average Position- just include the columns that examine your Lost Impression Share due to Rank and/or Budget. Budget is slightly less useful, as there’s no way to control spend distribution by device (thanks, Enhanced Campaigns), but it can give you an idea of where your money will be going should you decide to increase your budgets…

    PPC Heroin Paid Search Google- 11 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- 27 readers -
  • Project Your Ad Spend During Back To School Season

    … "Back to School" week continues as Hayley provides formulas that you should consider using to determine your visibility and spend during this important time of the year. If you haven't yet, read Amanda's post on "4 Steps To Back To School Success." Back to school means increased consumer shopping. Your target audience will be in the market…

    Hayley Cummings/ PPC Hero- 7 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 -