# Data Export

Export automates scheduled exports from Netmera to your FTP server. Use it for nightly report delivery and on-demand exports.

### Key behaviors and limits

{% hint style="info" %}
**7-day scan window (Push Reports)**

Push Report exports scan the **last 7 days** to resolve the **push send date**.

If the send is older than 7 days, the export does not look further back.
{% endhint %}

{% hint style="info" %}
**Nightly delivery window**

Scheduled exports are delivered nightly between **03:00 and 06:00**.
{% endhint %}

### What you need

Have these ready before setup:

* FTP **host**, **port**, and **path**.
* Auth method: **username/password** or **SSH key**.
* If you connect to a Netmera-hosted server: the **public IP** you will connect from (for allowlisting).

### Set up FTP export

{% stepper %}
{% step %}

#### Create or request an FTP user

Pick one model:

* **Customer-created FTP user:** You host the FTP server. Netmera uploads to your server.
* **Netmera-created FTP user:** Netmera hosts the FTP user. You connect to Netmera’s server. Connections are restricted to predefined IPs.
  {% endstep %}

{% step %}

#### Configure Export in the panel

Open: **Netmera Panel → Reports → Export**.

If you don’t see Export, ask your CSM to enable it for your account.

Then configure:

* **Reports** tab: pick the export type and file format.
* **Settings** tab: set server, credentials, and frequency.
  {% endstep %}

{% step %}

#### Validate with a manual send

Click **Send** to trigger an export.

Manual sends are limited to **3 times per day**.
{% endstep %}
{% endstepper %}

### File naming

{% hint style="info" %}
Files are delivered with these naming patterns:

* `appkey_PUSH_REPORTS_date`
* `appkey_msgID_PUSH_REPORTS_date` (when **External ID Breakdown** is enabled)
  {% endhint %}

{% file src="<https://1642824329-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FX6uilbEAw42gqsudlclY%2Fuploads%2FjjZM2MtEFzwvRusIFr22%2FSample%20Campaign%20Report.xlsx?alt=media&token=f304f394-b99d-418a-a5ee-f00b6bfc143b>" %}
Sample Campaign Report
{% endfile %}

{% file src="<https://1642824329-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FX6uilbEAw42gqsudlclY%2Fuploads%2Fw7cZlwdf8z0z0hBDBsCC%2FSample%20Campaign%20Report%20with%20External%20IDs%20.xlsx?alt=media&token=ff86eeaf-b27d-4097-8cfd-514a01d0e9b8>" %}
Sample Campaign Report with Ex IDs
{% endfile %}

{% file src="<https://1642824329-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FX6uilbEAw42gqsudlclY%2Fuploads%2FRPYElA8BK2YpSOGkXLJf%2FSample%20Automated%20Campaign%20Reports.xlsx?alt=media&token=f951e3e4-d84b-44fc-9c21-38ef9676e27e>" %}
Sample Automated Campaign Report
{% endfile %}

{% file src="<https://1642824329-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FX6uilbEAw42gqsudlclY%2Fuploads%2FqQ23BsP9pfvFthqJ9fqP%2FSample%20Transactional%20Campaign%20Report.xlsx?alt=media&token=26a926ff-bec4-470f-b627-d1580bddbef3>" %}
Sample Transactional Campaign Report
{% endfile %}

{% file src="<https://1642824329-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FX6uilbEAw42gqsudlclY%2Fuploads%2FcczXPCQfVP2T1n6sE4m2%2FApp%20Tracking%20Sample.csv?alt=media&token=e6866513-9664-449e-89c5-eae8eca3733a>" %}
App Tracking Sample
{% endfile %}

{% file src="<https://1642824329-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FX6uilbEAw42gqsudlclY%2Fuploads%2FYFTdQXt2Aq0QE1vP4IrB%2FInstallation%20%26%20Permission%20Sample%20Data%20File.csv?alt=media&token=c607f6af-0fb7-4dd8-a1ec-369ba9b3a53c>" %}
Installation & Permission Sample Data File
{% endfile %}

{% file src="<https://1642824329-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FX6uilbEAw42gqsudlclY%2Fuploads%2FB86hKt2DAcWwvdj5Slc8%2FEvents%20Sample.xlsx?alt=media&token=929bed8a-d33f-47b6-9f41-b7814111991d>" %}
Events Sample
{% endfile %}

### Panel Export Dashboard

