Extracting data from tracked links thru PhpMyAdmin

[jonisolis]

Hi, I am just wanting to know if the script code as shown here (codespecial.php) is working well for everyone with the lastest update to ListMail. Have you found this code helpful for your business? Thanks!

By the way, have you used and found anyother script codes listed in this forum helpful?

[DW]

This script will not work with v1.8 because the custom HTML feature has changed.  Who wants me to fix it?

[KB]

Hi Dean - Iwant you to fix it

Strangly enough - the script processed differently for each listmailpro setup I had. On one system the extracted list was placed in a new list and allocated a list title. On another the list was extracted to a new untitled list and it would have to be titled through the list editing process. Failure to do that would mean thet the next list extracted would overwrite the one before.

Regards

Kevin

[BGSWebDesign]

Hi DW,

I'd love you to fix this too, it will be important to me..

[DW]

This and the Perl remove script in the Customizations forum are what I will be working on next.  I have been busy with a long-standing SMTP issue and changes to my automated purchase routine.  I may make some progress tonight -  if not, tomorrow.

Regards

[DW]

I will be fixing this script tomorrow, for sure.

Worked around the idiocyincracy of the lists deleting themselves - if anyone wantd details just post request and I'll explain my experience.

Kevin, can you tell me how you solved the problem with lists deleting themselves?

Regards

[KB]

Hi Dean

2 things. The concern of all the ? showing were from visitors who had subsequently unsubscribed before I extracted the list. You mentioned that this may have been one of the reasons when I raised the issue. I tested it and that proved to be correct. The second reason was not so much as deleting themselves as being overwritten by the next extract.
A list is extracted through codespecial and a new list is created. This new list is not allocated a name - it shows as a blank space with a number allocated. If the next list is extracted before this list is given a listname, the new extract overwrites the previous one. At one stage the codespecial extract process would not extract the same list again. I can't remember all the details.However, in one of my setups the codespecial extract allocated a list number and list name to the extracted list. The next extract would then be automatically allocated the next spot.  This was a user understanding problem. I didn't set anything up different on any of the applications - I don't know why there was a different performance. I have subsequently dismantled those mailers as the bulk mailing was a disaster from a cost point of view. I want to set up 1.8 on your recommended server and just run my subscriber lists - maybe 20k.
Hope that was of use Dean - although I suspect not much.

Regards

Kevin

[DW]

Okay, it's finally done!  I figured out the list naming problem - the new_list() function call wasn't being sent the correct variable...  I have updated the list creation routine to work with v1.8.  Instead of re-posting I updated the code I had already posted here.

Regards

[BGSWebDesign]

Hi DW,

Wow, this looks amazing, and something I'm going to implement, love the Track Links feature, just fantastic  

One question, on this codespecial.php (which I think you should rename - createtracklist.php or something similar), I see this line:

Code: [Select]


 $cmd2 = "insert into $ltable values('null','$nlnum','".addslashes($refcode)."','news@$dom','New List Newsletter','Welcome!','Welcome to the mailing list!','','','1','Please verify your subscription','Click the link below to verify your email address for subscription to the yoursite.com newsletter\n\n!confirm','','','0','','', '','','','','','','','','','','0;0;0;0;0','$adminmail','0;1','1','1')";

It seems this is autmoatically setting up a confirm/welcome message?  Is that right?  I really don't need a Confirm, or a Welcome message setup, I just want to copy the tracked links to a new Table that I can save (Responsive Visitors, or something similar) and use that for marketing further to that group, so telling them I've signed them up to another list is not a good think...  can I just remove that Insert to not automatically add the user to the Confirm/Welcome message list, can you please post modified code, or just tell me how to change that last piece?

[DW]

The welcome and confirmation messages are, against better programming practices, stored in the list table.  A default value is entered when creating the list, but welcome messages are not actually sent.

Regards

[BGSWebDesign]

Hi,

but welcome messages are not actually sent.

So, does this mean that Confirm messages are NOT actually sent also?
Just to make sure...

[DW]

Correct, the confirmation is also not sent.  This line of code is simply to create the list - there are no mailing functions used.

Regards

[BGSWebDesign]

Hi,

Correct, the confirmation is also not sent. This line of code is simply to create the list - there are no mailing functions used.

Got it, yes, it does seem they don't belong in the list table.

One thing I noticed, and maybe you can help with this, I see that I get Multiple Tracking 'hits' appearing each time the user clicks, would it be possible to throw the COUNT of the tracked links (by email address) into a custom field, and a SORT, to bring the most clicked addresses up to the top, or highlight those that are clicking more?  Anyway, I could see this going way further than this even, and have the clicked Email addresses being highlighted in other lists too - sort of like a cross-reference showing which links they clicked on from mailings, really powerful stuff from a marketing standpoint, what do you think?

[BGSWebDesign]

Hi DW,

Ok, this little routine is useful, but what I really need is to KEEP the users in the list, and COPY them to another list.... if I just move them like you have this working, I'll never know WHICH list they started on!

Do you see the problem with that?   I have several lists, all split up by where the user came from, some have Follow Ups, some do not, but if I MOVE them to a new list, I won't know if the ones who had follow-ups coming are going to get them or not!

Can you provide a script that would COPY the users that are in the Hits table to another List, and also KEEP them in their original list?  

Thanks,
-Brett

p.s. In the next version it would be great if you could select Active-HITS to filter the table to only those users in that specific list who HAVE clicked on a link....

[BGSWebDesign]

Hi,

bump....  

KEEP the users in the list, and COPY them to another list....

Any chance we'll see this soon in this custom module, or should I have a go at writing it myself?