ActiveCampaign

Adicionando o conector

Baseado na documentação da API do ActiveCampaign

Este conector está em modo beta

Requisitos

Siga as instruções abaixo com um usuário com permissão para administrar ou apenas ler todas as entidades do activeCampaign

Caso seu usuário não possua essas permissões peça para um administrador dessa conta para dar as permissões seguindo o passo a passo:

Para dar ao usuario permissões você precisa criar um grupo de usuários e dar permissões ao grupo. Todas as permissões aplicadas a aquele grupo afetam todos os usuários no grupo

Com permissão de usuário você pode precisa das permissões para interagir com:

Lists
Campaigns
Subscription Forms
Templates
Deals
Accounts
Contacts
Automations
Reports
Saved Responses
Landing Pages
Web Personalization

Para criar um grupo e dar permissões para ele:

Click “Settings” > “Users and Group” no menu da esquerda.
Click on the “Groups” tab.
Click “Add Group.”
Complete a informação na aba “Info” e selecione as permissões para esse grupo (todas).
Na aba “Permissions” , selecione todas as permissões.
Na aba “Limits” não marque nada.
Depois clique em “add group”.

Instruções

1) Faça login na sua conta do ActiveCampaign, na barra lateral esquerda, selecione “Settings”

2) No segundo menu, selecione “Developer”

3) Copie os valores de “URL” e “Key”

4) Faça login na plataforma da Kondado, vá para a seção de acionar conectores e selecione o conector do ActiveCampaign

5) Dê um nome para o seu conector e, em URL e Key, cole os valores obtidos no passo 3

Agora basta clicar em SALVAR para começar a receber dados do ActiveCampaign no seu Data Warehouse ou Data Lake

Integrações

Índice

Accounts
Accounts: contacts
Accounts: custom fields (data)
Accounts: custom fields (meta)
Accounts: notes
Campaigns
Campaigns: messages
Campaigns: messages: content
Contacts
Contacts: custom fields (data)
Contacts: custom fields (meta)
Contacts: list activity
Contacts: notes
Contacts: tags
Contacts: tasks
Deals
Deals: activities
Deals: custom fields (data)
Deals: custom fields (meta)
Deals: secondary contacts
Deals: tasks
Lists
Lists: contacts
Pipelines
Scores
Tasks: outcomes
Tasks: types
User groups
Users

Gráfico de relacionamento

Clique para ampliar

Accounts

Campo	Tipo
id	float
accounturl	text
contactcount	float
createdtimestamp	timestamp
dealcount	float
name	text	[en] The account name
owner	float	Users > > id
updatedtimestamp	timestamp

Accounts: contacts

Campo	Tipo
id	float
account_id	float	[en] Account ID Accounts > > id
contact_id	float	[en] Contact ID Contacts > > id
createdtimestamp	timestamp
jobtitle	text	[en] Job Title of the contact at the account
updatedtimestamp	timestamp

Accounts: custom fields (data)

Campo	Tipo
id	float
accountid	float	[en] The ID of the account this field value relates to Accounts > > id
createdtimestamp	timestamp
customfieldid	float	[en] The ID of the custom field metum this field value relates to Accounts: custom fields (meta) > > id
fieldcurrency	text	[en] Currency code for the money value
fieldvalue	text	[en] Values for the field
updatedtimestamp	timestamp

Accounts: custom fields (meta)

Campo	Tipo
id	float
createdby	float	Users > > id
createdtimestamp	timestamp
displayorder	float	[en] Order for displaying the field on Manage Fields page and deal profiles
fielddefault	text	[en] Default value of the field
fielddefaultcurrency	text
fieldlabel	text	[en] Name of the field
fieldoptions	text	[en] Options for the field.
fieldtype	text	[en] Type of field. Possible values are: text, textarea, date, datetime, dropdown, multiselect, radio, checkbox, hidden, currency, or number.
hidefieldflag	float
isformvisible	float	[en] Whether or not the field is visible on forms
isrequired	float
knownfieldid	float
personalization	text
updatedby	float	Users > > id
updatedtimestamp	timestamp

Esta integração é gratuita

Accounts: notes

Campo	Tipo
id	float
account_id	float	Accounts > > id
cdate	timestamp
is_draft	float
mdate	timestamp
note	text
owner_id	float	Users > > id
owner_type	text
userid	float	Users > > id

