CRM

grocerkey

grocerkey_order_item

It contains order item data. Learn more.

name	type	description
user_id	STRING
product_id	STRING
picker_id	STRING
order_id	STRING
total_tax	NUMERIC
total	NUMERIC
subtotal	NUMERIC
quantity	NUMERIC
picked_quantity	NUMERIC
pick_time	TIMESTAMP
pick_status	STRING
original_price	NUMERIC
order_line_updated	TIMESTAMP
order_line_status	STRING
is_modification	NUMERIC
fixed_tax	NUMERIC
discount	NUMERIC
date	TIMESTAMP	The date (yyyy-MM-dd).

grocerkey_order_metrics

It contains order data and caluclated order metrics. Learn more.

name	type	description	values
user_id	STRING	ID of the user.
order_id	STRING	ID of the order.
idle_time	NUMERIC	Time between user placed an order and earliest picking time. Based on the formula idle_time = order_created_at - earliest_start_pick_time.
zip_code	STRING	Zip code of the address.
user_weeks_since_registration	NUMERIC	Weeks since user was created.
user_weeks_since_first_order	NUMERIC	Weeks since user's first order_completed_date with status 'Complete'.
user_second_order_date	DATE	User second order date. This metric takes into account user's second order_completed_date with status 'Complete'.
user_registration_cohort_week	DATE	Week that user was created.
user_registration_cohort_quarter	DATE	Quarter that user was created.
user_registration_cohort_month	DATE	Month that user was created.
user_quarters_since_registration	NUMERIC	Quarters since user was created.
user_quarters_since_first_order	NUMERIC	Quarters since user's first order_completed_date with status 'Complete'.
user_months_since_registration	NUMERIC	Months since user was created.
user_months_since_first_order	NUMERIC	Months since user's first order_completed_date with status 'Complete'.
user_first_order_date	DATE	User first order date. This metric takes into account user's first order_completed_date with status 'Complete'.
user_acquisition_cohort_week	DATE	Week of user's first order_completed_date with status 'Complete'.
user_acquisition_cohort_quarter	DATE	Quarter of user's first order_completed_date with status 'Complete'.
user_acquisition_cohort_month	DATE	Month of user's first order_completed_date with status 'Complete'.
total_time	NUMERIC	Time between user placed an order and order was completed. Based on the formula order_completed_at - order_created_at.
total_sub_categories_picked	NUMERIC	Total sub categories picked inside the order basket
total_parent_categories_picked	NUMERIC	Total parent categories picked inside the order basket.
total_modification_times	NUMERIC
total_items_picked	NUMERIC
total_items	NUMERIC
subtotal	NUMERIC	Total items price (based on original price).
store_name	STRING	Name of the store.
store_code	STRING	ID of the store.
status	STRING	Status of an order	complete, canceled
state	STRING	State of the address.
start_time_window	TIMESTAMP
revenue_no_vat	NUMERIC	Revenue of the order (no VAT). Based on the formula revenue_no_vat = (subtotal+delivery_cost)-(coupon_amount+credits+refund_amount).
refund_amount	NUMERIC
pickup_location	STRING
pick_time	NUMERIC	Time for picking order items.
payment_method	STRING	Payment method.	cc, ccu
pack_time	NUMERIC	Time for packing order items.
order_rank	NUMERIC	Order rank per user.
order_frequency	NUMERIC	Frequency between user's orders.
mode	STRING
is_valid_order	NUMERIC	Valid order is order with status 'Complete'.
is_second_order	NUMERIC	The second order of the user, indicating a stronger relation with the brand.
is_refunded	NUMERIC
is_cancelled	NUMERIC
is_acquisition	NUMERIC	User is acquired/converted when his first order is complete.
hour_of_date	NUMERIC	The hour of the order date.
gross_revenue_no_vat	NUMERIC	Gross revenue of the order (no VAT). Based on the formula revenue_no_vat = subtotal+delivery_cost.
end_time_window	TIMESTAMP
driver_score	NUMERIC
driver_name	STRING
discount_applied	NUMERIC
discount_amount	NUMERIC
delivery_time	NUMERIC	Time between packing finished and order was completed. Based on the formula delivery_time = total_time - (pack_time + pick_time).
delivery_cost	NUMERIC	Delivery fee.
date	DATE	The date (yyyy-MM-dd). Order created date.
credits	NUMERIC
credit	NUMERIC
coupon_used	STRING
coupon_code	STRING
coupon_amount	NUMERIC
city	STRING	City of the address.
cancelled_reason	STRING
batch_order	STRING

