Piku export format

Getting an export

In Piku, go to Settings > Your data > Export. We email a link to the zip, usually within minutes and within two days for large accounts. The link works for 48 hours and only for the account that asked.

The rules

• manifest.json names the format ("piku-export") and its version (1), the export date, and every file with its size, SHA-256, row count and schema.
• CSV files are RFC 4180, UTF-8, CRLF line ends, with a header row. A cell that a spreadsheet would read as a formula starts with an apostrophe.
• Money: amount_minor is whole minor units in its own currency (ISO 4217 code in currency); amount is the same value as a decimal string. Amounts are never converted.
• Dates are ISO 8601 in UTC. Every row has its Piku id, and files point at each other with those ids (deal_id, invoice_id, rate_id).
• Columns are snake_case and only ever added. A removed or renamed column means a new version.
• Lists and objects inside a cell are JSON.

Other files

• README.txt: the same in plain words.
• profile.json (profile@1): name, handle, bio, niches, place, default currency, page design, Business details and plan.
• pdf/invoices/ and pdf/receipts/: every invoice and receipt as your clients got them, named by number.
• media/: your photo, logo, link images and work files, stored as uploaded. Paths are in the rows that use them.

links.csv

Links and widgets on your page, in order. Schema link@1.

• id, title, url, visible, embed, thumb, position, widget_type, widget, image, created_at

rates.csv

Your Rates. Schema rate@1.

• id, slug, title, platform, price_kind, amount_minor, amount, amount_max_minor, amount_max, currency, turnaround_days, usage_rights, deliverables, visible, requestable, position, created_at, updated_at

media_kit.csv

Media kit: platforms and followers. Schema media_stat@1.

• id, platform, handle, followers, engagement_bp, position

brand_work.csv

Brands you worked with. Schema brand_work@1.

• id, brand, note, position

brand_work_media.csv

Photos and videos of that work. Schema brand_work_media@1.

• id, brand_work_id, kind, caption, position, file, created_at

clients.csv

Everyone you made a deal with, by email. Schema client@1.

• email, name, phone, country, first_deal_at, last_deal_at, deals, paid, paid_minor

deals.csv

Deals and quotes. Schema deal@1.

• id, created_at, updated_at, stage, source, client, client_email, client_phone, client_country, title, brief, rate_id, quote_minor, quote, currency, due_days, options, basis, chosen, split, booking

deal_lines.csv

Lines on each deal's quote. Schema deal_line@1.

• deal_id, position, description, note, quantity, unit_amount_minor, unit_amount, total_minor, total, currency, from_price

deal_events.csv

Each deal's timeline. Schema deal_event@1.

• id, deal_id, type, reason, by, at

invoices.csv

Invoices. Schema invoice@1.

• id, deal_id, no, part, status, amount_minor, amount, currency, period, period_from, period_to, due_on, created_at, paid_at, archived_at, receipt_no, payment_ref, pdf

invoice_lines.csv

Lines on each invoice. Schema invoice_line@1.

• invoice_id, position, description, note, quantity, unit_amount_minor, unit_amount, total_minor, total, currency, from_price

receipts.csv

Receipts. Schema receipt@1.

• id, invoice_id, no, amount_minor, amount, currency, created_at, archived_at, pdf

payments.csv

Payments through Piku (invoices, plan, SMS). Schema payment@1.

• id, reference, purpose, status, amount_minor, amount, currency, method, charge_id, email, fee_minor, fee, fee_currency, fee_percent, fee_payer, processing_fee_minor, processing_fee, processing_fee_currency, charged_minor, charged, reversal, reversed_minor, reversed, created_at, settled_at

schedules.csv

Repeat billing on deals. Schema schedule@1.

• deal_id, option, basis, status, next_on, anchor_day, period, lines, created_at, updated_at

wallet.csv

Wallet ledger: earnings, fees and withdrawals. Schema wallet_entry@1.

• id, kind, ref, label, amount_minor, amount, currency, created_at

withdrawals.csv

Withdrawals to your bank or mobile money (last 4 digits only). Schema withdrawal@1.

• id, status, amount_minor, amount, currency, fee_minor, fee, fee_currency, receive_minor, receive, receive_currency, destination_type, destination_network, destination_last4, destination_name, requested_at, sent_at, paid_at, failed_at, cancelled_at, failure

qr_codes.csv

QR codes. Schema qr_code@1.

• id, name, target, ink, scans, created_at

analytics/visits_daily.csv

Page visits per day, by source and country. Schema visits_daily@1.

• day, source, country, visits

analytics/clicks_daily.csv

Link clicks per day, by link and country. Schema clicks_daily@1.

• day, link_id, country, clicks

analytics/qr_scans_daily.csv

QR scans per day, by code and country. Schema qr_scans_daily@1.

• day, qr_id, country, scans

Left out

Sign-in sessions and tokens, links' secret codes, reply addresses, IP hashes, internal flags, and full payout account numbers (only the last 4 digits).