ListMailPRO Email Marketing Software Forums
ListMailPRO Email Marketing Software Forums => Customization, Integration => Topic started by: KB on January 31, 2005, 09:10:31 pm
-
Hi
I want to extract the data of who has clicked thru a tracked link.
I assume PhpMyAdmin is the way but I can"t seem to get the data out
in a useable form to import back into listmail.
Any ideas?
Regards
Kevin
-
I plan to improve existing and add new tracking soon.
Tracked hits are store in the lm_hits table.
There are 4 fields, id, uid, kid, and date.
The id field is an auto-incrementing ID which you don't need to worry about. (may be removed soon to prevent limitations/slowdowns)
The uid field contains the users id from the lm_users table.
The kid field contains the id of the link from the lm_links table.
So, the data is all there. What I need to know now is what data you are trying to extract?
Regards!
-
Hi Dean
I want to be able to extract as much of the personal data as possible - name, lname, ip, email,site visited(Code is fine) in a format that i can reimport into a new list.
Whar would be really great is if tey could be deleted from the list they were is before automatically.
Regards
Kevin
-
So, you'd like to extract the users who have clicked through to your tracked links so that you can build a highly responsive list, correct?
This would take a small custom script.
Do you want anyone who has clicked any link to be put on a single list?
Let me know and I'll help you out.
Regards
-
Hi Dean
Thanks for getting back on this. I would like the option to to split the lists according to site visited. IT would have to be linked to the code I give each link I guess.
Regards
kevin
-
Kevin,
Copy the code below into a new file, e.g.: codespecial.php and upload it to your main ListMail folder. Login to ListMail, then modify the URL in the address bar to browse to the custom script.
You'll be presented with a dropdown showing all of your links. Choose the link you want to process and hit "Create List". All users on all lists who have clicked this link will be moved to a new list (created with a List Name the same as the Link's Title). If you run the process twice on the same link there will be a new list again with all users from all lists, so the OLD new list will still exist but have no users.
I hope this works as you like!
Note: Modified to work with v1.88
Last Updated: May 16, 2014
<?php
// process specified link code
// create a new list with all users who clicked code
// ** Be sure to place this script IN your ListMail directory
// v1.8 Note: List is configured with the Default HTML and Error Messages
include("./config.php");
include("./admin.php");
$islogged = islogged();
ini_set("max_execution_time","0");
if($islogged){$isadmin='true';} else { adminheader('Not logged in','Not logged in','x');echo "<center>You must <a href=login.php>login</a>."; exit; }
if ($isadmin == 'true'){
$link = mysql_connect($sqlhost,$sqluser,$sqlpass);
mysql_selectdb($sqldb);
if($_POST['submit']=='Copy'){ $copy = 1; $move = ''; $append = '';}
if($_POST['submit']=='Move'){ $copy = ''; $move = 1; $append = '';}
if($_POST['submit']=='Append'){ $copy = ''; $move = ''; $append = 1; }
if($move) $txt = 'moved'; elseif($copy) $txt = 'copied'; elseif($append) $txt = 'appended';
echo "<a href=./>Back to ListMail</a><br><br>";
if($process_link){
// create new list with link ref code (if doesn't exist)
list($kref)=mysql_fetch_row(mysql_query("select refcode from $ktable where id = '".addslashes($process_link)."'"));
if($append){ $newlist = $list; echo "Target "; } else { $newlist = new_list($kref); echo "New "; }
echo "list num = $newlist<br>";
// get user hits for this link
$cmd = "select uid from lm_hits where kid = '".addslashes($process_link)."' group by uid";
$rows = mysql_query($cmd);
echo "new list: $newlist<br>$txt users: ";
if(@mysql_num_rows($rows)>0){
while(list($uid)=mysql_fetch_row($rows)){
if($move){
// update the user with the new list
mysql_query("update lm_users set list = '$newlist' where id = '".addslashes($uid)."'");
} elseif($copy || $append){
// get all user data and create a new user on the new list
list($fn,$ln,$em,$u1,$u2,$u3,$u4,$u5,$u6,$u7,$u8,$u9,$u10,$cn,$da,$ip,$ru,$htm)=mysql_fetch_row(mysql_query("select fname,lname,email,user1,user2,user3,user4,user5,user6,user7,user8,user9,user10,cnf,dateadd,ipaddr,refurl,htmail from lm_users where id = '".addslashes($uid)."';"));
// create new uid
$uniq = '';
while(!$uniq){
$newuid = unique_id(7);
if(@mysql_num_rows(mysql_query("select id from $utable where uid = '$newuid'"))==0) $uniq=1;
}
// insert user if not already on new list
$trow = mysql_query("select id from lm_users where email like '$em' and list = '$newlist'");
if(@mysql_num_rows($trow)==0){
mysql_query("insert into lm_users values('','$newuid','$newlist','".addslashes($fn)."','".addslashes($ln)."','".addslashes($em)."','".addslashes($u1)."','".addslashes($u2)."','".addslashes($u3)."','".addslashes($u4)."','".addslashes($u5)."','".addslashes($u6)."','".addslashes($u7)."','".addslashes($u8)."','".addslashes($u9)."','".addslashes($u10)."','1','','$cn','".addslashes($da)."','".addslashes($ip)."','".addslashes($ru)."','".addslashes($htm)."','0');") or die('user insert error..'.mysql_error());
} else {
echo "skip";
}
}
echo "$uid "; flush();
}
} else echo "process aborted: no tracked users found for selected link<br>";
echo "<br><br>";
}
// show all links
$cmd = "select id,refcode,title,http,hits from $ktable where 1 order by refcode";
$rows = mysql_query($cmd);
echo "This script will create a new list containing all users from any list who have clicked through a certain link. Users can be copied or moved from their old list.<br><br>";
if(@mysql_num_rows($rows)>0){
echo " Select link to process:<br><br><form method=post><input type=hidden name=process value=1><select name=process_link>";
while(list($i,$r,$t,$h,$s)=mysql_fetch_row($rows)){
echo "<option value=$i>$r - $h";
}
echo "</select><br><br><input name=submit type=submit value=\"Move\"> <input name=submit type=submit value=\"Copy\"> or <input name=submit type=submit value=\"Append\"> to <select name=list>\n";
$lrows = mysql_query("select listnum,title from $ltable where 1 order by listnum");
while(list($li,$ti)=mysql_fetch_row($lrows)){
echo "<option value=$li>$li: $ti\n";
}
echo "</select></form>";
} else echo "no links found!<br>";
}
function new_list($refcode){
global $link; global $ltable; global $vtable;
$cmd = "select id,listnum from $ltable where title like '".addslashes($refcode)."' limit 1";
$result = mysql_query($cmd);
if(@mysql_num_rows($result)>0){
list($id,$nlnum)=mysql_fetch_row($result);
} else {
$cmd = "select id,listnum from $ltable where id >= '0' order by listnum desc limit 0,1";
$result = mysql_query($cmd);
while(list($id,$listnum) = @mysql_fetch_row($result)){
$nlnum = $listnum+1;
$xmails = explode(';',$adminmail); $adminmail = $xmails[0];
$dom = getdomain();
$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','remsubj','remmsg','','','','','','', '','','','','','','','','','','0;0;0;0;0','$adminmail','0;1','1','1','')";
mysql_query($cmd2) or die('list creation error: '.mysql_error());
}
}
return $nlnum;
}
?>
-
Hi Dean
Great - I'll have a bash at following your instructions.
Regards
Kevin
-
I can modify the script to create the list with the link ref code if that's more useful. I could also put in a check to see if a list named with that ref code exists and, if so, move users to the existing list instead of creating a new one.
Regards :)
-
Hi Dean
Yes please.
-
Hi Dean,
WOw, that looks great, I suggest you call it targethit.php, or targetlink.php and add the modifications you suggested: very useful, and thanks ;)
-
Okay, I have made the changes (to the original post) but it's untested. Let me know if you have any troubles.
Regards!
-
That looks great Dean!
I have wanted to know who clicked on my links for a long time, but
wasn't sure how to find out. I thought I would get some kind of report,
but of course it never came so I thought no one ever clicked on them.
Thanks for fixing it so fast.
Kevin,
I'm glad you brought this topic up!
Neil
CONQUER the Internet! GRAB your piece of the Internet pie!
It's time someone gave you the training you need to launch your
Internet success story. Why settle for reading about how others
are making it big online? When you decide it's YOUR TURN,
I’ll reimburse your $24.95 Fast Track Fee to your
Paypal account as soon as you send me You account confirmation!
Signup here:
http://www.MultipleStreamsOfProfit.com/empower.html
-
Hi Dean
My experiences with the extraction code you posted.
Loaded fine. Seems to work fine for two extractions - creates new list - and all details/records shown in new list. After two extracts, the records are shown as extracted but don't appear in the userdatabase - which is shown as empty. Then the codespecial page requests login, and then reverts to editlist and a loop is created. Puzzling.
Any suggestions?
Regards
Kevin
-
Open note and Dean
Worked around the idiocyincracy of the lists deleting themselves - if anyone wantd details just post request and I'll explain my experience.
However new factor
A large number of records are now represented with a ? instead of personal details. I've thought of two possible reasons. The link is being activated but the server response is too slow and the subscriber has left or the subscriber has software hiding his identity. The frequency of the ? is increasing to almost everyone.
Your thoughts/experiences
Regards
kevin
-
Kevin,
Sorry, I didn't notice your other reply. What was, and how did you fix, the problem you were experiencing?
I am not sure why ListMail isn't finding the user information. It's possible the users unsubscribed or were otherwise removed.
The tracking is based on the user id field and the link id field. The custom script should not cause a problem because it simply changes users' "list" values, keeping the same id and user data. I'm not sure what is going on here. :?
-
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?
-
This script will not work with v1.8 because the custom HTML feature has changed. Who wants me to fix it? :D
-
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
-
Hi DW,
I'd love you to fix this too, it will be important to me..
-
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
-
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
-
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
-
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 (http://listmailpro.com/forum/index.php?topic=496.msg1767#msg1767).
Regards
-
Hi DW,
Wow, this looks amazing, and something I'm going to implement, love the Track Links feature, just fantastic :D
One question, on this codespecial.php (which I think you should rename - createtracklist.php or something similar), I see this line:
$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?
-
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
-
Hi,
but welcome messages are not actually sent.
So, does this mean that Confirm messages are NOT actually sent also?
Just to make sure...
-
Correct, the confirmation is also not sent. This line of code is simply to create the list - there are no mailing functions used.
Regards
-
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?
-
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....
-
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?
-
I've updated the code (http://listmailpro.com/forum/index.php?topic=496.msg1767#msg1767) to include a Move/Copy option. Let me know if you have any troubles.
Regards
-
Hi DW,
Great, I loaded it up but have a problem, and I found a bug.
Here's the bug:
This code:
echo "This script will create a new list containing all users from any list who have clicked through a certain link. Users are _$txt_ from their old list.<br><br>";
Needs to be like this:
echo "This script will create a new list containing all users from any list who have clicked through a certain link. Users are _" . $txt . "_ from their old list.<br><br>";
I also moved this line up to the top as follows:
$move = false;
$copy = true;
if($move) $txt = 'moved'; elseif($copy) $txt = 'copied';
I keep getting this:
(new) list num = 33
new list: 33
copied users: problem inserting..
Every time I run it, there are NO users in the new list, and the old list is the same size, have you tested this on a sample list/hits?
Also a suggestion, up at the top since you are moving/copying things around I suggest you add this piece (as it was listed in the Excel query page to also grab hits) add it right between include admin.php and $islogged as indicated:
include("./config.php");
include("./admin.php");
/* ====== THE MEAT ======== */
if ( $p == "password-of-your-choice" ) {
// continue
} else {
echo "<html><head></head><body>Cannot Access Extract Hits</body></html>";
exit;
}
$islogged = islogged();
Then the program can be called as follows:
http://yourdomain.com/mail/extracthits.php?p=password-of-your-choice
This adds a bit of security since users records are being copied/moved, etc...
Can you please do a test, on why I'm getting
copied users: problem inserting..
-
Hi,
bump....
Can anyone tell me why this returns error every time (see my previous message), has anyone else been able to get it to work?
-
I had fixed those issues but forgot to re-update the post (http://listmailpro.com/forum/index.php?topic=496.msg1767#msg1767). The "problem inserting.. " error was debugged by adding the following:
...or die('problem inserting..'.mysql_error());
There was a quote typo near the seq value.
I also added buttons for Move / Copy. :)
There is some security. You must be logged in to ListMail to use the script.
Regards
-
Hi DW,
There's ONE MORE Additiona needed here, the ability to APPEND the records to an already existing list. Here's why, think about it, I have 50-60 lists, I want to just keep ADDING my interested people who clicked to the list that I have already COPIED them to.
Right now I have to Save to new list, then Export to txt file, then go to old list, then Import txt file, ( A REAL PAIN :oops: )
Better way, I can choose Move, Copy, or Append, if I choose Append, I am asked, WHICH list to append to - from a drop-down list, I choose the list, click Go, and it Appends the records (*ignoring duplicates) to the already created list... make sense?
How about a quick change addition to this code, it shoudln't take long...
-
Brett,
You got it! :D Grab the new code (http://listmailpro.com/forum/index.php?topic=496.msg1767#msg1767).
-
I really love this code and feature!
I've really started using it and it works well. One problem I'm running into now is that I have around 10 tracked links / lists that I want to continue to append to when someone clicks the link.
The problem is doing 10 or so every day is getting cumbersome. If there was some way to link the "tracked links" and "lists" together and have one page that does them all at once or better yet get processed right before daily mail runs would be NICE!
I'd be willing to Donate a small amount to make this feature available, I bet there are a couple others... Any interest in this?
-
I wonder if this is possible with the new "Custom Query" option in User Selection. MySQL 4+, I believe, is required.
Here's a way to send to all users on a list who are not on another list:
http://listmailpro.com/forum/index.php?topic=906.msg3899#msg3899
Let's see...
The hits table stores the numeric user and link ids.. that gets a bit tricky. It would be easiest to take the link id from within LMP interface. Ahh, it's not displayed.. :( You can get the id by checking the "View Source" of the Link Tracking page. Each link has the following entry which shows the numeric link id...
<input type=hidden name=saveid value=1>
The resulting custom query might be:
SELECT *
FROM lm_users a
WHERE a.list = '2'
AND cnf = '1'
AND EXISTS (
SELECT *
FROM lm_hits b
WHERE a.id = b.uid
AND b.kid = '1'
);
I could make it easier to obtain the link ID from the ListMail interface.
To show the linkid you could modify link.php, this line:
<input type=hidden name=saveid value=$kid>
to:
<input type=hidden name=saveid value=$kid>$kid
How about this quick fix? :)
Regards
-
Hi DW,
Here's a way to send to all users on a list who are not on another list
I think what he's looking for instead is having this added to Dailymail (as an option possibly), so that it AUTOMATICALLY moves the clicked links over to the other lists...
I like that idea, but only if I can get reliable Statistics on the lists after the move such as How Many Clicks happened between these dates, etc, etc...
-
I think what he's looking for instead is having this added to Dailymail (as an option possibly), so that it AUTOMATICALLY moves the clicked links over to the other lists...
I like that idea, but only if I can get reliable Statistics on the lists after the move such as How Many Clicks happened between these dates, etc, etc...
Yes I am looking for them to be appended to the list automatically each day. My followups on the lists would then take care of the emailing to them.
Sorry if I made my previous post a bit confusing and unclear. I simply want to be able to append them automatically each day, so I don't have to manually run down 10 diffirent tracked links into 10 diffirent lists, which will grow and grow even bigger.
Stats would be good, IE. How many clicks(people) were moved/copied/appended each time. But for me This isn't real necessary at the moment.
This would take a bit of manual work at first (IE, we'd have to go somewhere and say ok, Tracked Link "!link_ma010106" Is tied to "List 4: Followup - http://mjracejr.3500weekly.hop.clickbank.net" and users should be appended, etc, etc for each link to auto append into a new list. But once you set each one up, it just appends any new clicks daily to each list and my followups would then go out.
-
Bump > any news on this?
-
Hi DW,
Ok, back to this script, I've noticed something very strange, I ran it 'Append' mode on several lists I have, the first list, I keep getting something bizarre!
If I run it in 'Append', it says added one and shows the ID number of the new one added, BUT, the actual count when I click on User Database does NOT increase, it stays the same?
Secondly, if I then choose to run it in 'Copy' mode it shows me a different ID number, but again does NOT increase the number of users in the Users Database...
Next
-----------
I also see this sometimes:
appended users: skip0
How well is this tested, are you certain it works correctly?
Also, it would help tremendously if the Selected Lists for BOTh the From and To list would STAY Selected after clicking, so I could move right on to the next one, instead of having to hunt through the entire Selection list every time...
-
Script updated for v1.85+ [click here (http://listmailpro.com/forum/index.php?topic=496.msg1767#msg1767)]
-
Hi,
Ok, I hate to be picky but I noticed this... when I do an Append into a table when the number of clicks is showing as: 2 clicks (in Link Tracking), I notice only 1 number shows up when I click Append:
Target list num = 87
new list: 87
appended users: 302555
When I then go to User Database for that list - it is only increased by 1?
Since there are 2 clicks showing, it seems it is leaving one out, or the number of clicks showing is off by 1, though it seems it's the other way around - this script is MISSING ONE of the clicks???
Weird, have you fully tested this, try it with 1 or 2 clicks, you'll see what I do, I'm sure...
-
I really love this thread.... This kind of sorting by clicked tracking link is very powerful and I am not sure if people really understand this....
Imagine if you set up a marketing campaign to promote xyz product... if you had an auto sort by clicked tracking code then we can move the user to a folowup list sequence that will personalise the email to them as if we know that they checked out the product and followup according.
An automated feature would be cool to allow for this additional copy to new list on tracked link click.
You could take this one step further and set rules for the amount of times a link is clicked to copy/move to a list. if they click on it 1-4 times copy to one list or 5 + copy to another list. and remove from the the 1-4 times list. etc....
we could then see if they have made a purchase from us and if not maybe we can push them over the fence with an offer they can't refuse or ask them if they have some questions they need answered or clarified.
I hope that this feature will be developed further and added into the system as a standard feature.
Richard Wing
-
I have gone in and figured where to add into the link.php page so we have a simple way to access that page from within ListMail.
Below is the code that starts on line 332
<td width=1>
<form name=add method=post action=$PHP_SELF>
<input type=hidden name=doadd value=yes>
<input type=hidden name=list value=$list>
<input class=button type=submit name=asub value=\"Add Link\" onmouseover=\"this.className='button_over'\" onmouseout=\"this.className='button'\" style=\"width: 80px\">
</td></form>
<td width=3><img src=1.gif width=3></td>
<td width=1>
<form name=vhits method=post>
<input type=hidden name=hitpage value=1>
<input type=hidden name=list value=$list>
<input class=button type=submit value=\"Tracked Hits\" onmouseover=\"this.className='button_over'\" onmouseout=\"this.className='button'\" style=\"width: 100px\">
</td></form>
<td align=right>";
You will want to insert this code here into it starting at line 345
<!-- Start New Button Code -->
<td width=3><img src=1.gif width=3></td>
<td width=1>
<form name=vhits method=post action=trackedlinklist.php>
<input class=button type=submit value=\"Tracked Hits List Builder\" onmouseover=\"this.className='button_over'\" onmouseout=\"this.className='button'\" style=\"width: 200px\">
</td></form>
<!-- End New Button Code -->
My custom code page is referenced as trackedlinklist.php and I have my button named Tracked Hits List Builder, both of which you will want to customise in the above referenced code.
After you insert the new code into your old code it should look like this....
<td width=1>
<form name=add method=post action=$PHP_SELF>
<input type=hidden name=doadd value=yes>
<input type=hidden name=list value=$list>
<input class=button type=submit name=asub value=\"Add Link\" onmouseover=\"this.className='button_over'\" onmouseout=\"this.className='button'\" style=\"width: 80px\">
</td></form>
<td width=3><img src=1.gif width=3></td>
<td width=1>
<form name=vhits method=post>
<input type=hidden name=hitpage value=1>
<input type=hidden name=list value=$list>
<input class=button type=submit value=\"Tracked Hits\" onmouseover=\"this.className='button_over'\" onmouseout=\"this.className='button'\" style=\"width: 100px\">
</td></form>
<!-- Start New Button Code -->
<td width=3><img src=1.gif width=3></td>
<td width=1>
<form name=vhits method=post action=trackedlinklist.php>
<input class=button type=submit value=\"Tracked Hits List Builder\" onmouseover=\"this.className='button_over'\" onmouseout=\"this.className='button'\" style=\"width: 200px\">
</td></form>
<!-- End New Button Code -->
<td align=right>";
As with any modifications you should back up the original.
Hope this is helpful to someone.
Richard Wing[/code]
-
Hi Richard,
You could take this one step further and set rules for the amount of times a link is clicked to copy/move to a list. if they click on it 1-4 times copy to one list or 5 + copy to another list. and remove from the the 1-4 times list. etc....
Yes, that's brilliant, I never thought of that... actually now that I do it won't work for me, I gather about 15,000 clicks every month or so, so it would too many clicks to store to make it an option - UNLESS - the number of times they clicked was also stored somewhere?
Hey, that's brilliant, I'd love to see that built into LMP - what do you think DW?
Also, Richard, have you marketed this way before, counting the number of clicks, does it work?
-
See my posts earlier... I begged (well not really) for an option to automate the process of pulling out clicks to certain lists daily, instead of have to doing it manually...
As for the amout of times clicked that could be interesting I guess, but simply automating this process daily would be HUGE for me....
-
Hi Mike,
simply automating this process daily would be HUGE for me....
Yes, I have to agree on this, I have to login and monkey around with moving all of the clicks over to the appropriate places - :shock:
Can you please integrate this into LMP next version DW?
-
another simple feature I would like to see in the tracking link is to place an issue number in it...
each mailing can have an issue number assigned to it when mailed...
this issue number could be used within the mailing with a global code...
The issue number could also be used within the link tracking url so that when we view user statistics about those that click the links... we can see that they clicked on the link to amazon and what issue that tracking link was in...
I use some of the same links in follow up emails...
When I look at the stats and I see who has clicked a link I dont know if it was a recent email or one from a week ago?
with an issue number we can display that in the stats area....
also would be nice to be able to click on a persons name in the stats area and it could open up the send mail screen with the users name in it to maybe send them a follow up since we seen they clicked on the links. that would be a manual sending of the email feature as opposed to the automated system we have spoken of before that we all wish for... This manual way can be a temp solution...
thats it for now..