Data Exports

Data exports send daily raw DMP data to a destination controlled by the advertiser or data team.

Exports start from the moment the integration is saved. They do not backfill historical days automatically.

Where To Configure

  1. Open Sites.
  2. Open the target site.
  3. Go to Integrações > Database export.
  4. Enable Enable daily export.
  5. Choose the destination type.
  6. Fill in table names and connection details.
  7. Save the integration.

Exports run after midnight in the site's timezone.

Exported Tables

The integration writes daily data into these logical tables:

Table Default Name Purpose
Users site_users Visitor-level identity, profile, and audience fields.
User attributes Created with the integration schema Attribute rows connected to users.
Sessions site_sessions Session-level journey, referrer, UTM, and conversion context.

The screen can show table creation SQL when an integration is saved.

Relational Destinations

Supported relational destinations:

  • MySQL
  • PostgreSQL
  • SQL Server

Required fields:

Field Description
Host / IP Database host reachable from Orbital export infrastructure.
Port Database port.
Database Target database name.
Schema Optional schema name, mainly for PostgreSQL/SQL Server.
Username Database user used by the exporter.
Password Database password. Leave blank later to keep the current password.
Users table Destination table for visitor rows.
Sessions table Destination table for session rows.

Allowlist the outbound IPs shown in the integration screen before saving, when the database is behind a firewall.

BigQuery Destination

Required fields:

Field Description
Project ID Google Cloud project ID.
Dataset BigQuery dataset where tables should be created or updated.
Service account JSON JSON key for a service account with permissions on the dataset.
Users table Destination table for visitor rows.
Sessions table Destination table for session rows.

Recommended BigQuery permissions:

  • Create tables in the dataset.
  • Update table schema when required.
  • Insert rows.
  • Read dataset metadata.

Use a dedicated service account for the DMP export instead of a personal user credential.

Status And Monitoring

The integration page shows:

  • Enabled status.
  • Driver.
  • Activation time.
  • Next export date.
  • Last exported date.
  • Provisioning status and errors.
  • Last upload summary.
  • Recent uploads.

If provisioning fails, review credentials, firewall rules, dataset/table permissions, and table names.

Manual Export

When available to your role, Send yesterday now exports the previous day immediately.

Manual export does not duplicate a day that was already exported.