how do you de-duplicate

[kcheung]

Tweet

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

[morleymouse]

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.

[Chuck_Hamrick]

Ken,

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

Chuck

[nim-b]

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

[kcheung]

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.

[nim-b]

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

[GW-Sean]

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

http://www.affiliates4u.com/forums/a...tened-you.html

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

[kcheung]

Pucker, thanks for all this! thanks for all the response