Start free
Read & reportRead-only source

See your Ortto numbers in Data Studio.

Review Ortto marketing audiences, activity definitions and contact profiles in a read-only data source.

  • Campaign, list and subscriber results in one refreshing sheet
  • Compare sends month over month without exporting
  • Ask an AI assistant which emails worked, using live Ortto data
OrttoData StudioData Studio

Start free Connect Ortto

Updated November 2026

Ortto reportSample data
Audience nameTypeMembers
Active Trial Userssegment3,420
640640640
210210210
Refreshes on your schedule in Data Studio

Who uses Datapipe with Ortto

Lifecycle marketers

Track opens, clicks and list growth across every send.

Founders

See whether the newsletter is growing without logging in.

Agencies

Send each client a monthly email performance report.

What you can do with Ortto

Read-only source

Datapipe reads Ortto data for reports. It never changes anything in Ortto.

Full read details

Customer journeys and contacts are never modified.

Examples for your team

Read & report

Track lifecycle audiences and contacts

Combine audience member counts, activity definitions and customer profiles across Ortto.

  1. Scheduled refresh
  2. Latest Ortto data
  3. Updated report

Before you connect

What you need

An API key or token from your Ortto account.

Read-only

Read access only. Datapipe never changes anything in Ortto.

Limits and exclusions

Read-only. Journeys and contacts are never changed, and contact reports include emails.

Full details and limits

Customer audiences, activity definitions, and contact profiles from Ortto.

Read-only reporting access using your Ortto X-Api-Key. Journeys, audiences, and contacts are never modified.

Read-only. Journeys and contacts are never changed, and contact reports include emails.

Reports you can build

3 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.

What each dataset reports
  • Audiences

    Ortto audiences with type, member count and subscriber count.

  • Activity definitions

    Custom activity definitions in your Ortto account with display type and whether they are archived.

  • Contacts

    Ortto contacts with email, first name and last name.

Metrics and dimensions

13 report fields across 3 datasets.

Hover or tap a field to see what it means. Custom fields from your own account appear after you connect.

Send Ortto data anywhere

Ask AI about your data

Claude or ChatGPT can read the same numbers. You ask in a normal sentence, and the answer stays with your report.

Summarize Ortto audiences, activity definitions, and contact totals.

Active Trial Users leads with 3,420 members across 18 tracked custom activities.

Better than exporting by hand

Start from a goal

How it works

  1. Create a project and choose Ortto in Data sources.

  2. Pick where it goes. This one sends the numbers to Data Studio.

  3. Pick where it goes. Choose audiences, activities or contacts and a destination.

Sample report

Ortto reportSample data
Audience nameTypeMembersActivity nameDisplay typeArchived
Active Trial Userssegment3,4201,2401,2401,240
640640640640640640
210210210210210210

Sample numbers, so you can see the shape. Your report uses your accounts.

Works well with Ortto

Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.

Questions

Free to start. Paid plans add more data sources and refresh faster.

Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.

No. Name a project, add a data source, then choose a report and destination.

OAuth means you sign in with the service and grant access, without pasting an API key. Datapipe works with multiple partners to provide that sign-in. Some partners already provide it. Some integrations are API-only at present, so you paste a key or token. OAuth is coming soon for some. Some partners do not provide OAuth at all. The setup steps on each integration page say how that source connects. Signing in is only how the connection is made. It is not permission to change records. Where a source supports changes, those writes stay off until the workspace owner turns specific actions on and approves each one. We do not promise OAuth on every source, and we do not share dates.

This integration is read-only in Datapipe. You can report on Ortto, send the reports to your destinations and ask an AI assistant about them. Datapipe never changes anything in Ortto. Read-only reporting access using your Ortto X-Api-Key. Journeys, audiences, and contacts are never modified.

This page lists 13 report fields across 3 datasets. You pick the columns when you build the report.

Customer audiences, activity definitions, and contact profiles from Ortto. Account permissions and the records available from the provider determine which rows can be read.

One for each Ortto account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.

Yes. The same numbers can go to a sheet, a chart, a warehouse, or an assistant.

Try Ortto with sample data first

Build the report first, then add Ortto when you are ready.

Start free Add data source