grocerkey_product

It contains product data. Learn more.

name	type	description	values
product_id	STRING
updated	TIMESTAMP
upc	STRING
total_fat	NUMERIC
sub_category	STRING
quantity	NUMERIC
protein	NUMERIC
price	NUMERIC
parentcategory	STRING
name	STRING
is_vegetarian	NUMERIC
is_vegan	NUMERIC
is_sugar_free	NUMERIC
is_low_fat	NUMERIC
is_lactose_free	NUMERIC
is_dairy_free	NUMERIC
is_active	STRING
created	TIMESTAMP
calories	NUMERIC
amount	NUMERIC

grocerkey_product_historical

It contains product data. Learn more.

name	type	description
product_id	STRING
sub_category	STRING
quantity	NUMERIC
price	NUMERIC
parentcategory	STRING
name	STRING
date	DATE	The date (yyyy-MM-dd).
amount	NUMERIC

hubspot

hubspot_company_contact

name	type	description
contact_id	STRING
company_id	STRING
updated_at	DATE	The latest timestamp that record was updated, in source_service.

hubspot_company

name	type	description
domain_x_id	INT
id	STRING
updated_at	DATE	The latest timestamp that record was updated, in source_service.
domain	STRING
created_at	DATE	The timestamp that record was created, in source_service.
archived	BOOL_BOOL

hubspot_contact

name	type	description
id	STRING
updated_at	DATE	The latest timestamp that record was updated, in source_service.
created_at	DATE	The timestamp that record was created, in source_service.
archived	BOOL_BOOL

hubspot_company_deal

name	type	description
deal_id	STRING
company_id	STRING
updated_at	DATE	The latest timestamp that record was updated, in source_service.

hubspot_contact_deal

name	type	description
deal_id	STRING
contact_id	STRING
updated_at	DATE	The latest timestamp that record was updated, in source_service.
jobtitle	STRING
email	STRING

hubspot_deal

name	type	description
id	STRING
updated_at	DATE	The latest timestamp that record was updated, in source_service.
created_at	DATE	The timestamp that record was created, in source_service.
archived	BOOL_BOOL

pipedrive

pipedrive_deal

name	type	description
user_id_value	STRING
user_id_pic_hash	STRING
user_id_name	STRING
user_id_id	STRING
user_id_has_pic	STRING
user_id_email	STRING
user_id_active_flag	STRING
stage_id	STRING
pipeline_id	STRING
person_id_value	STRING
person_id	STRING
org_id_value	STRING
org_id_people_count	NUMERIC
org_id_owner_id	STRING
org_id_name	STRING
org_id_cc_email	STRING
org_id_address	STRING
org_id_active_flag	STRING
org_id	STRING
next_activity_id	STRING
last_activity_id	STRING
id	STRING
creator_user_id_value	STRING
creator_user_id_pic_hash	STRING
creator_user_id_name	STRING
creator_user_id_id	STRING
creator_user_id_has_pic	STRING
creator_user_id_email	STRING
creator_user_id_active_flag	STRING
creator_user_id	STRING
won_time	DATE
weighted_value_currency	NUMERIC
weighted_value	NUMERIC
visible_to	STRING
value	STRING
update_time	DATE
undone_activities_count	NUMERIC
title	STRING
status	STRING
stage_order_nr	STRING
stage_name	STRING
stage_change_time	DATE
rotten_time	DATE
products_count	NUMERIC
probability	NUMERIC
pipeline_name	STRING
person_name	STRING
person_hidden	STRING
participants_count	NUMERIC
owner_name	STRING
org_name	STRING
org_hidden	STRING
notes_count	NUMERIC
next_activity_type	STRING
next_activity_time	DATE
next_activity_subject	STRING
next_activity_note	STRING
next_activity_duration	NUMERIC
next_activity_date	DATE
lost_time	DATE
lost_reason	STRING
last_outgoing_mail_time	DATE
last_incoming_mail_time	DATE
last_activity_date	DATE
label	STRING
formatted_weighted_value	STRING
formatted_value	STRING
followers_count	NUMERIC
first_won_time	DATE
files_count	NUMERIC
expected_close_date	DATE
email_messages_count	NUMERIC
done_activities_count	NUMERIC
deleted	STRING
currency	STRING	The currency of the account.
close_time	DATE
cc_email	STRING
add_time	DATE
activities_count	NUMERIC
active	STRING

pipedrive_deal_full

