edtiger Posted March 4, 2004 Share Posted March 4, 2004 then i noticed that if i put the ad=test for example: www.mysite.com/catalog/index.php?ad=test after the user clicks somewhere else the ad=test does not stick to the link, could this be the problem nothing at all shows up on my ad reports? I *think* the variable is set in the session or cookie because it dissappears when I click off the entry page but the click is still recorded in the back end. I can even go to ssl at a different url and the click is still recorded. ok one more thing that may be the problem, inthe database i noticed that both customer_refer_id and customer_advertiser were both NULL, so i changed that.. to not null, but still no luck, I wouldn't mess with the DB. ad tracker (admin it will not show up.... does anyone know why??? Are you looking in the wrong place? Nothing will show up in the Admin: Reports: Ad Results until an order has been placed. Try looking in Admin: Customers: (the customer record for the account you created after you clicked) Quote Link to comment Share on other sites More sharing options...
jrconsultations Posted March 4, 2004 Share Posted March 4, 2004 hmmm yea i just noticed that, but why when i put ad=test as soon as i click somewhere else it doesn't stick? Quote Link to comment Share on other sites More sharing options...
akhunaton Posted March 8, 2004 Share Posted March 8, 2004 (edited) I too have tried everything and it does not record the ad info into the customer table. I would throw a party if I could get this to work. Tis a great idea. Edited March 8, 2004 by akhunaton Quote Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2004 Share Posted March 19, 2004 Judging by the fact that about 99% of the posts in this thread are complaints from those who could not get this working I had figured I would not be able to either. Still the capabilities of this contribution were so great I at least had to try. As per my prediction, I was unable to get it to work. I've followed the directions to a T and reverted back to a pre-mod state then tried again using all the "fixes" listed in this thread. Still no luck and it seems to be that the tep_session_register('variable') statements are not working. I can access these variables from within application.php on the entry page but not from any others. Is there some way that I must call these two variables back from the session data before they can be accessed from the create_account.php page? It seems like the data is being properly set with the tep_session_register function but is not being recalled correctly in create_account.php. Quote Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2004 Share Posted March 19, 2004 I also just queried my db to find that the advertising and referers_url variables are not being passed to the session table, which confirms my initial belief that tep_session_register is not doing its job. I even tried setting both variables directly in application_top.php, for example: $advertiser = 'test.advertiser'; tep_session_register('test.advertiser'); Even this did not work. This function seems to be used throughout osC so I find it hard to believe that it would be broken. It seems to me that maybe I just have something turned off in my configuration that may be required to be turned on? Quote Link to comment Share on other sites More sharing options...
talon177 Posted March 19, 2004 Share Posted March 19, 2004 //use this #5 instead of #5 in contribution to use contrib with MS2 (works on my setup) 5. UPDATE /catalog/create_account.php (create_account_process.php has been depreciated)---------------------------------------- Change THIS (around line 250): $sql_data_array = array('customers_firstname' => $firstname, 'customers_lastname' => $lastname, 'customers_email_address' => $email_address, 'customers_telephone' => $telephone, 'customers_fax' => $fax, 'customers_newsletter' => $newsletter, 'customers_password' => tep_encrypt_password($password)); To THIS: $sql_data_array = array('customers_firstname' => $firstname, 'customers_lastname' => $lastname, 'customers_email_address' => $email_address, 'customers_telephone' => $telephone, 'customers_fax' => $fax, 'customers_newsletter' => $newsletter, 'customers_password' => tep_encrypt_password($password), 'customers_advertiser' => $advertiser, 'customers_referer_url' => $referer_url); any questions, let me know. I also hacked a quick add on so the referring url is displayed with along with the Ad source in the customer list in the admin //this code displays the referring url in customer list in admin area //add to admin/includes/english/customers.php define('TABLE_HEADING_REFURL', 'Ref. URL'); //alter admin/customers.php //after this line <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_AD; ?></td> //add this string <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_REFURL; ?></td> //change this line $customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id, c.customers_advertiser from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by c.customers_lastname, c.customers_firstname"; //to this (change is adding c.customers_referer_url) $customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id, c.customers_advertiser, c.customers_referer_url from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by c.customers_lastname, c.customers_firstname"; //after this line <td class="dataTableContent"><?php echo $customers['customers_advertiser']; ?></td> //add this string <td class="dataTableContent"><?php echo $customers['customers_referer_url']; ?></td> ENJOY! Thanks, now it works perfectly for MS2 Quote Link to comment Share on other sites More sharing options...
Guest Posted March 23, 2004 Share Posted March 23, 2004 Wish I could say the same. :unsure: Quote Link to comment Share on other sites More sharing options...
talon177 Posted March 23, 2004 Share Posted March 23, 2004 What kind of problems you having oarie? Quote Link to comment Share on other sites More sharing options...
Guest Posted March 24, 2004 Share Posted March 24, 2004 (edited) Judging by the fact that about 99% of the posts in this thread are complaints from those who could not get this working I had figured I would not be able to either. Still the capabilities of this contribution were so great I at least had to try. As per my prediction, I was unable to get it to work. I've followed the directions to a T and reverted back to a pre-mod state then tried again using all the "fixes" listed in this thread. Still no luck and it seems to be that the tep_session_register('variable') statements are not working. I can access these variables from within application.php on the entry page but not from any others. Is there some way that I must call these two variables back from the session data before they can be accessed from the create_account.php page? It seems like the data is being properly set with the tep_session_register function but is not being recalled correctly in create_account.php. I also just queried my db to find that the advertising and referers_url variables are not being passed to the session table, which confirms my initial belief that tep_session_register is not doing its job. I even tried setting both variables directly in application_top.php, for example: CODE $advertiser = 'test.advertiser'; tep_session_register('test.advertiser'); Even this did not work. This function seems to be used throughout osC so I find it hard to believe that it would be broken. It seems to me that maybe I just have something turned off in my configuration that may be required to be turned on? These are the problems I am encountering. Any help would be most appreciated. Thanks. O Edited March 24, 2004 by oarie Quote Link to comment Share on other sites More sharing options...
talon177 Posted March 24, 2004 Share Posted March 24, 2004 Are you using 2.2 MS2? Quote Link to comment Share on other sites More sharing options...
Guest Posted March 24, 2004 Share Posted March 24, 2004 Yes, 2.2 MS2. O Quote Link to comment Share on other sites More sharing options...
sefu Posted May 1, 2004 Share Posted May 1, 2004 I have it working in MS1, it shows up fine in the customers part of the admin but I am getting $0 and no results in the reports section. Could this be something to do with orders_total table? Quote Link to comment Share on other sites More sharing options...
talon177 Posted June 1, 2004 Share Posted June 1, 2004 One thing i noticed is that the stats_ad_results.php counts in shipping and tax, so you still don't really no how much profit you make from each ad. For instance lets say 1 item totals 37.88 but 5 was shipping and 2.88 was tax, and item sold was 30 and item cost was 28 which equals 2 profit. But then u spent 15 dollars for advertising. Currently theres no way to factor in how much you really made, I guess the best solution for now would be just to show total sale item, that way you can just sales - cost = profit, but then you would still have to figure out what profit came from which ad. Quote Link to comment Share on other sites More sharing options...
Guest Posted June 1, 2004 Share Posted June 1, 2004 I still have this contrib installed but over the last 2 months since I installed it the only two users returned when I run this myswl query: select customers_firstname, customers_lastname from customers where customers_advertiser is not null; are the two test users I set up when testing to see if it was working. It seems to work only if a customer signs up for an account immediately after clicking the link to the site. The "sign up for an account" link must be the first link they click, otherwise the ad= value is lost. I left it installed but for me it's only wasting CPU cycles. :( Quote Link to comment Share on other sites More sharing options...
talon177 Posted June 2, 2004 Share Posted June 2, 2004 thanks for that info, i gotta test that out to see if it works or not on mine Quote Link to comment Share on other sites More sharing options...
talon177 Posted June 14, 2004 Share Posted June 14, 2004 One thing i noticed is that the stats_ad_results.php counts in shipping and tax, so you still don't really no how much profit you make from each ad. For instance lets say 1 item totals 37.88 but 5 was shipping and 2.88 was tax, and item sold was 30 and item cost was 28 which equals 2 profit. But then u spent 15 dollars for advertising. Currently theres no way to factor in how much you really made, I guess the best solution for now would be just to show total sale item, that way you can just sales - cost = profit, but then you would still have to figure out what profit came from which ad. bump, anyone have an opinion on this or know a solution/fix? Quote Link to comment Share on other sites More sharing options...
talon177 Posted June 14, 2004 Share Posted June 14, 2004 I still have this contrib installed but over the last 2 months since I installed it the only two users returned when I run this myswl query: select customers_firstname, customers_lastname from customers where customers_advertiser is not null; are the two test users I set up when testing to see if it was working. It seems to work only if a customer signs up for an account immediately after clicking the link to the site. The "sign up for an account" link must be the first link they click, otherwise the ad= value is lost. I left it installed but for me it's only wasting CPU cycles. :( works for me, value still shows after clicking other links within the site before signing up. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.