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

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.

Nightly delivery window

Scheduled exports are delivered nightly between 03:00 and 06:00.

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

1

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.

2

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.

3

Validate with a manual send

Click Send to trigger an export.

Manual sends are limited to 3 times per day.

File naming

Files are delivered with these naming patterns:

• appkey_PUSH_REPORTS_date

• appkey_msgID_PUSH_REPORTS_date (when External ID Breakdown is enabled)

306KB

Sample Campaign Report.xlsx

Open

Sample Campaign Report

338KB

Sample Campaign Report with External IDs.xlsx

Open

Sample Campaign Report with Ex IDs

338KB

Sample Automated Campaign Reports.xlsx

Open

Sample Automated Campaign Report

338KB

Sample Transactional Campaign Report.xlsx

Open

Sample Transactional Campaign Report

869B

App Tracking Sample.csv

Open

App Tracking Sample

652B

Installation & Permission Sample Data File.csv

Open

Installation & Permission Sample Data File

306KB

Events Sample.xlsx

Open

Events Sample

Panel Export Dashboard

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.

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.

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.

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.

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.

Monthly and Bulk

These options apply only to Installation & Permission exports.

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.