PHP script to export web push subscription stats from SendPulse

Steps to use:

1. Download the archive.
2. Exctract it.
3. Enable API access in your SendPulse settings.
4. Make the needed amendments to the script:
1. set your API_USER_ID and API_SECRET.
2. add the list of your domains into $country_mapping variable
5. Run the script with php index.php > senpulse.csv (PHP 7+ needed):
6. Wait for the script to finish (average speed is ~60k subscribers per hour).

Important! The exported data  isn't enough for transfering yoour subscribers to other web push service provider. It's good only for stat analysis.

Not the best way to make you emails recognised by AliExpress

Just see the 'friendly' from name sent to a customer from Russia:

Someone else's thoughts on comms frequency

Last week I've been speaking with a marketing manager from another company. She told me a remarkable thing:

"Andrey, clients who are not engaged with our product recently should be targeted by our email notifications more frequently in order to make them buy our stuff"

I've been shocked, to be honest.

Reply by email to a reported issue which impressed me

It's really hard for me to find a thing to write about in this blog lately as I've basically seen it all in email marketing. But today I've got an epic story for you.

Last week I've reported my bank an issue in their mobile app. And asked to provide a reply via email address. Few days after I've got an email, below are the steps I had to take in order to actually read their reply:

1. I opened the email, it said that the reply is provided as an encrypted email in a second email message. The first email also had a pdf manual attachment explaining how to open an encrypted email (sic!).
2. I scrolled down to the second email message and found it has some kind of an attachment (probably the encrypted email reply) and a link to read it.
3. After clicking the link I had to set up some sort of an account in a system allowing to read encrypted emails in a browser (sic!).
4. Then I've seen a content of an encrypted email, saying that the reply itself is attached as a pdf document.
5. I opened the pdf attachment and found out it's just saying 'sorry for the bug, you can do this in an office'.

OMG, that was sick!

Renault email marketing manager probably is a good guy, but...

Why did I get an email saying 'While you're waiting for a car to be delivered...' when I've been driving the car for 2 weeks? Yes, I understand that usually, you have to wait for a car to be delivered, but that's not my case.

Not enough details in a LinkedIn email

I'm not a fan putting all the possible information in an email and turning it into a landing page. So I personally prefer to keep 'em short and effective in terms of CTR. Anyway, sometimes I feel that an email is missing really important information which just *has* to be there.

Here's an example of this situation - an email about my LinkedIn job application. Will you be able to guess what's missing?

Guys, the company name is missing. Email marketing positions are named pretty much similar, so I need the company name in order to remember my application. And it's just not there, and I have to click on a link (no button or CTA, by the way) in order to learn it. And I won't be doing so 'cause I'm reading it on mobile.

Nice email marketing where you don't expect it

I've visited a nice karting place a week ago. I have to admit it has a great management system right from the start - initially you create you racer's profile with a PC stand and then you actually get a chance to drive.

I've been impressed a day after the visit when I finally checked out my inbox to find an email... coming from the venue. And it was just great - not the usual marketing bullshit, but the results of the races I've had on the previous evening.

We're so obsessed with finding best touch points with our customers that we totally forget about the businesses and cases when desirable email content comes straight from client's situation.

Anyways the email isn't perfect. Take a look at its poor view on mobile: