1. Granularity

The d_client_accounts dbt table has information about a client on a client level. This means that there is 1 row for 1 client.

You will be able to find the following data for each client:

• client_id
• client_name
• created_datetime
• is_offboarded
• deleted_at → deleted_datetime
• is_deleted
• is_external
• account_director
• delivery_manager
• industry
• parent_industry
• category
• subscription_start_datetime
• usage_revenue_cohort_month
• subscription_start_cohort_month
• assistant_created_cohort_month
• company_created_cohort_month