You can download your Conjura product-level data directly using any SFTP client.
Step 1: Get Your Credentials
Go to https://app.conjura.com/settings/data-access and click Create new credential.
Once generated, copy your username and password.
Step 2: Connect with an SFTP Client
Download any SFTP client (e.g., https://cyberduck.io/, https://filezilla-project.org/, or WinSCP) or via an SFTP portal on your third-party tool of choice.
Use these connection settings:
Setting | Value |
Protocol | SFTP |
Host | data.conjura.com. (final |
Port | 22 |
Username | From Step 1 |
Password | From Step 1 |
Step 3: Download Your Data
Once connected, navigate to /data/conjura_metrics.parquet. This file contains your organization's metrics data in Parquet format and is refreshed daily.
FAQs
What file format is the data in?
Parquet. This format is efficient and widely supported by tools like Python (pandas), DuckDB, Excel (via plugins), and most data platforms.
My integration requires specific column names or a custom schema
Our export uses a fixed schema - the column names and structure are the same for all customers. We can't customize the export to match a specific tool's expected format (e.g., renaming product_sku to sku or gross_revenue to price).
If your tool requires a specific format, you'll need to transform the data yourself before loading it. Common approaches:
Download via SFTP → transform with a script or spreadsheet → upload to your tool
Use an intermediary like Google Sheets to reshape the data
Let us know which integration you're working with - if there's enough demand, we may add native support.
Data Schema
The export file contains daily product-level metrics across your data sources.
Column | Description |
conjura_account_id | Your Conjura account identifier |
updated_at | When this data was last refreshed |
currency_code | Currency for monetary values |
store_key | Unique store identifier |
store_name | Store display name |
product_key | Unique product identifier |
product_sku | Product SKU |
date | Date of the metrics |
unique_purchases | Number of unique purchases |
gross_revenue | Total revenue |
net_revenue | Revenue excl. tax |
new_customer_gross_revenue | Revenue from first-time customers |
existing_customer_gross_revenue | Revenue from repeat customers |
num_new_customers | Count of new customers |
contribution | Profit contribution |
ad_spend | Marketing spend |
impressions | Ad impressions |
clicks | Ad clicks |
product_views | Product page views |
ltv_gross_revenue | Lifetime value (gross) |
ltv_profit_ex_marketing | LTV profit excluding marketing spend |
ltv_num_repeating_customers | Number of repeat customers |
ltv_net_revenue | Lifetime value (net) |