name	type	description
user_id_value	STRING
user_id_pic_hash	STRING
user_id_name	STRING
user_id_id	STRING
user_id_has_pic	STRING
user_id_email	STRING
user_id_active_flag	STRING
stage_id	STRING
pipeline_id	STRING
person_id_value	STRING
person_id	STRING
org_id_value	STRING
org_id_people_count	NUMERIC
org_id_owner_id	STRING
org_id_name	STRING
org_id_cc_email	STRING
org_id_address	STRING
org_id_active_flag	STRING
org_id	STRING
next_activity_id	STRING
last_activity_id	STRING
id	STRING
creator_user_id_value	STRING
creator_user_id_pic_hash	STRING
creator_user_id_name	STRING
creator_user_id_id	STRING
creator_user_id_has_pic	STRING
creator_user_id_email	STRING
creator_user_id_active_flag	STRING
creator_user_id	STRING
won_time	DATE
weighted_value_currency	NUMERIC
weighted_value	NUMERIC
visible_to	STRING
value	STRING
update_time	DATE
undone_activities_count	NUMERIC
title	STRING
status	STRING
stage_order_nr	STRING
stage_name	STRING
stage_change_time	DATE
rotten_time	DATE
products_count	NUMERIC
probability	NUMERIC
pipeline_name	STRING
person_name	STRING
person_hidden	STRING
participants_count	NUMERIC
owner_name	STRING
org_name	STRING
org_hidden	STRING
notes_count	NUMERIC
next_activity_type	STRING
next_activity_time	DATE
next_activity_subject	STRING
next_activity_note	STRING
next_activity_duration	NUMERIC
next_activity_date	DATE
lost_time	DATE
lost_reason	STRING
last_outgoing_mail_time	DATE
last_incoming_mail_time	DATE
last_activity_date	DATE
label	STRING
formatted_weighted_value	STRING
formatted_value	STRING
followers_count	NUMERIC
first_won_time	DATE
files_count	NUMERIC
expected_close_date	DATE
email_messages_count	NUMERIC
done_activities_count	NUMERIC
deleted	STRING
currency	STRING	The currency of the account.
close_time	DATE
cc_email	STRING
add_time	DATE
activities_count	NUMERIC
active	STRING

pipedrive_person

name	type	description	values
owner_id	STRING
org_id	STRING
next_activity_id	STRING
last_activity_id	STRING
id	STRING
company_id	STRING
won_deals_count	NUMERIC
visible_to	INT
update_time	DATE
undone_activities_count	NUMERIC
related_won_deals_count	NUMERIC
related_open_deals_count	NUMERIC
related_lost_deals_count	NUMERIC
related_closed_deals_count	NUMERIC
participant_open_deals_count	NUMERIC
participant_closed_deals_count	NUMERIC
open_deals_count	NUMERIC
notes_count	NUMERIC
next_activity_time	DATE
next_activity_date	DATE
name	STRING
lost_deals_count	NUMERIC
last_outgoing_mail_time	DATE
last_name	STRING
last_incoming_mail_time	DATE
last_activity_date	DATE
label	STRING
followers_count	NUMERIC
first_name	STRING
files_count	NUMERIC
email_messages_count	NUMERIC
done_activities_count	NUMERIC
closed_deals_count	NUMERIC
add_time	DATE
activities_count	NUMERIC
active_flag	NUMERIC

pipedrive_person_full

name	type	description	values
owner_id	STRING
org_id	STRING
next_activity_id	STRING
last_activity_id	STRING
id	STRING
company_id	STRING
won_deals_count	NUMERIC
visible_to	INT
update_time	DATE
undone_activities_count	NUMERIC
related_won_deals_count	NUMERIC
related_open_deals_count	NUMERIC
related_lost_deals_count	NUMERIC
related_closed_deals_count	NUMERIC
participant_open_deals_count	NUMERIC
participant_closed_deals_count	NUMERIC
open_deals_count	NUMERIC
notes_count	NUMERIC
next_activity_time	DATE
next_activity_date	DATE
name	STRING
lost_deals_count	NUMERIC
last_outgoing_mail_time	DATE
last_name	STRING
last_incoming_mail_time	DATE
last_activity_date	DATE
label	STRING
followers_count	NUMERIC
first_name	STRING
files_count	NUMERIC
email_messages_count	NUMERIC
done_activities_count	NUMERIC
closed_deals_count	NUMERIC
add_time	DATE
activities_count	NUMERIC
active_flag	NUMERIC

pipedrive_user

name	type	description	values
role_id	STRING
id	STRING
signup_flow_variation	STRING
phone	STRING
name	STRING
modified	DATE
last_login	DATE
is_admin	BOOLEAN
email	STRING
created	DATE
active_flag	BOOLEAN

pipedrive_user_full

name	type	description	values
role_id	STRING
id	STRING
signup_flow_variation	STRING
phone	STRING
name	STRING
modified	DATE
last_login	DATE
is_admin	BOOLEAN
email	STRING
created	DATE
active_flag	BOOLEAN

zoho_crm

zoho_crm_accounts

name	type	description
id	STRING
website	STRING
tax_authority	STRING
record_image	STRING
phone	STRING
payment_method	STRING
owner_name	STRING
official_account_name	STRING
next_invoicing_amount	NUMERIC
modified_time	DATE
last_activity_time	DATE
invoicing_date	DATE
industry	STRING
field_states	STRING
exchange_rate	STRING
employees	STRING
email_invoicing	STRING
description	STRING
currency	STRING	The currency of the account.
created_time	DATE
created_by_name	STRING
account_type	STRING
account_name	STRING	The name of the account.

zoho_crm_activities

It contains Zoho CRM activities.

name	type	description	values
who_id_name	STRING
who_id_id	STRING
who_id	STRING
what_id_name	STRING
what_id_id	STRING
what_id	STRING
id	STRING
zip_code	STRING
venue	STRING
type	STRING
top_priority	STRING
tag	STRING
subject	STRING
status	STRING
start_date_time	DATE
se_module	STRING
review_process	STRING
reminder	STRING
participants	STRING
owner_name	STRING
modified_time	DATE
longitude	STRING
latitude	STRING
end_date_time	DATE
due_date	DATE
description	STRING
created_time	DATE
created_by_name	STRING
closed_time	DATE
check_in_time	STRING
check_in_sub_locality	STRING
check_in_status	STRING
check_in_state	STRING
check_in_country	STRING
check_in_comment	STRING
check_in_city	STRING
check_in_by	STRING
check_in_address	STRING
call_type	STRING
call_status	STRING
call_start_time	STRING
call_result	STRING
call_purpose	STRING
call_duration_in_seconds	STRING
call_duration	NUMERIC
all_day	STRING
activity_type	STRING
account_vin	STRING

zoho_crm_contacts

It contains Zoho CRM contacts. Learn more.

name	type	description	values
id	STRING	The ID of the Contact.
visitor_score	NUMERIC	Score for the Contact obtained from SalesIQ.
unsubscribed_time	DATE	Date and time at which the Contact was unsubscribed.
unsubscribed_mode	STRING	Unsubscribed mode.
tag	LIST_AS_STR	List of tags associated with the Contact.
salutation	STRING	The salutation for the Contact.	Ms, Mr
referrer	STRING	Name and ID of the Contact who referred this Contact.
record_image	STRING	The profile image of the Contact.
owner_name	STRING	Name of the Zoho CRM user who created the Contact.
number_of_chats	NUMERIC	The number of times the Contact has had a chat with the Zoho CRM team.
modified_time	DATE	Date and time at which the Contact was last modified.
mailing_zip	STRING	Represents address zip details of the Contact.
mailing_street	STRING	Represents address street details of the Contact.
mailing_country	STRING	Represents address country details of the Contact.
mailing_city	STRING	Represents address city details of the Contact.
last_visited_time	DATE	The date and time at which the Contact last visited Zoho CRM.
last_activity_time	DATE	The date and time at which the Contact was last used in an operation.
first_visited_url	STRING	The URL address of the page that the Contact visited first.
first_visited_time	DATE	Date and time at which the Contact first visited Zoho CRM.
first_name	STRING	First name of the Contact.
email_opt_out	STRING	Specifies whether the Contact has opted out of email notifications from Zoho CRM.
email	STRING	Email ID of the Contact.
days_visited	STRING	The number of days the Contact visited Zoho CRM.
date_of_birth	STRING	Date of birth of the Contact.
created_time	DATE	Date and time at which the Contact was created.
created_by_name	STRING	Name of the user who created the Contact.
average_time_spent_minutes	NUMERIC	The average time in minutes the Contact spends in Zoho CRM.
account_name_name	STRING	Name of the Account the Contact is associated with.
account_name	STRING	The name of the account. Name of the Account the Contact is associated with.

zoho_crm_leads

It contains Zoho CRM leads. Learn more.

