Raw Data Exports from Marfeel to your data warehouse

Marfeel lets you export large amounts of raw data at regular intervals directly to your data warehouse. Organizations become permanent owners of their data and can use it however they see fit. Every organization is different, and sometimes it is necessary to go back to the raw building blocks and construct something new to answer specific queries in the most helpful way.

Raw Data Exports provide additional insights and ways to use data that are not accessible any other way. Perform custom analysis to answer questions specific to the organization.

• Audience segmentation: Segment audience based on demographic and behavioral data like age, gender, and location. Achieve more granularity in terms of user behavior. For example:
  • User region and user city: See if your users are accessing the site from New South Wales, Barcelona, or Cape Town.
  • Split RFVinto separate metrics: access not only the final loyalty score, but the individual factors: date last accessed, how often accessed, volume of pageviews.
• Data integration: Integrate data from multiple sources to perform custom analysis on the combined dataset.
• Data science: Raw Data Exports can be fed into Excel or data visualization tools like Tableau. Feed raw data into Google Data Studio or interactive data exploration environments such as Jupyter Notebooks, R Studio, and scikit-learn.
• Historical analysis: Raw Data Exports can provide access to historical data that may go back further than the data retention period agreed with Marfeel.

Data export methods

There are several ways to export data from Marfeel, ranging from straightforward to more complex depending on the needs of the individual or organization.

• CSV file: Export any Explore query as a CSV file to load in your spreadsheet application.
• Online Spreadsheets: Export to Google Sheets and Excel for the web from any Explore report.
• Google Sheets add-on: Marfeel for Google Sheets is an extension available from Sheets. It uses Marfeel’s API to execute and schedule reports within Google Sheets.
• Marfeel API: Create a request object for direct access to Marfeel’s data reporting structure in order to customize queries, automate operations, and integrate data with other applications.
• Raw Data Exports: Execute data dumps using Marfeel’s Google Cloud Storage or Amazon S3 integrations to keep data in your possession in perpetuity and perform custom analysis. If you run into issues, see troubleshooting Raw Data Exports for monitoring data stream logs.

What types of custom analysis can raw data exports support?

Raw data exports support audience segmentation by demographics and behavior, data integration from multiple sources, data science workflows in tools like Tableau and Jupyter Notebooks, and historical analysis beyond the standard data retention period.

What are the available methods for exporting data from Marfeel?

Marfeel offers five export methods: CSV file exports from Explore queries, direct export to Google Sheets and Excel for the web, the Marfeel for Google Sheets add-on for scheduled reports, the Marfeel Reporting API for custom queries and automation, and Raw Data Exports via Google Cloud Storage or Amazon S3.

How can organizations permanently own their Marfeel data?

Organizations can execute data dumps using Marfeel’s Google Cloud Storage or Amazon S3 integrations. This keeps data in your possession in perpetuity, allowing you to perform custom analysis and answer organization-specific queries with the raw building blocks.