text parsing for new adds to bin / cart - has anyone got a method?

hi.

when i go to the sales data of my uploads,
a long and kind of full of zeros (but not only)
table of data appears.

the whole table has little relevance, since you
cant compare from memory the data with the
data that was there, say, 3 days ago.

has anyone of you found a method to parse that
data and to display somehow with a program or somth.
the new adds to bin / cart that occured since a specified
data?

for example, if i would want to see how many adds
i had in the period since 3 days ago til today -
and to which of my clips.

thanx.

Copy And paste into excel!

..............................
......................................
ok, and then?
copy paste the next day and compare each cell manually?
i meant an automatic routine, that does it instantly,
not me running through hundreds of clips looking for a changed number....

Well... I sum up the add to cart, views, bin add every now and then and copy the result with the relative day
Then I make some graph with time dependence. It's tedious and not so useful but I like to do it

but you only find out how many new adds you have.
that doesnt tell you which tracks have those new adds.
you just now some sales might be coming, but you dont know to which trax.

if all your trax are priced relatively the same, than it's useful,
but in my case, i have sfx too, and for all my portfolio, prices
vary 10 to 70 bucks, so a new add wouldnt tell me much, if
i dont know the track that has it.

bosone, actually you are right in starting with excel.

- start by sorting the sales data by id, so that the the new clips
are always at the bottom, and the rest of the already added clips
are always in the same position / row

- copy the whole sales data table and paste it into a notepad,
then copy it again from the notepad and paste it unicode in excel

- keep only the bin or cart adds column in excel (and the clip id column)

- add a new column with the new bin / cart adds several days after, to compare data

- make a third column that subtracts first column from the second
so that it displays the new adds - and you get to know exactly which clips got it

- optionally, make a cell that sums up all the adds

, indeed, the excel solution does seem to work.
im onna try it.

thanx bosone :)

I didn't think about handling the columns as you said. I'll try...

i did such an excel (actually an open office scalc) and i tested it today.
it displayd 2 new cart adds, as indeed was the case.
and it took couple of seconds to find that out and to see which clips got the adds.