Product

Learn

Data sourcesApps and databases →DocsHow Orcabase works →PricingPlans and prices →
Log inGet started

Linear + Orcabase

Where does your team’s time go?

Sync Linear through Fivetran and ask how much of each cycle goes to bugs, which projects slip and how fast issues move, in plain words.

Get startedHow to connect
  • Synced by Fivetran
  • Syncs every 6 hours
  • No Fivetran account needed
AgentLinear connected

How much of each cycle went to bugs?

Reading your Linear data…

Bugs took 34% of the last cycle, the most this year.

  • Most came from the new import feature.
  • Feature issues finished dropped to 11, from 18.
  • Bugs reported by customers were fixed in 2 days on average.

Bug share by cycle, %

C1C2C3C4C534C6
How I got this· 4 steps
  1. Looked at your Linear issues and cycles
  2. Kept issues finished in each cycle
  3. Split them into bugs and everything else
  4. Grouped the latest bugs by project

Example answer. Numbers are illustrative.

In plain words

How can I report on Linear cycles and projects?

Linear shows the work in front of you. Trends across cycles, like how much time goes to bugs, need history. Fivetran copies your issues, cycles and projects into a database Orcabase hosts for you.

Ask in plain words, and see the work next to the support tickets and revenue it affects.

Ask in plain words

What you can ask about your Linear data

The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.

Meet the data agent

  • How much of each cycle went to bugs?

  • Which projects are behind their target date?

  • How long do issues take from started to done?

  • How many issues did each team finish this month?

  • Which labels come up most on bugs?

  • How much work carries over between cycles?

  • How fast do we fix bugs customers report?

  • Show me issues created and completed by week.

What comes in

Your Linear data, ready to ask about.

A copy in a database Orcabase hosts for you, with its own folder for each app.

01

Issues

Every issue, with its state, priority, estimate, labels and assignee, archived ones included.
02

Cycles

What each cycle planned, and what it finished.
03

Projects

Projects, their status and target dates.
04

Teams and users

Who works on what.

Numbers worth defining

Define them once. Every answer agrees.

Tell Orcabase what each number means, certify it, and your dashboards, the agent and your whole team use the same one. The agent can draft these from your Linear data.

How metrics work

  • Bug share

    Share of finished issues that were bugs.

  • Cycle completion

    Share of a cycle’s planned issues that were finished in it.

  • Time to done

    Days from started to done.

  • Scope added

    Issues added to a cycle after it began.

Dashboards to start with

Your Linear numbers at a glance.

Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.

Cycles

4 charts
  • Bug share by cycle
  • Cycle completion
  • Issues done by week
  • Carry-over

Projects

3 charts
  • Projects by status
  • Behind target date
  • Time to done

About dashboards

Better together

Ask across Linear and the rest of your business.

The best questions need more than one app. The agent can pull from several sources for one answer.

“Which bugs do customers write to us about most?”

Linear + Intercom

“How long does an issue wait for its pull request to merge?”

Linear + GitHub

“Did the features we shipped last cycle get used?”

Linear + PostHog

How to connect

Connect Linear, step by step.

  1. 1

    Find it in Sync data

    In Orcabase, go to Sync data → Add source and search for Linear. Pick the database to sync into.

  2. 2

    Connect Linear on Fivetran’s page

    Fivetran’s page asks for a Linear personal API key, which you create in Linear’s settings.

  3. 3

    Choose what to sync

    Back in Orcabase, tick the data you want. Only what you pick is synced, and only it counts toward your allowance.

  4. 4

    Ask away

    The first sync starts straight away. When it’s done, ask the agent about your Linear data.

What you’ll need

  • A Linear login that can create a personal API key.
  • The Admin role in Orcabase, and data hosting: Fivetran writes into a database Orcabase hosts for you.
At a glance
How it connects
Synced by Fivetran
How fresh
Every 6 hours, as standard.
Where your data lives
A copy in a database Orcabase hosts for you, with its own folder for each app.
Who can set it up
An admin in your organization.
Your login
You sign in on Fivetran’s own page. Orcabase never sees your password or keys.
Cost
Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard.
Sync apps with FivetranStep-by-step, in the docs.

Questions

About Linear and Orcabase

More in the docs: Sync apps with Fivetran

Does it include archived issues?
Yes. Archived issues come along too, so counts over time stay honest.
Can Orcabase change issues?
No. Orcabase only reads the synced copy.
Do I need a Fivetran account?
No. Orcabase uses its own. You sign in to Linear on Fivetran’s page, and the data lands in a database Orcabase hosts for you, so there’s nothing else to set up or pay Fivetran for.
How fresh is my Linear data in Orcabase?
Fivetran syncs it every 6 hours as standard, and an admin can run a sync by hand at any time. The page for each source shows when it last synced and when it syncs next.
What does syncing cost?
Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard. Each distinct row that’s added or changed in a month counts once, however often it changes, and the first full copy is free. You choose which tables sync, so you only spend the allowance on what you need.

Keep exploring

More data sources

All data sources

Your Linear data already has the answers.

Connect it, ask your first question, and pin the answers you want to see every week.

Get startedAll data sources