Jump to content
Latest News: (loading..)

FWR Media

♥Ambassador
  • Content count

    6,718
  • Joined

  • Last visited

  • Days Won

    46

Everything posted by FWR Media

  1. you seem to have added keyword twice .. e.g. AdGroupName:keyword,keyword My understanding is the following is correct ... AdGroupName:keyword,AdGroupName:keyword,AdGroupName:keyword,AdGroupName:keyword
  2. Did you run the DB query to update your database?
  3. Well .. you may want the campaign item to point to "products_id=" so the click moves to a specific product, but you still need ref=xxx&keyw=xxx for supertracker to record it you would probably add it as "&ref=xxx&keyw=xxx" but I'm sure Mark will reply with a recommended solution when he has the time.
  4. In google admin you will see a URL for each "campaign item" e.g. the google URL may be .. http://www.mysite.com/myshop/ you would want to change each url to look like .. http://www.mysite.com/shop/index.php?ref=g...ad&keyw=wiggits g...ad was meant to read "googlead" Where "wiggits" is the specific term for the campaign item or product All this does is add ?ref=googlead&keyw=wiggits to the end of each click comming into you from adwords, oscommerce wont notice the "ref=googlead&keyw=wiggits" but supertracker will record it for you. Hope this helps
  5. keywords should be written like ...... kw:keywords where kw is the short code .. seperated by ":" .. then full description e.g. the following is mine: $ppc = array ('googlead' => array ('title' => 'Google Adwords', 'keywords' => 'gb:grobag,gbs:grobags,bb:baby,bgb:baby_grobag,bc:baby_clothes,bsb:baby_sleeping_bags,gw:grow_bags,bgbs:baby_grobags'));
  6. Mark I use Worldpay and no problems with callback yet (8 orders today)
  7. Top of admin>supertracker find $ppc = array ('googlead' => array ('title' => 'Google Adwords', 'keywords' => 'sextoysuk:sex toys uk,bondageuk:bondage uk'), 'miva' => array ('title' => 'Miva', 'keywords' => 'st:sex toys,vib:vibrators')); Replace with $ppc = array ('googlead' => array ('title' => 'Google Adwords', 'keywords' => '')); Yup There are a few errors I think .. e.g replace .. $ppc_q = "SELECT * from supertracker where landing_page like '%ref=" . $ref_code . "'"; with .. $ppc_q = "SELECT * from supertracker where landing_page like '%ref=" . $ref_code . "%'"; I assume it the same further down as when I change .. line 532 $ppc_key_q = "SELECT *, count(*) as count, AVG(num_clicks) as ave_clicks, AVG(UNIX_TIMESTAMP(last_click) - UNIX_TIMESTAMP(time_arrived))/60 as ave_time from supertracker where landing_page like '%ref=" . $ref_code . "&keyw=" . $keyword_code . "' group by landing_page"; with .. $ppc_key_q = "SELECT *, count(*) as count, AVG(num_clicks) as ave_clicks, AVG(UNIX_TIMESTAMP(last_click) - UNIX_TIMESTAMP(time_arrived))/60 as ave_time from supertracker where landing_page like '%ref=" . $ref_code . "&keyw=" . $keyword_code . "%' group by landing_page"; It fills one of my PPC keywords but only one
  8. Hi I got this installed .. thanks However PPC now shows no stats. Any ideas?
  9. I'd just like to say .. what a SUPERB! contribution. Thanks Mark For me this rates alongside SEO urls and cdynamic metatags as the most valuable contributions. Regards Rob
  10. FWR Media

    Worldpay Question

    I have this problem also, but it seems there is no support for this issue here. No worldpay = no Oscommerce for me :(
×