Category: Data/Analytics

Analytics Advice

Posted on

Episode 103: Data First Marketing, with Janet Driscoll Miller

If you’ve listened to this show, you know that I believe we can base all the marketing decisions we make on data. This fourth book in our Marketing Books summer series talks with an author who’s extensively described how we get data in a form that helps us make decisions.

Janet Driscoll-Miller brings over twenty years of search engine marketing experience to Marketing Mojo and is considered a leading expert in her field. Janet has spoken at search engine and marketing conferences including Digital Summit, SMX Advanced, MarketingProfs B2B and Pubcon. Janet is also a frequent guest lecturer at colleges and universities including the University of Virginia and James Madison University.

In 2020, she co-authored Data-First Marketing with Julia Lim.

People/Products/Concepts Mentioned in Show

Posted on

Episode 101: Age of Customer Equity, with Allison Hartsoe

Think of the data you have on your customers as having value. It does, by the fact that the more you know your clients, the better you can serve them. This “unlocked potential revenue” of all your current customers can be quantified as your whole customer’s lifetime value (CLV) added together. 

This number is known by finance people as Customer Equity, but it’s much more than a mathematical formula. The value that VCs and public markets have put on assets such as loyalty programs and subscription lists is often greater than the value of a company’s capital assets!

While it might sound like it has to do with finance, this is all highly related to marketing. This is because each tactical decision gets vetted by whether it will optimize CLV; it becomes your company’s North Star.  

Allison Hartsoe has strategize d the digital customer analytics for dozens of Fortune 500 customers throughout her career. She now leads an analytics consultancy in Portland OR, Ambition Data, and published the book, “The Age of Customer Equity”,  in 2021. She has been published in Forbes.com, MIT Technology Review, and Fast Company and somewhere in between all this writing, she found time to cycle across the USA. 

People/Products/Concepts Mentioned in Show

Posted on

Episode 99: Tying Revenue back to Traffic, with Steffen Hedenbrandt

Disclaimer: When I bring technology vendors on the show, you should know that they are not sponsors or affiliates. They’re simply here to give you a broader perspective.

If you have been to the eye doctor for near or far sightedness, the equipment that’s likely been used to assess you is a phoropter. The part that’s put in front of your eyes looks somewhat like a pair of glasses, but it branches out from that with an imposing array of lenses, dials and machinery. You are shown an eye chart and the doctor flicks through alternate lenses, asking you to say whether the image is clearer with lens 1 or lens 2. When tests on the phoropter & other equipment is done, you end up with lens prescriptions that are right for you. 

This process isn’t unlike what’s behind marketing’s use of attribution models. They serve to show what impact advertising channels have on a company’s revenue, with pre-set models, each one weighing the impact of digital touchpoints differently. By attributing revenue back to the channels and campaigns that helped acquire it, you get a clearer view of what you are getting for your marketing dollar. 

Of course, marketers don’t use phoropters, but doing attribution analysis does take specific tools, and that’s what this episode takes us through. 

My guest is Steffen Hedenbrandt, who’s growth-oriented, data-driven and loves all parts of scaling a business.  He worked at places like Upwork and Airtame before cofounding DreamData, where he serves as the Chief Marketing Officer.He has a bachelor’s degree from Aalborg University and a Masters from Copenhagen Business School. 

People/Products/Concepts Mentioned in Show

Posted on

Episode 93: Visualizing & Making Data Valuable, with Eric Boissonneault

In its raw form, data’s not worth much. If refined and put together with other data, it can be worth a lot. Here are well-known brands that built their value by creating a useful visual experience out of user-generated data:

  • Notable Examples:
    • Glassdoor
    • Nest
    • Zapier
    • Mint
    • Robinhood
    • Flipboard
    • Ancestry
    • GoodReads

This episode’s guest will help us see what is possible once you have data in your hands. Eric Boissonneault grew up loving numbers, but it wasn’t until he saw a Hollywood movie about card players at age 16, that he knew how he would apply his skill. He taught himself poker and methodically played this ‘game of chance’ so well that He became a professional player through his years at University du Quebec à Montreal and beyond. 

After cashing his poker chips in, he wanted to show the business world how they could look at the data they have on-hand as the basis for decisions. In 2020 he founded data consulting company Systematik to help businesses untangle, collect, visualize and understand their data.

Listen in this episode for Eric’s explanation of how you can put a unique transformation or twist on the data you already have, and even make an application that monetizes the data. 

People/Products/Concepts Mentioned in Show

How fast will you hit Google Sheets 5-million cell limit? If you have a spreadsheet with 5 tabs and each tab fills columns A to CW, and there is 10000 rows of data in each tab. It happens faster than you think.

Posted on

Episode 83: Quantifying Your Marketing Funnel’s Revenue with Keith Perhac

Disclaimer: The company featured here is not a sponsor of the show, nor have I affiliated with them. They simply bring a perspective that I think you’ll get some use from.

“It’s not working.” That’s the gist of every complaint made about marketing funnels. Marketers painstakingly build a series of offers and pay for traffic to see them, but the conversion rates drop off somewhere between there and the point where sales close.

Can funnels be fixed? Absolutely, but not without knowing a critical piece of data. Getting that data that helps fix the suboptimal parts of the funnel is our focus today. 

To go through this I’m joined by Keith Perhac, a digital marketing expert and software entrepreneur. After growing up in the states, he headed to Japan to become what’s known there as a salaryman. He moved back In 2010 to work with startups and digital marketers looking to grow quickly. He founded SegMetrics, a tool that lets you see revenue from the perspective of each touchpoint in your marketing funnel. Since then, he’s appeared on over 35 podcasts & in 2020 published the book we’re here to discuss, “Building Marketing Funnels that Convert, a 90 minute guide”

When he’s not working on SegMetrics, Keith draws and attempts (futilely) to spend more time outdoors. He lives in Portland, Oregon with his wife and two daughters.

People/Products/Concepts Mentioned in Show