Pipedrive → Google BigQuery: data schema – OWOX Help Center

Pipedrive data is imported to 12 separate Google BigQuery tables.

activities

Filed	Type
`add_time`	STRING
`assigned_to_user_id`	INTEGER
`attendees`	ARRAY
`busy_flag`	BOOLEAN
`calendar_sync_include_context`	BOOLEAN
`company_id`	INTEGER
`conference_meeting_client`	STRING
`conference_meeting_id`	STRING
`conference_meeting_url`	STRING
`created_by_user_id`	INTEGER
`deal_dropbox_bcc`	STRING
`deal_id`	INTEGER
`deal_title`	STRING
`done`	BOOLEAN
`due_date`	STRING
`due_time`	STRING
`duration`	STRING
`file`	OBJECT
`file.clean_name`	STRING
`file.id`	STRING
`file.url`	STRING
`gcal_event_id`	STRING
`google_calendar_etag`	STRING
`google_calendar_id`	STRING
`id`	INTEGER
`last_notification_time`	STRING
`last_notification_user_id`	INTEGER
`lead_id`	INTEGER
`location`	STRING
`location_admin_area_level_1`	STRING
`location_admin_area_level_2`	STRING
`location_country`	STRING
`location_formatted_address`	STRING
`location_lat`	NUMBER
`location_locality`	STRING
`location_long`	NUMBER
`location_postal_code`	STRING
`location_route`	STRING
`location_street_number`	STRING
`location_sublocality`	STRING
`location_subpremise`	STRING
`marked_as_done_time`	STRING
`note`	STRING
`notification_language_id`	INTEGER
`org_id`	INTEGER
`org_name`	STRING
`owner_name`	STRING
`participants`	ARRAY
`person_dropbox_bcc`	STRING
`person_id`	INTEGER
`person_name`	STRING
`public_description`	STRING
`rec_master_activity_id`	INTEGER
`rec_rule`	STRING
`rec_rule_extension`	STRING
`reference_id`	INTEGER
`reference_type`	STRING
`series`	STRING
`source_timezone`	STRING
`subject`	STRING
`type`	STRING
`update_time`	STRING
`update_user_id`	INTEGER
`user_id`	INTEGER

person_fields

Filed	Type
`active_flag`	BOOLEAN
`add_time`	STRING
`add_visible_flag`	BOOLEAN
`bulk_edit_allowed`	BOOLEAN
`details_visible_flag`	BOOLEAN
`edit_flag`	BOOLEAN
`field_type`	STRING
`filtering_allowed`	BOOLEAN
`id`	INTEGER
`important_flag`	BOOLEAN
`index_visible_flag`	BOOLEAN
`key`	STRING
`last_updated_by_user_id`	INTEGER
`mandatory_flag`	BOOLEAN
`name`	STRING
`options`	ARRAY
`order_nr`	INTEGER
`searchable_flag`	BOOLEAN
`sortable_flag`	BOOLEAN
`update_time`	STRING

organization_fields

Filed	Type
`active_flag`	BOOLEAN
`add_time`	STRING
`add_visible_flag`	BOOLEAN
`bulk_edit_allowed`	BOOLEAN
`details_visible_flag`	BOOLEAN
`edit_flag`	BOOLEAN
`field_type`	STRING
`filtering_allowed`	BOOLEAN
`id`	INTEGER
`important_flag`	BOOLEAN
`index_visible_flag`	BOOLEAN
`key`	STRING
`last_updated_by_user_id`	INTEGER
`mandatory_flag`	BOOLEAN
`name`	STRING
`options`	ARRAY
`order_nr`	INTEGER
`searchable_flag`	BOOLEAN
`sortable_flag`	BOOLEAN
`update_time`	STRING

stages

Filed	Type
`active_flag`	BOOLEAN
`add_time`	STRING
`deal_probability`	INTEGER
`id`	INTEGER
`name`	STRING
`order_nr`	INTEGER
`pipeline_deal_probability`	BOOLEAN
`pipeline_id`	INTEGER
`pipeline_name`	STRING
`rotten_days`	INTEGER
`rotten_flag`	BOOLEAN
`update_time`	STRING

activity_fields