Campaigns

Campo	Tipo
id	float	[en] id of the automation
activerss_interval	text
activerss_items	float
activerss_url	text
addressid	float
analytics_campaign_name	text
automation	float
basemessageid	float
basetemplateid	text
bounceid	float
can_skip_approval	float
cdate	timestamp
created_timestamp	timestamp
embed_images	float
facebook	float
formid	float
forwards	float
hardbounces	float
has_predictive_content	float
htmlunsub	float
htmlunsubdata	text
ip	text
ip4	text
laststep	text
ldate	timestamp
linkclicks	float
mail_cleanup	float
mail_send	float
mail_transfer	float
mailer_log_file	float
managetext	float
mdate	timestamp
name	text
opens	float
public	float
realcid	float
recurring	text
reminder_field	text
reminder_format	text
reminder_last_cron_run	text
reminder_offset	float
reminder_offset_sign	text
reminder_offset_type	text
reminder_type	text
replies	float
replysys	float
responder_existing	float
responder_offset	float
responder_type	text
schedule	float
scheduleddate	text
screenshot	text
sdate	timestamp
segmentid	float
segmentname	text
send_amt	float
sendid	float
series_send_lock_time	text
seriesid	float
socialshares	float
softbounces	float
source	text
split_content	float
split_offset	float
split_offset_type	text
split_type	text
split_winner_awaiting	float
split_winner_messageid	float
status	float
subscriberclicks	float
survey	text
textunsub	float
textunsubdata	text
threadid	float
total_amt	float
tracklinks	text
tracklinksanalytics	float
trackreads	float
trackreadsanalytics	float
tweet	float
type	text
uniqueforwards	float
uniquelinkclicks	float
uniqueopens	float
uniquereplies	float
unsubreasons	float
unsubscribes	float
updates	float
use_quartz_scheduler	float
userid	float	Users > > id
waitpreview	float
willrecur	float

Campaigns: messages

Campo	Tipo
id	float
automation_or_campaign_id	float	[en] automation or campaign id Campaigns > > id
forwards	float
hardbounces	float
initial_split_percentage	float
linkclicks	float
messageid	float	[en] message id Campaigns: messages: content > > id
opens	float
percentage	float
replies	float
screenshot	text
send_amt	float
socialshares	float
softbounces	float
sourcesize	float
spamcheck_max	float
spamcheck_score	float
subject	text
subscriberclicks	float
total_amt	float
uniqueforwards	float
uniquelinkclicks	float
uniqueopens	float
uniquereplies	float
unsubreasons	float
unsubscribes	float
updates	float

Campaigns: messages: content

Campo	Tipo
id	float	[en] id of the message
cdate	timestamp
charset	text
ed_instanceid	float
ed_version	float
encoding	text
format	text
fromemail	text
fromname	text
has_predictive_content	float
hidden	float
htmlfetch	text
mdate	timestamp
name	text
preheader_text	text	[en] Preheader Text
preview_data	text
preview_mime	text
priority	float
reply2	text	[en] Reply email for the recipient to reply to
subject	text	[en] Subject of message
text	text	[en] text of the mensage. Obs. 1000 charecters limit
textfetch	text
userid	float	Users > > id

Contacts

Nesta integração, você pode escolher o tipo de replicação de dados. Caso não remova dados da sua conta, selecione “incremental”. Utilize “integral” caso delete registros e queira que essas remoções sejam replicadas para o seu destino

Campo	Tipo
id	float
adate	timestamp
anonymized	float
bounced_date	date
bounced_hard	float
bounced_soft	float
cdate	timestamp
created_timestamp	timestamp
created_utc_timestamp	timestamp
deleted	float
deleted_at	timestamp
edate	timestamp
email	text	[en] Email address of the new contact.
email_domain	text
email_empty	boolean
email_local	text
firstname	text	[en] First name of the new contact.
gravatar	float
hash	text
ip	text
lastname	text	[en] Last name of the new contact.
mpp_tracking	float
orgid	float	Accounts > > id
orgname	text
phone	text	[en] Phone number of the contact.
rating_tstamp	date
segmentio_id	text
sentcnt	float
socialdata_lastcheck	timestamp
ua	text
udate	timestamp
updated_timestamp	timestamp
updated_utc_timestamp	timestamp

