Bulk Export

Bulk Export is an enterprise feature that provides direct access to your data stored in Moesif. It allows you to efficiently retrieve hundreds of millions of User and Company Lookup data from Moesif and quickly load them into data warehouses like Snowflake, Redshift, and BigQuery.

You can use Bulk Export both from Moesif UI in the browser and Moesif Management API. Using the Management API, you can set up recurring bulk exports for different use cases—for example, a data pipeline that feeds your data in Moesif into a data warehouse like BigQuery.

Bulk Export is designed to move large amounts of your raw events for archival and data warehousing purposes. If you want to import a chart’s dataset into tools like Microsoft Excel and Google Sheets, download the chart instead for your Composition analysis.

Supported Analysis Types

Bulk export is available for User and Company Lookup analysis.

Supported Export File Types

Moesif supports the following file types for bulk export:

CSV
CSV files have some of the widest support for many of your favorite tools. This makes it ideal for exporting user and company data to your CRM and more.
JSON
JSON has become a standard for parsing data quickly for scripting purposes. Many fields in Moesif are deeply nested, making JSON an ideal choice.
Parquet
Parquet is an open source column-oriented data format that can make analysis on a subset of columns faster when compared to loading the entire file in memory. Your schema is directly embedded in the file. This can help SQL warehouse-like tools that require strict schema enforcement.

Event Filters for Exported Data

Bulk exports adhere to any filters that you have applied. Make sure you apply the filters you require before exporting.

Export Lookup Data from Moesif Portal

To export Lookup analysis data from Moesif Portal, follow these steps:

  1. Go to your Lookup workspace.
  2. Select Export and then select Bulk Export.
  3. Specify the email address where you want Moesif to send the export file.
  4. Select the export file format.
  5. Select the fields you want to include in the export.
  6. Select Start Export.

The time it takes to export your data depends on the number of customers you export and the number of fields you select.

Export Lookup Data using Moesif Management API

If you want to trigger export jobs using Moesif Management API, contact your account manager or reach out to support for instructions.

Fields Selection

If you don’t want to include all Lookup fields in the bulk export, you can specify the fields you want in the Lookup table before selecting Bulk Export. Otherwise, select All Fields in the Bulk Events Export dialog.

Updated: