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

How to Calculate the Lifetime Value of Your Mobile App User

We have startups, established companies, and even highly-analytics and sophisticated companies that come to us for assistance to grow their online business. Regardless of the size or sophistication, when we ask about their cost-per-acquisition and the lifetime value (LTV) of a customer, we’re often met with a blank stare. Too many companies calculate budgets simplistically: With this perspective, marketing winds up going into the expense column. But marketing isn’t an expense like your rent… it’s