No IP address here. No country either.
If you're missing something, then I'm missing it as well.
Okay I could have posted this thread at the Reflexive forums but I couldn't bother to open an account yet on another forum as I already have too much of these. So Reflexive people please pardon me. Anyway my request may be of interest to other affiliates frequenting this boards.
What about the ability to list the customer's country (or IP address) in the reports available to us affiliates? I remember writing to the affiliate support about that matter. I was told to use a custom report and that one of the drop down list should have IP address in there. But this just isn't true, unless I'm missing something?
I think that the person who responded to me thought it was there, but it isn't. Or maybe this option is available to Reflexive staff only.
Anyway I think that this information could be useful to us affiliates. Personnaly I'd really need to know the country/IP of each of my customer's so I can add their email address to the relevant list of subscribers. This is because I'm running two newsletters, one in french and the other in english.
Such info could certainly be used for other useful purposes too.
And I would like if a 'Other games' (after you install the game) redirect to my site directly, instead of gamecenter site.
Also, it would be good if 'Order by mail' form include affiliate code, I don't think affiliates are now credite if ordered by mail.
Yes, it is a reflexive staff only option on the "Affiliate Sales History" type of report - I don't know the rationale for limiting it in that way. I'll see what I can figure out there.Originally Posted by OliverPearl
If we make it available in the report, we will make it available there as well.Originally Posted by Maupin
We actually can't know it for every customer - Mail order is the more obvious exception, but last I checked paypal didn't provide a way for us to get IP address for paypal orders either.Originally Posted by OliverPearl
I assume it's still useful to you guys even if it is unavailable for 15% or so of sales?
If you look at the printable mail order form, you will see that the ProductID for the game is already burned in. The ProductID has the ChannelID for the affiliate embedded in it. So provided the customer uses the form, the sale will be done on that productID which means the Affiliate will get credit. As far as I know, we get a proper form in the vast majority of mail orders.Also, it would be good if 'Order by mail' form include affiliate code, I don't think affiliates are now credite if ordered by mail.
Last edited by neo71; 11-12-2007 at 04:34 AM.
We enabled IP address for all affiliate users in the Affiliate Sales History report, and added ip address to the order xml feed.
If the sale was one where ip address was not available, we return ... (think the 3 dots in the dotted decimal, with no numbers) so when processing the data you should treat ... appropriately for your purposes as a "no data" case.
Paypal orders currently come across as the no data three dots - but we think we might be able to get ip address as a passthrough field (i.e. you'd get the ipaddress of the person who we gave a paypal link to), but I can't say when or if we might put that in.
Thanks! This will be really helpful in revealing how paying customers use my site.
I didn't see ... in the XML feed (not that it matters). Looks like the feed uses an empty element <IPAddress></IPAddress> in the case of Paypal purchase orders.
I spent the last few hours figuring out how to get country from ip. If anyone is looking for how to do it I found this helpful http://meshier.com/2007/04/21/blocki...ing-php-mysql/ Turns out 95% of my orders that have an ip address are from the US.
With respect to mapping ip to country, we use maxmind's database: