Extracting data from tracked links thru PhpMyAdmin

[richardwing]

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

Code: [Select]


     <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

Code: [Select]


<!--  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....

Code: [Select]


     <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]

[BGSWebDesign]

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?

[mike2]

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....

[BGSWebDesign]

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?

[richardwing]

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..