[thelist] Tracking users & CSV files
Paul Bennett
paul at web-business-pack.com
Thu Oct 28 15:13:56 CDT 2004
mysql offers the ability to read a csv file right into a db table
(designed with the same columns as the file naturally). From there you
can let php and mysql do their magic...
phpmyadmin offers this easily through it's interface
table > 'sql' tab > 'insert data from a text file into a table'
if you don't have phpmyadmin installed, google for the 'load data
infile' mysql command
Paul B
Tim Burgan wrote:
> Hello,
>
>
> I'm trying to use PHP to track users paths on my website. The purpose
> of the tracking is to test results from search engine clicks and how
> much success is directly related to Google AdWords.
>
> 1. I want to track where users come from.
> * If from a search engine, I what to know what keywords were
> used.
> * Same as above for tracking if Google AdWords was used.
> * If somewhere else, just record 'other'.
> 2. Also track whatever else. Such as click on a particular link, or
> purchase a certain item.
>
> AdWords provides a good CSV file in the form:
> <http://www.timburgan.com/csv.gif>
>
> What I want to do with this CSV file, is for PHP to read it, read what
> keywords how what results on a specific day (given in the
> Click-Thru-Rate column), and then for my website tracking to add to
> the CSV results and show which users from Google AdWords (by detecting
> the keywords they used, and the date) then go on to do whatever I
> decide to track.
>
>
> How would I go about doing something like this? I'm quite confident in
> my PHP programming, but I need a hand in planning and figuring out how
> I actually go about doing this (as a flowchart, or in pseudocode maybe)?
>
> How do I track information from users in relation to how they get to
> my site, and the keywords they used?
>
> How do I go about reading a CSV file, and interpreting the information
> in it, then taking those results and combining them with my tracking
> results to produce a graph showing which Google AdWords clicks are
> turning into specific results within my site?
>
>
> Thanks for your time. I appreciate any ideas and assistance.
>
> Regards
>
> Tim Burgan
>
>
More information about the thelist
mailing list