How to tell if a subscriber is active?

[Lakjin]

I see two tables -- campaign_track_url and campaign_track_open. I assume if a user (a) clicks a URL in an email then it is recorded in campaign_track_url and (b) opens an email then it is recorded in campaign_track_open. I also see last_updated column in list_subscriber.

Is there any other way to tell if a subscriber is active (i.e. still responding to your emails)?

 

[twisted1919]

Nope, those you enum are the only ones.

 

[frm.mwz]

I see two tables -- campaign_track_url and campaign_track_open. I assume if a user (a) clicks a URL in an email then it is recorded in campaign_track_url and (b) opens an email then it is recorded in campaign_track_open. I also see last_updated column in list_subscriber.

Is there any other way to tell if a subscriber is active (i.e. still responding to your emails)?

(even though this may not be a technical, but more a marketing answer)
One good way to see if subscribers are deleting/filtering to unseen archive is to offer a nice bonus/gift/addon/etc from time to time (perhaps no more than once a month and no less than once a year). If they react to it, then the above 3 tools help, otherwise, none will...but even so, long-term inactivity does not mean they do not wake up again at some point

 

[Lakjin]

Nope, those you enum are the only ones.

So the pixel within emails is able to track opens to people who use HTML emails -- does this work with all domains, even Gmail (I recall Gmail started caching pixels)?

 

[Lakjin]

(even though this may not be a technical, but more a marketing answer)
One good way to see if subscribers are deleting/filtering to unseen archive is to offer a nice bonus/gift/addon/etc from time to time (perhaps no more than once a month and no less than once a year). If they react to it, then the above 3 tools help, otherwise, none will...but even so, long-term inactivity does not mean they do not wake up again at some point

We do something like that

 

[twisted1919]

does this work with all domains, even Gmail (I recall Gmail started caching pixels)?

It works with gmail too, we have a trick for this

 

[frm.mwz]

It works with gmail too, we have a trick for this

How does it work (perhaps important to know to not break it)?

 

[twisted1919]

It's about sending some special headers that instruct gmail to not cache the tracking pixel

 

[Lakjin]

It's about sending some special headers that instruct gmail to not cache the tracking pixel

Or just using a "unique" image for each subscriber

 

[frm.mwz]

@Lakjin @twisted1919
Ah, you mean it is just renamed or changed in checksum?

 

[twisted1919]

@frm.mwz / @Lakjin - Each tracking pixel is using a unique url/hash/whatever since that's the way we can identify each subscriber