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.
Jacob Fairclough
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 to Validate Marketing Tags and Pixels
In this article, a Director of Analytics covers how to check which tags exist on a site, which information is sent, and proper tag setup.
Accounting for Future Performance in Paid Media
Changing circumstances can force you to confront the future. Planning ahead is essential and can better prepare you for what comes next.
Continue Reading Accounting for Future Performance in Paid Media
Taking Advantage of MCC Scripts for Multi-Account PPC Efficiency
Working at the account level can be restrictive. MCC level scripts provide a solution for handling many accounts to scale further and work more efficiently.
Continue Reading Taking Advantage of MCC Scripts for Multi-Account PPC Efficiency
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
Robust Reporting with Google Sheets Query Function
The reporting steps and examples in this article will assist in automating your own complex report and creating dynamic tables to save your time and sanity.
Continue Reading Robust Reporting with Google Sheets Query Function
Upgrade Your Data, Upgrade Your Analysis
It’s easy to hit a rut in your analysis. Problems become stale, questions feel like they will never be resolved, and there isn’t anything left to find in the data. This is where adding extra data sources or facets can...
Getting a Little Help with Your Bids – ECPC vs CPA Bidding
Beyond standard CPC bidding, Google Ads lets you choose two advanced options, enhanced cost-per-click and CPA bidding. This post serves as a primer to the bidding types.
Continue Reading Getting a Little Help with Your Bids – ECPC vs CPA Bidding
Starter Projects for New Coders
Knowing what to do can be one of the biggest challenges for new coders. In a previous article we covered choosing a language. Now you’ve made your way around tutorials on variables, loops, and functions but how can you apply...
Coding for Marketers – Where to Start
Choosing a language can be hard. This article walks you through the three main languages for digital marketing analysts.
Update Bids and Monitor Changes with AdWords Scripts
Explore different ways to use Google Sheets and AdWords Scripts to change bids and handle uploads. Get started with creating your own bidding system!
Continue Reading Update Bids and Monitor Changes with AdWords Scripts
