JustControl.it: Automate Attribution Data Collection Across Channels

Digital marketing is driven by a need for greater customization: new data sources, fresh combinations of partnerships, ever-changing rates, sophisticated UA scenarios, etc. As for the future of our industry, it promises to be even more challenging and granular. That is why successful and aspiring professionals need workable leverage to deal with complicated situations and complex pictures. However, a lot of existing tools still offer an outdated ‘one-size-fits-all’ approach. Within this first framework, all the

CSV Explorer: Work With Large CSV Files

CSV files are foundational and are typically the lowest common denominator of importing and exporting data from any system. We’re working with a client right now that has a very large database of contacts (over 5 million records) and we need to filter, query, and export a subsegment of the data. What is a CSV File? A comma-separated values file is a delimited text file that uses a comma to separate values. Each line of

Email Marketing: Simple Subscriber List Retention Analysis

People underestimate the value of a subscriber. Here’s a breakdown of how to not only measure the value, but how to analyze list retention to identify where to acquire new customers and how many with list retention analysis. Sample worksheet included!

Common Data Cleanup Formulas in Excel

For years, I’ve used the publication as a resource to not just describe how to do things, but to also keep a record for myself to look up later! Today, we had a client that handed us a customer data file that was a disaster. Virtually every field was misformatted and; as a result, we were unable to import the data. While there are some great add-ons for Excel to do the cleanup using Visual

Adverity: Connect, Manage, and Analyze Your Marketing Data

One project I’m continuing to work on for one of my clients is to build out marketing dashboards that provide some real data to make decisions on. If that sounds easy, it’s really not. It’s not easy. Every search, social, ecommerce, and analytics platform have their own means of tracking data – from engagement logic to returning or current users. Not only that, but most platforms don’t play well with pushing or pulling data to

Excel Formula for Scheduling Social Updates by Day of the Week

One of the clients that we work with has a fairly consistent seasonality to their business. Because of this, we like to schedule social media updates far ahead of time so that they need not worry about hitting those specific dates and times. Most social media publishing platforms offer a bulk upload capability to schedule out your social media calendar. Since Agorapulse is a sponsor of Martech Zone, I’ll walk you through their process. As