We need detailed agent time reporting in our warehouse and Looker dashboards. Aircall Analytics+ exposes both high-level availability and detailed substatus (on_break, out_for_lunch, in_training, back_office, other).

Problem:

• The current Fivetran Aircall connector syncs only availability_status

• The substatus field from Aircall’s User APIs and webhooks is not captured. 

• As a result, we cannot reproduce the “% of time by detailed status” chart available in Aircall Analytics+.

Impact:

• Blocks adherence, coaching, and scheduling reporting for teams and users.

• Without substatus, managers lose visibility into why agents are unavailable.

Request:

• Add substatus to the connector’s schema.

• Create a history table (with started_at, ended_at, availability, substatus) that tracks status changes over time.

• This would allow us to calculate duration_seconds and percent of time in each detailed state, aligned with Aircall Analytics+.