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 or /data/conjura_metrics.csv. This file contains your organization's metrics data and is refreshed daily.
FAQs
What file format is the data in?
Parquet and CSV.
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) |