Excel Solver is a fantastic tool, but most examples only cover simple marketing use cases. We’ll cover the next steps of enhancing your models and how to automate the process.
Excel
How to Automate Excel Solver
In this article we’ll go in depth from start to finish covering the concepts and methods step by step. By the end you’ll be able to automate any of your own personal models and scale your analysis.
How Excel Macros Save Digital Marketers Time
In this post, we’ll talk about the steps necessary to get your macro set up, where they are best applied in your daily PPC grind, and how they save time.
Continue Reading How Excel Macros Save Digital Marketers Time
Hero Conf Austin Keynote Announcement!!
Ogilvy's Dan Bennett will kick off Hero Conf Austin! Dan co-leads the behavioral science practice within Ogilvy Consulting London. See what his keynote's about.
Sheets & Excel Tips for PPC Newbies
Learn some helpful excel and sheets tips and how to apply them to everyday PPC account management, so you can excel at your job.
Excel Masterclass for Digital Marketers: 3 Sessions to Supercharge Your Efficiency
This webinar will be a deep dive into Excel. The 3 mini-sessions are geared towards improving the way you work.
Continue Reading Excel Masterclass for Digital Marketers: 3 Sessions to Supercharge Your Efficiency
A Deep Dive Into Advanced Pivot Tables for PPC
A deep dive into how to look at audiences, ad copy, and data over time through quick and easy Excel pivot tables.
Continue Reading A Deep Dive Into Advanced Pivot Tables for PPC
Excel For Marketers: Make Your PPC Dashboards Dynamic With Data Validation
PPC dashboards are great for account managers, but they're even better if they're dynamic. In this post, I'll walk you through the steps to create a dynamic dashboard.
Continue Reading Excel For Marketers: Make Your PPC Dashboards Dynamic With Data Validation
How to Pivot Paid Search Data in Excel
Create Pivot tables to analyze how campaigns are performing across different marketing platforms, campaign type, and client-specific goals.
How to Forecast Spend Potential for Paid Social Campaigns [Free Tool]
Ideating and building strategies is often much more fun than presenting your plan and being pressed by the question, “what am I going to get from this?” Today, we go through two approaches, including a free tool, to forecast spend...
Continue Reading How to Forecast Spend Potential for Paid Social Campaigns [Free Tool]
Index Match: The Better Alternative to Vlookup
VLOOKUP is one of those functions that makes Excel great. VLOOKUP has its issues though. Don't worry there is an alternative, INDEX MATCH. Not only does it replicate the functionality but has its own perks and bonuses. By the end...
Continue Reading Index Match: The Better Alternative to Vlookup
Free PPC Training for the Noobs at Your Agency
Hero Academy offers short, entry-level how-to training videos for marketers new to paid media at no cost. Perfect for an employee that just started working at your digital marketing agency.
Continue Reading Free PPC Training for the Noobs at Your Agency
