ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => Development, Suggestions => Topic started by: dane on February 13, 2005, 09:27:48 pm

Title: How to view list stats
Post by: dane on February 13, 2005, 09:27:48 pm

Is there a way to view the current stats on a list?

Total in list:
Bounces:
Removed:
unconfirmed:
active:

I get the daily email with some stats but should there be a way to get realtime stats (or run the quert to get it realtime)?

Thanks,

Dane

Title: How to view list stats
Post by: DW on February 14, 2005, 02:47:58 pm

Currently there are is no such report available.  I will consider adding this to the dailymail report.

It is possible to view the number of Active, Unconfirmed, Removed, and Bounced users by changing the 'status' dropdown on the User Database page.  You will see the total # of users for the selected status in the top right section of the page 'toolbar' (Where the "Help" button usually is).

Regards

Title: List Stats
Post by: dane on February 14, 2005, 02:58:26 pm

Is it possible to have one of my programmers create a little script that could access the database and report the stats based on their current state and jsut display those totals on screen?

Is there any issue regarding me having a programmer just run a screen display query like that per each list int he listmail system?

Thanks,

Dane

Quote from: "DW"

Currently there are is no such report available.  I will consider adding this to the dailymail report.

It is possible to view the number of Active, Unconfirmed, Removed, and Bounced users by changing the 'status' dropdown on the User Database page.  You will see the total # of users for the selected status in the top right section of the page 'toolbar' (Where the "Help" button usually is).

Regards

Title: How to view list stats
Post by: DW on February 14, 2005, 09:35:44 pm

Absolutely.  This is a script that should take about 5 minutes to make.  The user's status is stored in the cnf field of the lm_users table.

0 = Unconfirmed
1 = Confirmed
2 = Removed
3 = Bounced

The users list is stored in the list variable.

Regards

Title: How to view list stats
Post by: richardwing on March 14, 2005, 11:24:24 pm

I have an idea to add to your live stats feature.

Wouldn't it be cool to have a little program that runs in your systray that we can have display the stats for us? Have it connect to the server. Kind of like some of the live help scripts have.

If we really wanted to we could have it tell us when tracking links have been hit or when email is read and so on.

We can add a rightclick context menu with quick links to the admin that would open up the browser to our page.

I'd love to see in real time the activity that goes on as my emails are getting sent out.

I think that would be a cool little tool. What do you guys think?

Title: How to view list stats
Post by: DW on March 15, 2005, 12:15:26 am

This is a very cool idea, and would be fairly simple if I had more VB or VC++ experience.  If anyone can create a tool (possibly providing me the source) that can do this I'd be happy to feature it here in the forum.  The tool could simply check a web site every X minutes (Options page?) and display the stats (a few lines of text, output by a small custom script) in an automatic pop-up or manual hover.

An alternative could be to set up a small custom stats script that does an HTML refresh every few minutes and add it as an "Active Desktop" item.

Title: How to view list stats
Post by: richardwing on March 15, 2005, 03:35:19 am

I was envisioning something like this here but for our email stuff that we want to track......  http://www.idevdirect.com/commissionalert.php

Hope this helps.