Contacts: custom fields (data)

Campo	Tipo
id	float
cdate	timestamp
contact	float	[en] ID of the contact Contacts > > id
field	float	[en] ID of the custom field Contacts: custom fields (meta) > > id
owner	float	Accounts > > id
udate	timestamp
value	text	[en] Value for the field

Contacts: custom fields (meta)

Objeto principal

Campo	Tipo
id	float
cdate	timestamp
cols	float
created_by	float	Users > > id
created_timestamp	timestamp
defval	text	[en] Default value of the field created
descript	text	[en] Description of field being created
isrequired	float
ordernum	float	[en] Order of appearance in ‘My Fields’ tab.
perstag	text	[en] The perstag that represents the field created
rows	float
show_in_list	float
title	text	[en] Title of the field created
type	text	[en] Possible Values: dropdown, hidden, checkbox, date, text, datetime, textarea, NULL, listbox, radio
udate	timestamp
updated_by	float
updated_timestamp	timestamp
service	text	[en] Possible Vales: nimble, contactually, mindbody, salesforce, highrise, google_spreadsheets, pipedrive, onepage, google_contacts, freshbooks, shopify, zendesk, etsy, NULL, bigcommerce, capsule, bigcommerce_oauth, sugarcrm, zohocrm, batchbook
visible	float	[en] Show or hide this field when using the Form Builder

activecampaign_contacts_custom_fields_meta__fieldOptions

Campo	Tipo
field_id	float
fieldoptions_id	float
fieldoptions_cdate	timestamp
fieldoptions_label	text
fieldoptions_orderid	float
fieldoptions_udate	timestamp
fieldoptions_value	text

Esta integração é gratuita

Contacts: list activity

Campo	Tipo
id	float	[en] The activity id
automation	float
autosynclog	text
campaign	text	Campaigns > > id
contact	float	Contacts > > id
created_timestamp	timestamp
form	float
first_name	text
ip4sub	text
ip4unsub	text
ip4_last	text
last_name	text
list	float	Lists > > id
message	text
responder	float
sdate	timestamp
seriesid	float
sourceid	float
status	float	[en] Status in list: 0 to unconfirmed, 1 to subscribed, 2 to unsubscribed, 3 to bonced
sync	float
udate	timestamp
unsubreason	text
unsubscribeautomation	text
updated_timestamp	timestamp

Contacts: notes

Campo	Tipo
id	float	[en] The note id
cdate	timestamp
is_draft	float
mdate	timestamp
note	text
relid	float	[en] The contact id Contacts > > id
reltype	text
userid	float	[en] The user id Users > > id

Contacts: tasks

Campo	Tipo
id	float
assigned_date	timestamp
assignee	float	[en] The id of an user the task is assigned to Users > > id
automation	text
cdate	timestamp
created_utc_timestamp	timestamp
donedate	timestamp
tasktype	float	[en] The type of the task based on the available Task Types in the account
doneautomation	text	[en] Id of an automation that will be triggered when the task is completed.
done_by	float	Users > > id
done_utc_timestamp	timestamp
duedate	timestamp	[en] Due date of the task
duration	float
edate	timestamp
note	text	[en] The content describing the task
outcomeid	float	Tasks: outcomes > > id
outcomeinfo	text
contact_name	text
contact_id	float	[en] Id of relational object Contacts > > id
status	float	[en] Task status means complete or incomplete. 1 is complete and 0 is incomplete.
tasktitle	text	[en] The title of the task
udate	timestamp
updated_utc_timestamp	timestamp
user	float

Deals

Campo	Tipo
id	float
account	float	[en] Deals account id Accounts > > id
activitycount	float
cdate	timestamp
contact	float	[en] Deal's primary contact's id. Contacts > > id
currency	text	[en] Deal's currency in 3-digit ISO format, lowercased.
customeraccount	float
description	text	[en] Deal's description
edate	timestamp
pipeline_id	float	[en] Deal's pipeline id. Pipelines > > id
hash	text
isdisabled	boolean
mdate	timestamp
nexttask	float	Deals: tasks > > id
nextdate	timestamp
nextdealid	float
nexttaskid	float
organization	float
owner	float	[en] Deal's owner id. Users > > id
percent	float	[en] Deal's percentage.
stage	float	[en] Deal's stage id. Pipelines > dealStages > dealstages_id
status	float	[en] Deal's status.
title	text	[en] Deal's title.
value	float	[en] Deal's value in cents
winprobability	float
winprobabilitymdate	timestamp

