In this post, we’ll discuss what a macro is, why you’d want to use one, pros and cons, and how to get started with writing Visual Basic for Applications (VBA).
Excel
How To Perform Excel Lookups With Multiple Criteria
We’ll discuss Vlookup examples for the purists and a couple of other functions for those who want to add multiple criteria.
Continue Reading How To Perform Excel Lookups With Multiple Criteria
[New Flash Webinar!] Mastering the Art of Ecommerce Reporting with Excel
Experts from Hanapin Marketing walk you through a number of reports and calculations you can use in excel to make sure you have the most relevant and valuable information for your ecommerce accounts.
Continue Reading [New Flash Webinar!] Mastering the Art of Ecommerce Reporting with Excel
How To Find Your Competitors’ Bidding Schedule
When digging into Auction Insights in the AdWords interface, you are able to utilize segments, with time and device as the options of segmentation.
Continue Reading How To Find Your Competitors’ Bidding Schedule
Helpful Excel Functions For Building URLs
Building URLs is a common pain point for marketers. Thankfully, we can take advantage of Excel or your choice of spreadsheet to efficiently implement.
5 More Excel Tips To Get You Through Your Workday
Excel is capable of doing so much more than what the majority of people use it for, so today we’ll go through a few features that are commonly overlooked.
Continue Reading 5 More Excel Tips To Get You Through Your Workday
Understand Your User Flow: Creating Funnel Charts In Excel
There are often multiple steps along the pathway from visitor to purchaser. Funnel charts can help clarify the numbers to analyze performance by step.
Continue Reading Understand Your User Flow: Creating Funnel Charts In Excel
Creating Better Client Facing Reports With Excel
By taking the time to create an Excel template that you can plug data into, you can save precious time that you can spend on analysis and strategy.
Continue Reading Creating Better Client Facing Reports With Excel
Make Better Projections With Excel’s “What-If” Analysis
In this article, we’ll cover What-If analysis through Excel as a way of determining and analyzing projections.
Continue Reading Make Better Projections With Excel’s “What-If” Analysis
[New Whitepaper!] Beginner Excel: 10 Must-Haves For PPC Newbies
In this whitepaper, you’ll get 10 tips that will have you zipping through data, pulling insights and optimizations like a pro.
Continue Reading [New Whitepaper!] Beginner Excel: 10 Must-Haves For PPC Newbies
The One Metric We All Should Be Using in Our Bidding Strategies
Using impression share when changing bids is extremely important and average position does not take impression share into account. Use the impression metric.
Continue Reading The One Metric We All Should Be Using in Our Bidding Strategies
How To Create Display URLs In Bulk
Have you faced a tight deadline and needed to create hundreds or thousands of new display URLs? This post is for you!
