1. #1
    kcheung is an unknown quantity at this point affiliate commando
    Join Date
    Jul 2006
    Location
    london
    Posts
    1,597
    Thanks
    73
    Thanked 96 Times in 73 Posts

    how do you de-duplicate

    HI,

    Just a quick question, how are you deduplicating sales? are you using a software or manually deduping via a report?? how often are you doing this?

    Thanks!

    Ken

  2. #2
    morleymouse is an unknown quantity at this point Super Member
    Join Date
    Aug 2003
    Location
    Costa Del Sheffield
    Posts
    2,839
    Thanks
    5
    Thanked 18 Times in 14 Posts
    on site via an additional URL parameter.

    Any link going into alpha will have an r= tag, eg. from AF its r=AF its automatically added by them so no extra work on anyones part, if the last r= 's into the site was AF then the AF tracker shows.
    Dan Morley
    alpharooms.com
    daniel at alpharooms dot com - Hotels, Flights, Airport Transfers, Care Hire + More! sign up
    My Blog | Cheap Holidays

  3. The Following User Says Thank You to morleymouse For This Useful Post:

    kcheung (26-09-08)

  4. #3
    Chuck_Hamrick is an unknown quantity at this point Registered User
    Join Date
    Dec 2007
    Posts
    22
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Ken,

    Are you talking about running more than one affiliate network on a merchants site?

    Chuck

  5. The Following User Says Thank You to Chuck_Hamrick For This Useful Post:

    kcheung (26-09-08)

  6. #4
    nim-b is an unknown quantity at this point nim-b's Avatar Gadget Girl
    Join Date
    Aug 2006
    Location
    London
    Posts
    788
    Thanks
    9
    Thanked 50 Times in 33 Posts
    We do the same as alpharooms, and use the parameter for other forms of paid-for marketing activity too, for example PPC. So we dedupe our affiliate sales against some of our other activity.

    Cheers
    Naomi


    Naomi Brown|Firebox.com|@firebox|@NaomiMB
    e:naomi.brownATfirebox.com| 0870 420 4946|Affiliate blog|On Affiliate Window and Affiliate Future.

  7. #5
    kcheung is an unknown quantity at this point affiliate commando
    Join Date
    Jul 2006
    Location
    london
    Posts
    1,597
    Thanks
    73
    Thanked 96 Times in 73 Posts
    Quote Originally Posted by Chuck_Hamrick View Post
    Ken,

    Are you talking about running more than one affiliate network on a merchants site?

    Chuck
    exactly that....basically, i'm trying to figure out what the best practice is in this regards and hopefully put something together to NOT piss affiliates off whilst making it more efficient for my clients.

  8. #6
    nim-b is an unknown quantity at this point nim-b's Avatar Gadget Girl
    Join Date
    Aug 2006
    Location
    London
    Posts
    788
    Thanks
    9
    Thanked 50 Times in 33 Posts
    Most companies will use the url parameter. A lot of networks will have this set so you can add it in automatically to all links.

    Its the best way I know of doing it without messing around with spreadsheets, and as the duplicate isn't even reported affiliates won't end up with a lot of cancelled sales.

    Cheers
    Naomi


    Naomi Brown|Firebox.com|@firebox|@NaomiMB
    e:naomi.brownATfirebox.com| 0870 420 4946|Affiliate blog|On Affiliate Window and Affiliate Future.

  9. The Following User Says Thank You to nim-b For This Useful Post:

    kcheung (26-09-08)

  10. #7
    Ogilvy-Sean Registered User
    Join Date
    Sep 2005
    Location
    London
    Posts
    351
    Thanks
    2
    Thanked 11 Times in 6 Posts
    Hey kcheung

    Here's one way to do it.... its not the actual nuts and bolts of how to achieve it... but its the theory behind it (and it seemed to go down well at the time) - I'm still looking to roll this out accross other clients

    Positive Action Taken RE: Last-Click Referrer - 24 Studio Have Listened to You

    We use either Atlas or Doubleclick as a 3rd party tracking system to help us do this... basically by adding in a click URL to the front-end of your landing page URL... it bounces the customer through the Atlas or Doubleclick tracking before landing them where they needed to be. Once this is done...at month-end (and bear with me...I'm only half-techie) it basically does a check against duplicate order IDs tracked from different campaigns (PPC, Affiliate etc.), crossed with the source and the time stamp for each order.

    Hope this helps - I'll go into more details if you like (I'll just have to make sure I've got the techincal details arranged in my brain before I start typing! :blush)

    Cheers

    Sean
    Sean | Senior Affiliate Manager | Ogilvy
    Email & MSN : sean.carter@ogilvy.com | Phone 0207 566 7415

  11. The Following User Says Thank You to Ogilvy-Sean For This Useful Post:

    kcheung (26-09-08)

  12. #8
    kcheung is an unknown quantity at this point affiliate commando
    Join Date
    Jul 2006
    Location
    london
    Posts
    1,597
    Thanks
    73
    Thanked 96 Times in 73 Posts
    Pucker, thanks for all this! thanks for all the response

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Similar Threads

  1. Replies: 4
    Last Post: 25-08-08, 01:00 PM
  2. Duplicate Sites/Content
    By Geoffuk in forum Affiliate Marketing Lounge
    Replies: 9
    Last Post: 28-07-08, 08:23 PM
  3. Replies: 4
    Last Post: 21-01-08, 10:31 AM
  4. My SQL Join table duplicate problems
    By scifind in forum Programming
    Replies: 2
    Last Post: 12-07-05, 01:43 PM
  5. Google Duplicate Content Filter
    By darrenw in forum Google SEO
    Replies: 10
    Last Post: 08-03-05, 07:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Content Relevant URLs by vBSEO 3.5.0 RC2