Data Source Page

Caplena makes it easy to merge different data sources in a single project, whether the data is uploaded via file or pulled automatically via integrations.

You can:

Combine reviews from multiple platforms, such as the Apple App Store and Google Play Store, into one cohesive analysis.
Mix manually uploaded data (Excel, CSV) with integrated data sources like Amazon or Trustpilot — all in one place.

This allows for a 360° view of your feedback across channels, perfect for analyzing multiple products, apps, or markets under one project umbrella.

💡 Example:

Create one project for a fitness app that includes survey responses from existing users (via Excel upload) and app store reviews (via Google and Apple integrations). This lets you compare internal feedback with public store reviews, all in one place.

Adding a New Data Source

To add a new file or connect an integration, simply click the “Add data source” button in the Data Sources section of your project. This will bring you to the familiar upload screen (see image below), where you can either:

Upload a file (.xls, .xlsx, .csv, .sav, .spss)
Select an integration from platforms like Amazon, Google Play, Trustpilot, etc.

After uploading your file or connecting an integration, you’ll be asked to match your columns to existing ones in the project.

On this screen, Caplena shows:

The new columns you're adding
The existing columns in your project
Suggested matches, especially for text to analyze (TTA), date fields, etc.

If there's no exact match, you’ll be prompted to take action.

If you don’t want to include a specific column, simply uncheck the box next to it under the "Keep" column. This is especially useful for skipping irrelevant metadata like internal IDs or unused tags.

The Data Sources page provides a clear overview of everything you’ve added to your project, whether via manual upload or external integration.

Activity Log

This section lists all your recent file uploads, including:

Date & time of the upload
Name of the source file
Number of rows added
Status (e.g. Completed, Cancelled)

💡 Tip:

Use this log to track upload history, troubleshoot issues, or ensure your latest data made it in.

Integrations

This section shows all active or pending external data connections, including:

Name/label of the integration
Source URL (e.g. from Trustpilot, Amazon, App Stores, etc.)
Type of integration
Row count (how many reviews have been imported)
Sync status (e.g. Initializing, Completed)

Once initialized, integrations will automatically pull in new data, if synchronization is enabled.