[New Whitepaper!] Beginner Excel: 10 Must-Haves For PPC Newbies

By Jamie Newton | @jnewton09 | Senior Communications Manager at Hanapin Marketing

If you’re just starting off down the road of mass data analysis, Microsoft Excel can be a little daunting. The secret, is that once you know a handful of tricks, it becomes pretty easy to figure out how to make Excel work for you.

In this whitepaper, you’ll get 10 tips that will have you zipping through data, pulling insights and optimizations like a pro.

In this Whitepaper we’ll discuss:

  • Using filters to start the process of finding your most relevant data
  • How to avoid the dreaded “#DIV/0!” error
  • Examples of using the SUM feature
  • Using freeze panes for a more efficient look at your data
  • Utilizing the =LEN function for character counting
  • Aggregating the contents of any number of cells
  • Creating a formula that generates a particular value when 2 sets of data overlap

New Paid Social Insights to Maximize Your ROAS

In this webinar panel discussion, Hootsuite’s Ryan Ginsberg, AdStage’s JD Prater, and Hanapin’s Steve Burnett will team up to walk you through all the new and exciting changes in social and offer opinions and strategies to use them for your benefit.

Amazon Updates AMS Reporting Abilities

Amazon has updated the Amazon Marketing Services (AMS) reporting abilities and insights. With the new reporting abilities, high-level account data is easily accessible and custom date ranges can be selected as well. There are also several new marketing reports that can be downloaded for more...