Documentation for the payday columns

[Changaco]

Question from @trebmuh in #388 (comment):

@Changaco , can you explain the column headings, please? (my guess in italic)

• id : identification number of a payday
• ts_start : ??
• ts_end : ??
• nparticipants : ??
• ntippers : number of people donating
• ntippees : number of people receiving donation
• ntips : number of donations
• ntransfers : ??
• transfer_volume : money which has been transferred during the week
• ntakes : ??
• take_volume : ??
• nactive : number of accounts which did received and/or sent money during the week
• nusers : number of accounts
• week_deposits : ??
• week_withdrawals : ??
• transfer_volume_refunded : ??
• week_deposits_refunded : ??
• week_withdrawals_refunded : ??
• stage : ??
• public_log : URL (here)
• week_payins : ??

[Changaco]

I'm pretty sure I've answered a question about the nparticipants column before, but it's probably buried in one of the payday issues.

[trebmuh]

@Changaco I understand that providing all the information here in one go could be very time-consuming and boring and not-a-sexy-thing-to-do-today from your side. What about providing one line definition each payday (or something like that) to make it not an over-boring thing to do for you?

PS: I've search for more than one hour the nparticipants column definition, but can't find it back unfortunately.

[Changaco]

The previous question about nparticipants is #270 (comment).

[Changaco]

• ts_start and ts_end: start and end times of the payday ("ts" stands for "timestamp")
• nparticipants: number of accounts "participating" in the payday
• ntippers: number of accounts with active outgoing donations
• ntippees: number of accounts with active incoming donations
• ntips: number of active donations
• ntransfers: number of "transfers" processed by the payday (real transfers in v1, virtual transfers in v2)
• transfer_volume: sum of active donations
• ntakes: number of "transfers" through teams
• take_volume: sum of "transfers" through teams
• nactive: number of accounts with active outgoing or incoming donations
• nusers: number of open individual and organization accounts
• week_deposits: sum of funds deposited into wallets
• week_withdrawals: sum of funds withdrawn from wallets
• transfer_volume_refunded: sum of refunded transfers
• week_deposits_refunded: sum of refunded deposits
• week_withdrawals_refunded: sum of refunded withdrawals (in other words, failed payouts from wallets to bank accounts)
• stage: current step of the payday (starts at 1)
• public_log: URL of the payday issue (now created automatically by @liberapay-bot)
• week_payins: sum of successful payments through Stripe and PayPal since the previous payday

[trebmuh]

Thank you @Changaco .