Deals: activities

Campo	Tipo
id	float
automation	float
cdate	timestamp
deal_id	float	[en] Deal id Deals > > id
d_stageid	float	Pipelines > dealStages > dealstages_id
dataaction	text
dataid	float
dataoldval	text
datatype	text
deleted	float
isaddtask	float
seriesid	float
sortdate	timestamp
stage	float	Pipelines > dealStages > dealstages_id
userid	float	Users > > id

Deals: custom fields (data)

Campo	Tipo
id	float
created_timestamp	timestamp
custom_field_currency_type	text
custom_field_currency_value	float
custom_field_date_value	timestamp
custom_field_id	float	Deals: custom fields (meta) > > id
custom_field_number_value	float
custom_field_text_blob	text
custom_field_text_value	text
dealcustomfieldmetum	float
deal_id	float	Deals > > id
updated_timestamp	timestamp

Deals: custom fields (meta)

Campo	Tipo
id	float
createdby	float	Users > > id
createdtimestamp	timestamp
displayorder	float	[en] Order for displaying the field on Manage Fields page and deal profiles
fielddefault	text	[en] Default value of the field
fielddefaultcurrency	text	[en] The 3-letter currency code of the default currency for the field.
fieldlabel	text	[en] Name of the field
fieldoptions	text	[en] Options for the field.
fieldtype	text	[en] Type of field. Possible values are: text, textarea, date, datetime, dropdown, multiselect, radio, checkbox, hidden, currency, or number.
hidefieldflag	float
isformvisible	float	[en] Whether or not the field is visible on forms
isrequired	float
knownfieldid	float
personalization	text
updatedby	float	Users > > id
updatedtimestamp	timestamp

Esta integração é gratuita

Deals: secondary contacts

Campo	Tipo
id	float
cdate	timestamp
contact	float	[en] Contact's id Contacts > > id
created_timestamp	timestamp
deal	float	[en] Deal's id Deals > > id
role	text
updated_timestamp	timestamp

Deals: tasks

Campo	Tipo
id	float
assigned_date	timestamp
assignee	float	[en] The id of an user the task is assigned to Users > > id
automation	text
cdate	timestamp
created_utc_timestamp	timestamp
donedate	timestamp
dealtasktype	float	[en] The type of the task based on the available Task Types in the account
doneautomation	text	[en] Id of an automation that will be triggered when the task is completed.
done_by	float	Users > > id
done_utc_timestamp	timestamp
duedate	timestamp	[en] Due date of the task
duration	float
edate	timestamp
note	text	[en] The content describing the task
outcomeid	float	Tasks: outcomes > > id
outcomeinfo	text
deal_name	text
deal_id	float	[en] Id of relational object Deals > > id
status	float	[en] Task status means complete or incomplete. 1 is complete and 0 is incomplete.
tasktitle	text	[en] The title of the task
udate	timestamp
updated_utc_timestamp	timestamp
user	float	Users > > id

Lists

Campo	Tipo
id	float
analytics_domains	text
analytics_source	text
analytics_ua	text
carboncopy	text	[en] Comma-separated list of email addresses to send a copy of all mailings to upon send
cdate	timestamp
created_timestamp	timestamp
deletestamp	text
facebook_session	text
fulladdress	text
get_unsubscribe_reason	float
name	text	[en] Name of the list to create
optinmessageid	float
optinoptout	float
optoutconf	float
p_embed_image	float
p_use_analytics_link	float
p_use_analytics_read	float
p_use_captcha	float
p_use_facebook	float
p_use_tracking	float
p_use_twitter	float
private	float
require_name	float
send_last_broadcast	float	[en] Value indicating whether or not to send the last sent campaign to this list to a new subscriber upon subscribing. 1 = yes, 0 = no
sender_addr1	text
sender_addr2	text
sender_city	text
sender_country	text
sender_name	text
sender_phone	text
sender_reminder	text	[en] A reminder for your contacts as to why they are on this list and you are messaging them.
sender_state	text
sender_url	text	[en] The website URL this list is for.
sender_zip	text
stringid	text	[en] URL-safe list name. Example: 'list-name-sample'
subscription_notify	text	[en] Comma-separated list of email addresses to notify when a new subscriber joins this list.
to_name	text
udate	text
unsubscription_notify	text	[en] Comma-separated list of email addresses to notify when a subscriber unsubscribes from this list.
updated_timestamp	timestamp
userid	float	[en] User Id of the list owner. Users > > id