name	type	description	values
id	STRING	The ID of the Lead.
zip_code	STRING	The zip code of the lead.
visitor_score	NUMERIC	Score for the Lead obtained from SalesIQ.
unsubscribed_time	DATE	Date and time at which the Lead was unsubscribed.
unsubscribed_mode	STRING	Unsubscribed mode.
tag	LIST_AS_STR	List of tags associated with the Lead.
street	STRING	The street address of the Lead.
state	STRING	The state of the Lead.
secondary_email	STRING	Alternative email Id of the Lead.
salutation	STRING	The salutation for the Lead.	Ms, Mr
referrer	STRING	Name and ID of the Contact who referred this Lead.
record_image	STRING	The profile image of the Lead.
owner_name	STRING	Name of the company where the Lead is working.
number_of_chats	NUMERIC	The number of times the Lead has had a chat with the Zoho CRM team.
modified_time	DATE	Date and time at which the Lead was last modified.
lead_status	STRING	Status of the Lead.
lead_source	STRING	Represents the source from which the Lead was created.
last_visited_time	DATE	The date and time at which the lead last visited Zoho CRM.
last_activity_time	DATE	The date and time at which the Lead was last used in an operation.
interested_in	STRING	Interests of the Lead.
first_visited_url	STRING	The URL address of the page that the lead visited first.
first_visited_time	DATE	Date and time at which the Lead first visited Zoho CRM.
first_name	STRING	First name of the Lead.
exchange_rate	NUMERIC	Represents the exchange rate of the current currency to the home currency.
email	STRING	Email ID of the Lead.
description	NUMERIC	Description of the Lead.
days_visited	STRING	The number of days the lead visited Zoho CRM.
currency	STRING	The currency of the account. The currency in which the revenue is generated.
created_time	DATE	Date and time at which the Lead was created.
created_by_name	STRING	Name of the user who created the Lead.
country	STRING	The name of the country. The country of the Lead.
company	STRING	The name of the owner of the Lead.
city	STRING	The city of the Lead.
category	LIST_AS_STR	Category of the Lead.
average_time_spent_minutes	NUMERIC	The average time in minutes the Lead spends in Zoho CRM.

zoho_crm_maintenance

name	type	description
vehicle_id	STRING
rider_id	STRING
id	STRING
vehicle_name	STRING
unsubscribed_time	DATE
unsubscribed_mode	STRING
type	STRING
status	STRING
service_minutes	STRING
service_location	STRING
service_date	DATE
rider	STRING
parts	STRING
owner_name	STRING
name	STRING
last_activity_time	DATE
fault	STRING
exchange_rate	NUMERIC
days_waiting_for_parts	STRING
days_in_warehouse	NUMERIC
currency	STRING	The currency of the account.
cost	NUMERIC	The amount of money spend.
contact_date	DATE

zoho_crm_products

It contains Zoho CRM products. Learn more.

name	type	description
id	STRING	The ID of the product.
tag	STRING	List of tags associated with the product.
record_image	STRING	Represents the product image details.
product_name	STRING	Name of the product.
owner_name	STRING	Name of the Zoho CRM user who created the product.
handler	STRING	Name of the Zoho CRM user who handles the product.

zoho_subscriptions

zoho_subscriptions_events

It contains Zoho Subscriptions events. Learn more.

name	type	description
table_x_id	INT	A surrogate key to uniquely identify specific row.
event_id	STRING
event_type	STRING
event_time	DATE
event_source	STRING

zoho_subscriptions_invoices

It contains Zoho Subscriptions invoices. Learn more.

name	type	description
invoice_id	STRING
customer_id	STRING
updated_time	DATE
transaction_type	STRING
total	NUMERIC
status	STRING
shipping_zipcode	STRING
shipping_street2	STRING
shipping_street	STRING
shipping_state	STRING
shipping_phone	STRING
shipping_country	STRING
shipping_city	STRING
shipping_address_zipcode	STRING
shipping_address_street2	STRING
shipping_address_street	STRING
shipping_address_state	STRING
shipping_address_phone	STRING
shipping_address_fax	STRING
shipping_address_country	STRING
shipping_address_city	STRING
shipping_address_attention	STRING
salesperson	STRING
phone	STRING
payment_expected_date	DATE
number	STRING
mail_last_viewed_time	DATE
mail_first_viewed_time	DATE
is_viewed_in_mail	STRING
is_viewed_by_client	STRING
invoice_date	DATE
has_attachment	STRING
email	STRING
due_date	DATE
customer_name	STRING
currency_symbol	STRING
currency_code	STRING
created_time	DATE
created_by	STRING
country	STRING	The name of the country.
client_viewed_time	DATE
billing_zipcode	STRING
billing_street2	STRING
billing_street	STRING
billing_state	STRING
billing_phone	STRING
billing_country	STRING
billing_city	STRING
billing_address_zipcode	STRING
billing_address_street2	STRING
billing_address_street	STRING
billing_address_state	STRING
billing_address_phone	STRING
billing_address_fax	STRING
billing_address_country	STRING
billing_address_city	STRING
billing_address_attention	STRING
balance	NUMERIC
ach_payment_initiated	STRING

