+ Reply to Thread
Results 1 to 9 of 9

Analyzing Paypal Spreadsheet. Finding First Instance of a Buyer

  1. #1
    Registered User
    Join Date
    12-13-2008
    Location
    new york
    Posts
    6

    Analyzing Paypal Spreadsheet. Finding First Instance of a Buyer

    Hi...

    I've been trying to apply various tutorials to solve my particular problem to no avail... i suppose mine would be a very common issue but i see no postings about a solution..

    ok so...

    i have the last 8 months of paypal records. I want to

    a. mark the very first occurance of every email address for one time buyers and repeat buyers chronologically. So... i will know how many new customers we served every day.

    b. total up the gross payment amounts of each new customer after any date. For instance, if we did a seminar in april, I want to know the total spending of only the new customers ... defined as anyone who has not purchased anything from january to the date of the seminar.


    help??? =)
    Last edited by VBA Noob; 12-13-2008 at 04:53 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Welcome to the forum.

    Would you please post an example workbook, with any sensitive data sanitized, and show an example of what you want?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    12-13-2008
    Location
    new york
    Posts
    6

    Smile example

    Ok here's a sample
    Date,email,amount,itemnumber
    04/01/2008,[email protected],100,08
    04/02/2008,[email protected],350,03
    04/03/2008,[email protected],200,07
    04/04/2008,[email protected],850,01
    04/05/2008,[email protected],100,07

    So... if I want to know the number of new customers since 4.1.08
    Then id get the list
    A@b,300
    B@b,350
    C@b,950

    But if I want a list from 4.4.08
    Then id only get
    C@c,950

    This is important because if I do a marketing campaign like an adwords adsense ad on 4.4.08... I want to track if we got any new customers.

    And how much the gross income was since that advert date. Pretty useful right?
    Thx¡!
    Last edited by biodrux; 12-13-2008 at 04:40 PM.

  4. #4
    Registered User
    Join Date
    12-13-2008
    Location
    new york
    Posts
    6
    Ps... I have wayyy too many rows to do the drag thing... I gotta use a formula... let's just imagine I have 10000 rows of data.

  5. #5
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949
    You so totally lost me there.

    A few questions
    -Is this info in different cells, or is it in one cell, and seperated by commas, as you've typed it.

    -When is 4.0.08? does 0 mean the whole month?

    -Where does the 900 come from? I see a C@c with 850, and one with 100.

    -What do you mean by
    I have wayyy too many rows to do the drag thing
    ?

    Also, as SHG has requested, an example workbook with any confidential information edited will help get you an answer much faster.

  6. #6
    Registered User
    Join Date
    12-13-2008
    Location
    new york
    Posts
    6

    Smile

    Sorry.. I'm typing in 3pt on my google g1 pgone.. so I don't see typos till after...

    I edited the orig post...

    Drag thing... refers to setting up formula then clickdragging over fields to apply...

    Thx!

  7. #7
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949

    k, but

    Without a sample, it's still kinda hard to say what we're up against here.
    As per the dragging thing, I know 2007 accelerates as you cover more ground, not sure if 2003 does, but I know I just worked on 72,000 lines of data exported from our crappy old Point of Sale system, (Thanks again for the VBA code, SHG), and dragging wasn't an issue.

  8. #8
    Registered User
    Join Date
    12-13-2008
    Location
    new york
    Posts
    6

    Cool

    Hi... welll my data looks just like the example above.
    Just a lot more different email addresses and more of them...

    Thx

  9. #9
    Registered User
    Join Date
    12-13-2008
    Location
    new york
    Posts
    6
    Ps... I'm trying to do this in spreadsheets.google.com so I do need the formula.. ugh! Scrolling takes wayyyyyyyy longgggggggggggg

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1