Lists: contacts

Campo	Tipo
id	float
automation	text
autosynclog	text
campaign	text	Campaigns > > id
contact	float	[en] contact id Contacts > > id
created_timestamp	timestamp
first_name	text
form	text
ip4sub	text
ip4unsub	text
ip4_last	text
last_name	text
list	float	[en] list id Contacts > > id
message	text
responder	float
sdate	timestamp
seriesid	float
status	float
sync	float
udate	timestamp
unsubreason	text
unsubscribeautomation	text
updated_timestamp	timestamp

Pipelines

Objeto principal

Campo	Tipo
id	float	[en] Pipeline Id
allgroups	float	[en] When the pipeline is visible to all groups, 1 to true, 0 to false
allusers	float	[en] When the pipeline is visible to all users, 1 to true, 0 to false
autoassign	float
cdate	timestamp
currency	text
title	text
udate	timestamp
win_probability_initialize_date	timestamp

deals_pipelines_all__dealStages

Campo	Tipo
pipeline_id	float	[en] Pipeline Id
dealstages_id	float	[en] Stage id
dealstages_cardregion1	text
dealstages_cardregion2	text
dealstages_cardregion3	text
dealstages_cardregion4	text
dealstages_cardregion5	text
dealstages_cdate	timestamp
dealstages_color	text
dealstages_dealorder	text
dealstages_order	float
dealstages_title	text
dealstages_udate	timestamp
dealstages_width	float

Scores

Campo	Tipo
id	float
cdate	timestamp
descript	text
mdate	timestamp
name	text	[en] Score name
reltype	text	[en] value type contact or deal
status	float

Tasks: outcomes

Campo	Tipo
id	float	[en] Outcome id
created_by	float	Users > > id
created_utc_timestamp	timestamp
disabled	float	[en] 1 is for disabled and 0 is for active outcome.
sentiment	text	[en] Sentiment of the outcome.'POSITIVE, NEGATIVE or NEUTRAL'
title	text	[en] outcome title
updated_by	float	Users > > id
updated_utc_timestamp	timestamp

Esta integração é gratuita

Tasks: types

Objeto principal

Campo	Tipo
id	float	[en] Task type id
cdate	timestamp
created_by	float	[en] id of user, if '0' or None is a pré build field Users > > id
created_utc_timestamp	timestamp
defduration	float
display_order	float
status	float
title	text
udate	timestamp
updated_by	float	[en] id of user Users > > id
updated_utc_timestamp	timestamp

tasks_types__outcomes

Campo	Tipo
type_id	float	[en] Task type id
outcomes_id	float	[en] Task outcome id Tasks: outcomes > > id
outcomes_display_order	float

Campo

Tipo

type_id

float

[en] Task type id

outcomes_id

float

[en] Task outcome id

Tasks: outcomes > > id

outcomes_display_order

float

Esta integração é gratuita

User groups

