Microsoft Power Query is a useful tool to work with data inside of Microsoft Excel. It comes with a lot of features that make managing data sets simple yet powerful. Power Query is most useful when working with multiple sets of data, rather than just one. It acts as a bridge between sets of data […]
How to Combine Multiple Data Sets in Microsoft Excel Using Power Query Read More »
Spying on your competitors’ marketing efforts is one of the most efficient ways to come up with your our marketing campaigns, learn new tactics as well as predict the future of your niche. The powerful driving source of any business is its competition. Competitors force us to move forward, implement changes and evolve. I am
Three tools providing actionable competitive research insight Read More »
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 help. More often than not, this will come down to your unique situation and needs.
To say that there are a host of factors impacting your website performance is to state the obvious, but are you currently measuring all the different factors involved? On any given day, both online and offline channels drive traffic to your site. Online traffic via paid search, social media and display are easily measured in
TV Advertising Effectiveness: How to Measure & Analyze Television Ads Read More »
If you’re an ecommerce company who sells products in-stores, estimating foot traffic by location can be tough. However, it can often glean important insight about your customer’s journey. Here’s the good news – activating GA 360 and having your Google Ads account linked gives you access to a new feature that helps you analyze exactly
Tie Together Offline & Online Engagement with ‘Store Visits’ in Google Analytics Read More »
The practice of collecting basic demographic information from customers to create a successful business marketing strategy is one of the past. In recent times, there has been a major shift in the way that businesses interact with their customers. The digital space has spread so far and wide that it has had a lasting influence
How AI Is Shaping the Future of Content Marketing and Personalization Read More »
Hotjar has incredible functionality, with tons of ways to get to know your users better. Hotjar allows you to visualize how users engage with your site. Hotjar uses interactive heatmaps of their clicks and actions, recordings of their sessions, and gathering of their words from survey and feedback polls to help you build a strong,
Getting into data visualization for finding new opportunities and accelerating analysis? Me too! But there’s a few best practices I’ve learned along the way when connecting datasets by URLs. When might you want to connect by URL? Here’s a few outputs I find I’m generally connecting on the URL level where I need to really
Gone are the days of using an “industry standard” click-through rate. While these studies are fantastic information to understand how click-through rate (CTR) varies overall between industries and devices, why are we still using other domains’ data to make calculations that impact our bottom line, when we could use our own data? The issue I
Leveraging PowerBI for marketers is a game changer. It’s completely changed the way Wil and Seer works for our clients. As part of Wil Reynold’s MozCon 2018 presentation that is happening this July in Seattle, we’re inviting conference attendees to participate in an interactive workshop that will show you how to break down silos in
Get the Most Out of Wil’s MozCon Presentation – You’ve Got Homework! Read More »
