Reading Time: 4 minutes 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
JustControl.it: Automate Attribution Data Collection Across Channels
Reading Time: 5 minutes 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
Reading Time: 2 minutes 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
Reading Time: 3 minutes 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
Reading Time: 2 minutes 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