Filed	Type
`active_flag`	BOOLEAN
`add_time`	STRING
`add_visible_flag`	BOOLEAN
`bulk_edit_allowed`	BOOLEAN
`details_visible_flag`	BOOLEAN
`edit_flag`	BOOLEAN
`field_type`	STRING
`filtering_allowed`	BOOLEAN
`id`	INTEGER
`important_flag`	BOOLEAN
`index_visible_flag`	BOOLEAN
`key`	STRING
`last_updated_by_user_id`	INTEGER
`mandatory_flag`	BOOLEAN
`name`	STRING
`options`	ARRAY
`order_nr`	INTEGER
`searchable_flag`	BOOLEAN
`sortable_flag`	BOOLEAN
`update_time`	STRING

deals

Filed	Type
`active`	BOOLEAN
`activities_count`	INTEGER
`add_time`	STRING
`cc_email`	STRING
`close_time`	STRING
`creator_user_id`	INTEGER
`currency`	STRING
`deleted`	BOOLEAN
`done_activities_count`	INTEGER
`email_messages_count`	INTEGER
`expected_close_date`	STRING
`files_count`	INTEGER
`first_won_time`	STRING
`followers_count`	INTEGER
`formatted_value`	STRING
`formatted_weighted_value`	STRING
`id`	INTEGER
`label`	STRING
`last_activity_date`	STRING
`last_activity_id`	INTEGER
`last_incoming_mail_time`	STRING
`last_outgoing_mail_time`	STRING
`lost_reason`	STRING
`lost_time`	STRING
`next_activity_date`	STRING
`next_activity_duration`	STRING
`next_activity_id`	INTEGER
`next_activity_note`	STRING
`next_activity_subject`	STRING
`next_activity_time`	STRING
`next_activity_type`	STRING
`notes_count`	INTEGER
`org_hidden`	BOOLEAN
`org_id`	INTEGER
`org_name`	STRING
`owner_name`	STRING
`participants_count`	INTEGER
`person_hidden`	BOOLEAN
`person_id`	INTEGER
`person_name`	STRING
`pipeline_id`	INTEGER
`probability`	NUMBER
`products_count`	INTEGER
`rotten_time`	STRING
`stage_change_time`	STRING
`stage_id`	INTEGER
`stage_order_nr`	INTEGER
`status`	STRING
`title`	STRING
`undone_activities_count`	INTEGER
`update_time`	STRING
`user_id`	INTEGER
`value`	NUMBER
`visible_to`	STRING
`weighted_value`	NUMBER
`weighted_value_currency`	STRING
`won_time`	STRING

organizations

Filed	Type
`active_flag`	BOOLEAN
`activities_count`	NUMBER
`add_time`	STRING
`address`	STRING
`address_admin_area_level_1`	STRING
`address_admin_area_level_2`	STRING
`address_country`	STRING
`address_formatted_address`	STRING
`address_locality`	STRING
`address_postal_code`	STRING
`address_route`	STRING
`address_street_number`	STRING
`address_sublocality`	STRING
`address_subpremise`	STRING
`cc_email`	STRING
`closed_deals_count`	NUMBER
`company_id`	NUMBER
`country_code`	STRING
`done_activities_count`	NUMBER
`email_messages_count`	NUMBER
`files_count`	NUMBER
`first_char`	STRING
`followers_count`	NUMBER
`id`	NUMBER
`label`	NUMBER
`last_activity_date`	STRING
`last_activity_id`	NUMBER
`lost_deals_count`	NUMBER
`name`	STRING
`next_activity_date`	STRING
`next_activity_id`	NUMBER
`next_activity_time`	STRING
`notes_count`	NUMBER
`open_deals_count`	NUMBER
`owner_id`	OBJECT
`owner_id.active_flag`	BOOLEAN
`owner_id.email`	STRING
`owner_id.has_pic`	NUMBER
`owner_id.id`	NUMBER
`owner_id.name`	STRING
`owner_id.pic_hash`	STRING
`owner_id.value`	NUMBER
`owner_name`	STRING
`people_count`	NUMBER
`picture_id`	OBJECT
`picture_id.active_flag`	BOOLEAN
`picture_id.add_time`	STRING
`picture_id.added_by_user_id`	NUMBER
`picture_id.item_id`	NUMBER
`picture_id.item_type`	STRING
`picture_id.pictures`	OBJECT
`picture_id.pictures.128`	STRING
`picture_id.pictures.512`	STRING
`picture_id.update_time`	STRING
`picture_id.value`	NUMBER
`related_closed_deals_count`	NUMBER
`related_lost_deals_count`	NUMBER
`related_open_deals_count`	NUMBER
`related_won_deals_count`	NUMBER
`undone_activities_count`	NUMBER
`update_time`	STRING
`visible_to`	NUMBER
`won_deals_count`	NUMBER

