How do I Export the Newsletter Subscriber List?

thomaswhiteeagle:

I have a question about the data exported using this mod.

Basically it is giving us 5 choices and counts:

all subscribers
dormant customers
active customer in last 3 months
active customers in last 3 months regardless of subscription status
customers who have never completed a purchase

does the first one (all subscribers) include everyone in the other 4 choices? (except probably the regardless of subscription status of course would include other customers that didn't subscribe)

Or for example is "all subscribers" only people that have made a purchase (and subscribed) and separate from the "customers who have never completed a purchase" choice.

all subscribers (As the name says all customers who are currently subscribed, doesn't matter how long or if they have ever made a purchase)

gilby:

all subscribers (As the name says all customers who are currently subscribed, doesn't matter how long or if they have ever made a purchase)

Hmm, ok then, well something doesn't add up.

Basically what we want to do is send out a newsletter to all customers that have made a purchase in the past. Preferably not a purchase in the last 3 months but can live with that. But the numbers don't add up if the first choice is everyone that has ever subscribed whether they have made a purchase or not.

because for all subscribers we have 6,059 people.

For dormant customer which means a customer that has ordered before but not in the last 90 days we have 3,947.

That leaves 2112 people which one would think would be made up of customers that have ordered in the last 90 days or never ordered.

But for people that have signed up but never ordered we have 4,046.

But then according to the numbers here you know we've had at least 3,947 customers plus whatever has ordered in the last 90 days.

So if all subscribers was/is made up of both customers that have ordered something in the past AND people that have signed up but never ordered anything then the "all subscribers" tally should be at least 7993 (3947 "all subscribers plus 4046 "never ordered anything").

Either something is not right, or it's not what we think it is or my math is really bad?

thomaswhiteeagle:

But for people that have signed up but never ordered we have 4,046."signed up" in this case means "created an account"
NOT "Subscribed" to the newsletter

It includes ALL who have created an account but never ordered (regardless of Subscription status)

So... of your 4046
2112 have purchased < 3 months ago
and 1934 have created an account and never ordered

gilby:

"signed up" in this case means "created an account"
NOT "Subscribed" to the newsletter

It includes ALL who have created an account but never ordered (regardless of Subscription status)

So... of your 4046
2112 have purchased < 3 months ago
and 1934 have created an account and never ordered

Still makes no sense, Because the numbers you suggest well, 2112 isnt the correct number that havent purchased in more than 90 days that number is 3947. Which then according to your argument would leave 99 that have signed up an account but never made a purchase. (Which sounds more realistic to me since we don't think thousands of people have signed up an account but never made a purchase).

But it seems a little contradictory since it says "Never ordered" but you are saying x number of the query of how many people signed up but never made a purchase are actually including ones that ordered more than 3 months ago (dormant). Makes no sense then why this field would even be there in such a way since dormant customers is already listed elsewhere. It should simply be the customers that signed up but never ordered anything, like it says it is otherwise without your explanation it makes no sense whatsoever but seems to reveal a flaw then in the mod.

Too, knowing which ones have signed up but never made a purchase and being able to extract those emails directly can have significant value since we could potentially send them a specially crafted inquiry and maybe learn more about why they signed up but never ordered and perhaps convert some of them. But as it stands the apparent flaw of it including, somewhat erroneously I might add, dormant accounts in the mix subtracts the potential value of being able to do that. Because we would craft an email for those that havent ordered in a while different from the one for those that have never ordered if you know what I mean.

Can you goto the Admin front page and state the quantity of
Customers: ?
Newletter Subscribers: ?

Let me give you an example from one of my sites

From the Admin Front Page:

Customers: 18527
Newsletter subscribers: 5585Customer: Everyone who has created an account (Signed up)(may not have purchased)
Subscriber: A Customer, who has also become a subscriber (may not have purchased)

From the Newsletter Audience Dropdown> All Newsletter subscribers (5585)

Dormant Customers (>3months)(Subscribers)(4522)
Active customers in past 3 months (Subscribers)(93)
Active customers in past 3 months (Regardless of subscription status)(197)
Customers who have never completed a purchase (3233)The first 3 are filtered for "ONLY subscribers"
The last 2 are "regardless of subscription status"

The first regardless of whether they have made a purchase
2, 3 and 4 must HAVE made a purchase
The last *Must NOT *have made a purchase

All Newsletter subscribers (5585)
Same as the Admin front page (includes customers that have never purchased)

Dormant Customers (>3months)(Subscribers)(4522)
Subscribers who have purchased, but not in the last 3 months

Active customers in past 3 months (Subscribers)(93)
Subscribers who have purchased, in the last 3 months

Active customers in past 3 months (Regardless of subscription status)(197)
Subscribers: 93
Non Subscribers: 104 (197 - 93)

Customers who have never completed a purchase (3233)
All Customers who have never purchased (Regardless of subscription status)
Subscribers: 970 (5585 - 4522 - 93)
Non Subscribers: 2263 (3233 - 970)

Hope that helps...

gilby:

Let me give you an example from one of my sites

Customers who have never completed a purchase (3233)
All Customers who have never purchased (Regardless of subscription status)
Subscribers: 970 (5585 - 4522 - 93)
Non Subscribers: 2263 (3233 - 970)

Hope that helps...

ok, that last part is where it makes perfect sense then. Thanks for taking the time to break it out because I probably would never have figured it out otherwise and now we can put this to bed and maybe it will help anyone else that is trying to understand it. Although that last one doesn't seem to have much value in terms of pulling a list. would be so much better if it separated the subscribers from the non subscribers because it would be useful to pull a list of subscribers that have never made a purchase.

thomaswhiteeagle:

ok, that last part is where it makes perfect sense then. Thanks for taking the time to break it out because I probably would never have figured it out otherwise and now we can put this to bed and maybe it will help anyone else that is trying to understand it. Although that last one doesn't seem to have much value in terms of pulling a list. would be so much better if it separated the subscribers from the non subscribers because it would be useful to pull a list of subscribers that have never made a purchase.Agreed... The last one is pretty useless

However you can always add more selections to that dropdown to get the list(s) that you want.
See here, and follow the links:

Adding other options in the customer/audience list in admin send-mail

Grancino:

How do I generate a list of all my customers and/or newsletter subscribers?

I can see them in the html newsletter editor, but I want a list of them independently of zen cart (to integrate other client management systems that I use for my business) - and I especially need all of their email addresses.

Where does Zen-Cart store this information on my server and how do I locate it?

Please help!!! THANK YOU!!!

Hello. Where is the "subscribed" field in the customers' table, please? We don't want all customer email addresses.

siriusmw:

Hello. Where is the "subscribed" field in the customers' table, please? We don't want all customer email addresses.

Note to self: Try exporting the field headers. :) customers_newsletter 1