{% @arcade/embed url="<https://app.arcade.software/share/QqnqYNv3JjE80id3CZb3>" flowId="QqnqYNv3JjE80id3CZb3" %}

### Use the Export dashboard

Work in two tabs:

* **Reports:** what to export and in which format.
* **Settings:** where to send it and how often.

### Reports tab: choose what to export

Pick an export type.

Then configure its options and click **Send**.

**1. Push Reports**

Campaign performance metrics such as opens, conversions, and engagement.

* **External ID Breakdown:** Adds an extra breakdown by external ID.

<figure><img src="https://1642824329-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FX6uilbEAw42gqsudlclY%2Fuploads%2F6d0Xqz4dF0VsuHa12SWp%2FScreenshot%202026-01-29%20at%2011.02.30.png?alt=media&#x26;token=53cad3ca-7168-44be-94b1-78eec0bc54cd" alt=""><figcaption></figcaption></figure>

**2. Event Data**

User events with name, timestamp, and parameters.

* You can customize which events (e.g., **Open App**, **Widget Shown**) are exported for analysis.

<figure><img src="https://1642824329-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FX6uilbEAw42gqsudlclY%2Fuploads%2F83LPjGDQb75SnKDF54iN%2FScreenshot%202025-07-22%20at%2017.11.36.png?alt=media&#x26;token=dba06f0e-d29e-4092-8b88-88d36dbc0075" alt=""><figcaption></figcaption></figure>

**3. App Tracking**

Apps installed on users’ devices.

**4. Installation & Permission**

Install details and granted permissions.

* **Monthly** and **Bulk** are available only for **Installation** exports.

**5. Channel Permission**

Provides data on user reachability across multiple communication channels, including **Mobile**, **Web**, **SMS**, and **Email**.

* **Incremental behavior:** First export is **full**. Next exports include **only updated/changed attributes**.

<figure><img src="https://1642824329-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FX6uilbEAw42gqsudlclY%2Fuploads%2FPIWp4W7w1sgkor1SpvyS%2FScreenshot%202025-07-22%20at%2017.10.47.png?alt=media&#x26;token=654eab67-61a7-4d2e-99dc-fb735ea5b7ef" alt=""><figcaption></figcaption></figure>

### Reports tab: file format

Choose **.xlsx** or **.csv**.

* If you select **.csv**, the **Delimiter Type** option becomes available.
* Supported delimiters include **Comma**, **Pipe**, **Tilde**, **Broken Pipe**, **Caret**, or **Semicolon**, allowing you to choose the format that best fits your requirements.

<figure><img src="https://1642824329-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FX6uilbEAw42gqsudlclY%2Fuploads%2Fnlbu2LAQ4esHsvO2rFgn%2FScreenshot%202025-07-22%20at%2014.22.09.png?alt=media&#x26;token=f0c30755-7449-4de3-a6c5-7ea28369d9b1" alt="" width="563"><figcaption></figcaption></figure>

### Settings tab: FTP connection and frequency

Open: **Netmera Panel → Reports → Export → Settings**.

1. **Server:** FTP server address.
2. **Port:** FTP port.
3. **Path:** Target folder on the FTP server.
4. **Username & Password:** FTP credentials.
5. **Export Frequency:** How much data to include per run.

* **Daily:** Users updated in the last 24 hours.
* **Monthly:** Users updated in the last 30 days.
* **Bulk:** All users, regardless of update date.

{% hint style="warning" %}
**Monthly and Bulk**

These options apply only to **Installation & Permission** exports.
{% endhint %}

### Settings tab: SSH key authentication

Open: **Netmera Panel → Reports → Export → Settings**.

Then set **Export Authorization Type → SSH Key**.

Use SSH keys instead of passwords when your FTP server supports it.

1. **Select SSH Key** as the authentication type.
2. **Generate SSH Public Key:** The system creates a secure public key automatically.
3. **Copy SSH Key:** Click **Copy** to save it to your clipboard.
4. **Grant FTP Access:** Add the copied SSH key to the FTP server to allow secure connections.

<figure><img src="https://1642824329-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FX6uilbEAw42gqsudlclY%2Fuploads%2FzINnMfrXJql15GhHwun4%2FScreenshot%202025-07-22%20at%2017.12.09.png?alt=media&#x26;token=6c9833b8-e5b4-4bd6-a8e0-c86a621c8a01" alt=""><figcaption></figcaption></figure>