Hmm, the charts don't tell me my #of downloads just %s


Sent from my iPhone using Tapatalk

These are from pivot table of my Jan 2017 report (non-exclusive):

Credit Pack 3.25
iStock Subscription 0.26
Premium Access Time Limited 0.71
RF Image 0.14
Thinkstock Image Pack 2500 0.60
Thinkstock Image Pack 5 3.96
Thinkstock Image Pack 500    1.00
Thinkstock Subscription SUBTHINK 0.22
Thinkstock Subscription SUBTHINK250   0.19
Thinkstock Subscription SUBTHINK50   0.23
Thinkstock Subscription SUBTHINKELP   0.14
Thinkstock Subscription TP 0.28
Thinkstock Subscritpion SUBTHINK100   0.14
Grand Total 0.56

Some pretty low commissions out there 

The charts are so 90's  Never mind, retro is a popular style these days.

Unfortunately my Jan revenue is the lowest in 24 months 

Quote from: panicAttack on February 22, 2017, 15:03

where can you see that?

You need to download your report in txt format, open it in Excel and create a pivot (summary) table of the huge and long table originally provides us.

thank you, but I have excel starter and when I open it there it's even bigger mess.

0.34

I'd like to answer or help others but ESP made it so impossible. I don't know what's a sub and what's a discount. I had some for 15% of 50 cents for 8 cents, and I'm supposed to dig through this mess, add up all my pages for subs for an average? Is TS a sub for the average, they are all 28 cents. Some were for disabled files on IS, that they disabled.

I can't read this and I think IS wants it that way.

Maybe next month? Instead of what's two month or partial or who knows what mess?

Pivot isn't going to make this readable or useful. Tab delimited only, try that. Good Luck!


http://www.activitydata.org/How_to_Pivot_data_in_Open_Office_Spreads.html

It's easy

    Open your results CSV file in OpenOffice:


Illustration 1: Sample granular data

    Use short cut keys to select all the data (make sure you select just the data not the whole spreadsheet).
    Data->DataPilot->Start
    Ok to using current selection
    Wait patiently for some time � you will see the Data Pilot window:
    Move the field names to the Rows and Columns as appropriate. Normally you will be putting a numeric value in the data field.
    The example below users Academic Year, Year, Month as the column headings for the pivoted table and event type to aggregate values over. The sum of the counts form the data fields.
    Click on the More button
    Choose to display �Results to� in a new sheet (if you don't do this, the results will appear below the current sheet. Click Ok.


Illustration 2: Selecting the pivot data

    Now the pivot table is there.
    Format columns etc to beautify. Select all the columns then
    Format>Column>Width


Illustration 3: Setting the Column Width

    Format the left and rightmost columns � and here is the result:


Illustration 4: Sample showing data pivoted for Academic Year 2005-06

My Subscription RPD is 0.54$

Overall my numbers are up, so I guess it was worth the wait.

People will still be on the old sub packages so the new scheme probably wont make a big difference for a few months.

Global average 0,37 here

Global subs 0.20.

I see 'what the fish' abbreviated gets corrected to just 'what' nowadays.
Good grief.

Quote from: alexzappa on February 23, 2017, 02:56

...
Global Average RPD   0,36

That is shocking. That is less than half my SS or FL RPD

Shocking is right. For the subs question, report is only Jan 1st I won't know until next month. Too many old package and old calculation commissions in the report. Can't start to answer until March 20th if that's like Feb report? Or did the op want before the change, 0ld system?

$0.55/iStock sub

$0.83 overall