invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

ContactBounceLogs: ActiveCampaign Contact Bounce Logs

read only

  • Catalogue : ActiveCampaign
  • Schéma : Views
  • Label: Contact Bounce Logs

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 ContactBounceLogs 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
bounce int64 Bounce filters on the platform, writable
bounceid int64 ID de rebond filters on the platform, writable
campaign int64 Campaign filters on the platform, writable
campaignid int64 Campaignid filters on the platform, writable
code varchar2 Code filters on the platform, writable
codeid int64 Codeid filters on the platform, writable
contact int64 Contact filters on the platform, writable
contact_adate datetime itgen_acn_adate writable
contact_anonymized int64 Anonymized filters on the platform, writable, computed Whether the contact has been anonymised.
contact_best_send_hour int64 Meilleur moment pour envoyer un message filters on the platform, writable, computed Hour of the day with the highest expected engagement.
contact_bounced_date datetime Date de rebond writable
contact_bounced_hard int64 Rebondi dur writable
contact_bounced_soft int64 Rebondi doux writable
contact_cdate datetime Created filters on the platform, writable, computed
contact_created_by int64 Crée par filters on the platform, writable, computed ID of the user that created the contact.
contact_created_timestamp datetime Created filters on the platform, writable, computed Moment of creation in the time zone of the account.
contact_created_utc_timestamp datetime Horodatage UTC de création filters on the platform, writable, computed Moment of creation in UTC.
contact_deleted int64 Deleted writable
contact_deleted_at datetime Supprimé le filters on the platform, writable, computed Moment of deletion.
contact_edate datetime itgen_acn_edate writable
contact_email varchar2 Adresse de courriel filters on the platform, writable
contact_email_domain varchar2 Domaine de messagerie writable
contact_email_local varchar2 Envoyer un e-mail à Local writable
contact_firstName varchar2 Prénom filters on the platform, writable
contact_gravatar int64 Gravatar writable
contact_hash varchar2 Hash writable
contact_id int64 ID filters on the platform, writable, computed
contact_ip int64 Adresse IP writable
contact_lastName varchar2 Nom filters on the platform, writable
contact_last_click_date datetime Date du dernier clic filters on the platform, writable, computed Moment the contact last clicked a link.
contact_last_mpp_open_date 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_last_open_date datetime Date de la dernière ouverture filters on the platform, writable, computed Moment the contact last opened a message.
contact_mpp_tracking int64 Suivi MPP filters on the platform, writable, computed Whether Apple Mail Privacy Protection was observed for this contact.
contact_organization int64 Account filters on the platform, writable Deprecated.Do not use.
contact_orgid int64 ID de l'organisation writable
contact_orgname varchar2 Nom d'organisation filters on the platform, writable, computed Name of the account the contact belongs to.
contact_phone varchar2 Phone filters on the platform, writable
contact_rating_tstamp datetime Date d'évaluation writable
contact_segmentio_id int64 ID de segment writable
contact_sentcnt int64 Nombre d'envois writable
contact_sms_consent int64 Consentement par SMS filters on the platform, writable, computed Consent status for SMS.
contact_sms_consent_updated_at datetime Consentement par SMS - Mis à jour le filters on the platform, writable, computed Moment the SMS consent was last changed.
contact_socialdata_lastcheck datetime Dernière vérification des données sociales writable
contact_ua varchar2 Agent utilisateur writable
contact_udate datetime Dernière mise à jour filters on the platform, writable, computed
contact_updated_by int64 Mise à jour par filters on the platform, writable, computed ID of the user that last changed the contact.
contact_updated_timestamp datetime Updated filters on the platform, writable, computed Moment of last change in the time zone of the account.
contact_updated_utc_timestamp datetime Horodatage UTC mis à jour filters on the platform, writable, computed Moment of last change in UTC.
contact_whatsapp_id varchar2 Whatsapp ID filters on the platform, writable, computed WhatsApp identifier of the contact.
contact_whatsapp_username varchar2 Whatsapp Username filters on the platform, writable, computed WhatsApp user name of the contact.
created_by varchar2 Crée par filters on the platform, writable, computed
created_timestamp datetime Created filters on the platform, writable, computed
email varchar2 Adresse de courriel filters on the platform, writable
error varchar2 Error filters on the platform, writable
id int64 ID filters on the platform, writable, computed
message int64 Message filters on the platform, writable
messageid int64 Identifiant du message filters on the platform, writable
source varchar2 Source filters on the platform, writable
subscriberid int64 Identifiant de l'abonné filters on the platform, writable
tstamp datetime Tstamp filters on the platform, writable
updated_by varchar2 Mise à jour par filters on the platform, writable, computed
updated_timestamp datetime Updated filters on the platform, writable, computed

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