ListMailPRO Email Marketing Software Forums
ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: jac on April 12, 2007, 10:43:02 am
-
Is there any way of exporting the Tracked Hits information?
I would like to be able to export a CSV file or the like, for importing into Excel so I can clear down the logs regularly and sort/present the information easily.
This is probably possible via PHP MyAdmin but could someone take my hand and lead me through the process as I am not too technically minded when it come to databases.
Many thanks
---
John
-
John,
Check out this post:
http://listmailpro.com/forum/index.php?topic=496.0
You'll be happy to know extensive detailed reports including impressions, click-thru rate, etc. are coming for ListMail in the next update. Patience. :)
Regards
-
Thanks for that Dean. That's good but not quite what I need.
In a similar way to the code you have already supplied, I would like to be able to select a particular link from a drop dowm menu and export a CSV file of all of that link's tracked hits information that is usually presented:
Date
Time
Link
Name
Email
List
I can then import this information to Excel to be manplulated/presented in various ways.
Any thoughts
Thanks
---
John
-
How about this one:
http://listmailpro.com/forum/index.php?topic=29.0
I would rather avoid an additional custom script considering I'm working so hard on the next update at the moment and there are huge improvements being made in this area.
Regards
-
Ok
I have tried to get this script working to see if it will do the job but it just gives me:
Cannot Access Hit Statistics
its set up in www.barntheatre.co.uk/listmail/hits_wq.php
hits_wq.php is set up as follows:
/* ====== STUFF TO EDIT MANUALLY ============= */
$configfile = "./config.php";
$adminfile = "./admin.php";
/* ====== THE MEAT ======== */
if ( $p == "btc" ) {
// continue
} else {
echo "<html><head></head><body>Cannot Access Hit Statistics</body></html>";
exit;
}
etc etc no change below this...
If I goto:
http://barntheatre.co.uk/listmail/hits_wq.php?p=btc
I just get the error. ListMail is working fine so I don't think its a database issue.
If you have time have you any ideas?
I would alse be interested know how much a custom script would cost me.
Many thanks for your help Dean
---
John
-
Hi John,
I have a hunch that this could be caused by the "p" variable not being passed properly from the address bar to the script.
After this line:
$adminfile = "./admin.php";
add
echo "P=$p<br>";
Browse to the script at ?p=btc and if it says "P=" with no value, there is an issue with "Register Globals" not being enabled.
You would have to add this at the top to set the variable:
$p = $_GET['p'];
or ALL this, to automatically cast all vars to "globals"....
if(isset($_GET)){
while(list($key,$val)=each($_GET)){
if(!is_array($val)){
if($gpc) $val = stripslashes($val);
@eval("\$$key = \$val;");
} else {
eval("\$$key = array();");
foreach ($val as $key2=>$val2){
if($gpc) $val2 = stripslashes($val2);
@eval("array_push(\$$key,\$val2);");
}
}
}
}
I unfortunately cannot do an involved custom script at this time - I need to get the next update finished! Of course, if it can be simplified I might be able to help.... :) What are you looking for, exactly?
Regards
-
Thanks for that Dean I'll try it. However as I have no got it working et I don't even know if it will do what I need! :?
I literally just need a script to output a CSV file of JUST the information presented when you go to Tracked Hits.
Date
Time
Link
Name
Email
List
I can then sort/present it from there.
Thanks Dean
---
John
-
John,
Are you familiar with PhpMyAdmin?
Try the following custom SQL query:
select h.date,k.refcode,k.title,u.fname,u.lname,u.email,u.list from lm_hits h left join lm_links k on h.kid = k.id left join lm_users u on h.uid = u.id
You should be able to export to CSV from there. :)
Regards
-
Dean
Thank you. I wish I knew what that query said and how to do it but I had a little look at PHpMyAdmin, put the query in where I thought it goes and tried it out...yes it worked perfectly.
Many thanks and kind regards
---
John