Posts

How I Automated Campaign Monitor in Zapier Without CSV Parsing (Real-Time JSON FTW)

🔥 Stop Parsing CSVs in Zapier: Flatten Campaign Monitor Custom Fields with Real-Time JSON A one-step JavaScript solution inside Code by Zapier to bypass broken webhook parsing and get clean Campaign Monitor custom fields in real time. 🚧 The Problem When using Zapier webhooks with Campaign Monitor , custom fields are often sent as flat CSV-style strings — and if your address or company name has a comma? Everything breaks. Result: Your subscriber's "Suite 200" ends up in the zip code field. Gross. 🧠 The Solution Skip the CSV hell completely. I built a Code by Zapier step that: Calls the Campaign Monitor API directly Authenticates with btoa(apiKey:) Parses real-time JSON Flattens CustomFields into a clean object No CSV splitting. No duct tape. Just clean data. 💻 The Code (Inside Zapier) const apiKey = "YOUR_API_KEY"; const listId = "YOUR_LIST_ID"; const email = inputData.email; const authHeader = btoa(`$...

Webinar Wisdom: Unveiling Three Essential Insights for Hosting Success

Image
A few weeks ago I hosted my first webinar called  Ask CTE Contributors: High-Pressure Coolant for Deep-Hole Drilling . Here are three things I wish I had known before I hosted the webinar: 1. Put script eye level with your webcam so that you are not looking down. This is a mistake that I made in this webinar, you can see me looking down reading off of my iPad in a lot of the introduction. To add to this point, try not to sound robotic and try to use the script as a guide not word for word. 2. My guests kept getting kicked from Vimeo , our webinar hosting software. My advice, have the technical rehearsal a few days before the event rather than just the day before. It was only after the webinar did I figure out it was due to my poor wifi signal, so ethernet fixed my issue. If we had done the technical rehearsal sooner, who knows, maybe this technical error could have been avoided. 3. Make sure that you can see the chat clearly. I had my laptop kind of far from me, and as a result, I ...

SOS Mode: AT&T Nationwide Outage...Solar Flare? No Service?

Image
Wow. Thursday, February 22nd 2024 8:13 a.m. CST. Well-good morning, If you have AT&T, you probably woke up to find that you and all of your family members had lost service. Maybe your phone said SOS, or SOS Only. Maybe calls just never rung. Maybe it's just too early to deal with this. I don't know, but many unconfirmed sources say that this is due to solar flares. My only question is: what's next? Is cell service the only things solar flares can affect? What about WiFi? I guess the vague AT&T notification will have to do until we hear more information. "Some functionality may not be available at the moment." Update as of 9:33 a.m. CST According to @Superdave14 on X (formerly Twitter), "AT&T provided no official reason for the outage, the issue appears to be related to how cellular services hand off calls from one network to the next, a process known as peering, according to an industry source who spoke on the condition of anonymity." Copyrig...

DMARC: Why have my emails suddenly stopped delivering? AND HOW TO FIX IT (CONSTANT CONTACT | MAILCHIMP | EMAIL MARKETING PLATFORMS | CUSTOM DOMAIN)

Image
If you have been using your own domain for your email, you are going to want to read this. Recent changes have been put into effect this month (February, 2024) that affect you if you are using your own domain for your email. Do you send out email blasts? Did your open rate recently plummet? The answer is only five letters: DMARC. Beginning 2024, you must enable DMARC. To Enable DMARC: Add a TXT record to your DNS with a host of: _dmarc.yourdomain.com and a value of: v=DMARC1; p=none Pick your desired TTL and save the record.  You can use this website to check if DMARC has been enabled for your sending domain. It can take anywhere from 24-48 hours for the TXT record creation to go into effect. Copyright © 2024 Timothy Spaeth

A Busy Schedule

Image
By Timothy Spaeth      As I grow older, I feel as if I never have any downtime. Day-to-day errands, chores, my son Xavier, work, food, mental stress, the need for entertainment and sleep are just a few of the many things that keep me occupied from the second I wake up, to the second I go to sleep. Upon review of an interactive online graph that compares the average hours per day spent on a given activity by a list of selected activities, created and maintained by the U.S. Bureau of Labor Statistics (BLS) with data from 2022, I realized that these activities give my life meaning; in other words, I realized these activities are my purpose. The activities mentioned in the graph that I related to the most include: "Personal care, including sleep; Eating and drinking, Household activities, Purchasing goods or services, Caring for and helping household members, working and work-related activities." As a Dad, I have to care for and feed Xavier and I everyday, I have to keep my h...