Data export

Principle: your data is always yours

tikento does not restrict data export on any plan. Manual export to CSV, XLSX, and JSON is always free. This is a fundamental principle: no vendor lock-in.

What data can be exported

Participants

A complete list of registered participants with all form fields:

• Name, email, phone, and other form fields
• Ticket type and options
• Registration status (registered, awaiting payment, canceled)
• Check-in status (checked in / not checked in)
• Registration date and time
• Promo code (if applied)

Payments

Financial data on transactions:

• Amount and currency
• Payment method (card, FPS, Telegram Stars, manual)
• Status (paid, refunded, pending)
• Payment date
• Idempotency key (for reconciliation)
• Platform commission

Analytics

Aggregated metrics:

• Registrations by day
• Revenue by period
• Funnel conversion
• Traffic sources (with UTM tags configured)

How to export

From the participant list

1. Open the event -> Registration tab -> Participants.
2. Set up filters (if needed): status, ticket type, registration date.
3. Click the Export button in the top right corner of the table.
4. Select the format: CSV, XLSX, or JSON.
5. The file will download in the browser.

From the analytics section

1. Open Analytics in the sidebar menu.
2. Set the period and filters.
3. On any chart or table, click the download icon.
4. Select the format.

From the payments section

1. Open the event -> Payments.
2. Filter by date, status, or payment method.
3. Click Export.

Export filters

When exporting, you can configure:

Filters applied to the on-screen table are automatically applied to the export.

Formats

CSV

• Delimiter: semicolon (;) for correct opening in Excel with European locale.
• Encoding: UTF-8 with BOM.
• Suitable for Google Sheets, LibreOffice Calc, and script processing.

XLSX

• Native Excel format.
• Preserves data types (dates, numbers) and formatting.
• Column headers in the interface language.

JSON

• Array of objects. Each record is one participant/payment.
• Suitable for loading into CRM, BI systems, and processing with code.
• Dates in ISO 8601 format.

Scheduled exports (Pro+)

On Pro, Business, and Enterprise plans, automatic scheduled exports are available.

Setup

1. Open Settings -> Export -> Scheduled exports.
2. Click Create.
3. Specify:
   • What data to export (participants, payments, analytics)
   • File format
   • Schedule (daily, weekly, monthly)
   • Delivery method: email or webhook URL
4. Click Save.

The file will be generated and delivered automatically. Export history is retained for 30 days.

Webhook delivery

When choosing webhook, tikento sends a POST request to the specified URL with the file in the request body. This is convenient for automatic loading into BI systems or storage.

Advanced export (Business+)

BI live connector (Business+) allows you to connect Metabase, Redash, Tableau, or another BI system directly to the tikento analytics layer for live queries.

SQL dump (Enterprise) -- a full export of your tenant's data in PostgreSQL dump format for offline analysis.

Export security

• Export is available only to users with the EXPORT_DATA permission (or the Owner/Admin role).
• Every export is logged in audit_log with information about who exported what data and when.
• Export files may contain personal data. Handle them in accordance with applicable data protection regulations and your organization's policy.
• Do not transfer files over unencrypted channels.