zoho_subscriptions_plans

It contains Zoho Subscriptions Plans. Learn more.

name	type	description
tax_id	STRING
setup_fee_account_id	STRING
product_id	STRING
plan_id	STRING
account_id	STRING	The ID of the account.
url	STRING
updated_time_formatted	DATE
updated_time	DATE
unit	STRING
trial_period	NUMERIC
tax_type	STRING
tax_percentage	NUMERIC
tax_name	STRING
store_markup_description	STRING
store_description	STRING
status	STRING
show_in_widget	STRING
shipping_interval_unit	STRING
shipping_interval	NUMERIC
setup_fee_account_name	STRING
setup_fee	NUMERIC
recurring_price	NUMERIC
product_type	STRING
plan_code	STRING
name	STRING
interval_unit	STRING
interval	NUMERIC
description	STRING
created_time_formatted	DATE
created_time	DATE
billing_mode	STRING
billing_cycles	NUMERIC
account	STRING	The name of the account.

zoho_subscriptions_products

It contains Zoho Subscriptions products. Learn more.

name	type	description	values
product_id	STRING
email_ids	STRING
updated_time	DATE
status	STRING
redirect_url	STRING
plans_count	NUMERIC
name	STRING
description	STRING
created_time	DATE
coupons_count	NUMERIC
addons_count	NUMERIC

zoho_subscriptions_subscriptions

It contains Zoho Subscriptions. Learn more.

name	type	description
table_x_id	INT	A surrogate key to uniquely identify specific row.
zcrm_potential_id	STRING
subscription_id	STRING
salesperson_id	STRING
reference_id	STRING
customer_id	STRING
crm_owner_id	STRING
zcrm_potential_name	STRING
updated_time	DATE
trial_extended_count	NUMERIC
total_orders	NUMERIC
subscription_number	STRING
sub_total	NUMERIC
status	STRING
source	STRING
shipping_interval_unit	STRING
shipping_interval	NUMERIC
scheduled_cancellation_date	DATE
salesperson_name	STRING
resume_date	DATE
plan_name	STRING
plan_code	STRING
payment_terms_label	STRING
payment_terms	STRING
pause_date	DATE
orders_remaining	NUMERIC
orders_created	NUMERIC
next_shipment_day	DATE
next_shipment_at	DATE
next_retry_at	DATE
next_billing_at	DATE
name	STRING
last_shipment_day	DATE
last_shipment_at	DATE
last_billing_at	DATE
is_metered_billing	STRING
interval_unit	STRING
interval	NUMERIC
expires_at	DATE
email	STRING
customer_name	STRING
current_term_starts_at	DATE
current_term_ends_at	DATE
currency_symbol	STRING
currency_code	STRING
created_time	DATE
created_by	STRING
created_at	DATE	The timestamp that record was created, in source_service.
coupon_duration	STRING
cancelled_at	DATE
billing_mode	STRING
auto_collect	STRING
amount	NUMERIC
activated_at	DATE

CRM

grocerkey​

grocerkey_order_item​

grocerkey_order_metrics​

grocerkey_product​

grocerkey_product_historical​

hubspot​

hubspot_company_contact​

hubspot_company​

hubspot_contact​

hubspot_company_deal​

hubspot_contact_deal​

hubspot_deal​

pipedrive​

pipedrive_deal​

pipedrive_deal_full​

pipedrive_person​

pipedrive_person_full​

pipedrive_user​

pipedrive_user_full​

zoho_crm​

zoho_crm_accounts​

zoho_crm_activities​

zoho_crm_contacts​

zoho_crm_leads​

zoho_crm_maintenance​

zoho_crm_products​

zoho_subscriptions​

zoho_subscriptions_events​

zoho_subscriptions_invoices​

zoho_subscriptions_plans​

zoho_subscriptions_products​

zoho_subscriptions_subscriptions​