Table: dim_account_contact

Type: Dimension Columns: 18

Description

Account contact information. The data grain is contacts within accounts.

Columns

Column Name Type Description
contact_id string

Unique identifier for the contact (A contact may belong to more than one account)

account_id string

Unique identifier for the account

business_id string

Unique identifier for the business

contact_last_name string

The last name of the contact

contact_first_name string

The first name of the contact

contact_type string

The type of contact; enumerated: 'Primary' or 'Non-Primary'

email string

The email of the contact

primary_phone string

The primary phone number of the contact

mobile_phone string

The mobile phone number of the contact

home_phone string

The home phone number of the contact

work_phone string

The work phone number of the contact

country string

The country where the contact is located

state string

The state where the contact is located

city string

The city where the contact is located

postal_code string

The postal code of the contact's address

address string

The first line of the contact's address

data_current_as_of_utc timestamp[ns] No description provided.
source_type string No description provided.