pipelines

Filed	Type
`active`	BOOLEAN
`add_time`	STRING
`deal_probability`	BOOLEAN
`id`	INTEGER
`name`	STRING
`order_nr`	INTEGER
`selected`	BOOLEAN
`update_time`	STRING
`url_title`	STRING

deal_fields

Filed	Type
`active_flag`	BOOLEAN
`add_time`	STRING
`add_visible_flag`	BOOLEAN
`bulk_edit_allowed`	BOOLEAN
`details_visible_flag`	BOOLEAN
`edit_flag`	BOOLEAN
`field_type`	STRING
`filtering_allowed`	BOOLEAN
`id`	INTEGER
`important_flag`	BOOLEAN
`index_visible_flag`	BOOLEAN
`key`	STRING
`last_updated_by_user_id`	INTEGER
`mandatory_flag`	STRING
`name`	STRING
`options`	ARRAY
`order_nr`	INTEGER
`searchable_flag`	BOOLEAN
`sortable_flag`	BOOLEAN
`update_time`	STRING

users

Filed	Type
`activated`	BOOLEAN
`active_flag`	BOOLEAN
`created`	STRING
`default_currency`	STRING
`email`	STRING
`has_created_company`	BOOLEAN
`icon_url`	STRING
`id`	INTEGER
`is_admin`	INTEGER
`is_you`	BOOLEAN
`lang`	INTEGER
`last_login`	STRING
`locale`	STRING
`modified`	STRING
`name`	STRING
`phone`	STRING
`role_id`	INTEGER
`signup_flow_variation`	STRING
`timezone_name`	STRING
`timezone_offset`	STRING

persons

Filed	Type
`active_flag`	BOOLEAN
`activities_count`	INTEGER
`add_time`	STRING
`cc_email`	STRING
`closed_deals_count`	INTEGER
`company_id`	INTEGER
`done_activities_count`	INTEGER
`email`	ARRAY
`email_messages_count`	INTEGER
`files_count`	INTEGER
`first_char`	STRING
`first_name`	STRING
`followers_count`	INTEGER
`id`	INTEGER
`label`	INTEGER
`last_activity_date`	STRING
`last_activity_id`	INTEGER
`last_incoming_mail_time`	STRING
`last_name`	STRING
`last_outgoing_mail_time`	STRING
`lost_deals_count`	INTEGER
`name`	STRING
`next_activity_date`	STRING
`next_activity_id`	INTEGER
`next_activity_time`	STRING
`notes_count`	INTEGER
`open_deals_count`	INTEGER
`org_id`	INTEGER
`org_name`	STRING
`owner_id`	INTEGER
`owner_name`	STRING
`participant_closed_deals_count`	INTEGER
`participant_open_deals_count`	INTEGER
`phone`	ARRAY
`picture_id`	OBJECT
`picture_id.active_flag`	BOOLEAN
`picture_id.add_time`	STRING
`picture_id.added_by_user_id`	INTEGER
`picture_id.item_id`	INTEGER
`picture_id.item_type`	STRING
`picture_id.pictures`	OBJECT
`picture_id.pictures.128`	STRING
`picture_id.pictures.512`	STRING
`picture_id.update_time`	STRING
`picture_id.value`	INTEGER
`related_closed_deals_count`	INTEGER
`related_lost_deals_count`	INTEGER
`related_open_deals_count`	INTEGER
`related_won_deals_count`	INTEGER
`undone_activities_count`	INTEGER
`update_time`	STRING
`visible_to`	STRING
`won_deals_count`	INTEGER

leads

Filed	Type
`add_time`	STRING
`creator_id`	INTEGER
`expected_close_date`	STRING
`id`	STRING
`is_archived`	BOOLEAN
`label_ids`	ARRAY
`next_activity_id`	INTEGER
`organization_id`	INTEGER
`owner_id`	INTEGER
`person_id`	INTEGER
`source_name`	STRING
`title`	STRING
`update_time`	STRING
`value`	OBJECT
`value.amount`	INTEGER
`value.currency`	STRING
`was_seen`	BOOLEAN

activities

person_fields

organization_fields

stages

activity_fields

deals

organizations

pipelines

deal_fields

users

persons

leads

0 Comments

Related articles