Reporting IP address - Ecommerce Forums
Results 1 to 2 of 2

Thread: Reporting IP address

  1. #1

    Reporting IP address

    Hi, I'm trying to figure out how I can generate a report based on where our coupons are being used from. I thought maybe if we could track the IP address from the customers that used a certain coupon, that this would help but I can't seem to figure out how to do it. I really want to avoid having to go through every coupon usage individually and would love to be able to just create a report. Any suggestions??

  2. #2
    I'm not sure I follow the logic here - you are looking for the IP of the person placing an order using the specific coupon? Not sure what that data will do for you, since they could be doing the order from work, home, mobile, etc all with differing IP addresses, and some dynamic so a customer may have multiple IPs associated to them.

    I'd imagine there is a custom SQL report that could do this, but even if you just did the general coupon used report from this forum across a date range, then you could export that to excel along with the Orders table and select OrderID and customerIP fields, then use a vlookup in excel to map orders with coupons used and pull the IP address across (again I can't figure out the SQL for Volusion, hopefully someene else can provide a simpler report)

    Are you more interested in the marketing aspect of where they found the coupon code?

Similar Threads

  1. Fake Purchase Orders Messing Up Volusion Reporting/Analytics
    By spicysauce in forum Site Performance
    Replies: 4
    Last Post: 10-28-2016, 07:53 AM
  2. helpful tax reporting
    By MelanieF in forum Reporting
    Replies: 0
    Last Post: 01-15-2016, 10:39 AM
  3. Replies: 6
    Last Post: 09-18-2014, 01:29 PM
  4. GWT Average Position Reporting
    By KKS in forum Search Engine Optimization
    Replies: 2
    Last Post: 02-20-2013, 06:42 AM
  5. Replies: 0
    Last Post: 11-05-2012, 10:40 AM

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
  •