Page 3 of 3 FirstFirst 123
Results 21 to 30 of 30
  1. #21
    Join Date
    Aug 2005
    Location
    Vic, Oz
    Posts
    1,905
    Plugin Contributions
    5

    Default Re: How do I Export the Newsletter Subscriber List?

    Quote Originally Posted by thomaswhiteeagle View Post
    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)

  2. #22
    Join Date
    May 2007
    Posts
    92
    Plugin Contributions
    0

    Default Re: How do I Export the Newsletter Subscriber List?

    Quote Originally Posted by gilby View Post
    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?

  3. #23
    Join Date
    Aug 2005
    Location
    Vic, Oz
    Posts
    1,905
    Plugin Contributions
    5

    Default Re: How do I Export the Newsletter Subscriber List?

    Quote Originally Posted by thomaswhiteeagle View Post

    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
    Last edited by gilby; 9 Jun 2015 at 07:14 AM.

  4. #24
    Join Date
    May 2007
    Posts
    92
    Plugin Contributions
    0

    Default Re: How do I Export the Newsletter Subscriber List?

    Quote Originally Posted by gilby View Post
    "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.

  5. #25
    Join Date
    Aug 2005
    Location
    Vic, Oz
    Posts
    1,905
    Plugin Contributions
    5

    Default Re: How do I Export the Newsletter Subscriber List?

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

  6. #26
    Join Date
    Aug 2005
    Location
    Vic, Oz
    Posts
    1,905
    Plugin Contributions
    5

    Default Re: How do I Export the Newsletter Subscriber List?

    Let me give you an example from one of my sites

    From the Admin Front Page:
    Customers: 18527
    Newsletter subscribers: 5585
    Customer: 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...
    Last edited by gilby; 10 Jun 2015 at 09:50 AM.

  7. #27
    Join Date
    May 2007
    Posts
    92
    Plugin Contributions
    0

    Default Re: How do I Export the Newsletter Subscriber List?

    Quote Originally Posted by gilby View Post
    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.

  8. #28
    Join Date
    Aug 2005
    Location
    Vic, Oz
    Posts
    1,905
    Plugin Contributions
    5

    Default Re: How do I Export the Newsletter Subscriber List?

    Quote Originally Posted by thomaswhiteeagle View Post
    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

  9. #29
    Join Date
    Nov 2013
    Posts
    4
    Plugin Contributions
    0

    Default Re: How do I Export the Newsletter Subscriber List?

    Quote Originally Posted by Grancino View Post
    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.

  10. #30
    Join Date
    Nov 2013
    Posts
    4
    Plugin Contributions
    0

    Default Re: How do I Export the Newsletter Subscriber List?

    Quote Originally Posted by siriusmw View Post
    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

 

 
Page 3 of 3 FirstFirst 123

Similar Threads

  1. Newsletter Subscriber Discount
    By swguy in forum All Other Contributions/Addons
    Replies: 119
    Last Post: 13 May 2023, 07:51 PM
  2. How to download Newsletter Subscriber Info?
    By goldnuggetsales.com in forum General Questions
    Replies: 1
    Last Post: 12 Aug 2011, 07:19 AM
  3. newsletter subscriber
    By cla74 in forum General Questions
    Replies: 0
    Last Post: 10 May 2009, 02:54 PM
  4. store sends plain text newsletter even to the HTML subscriber
    By one tall man in forum General Questions
    Replies: 3
    Last Post: 13 Mar 2009, 01:49 PM
  5. Export Subscriber Report
    By thecubelab3 in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 29 Sep 2008, 08:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR