Matt Hertig, Alight Analytics’ co-founder, recently spoke with TAAN President, Peter Gerritsen, about the data and analytics challenges facing the vast majority of marketing agencies today. In this short clip, Matt details how agencies are currently spending most of their time gathering data from source systems when performing …
Tackling the Marketing Measurement Challenge: Option 2 – Online Dashboard Solutions
Online dashboard solutions have grown in popularity over the past five years as simple, cost effective way to deliver automated dashboards. This type of solution is designed to allow marketers to connect directly to various types of common systems such as Facebook and Google Analytics …
How to Use Strings and Numbers in a Tableau Calculated Field
Transcript: Hi, this is Sean McLerran with Alight Analytics. Today, I’m going to walk you through a few functions in Tableau’s calculated fields, how to embed both text and numbers into the calculated field, and how to format your field to present your data in …
Integrating External Data into Google Analytics: Good Idea or Bad Idea?
Let’s assume for a minute that you are using Google Analytics on your website. And let’s also assume that you are doing paid advertising in other marketing channels such as Facebook, Bing and/or LinkedIn and you would like to know the ROI for these marketing …
Tackling the Marketing Measurement Challenge: Option 1 – Microsoft Excel & PowerPoint
Microsoft Excel, or the Marketer’s binky, as I often refer to it, has become the default solution to tackling the data challenge we face in Marketing today. The process goes something like this: We download multiple reports from all the marketing systems we use, we piece …
Tackling the Marketing Measurement Challenge: A Review of Five Primary Options
As the co-founder of a marketing analytics firm, I have found over the many years we have been in business that the two most common questions we as marketers need to answer are the following: What Happened? – Did this campaign work? Did we drive …
Excel Is Not a Database, So Stop Using It Like One!
Since its initial release in 1985, Microsoft Excel has grown to become a necessity for companies everywhere. It’s the most widely used spreadsheet software among the business community, and has been a robust tool for simple analysis and budgeting. The problem, however, is that a …
Smart Channel Mapping: Finding and Merging Similar Words
Analysis is hard. You have to formulate a question, find the data that purports to answer that question, slice and dice the data into something manageable, then maybe, just maybe, you’ll answer the question at hand. Oh, but if you mess something up or don’t answer …
Top 5 Tips for Successful Google Analytics Implementation
We’re a Google Analytics shop here at Alight Analytics. We’ve implemented Google Analytics on hundreds of sites. We’ve been a Google Analytics Certified Partner and Premium Reseller for a number of years. And just recently—not to toot our own horn—we’ve also become a Google Analytics …
5 Steps to Prepare for Data-Driven Omnichannel Marketing
The majority of the marketing and executive decision makers are convinced that using data to inform the decision-making process is not only worthwhile but necessary to operate in today’s marketplace. However, information about how to get started in this space is lacking. The purpose of …