Excel
Articles Tagged excel:
-
PHP and MySQL: Export a Query to a Tab Delimited or CSV File
This weekend, I wanted to build a PHP page that would back up any MySQL query or table into a Tab Delimited file. Most of the examples out on the net have the columns hard-coded. In my case, I wanted…
-
Keep Track Of Your Campaigns and Build Your UTM Querystring in Google Sheets (Free Copy)
We’ve been assisting a large e-commerce client with migrating to Google Analytics 4 from Universal Analytics and improving their campaign attribution to ensure they have accurate reporting on each of the mediums and channels they’re putting to use, including influencers.…
-
How To Migrate Events From Universal Analytics To Google Analytics 4
I’m not too confident in Google Analytics 4 despite the buzz being passed by the Google Analytics team. Companies have spent millions of dollars to enhance and integrate their sites, platforms, campaigns, events, and other measurement data within Universal Analytics…
-
Excel: Formulas for Scheduling Social Media Updates by Day of the Week And Random Times
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. Most social media publishing platforms offer a bulk upload capability…
-
Grow: Empower Your Marketing Team With No-Code Business Intelligence
Making data-driven decisions shouldn’t be the privilege of analysts or IT teams—it should be the superpower of every employee. Companies are often hindered by fragmented tools, inaccessible data, and slow, technical bottlenecks that hinder insights when they’re most needed. Grow…
-
CSV Explorer: Work With Large CSV Files Online
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…
-
Email Marketing: Simple Subscriber List Retention Analysis using Excel or Google Sheets
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…