Campo	Tipo
id	float
descript	text	[en] Group description
optinconfirm	float	[en] Whether or not to force optin confirm for this group
p_admin	float
pgaccountadd	float
pgaccountdelete	float
pgaccountedit	float
pgaccountexport	float
pgaccountimport	float
pgaccountmanagecustomfield	float
pgaccountnoteadd	float
pgaccountnotedelete	float
pgaccountnoteedit	float
pgautomationmanage	float	[en] Permission for manage automations
pgcontactactions	float	[en] Permission for managing contact actions
pgcontactadd	float	[en] Permission for adding contacts
pgcontactapprove	float	[en] Permission for approving contacts
pgcontactdelete	float	[en] Permission for deleting contacts
pgcontactedit	float	[en] Permission for editing contacts
pgcontactexport	float	[en] Permission for exporting contacts
pgcontactfields	float	[en] Permission for managing contact custom fields
pgcontactfilters	float	[en] Permission for managing contact list segments
pgcontactimport	float	[en] Permission for importing contacts
pgcontactmerge	float	[en] Permission for merging contacts
pgcontactresubscribe	float
pgcontactsync	float	[en] Permission for syncing contacts
pgdeal	float	[en] Permission for viewing deals
pgdealdelete	float	[en] Permission for deleting deals
pgdealexport	float
pgdealfields	float
pgdealgroupadd	float	[en] Permission for adding deal groups
pgdealgroupdelete	float	[en] Permission for deleting deals groups
pgdealgroupedit	float	[en] Permission for editing deal groups
pgdealimport	float
pgdeallistall	float
pgdealmanageroles	float
pgdealnoteadd	float
pgdealnotedelete	float
pgdealnoteedit	float
pgdealreassign	float	[en] Permission for reassigning deals
pgformedit	float	[en] Permission for editing subscription forms
pggroupadd	float	[en] Permission for adding groups
pggroupdelete	float	[en] Permission for deleting groups
pggroupedit	float	[en] Permission for adding groups
pglandingpagesaccess	float
pglistadd	float	[en] Permission for adding lists
pglistbounce	float	[en] Permission for accessing list bounce settings
pglistdelete	float	[en] Permission for deleting lists
pglistedit	float	[en] Permission for editing lists
pglistemailaccount	float	[en] Permission for managing Unsubscribe By Email
pglistheaders	float	[en] Permission for managing custom email headers
pgmessageadd	float	[en] Permission for adding messages
pgmessagedelete	float	[en] Permission for deleting messages
pgmessageedit	float	[en] Permission for editing messages
pgmessagesend	float	[en] Permission for sending messages
pgmfaadmin	float
pgpersonalizationadd	float	[en] Permission for adding personalization tags
pgpersonalizationdelete	float	[en] Permission for editing personalization tags
pgpersonalizationedit	float	[en]
pgreportscampaign	float	[en] Permission for viewing campaign reports
pgreportsdeal	float
pgreportslist	float	[en] Permission for viewing list reports
pgreportstrend	float	[en] Permission for viewing trend reports
pgreportsuser	float	[en] Permission for viewing user reports
pgsavedresponsesmanage	float	[en] Permission for managing saved responses
pgstartupgettingstarted	float	[en] Whether or not to show the (getting started) tutorial on overview page
pgstartupreports	float	[en] Campaign ID of last campaign report viewed to decide whether to show link on startup
pgtagmanage	float	[en] Permission for managing tags
pgtemplateadd	float	[en] Permission for adding templates
pgtemplatedelete	float	[en] Permission for deleting templates
pgtemplateedit	float	[en] Permission for editing templates
pgwebpersonalizationmanage	float
pg_user_add	float	[en] Permission for adding users
pg_user_delete	float	[en] Permission for deleting users
pg_user_edit	float	[en] Permission for editing users
reqapproval	float	[en] Whether or not this group requires all campaigns to be approved
reqapproval1st	float	[en] Whether or not this group requires first campaign to be approved
reqapprovalnotify	text	[en] Who to notify for approval related issues (email)
sdate	timestamp
socialdata	float	[en] Whether or not to show social links in campaigns sent from this group
title	text	[en] Title of the group
unsubscribelink	float	[en] Whether or not to force unsubscribe links

Users

Objeto principal

Campo	Tipo
id	float
username	text	[en] Username
cdate	timestamp
email	text	[en] Email address
firstname	text	[en] First name
lang	text
lastname	text	[en] Last name
localzoneid	text
mfaenabled	float
password_updated_utc_timestamp	timestamp
phone	text
signature	text
udate	timestamp

users__userGroups

Campo	Tipo
user_id	float
usergroups_cdate	timestamp
usergroups_groupid	float	[en] Group id User groups > > id
usergroups_udate	timestamp

Contacts: tags

Campo	Tipo
contact	float	[en] ID of the contact Contacts > > id
id	float	[en] ID of the association tag X contact
tag_name	text	[en] Name of the tag
tag_description	text	[en] Description of the tag
tag_id	float	[en] ID of the tag
tag_cdate	timestamp
tag_created_by	text
tag_created_timestamp	timestamp
tag_deleted	float
tag_tagtype	text	[en] Tag-type of the tag. Possible Values: template, contact
tag_updated_timestamp	timestamp
cdate	timestamp
created_by	text
created_timestamp	timestamp
updated_by	text
updated_timestamp	timestamp