Pipedrive → Google BigQuery: схема данных

Данные Pipedrive импортируются в 12 отдельных таблиц Google BigQuery.

 

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
Была ли эта статья полезной?
Пользователи, считающие этот материал полезным: 0 из 0
Еще есть вопросы? Отправить запрос

0 Комментарии

Войдите в службу, чтобы оставить комментарий.