ETL Bitrix24 data to Google BigQuery

Represents leads captured before qualification in the Bitrix24 CRM. Contains prospect data such as contact details, source, status, assigned user, and custom fields used for early-stage pipeline analysis.

Stores individual person records linked to CRM activity. Includes personal and business contact information, communication channels, responsible user, and relationships to leads, deals, and companies.

Represents organization-level customer or prospect records in the CRM. Contains company attributes such as name, industry, revenue-related fields, addresses, assigned owner, and links to contacts and deals.

Captures sales opportunities moving through the pipeline. Includes deal amount, currency, stage, probability, category, assigned user, related contact or company, and custom fields for revenue reporting and forecasting.

Stores interactions associated with CRM entities, such as calls, emails, meetings, and tasks. Useful for reconstructing engagement history, measuring sales activity, and analyzing response timelines.

Represents work items managed in Bitrix24 Tasks. Contains task metadata such as title, description, status, deadlines, participants, creator, responsible user, and time tracking fields for operational reporting.

Provides access to Bitrix24 user directory data. Includes employee profile information such as name, email, department, active status, position, and other attributes commonly used for ownership and permission mapping.

Represents the organizational structure of the Bitrix24 account. Contains department hierarchy, parent-child relationships, and department names, which are useful for team-level reporting and access modeling.