ContactNotes: ActiveCampaign Contact Notes
read only
- Catalogue :
ActiveCampaign - Schéma :
Views - Label: Contact Notes
Permet uniquement de récupérer des données.
Caractéristiques de performance
| Characteristic | Value |
|---|---|
| Latence moyenne d'accès (ms) | 264 |
| Nombre de lignes par minute en mode de balayage complet | 13,400 |
Le résultat peut être mis en cache côté client.
Colonnes de table
Les colonnes de la table ContactNotes sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
cdate |
datetime |
Created | filters on the platform, writable, computed | ||
contact_ |
datetime |
itgen_acn_adate | writable | ||
contact_ |
int64 |
Anonymized | filters on the platform, writable, computed | Whether the contact has been anonymised. | |
contact_ |
int64 |
Meilleur moment pour envoyer un message | filters on the platform, writable, computed | Hour of the day with the highest expected engagement. | |
contact_ |
datetime |
Date de rebond | writable | ||
contact_ |
int64 |
Rebondi dur | writable | ||
contact_ |
int64 |
Rebondi doux | writable | ||
contact_ |
datetime |
Created | filters on the platform, writable, computed | ||
contact_ |
int64 |
Crée par | filters on the platform, writable, computed | ID of the user that created the contact. | |
contact_ |
datetime |
Created | filters on the platform, writable, computed | Moment of creation in the time zone of the account. | |
contact_ |
datetime |
Horodatage UTC de création | filters on the platform, writable, computed | Moment of creation in UTC. | |
contact_ |
int64 |
Deleted | writable | ||
contact_ |
datetime |
Supprimé le | filters on the platform, writable, computed | Moment of deletion. | |
contact_ |
datetime |
itgen_acn_edate | writable | ||
contact_ |
varchar2 |
Adresse de courriel | filters on the platform, writable | ||
contact_ |
varchar2 |
Domaine de messagerie | writable | ||
contact_ |
varchar2 |
Envoyer un e-mail à Local | writable | ||
contact_ |
varchar2 |
Prénom | filters on the platform, writable | ||
contact_ |
int64 |
Gravatar | writable | ||
contact_ |
varchar2 |
Hash | writable | ||
contact_ |
int64 |
ID | filters on the platform, writable, computed | ||
contact_ |
int64 |
Adresse IP | writable | ||
contact_ |
varchar2 |
Nom | filters on the platform, writable | ||
contact_ |
datetime |
Date du dernier clic | filters on the platform, writable, computed | Moment the contact last clicked a link. | |
contact_ |
datetime |
Date de clôture de la dernière session du Mpp | filters on the platform, writable, computed | Moment of the last open attributed to Apple Mail Privacy Protection. | |
contact_ |
datetime |
Date de la dernière ouverture | filters on the platform, writable, computed | Moment the contact last opened a message. | |
contact_ |
int64 |
Suivi MPP | filters on the platform, writable, computed | Whether Apple Mail Privacy Protection was observed for this contact. | |
contact_ |
int64 |
Account | filters on the platform, writable | Deprecated.Do not use. | |
contact_ |
int64 |
ID de l'organisation | writable | ||
contact_ |
varchar2 |
Nom d'organisation | filters on the platform, writable, computed | Name of the account the contact belongs to. | |
contact_ |
varchar2 |
Phone | filters on the platform, writable | ||
contact_ |
datetime |
Date d'évaluation | writable | ||
contact_ |
int64 |
ID de segment | writable | ||
contact_ |
int64 |
Nombre d'envois | writable | ||
contact_ |
int64 |
Consentement par SMS | filters on the platform, writable, computed | Consent status for SMS. | |
contact_ |
datetime |
Consentement par SMS - Mis à jour le | filters on the platform, writable, computed | Moment the SMS consent was last changed. | |
contact_ |
datetime |
Dernière vérification des données sociales | writable | ||
contact_ |
varchar2 |
Agent utilisateur | writable | ||
contact_ |
datetime |
Dernière mise à jour | filters on the platform, writable, computed | ||
contact_ |
int64 |
Mise à jour par | filters on the platform, writable, computed | ID of the user that last changed the contact. | |
contact_ |
datetime |
Updated | filters on the platform, writable, computed | Moment of last change in the time zone of the account. | |
contact_ |
datetime |
Horodatage UTC mis à jour | filters on the platform, writable, computed | Moment of last change in UTC. | |
contact_ |
varchar2 |
Whatsapp ID | filters on the platform, writable, computed | WhatsApp identifier of the contact. | |
contact_ |
varchar2 |
Whatsapp Username | filters on the platform, writable, computed | WhatsApp user name of the contact. | |
id |
int64 |
ID | filters on the platform, writable, computed | ||
is_ |
int64 |
Est-ce un brouillon ? | filters on the platform, writable | ||
mdate |
datetime |
Dernière modification | filters on the platform, writable, computed | ||
note |
varchar2 |
Note | filters on the platform, writable | ||
owner_ |
int64 |
ID du propriétaire | filters on the platform, writable | ||
owner_ |
varchar2 |
Type de propriétaire | filters on the platform, writable | ||
relid |
int64 |
ID de relation | filters on the platform, writable | ||
reltype |
varchar2 |
Type de relation | filters on the platform, writable | ||
user |
int64 |
User | filters on the platform, writable | ||
userid |
int64 |
ID utilisateur | filters on the platform, writable |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :
Modifications apportées à cette table, 26.0 à 27.0
+contact_anonymized(int64)+contact_best_send_hour(int64)+contact_created_by(int64)+contact_created_timestamp(datetime)+contact_created_utc_timestamp(datetime)+contact_deleted_at(datetime)+contact_last_click_date(datetime)+contact_last_mpp_open_date(datetime)+contact_last_open_date(datetime)+contact_mpp_tracking(int64)+contact_orgname(varchar2)+contact_sms_consent(int64)+contact_sms_consent_updated_at(datetime)+contact_updated_by(int64)+contact_updated_timestamp(datetime)
3 modifications supplémentaires
+contact_updated_utc_timestamp(datetime)+contact_whatsapp_id(varchar2)+contact_whatsapp_username(varchar2)
Toutes les modifications apportées au chauffeur, 26.0 à 27.0