ContactBounceLogs: ActiveCampaign Contact Bounce Logs
read only
- Catalog:
ActiveCampaign - Schema:
Views - Label: Contact Bounce Logs
Can only retrieve data.
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 264 |
| Full scan rows per minute | 13,400 |
The result can be cached on the client.
Table Columns
The columns of the table ContactBounceLogs are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
bounce |
int64 |
Bounce | filters on the platform, writable | ||
bounceid |
int64 |
Bounce ID | 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_ |
datetime |
itgen_acn_adate | writable | ||
contact_ |
int64 |
Anonymized | filters on the platform, writable, computed | Whether the contact has been anonymised. | |
contact_ |
int64 |
Best Send Hour | filters on the platform, writable, computed | Hour of the day with the highest expected engagement. | |
contact_ |
datetime |
Bounced Date | writable | ||
contact_ |
int64 |
Bounced Hard | writable | ||
contact_ |
int64 |
Bounced Soft | writable | ||
contact_ |
datetime |
Created | filters on the platform, writable, computed | ||
contact_ |
int64 |
Created by | 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 |
Created UTC Timestamp | filters on the platform, writable, computed | Moment of creation in UTC. | |
contact_ |
int64 |
Deleted | writable | ||
contact_ |
datetime |
Deleted At | filters on the platform, writable, computed | Moment of deletion. | |
contact_ |
datetime |
itgen_acn_edate | writable | ||
contact_ |
varchar2 |
Email Address | filters on the platform, writable | ||
contact_ |
varchar2 |
Email Domain | writable | ||
contact_ |
varchar2 |
Email Local | writable | ||
contact_ |
varchar2 |
First Name | filters on the platform, writable | ||
contact_ |
int64 |
Gravatar | writable | ||
contact_ |
varchar2 |
Hash | writable | ||
contact_ |
int64 |
ID | filters on the platform, writable, computed | ||
contact_ |
int64 |
IP Address | writable | ||
contact_ |
varchar2 |
Last Name | filters on the platform, writable | ||
contact_ |
datetime |
Last Click Date | filters on the platform, writable, computed | Moment the contact last clicked a link. | |
contact_ |
datetime |
Last Mpp Open Date | filters on the platform, writable, computed | Moment of the last open attributed to Apple Mail Privacy Protection. | |
contact_ |
datetime |
Last Open Date | filters on the platform, writable, computed | Moment the contact last opened a message. | |
contact_ |
int64 |
MPP Tracking | 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 |
Organisation ID | writable | ||
contact_ |
varchar2 |
Organisation Name | filters on the platform, writable, computed | Name of the account the contact belongs to. | |
contact_ |
varchar2 |
Phone | filters on the platform, writable | ||
contact_ |
datetime |
Rating Date | writable | ||
contact_ |
int64 |
Segment ID | writable | ||
contact_ |
int64 |
Sent Count | writable | ||
contact_ |
int64 |
SMS Consent | filters on the platform, writable, computed | Consent status for SMS. | |
contact_ |
datetime |
SMS Consent Updated at | filters on the platform, writable, computed | Moment the SMS consent was last changed. | |
contact_ |
datetime |
Social Data Last Check | writable | ||
contact_ |
varchar2 |
User Agent | writable | ||
contact_ |
datetime |
Last Updated | filters on the platform, writable, computed | ||
contact_ |
int64 |
Updated by | 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 |
Updated UTC Timestamp | 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. | |
created_ |
varchar2 |
Created by | filters on the platform, writable, computed | ||
created_ |
datetime |
Created | filters on the platform, writable, computed | ||
email |
varchar2 |
Email Address | 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 |
Message ID | filters on the platform, writable | ||
source |
varchar2 |
Source | filters on the platform, writable | ||
subscriberid |
int64 |
Subscriber ID | filters on the platform, writable | ||
tstamp |
datetime |
Tstamp | filters on the platform, writable | ||
updated_ |
varchar2 |
Updated by | filters on the platform, writable, computed | ||
updated_ |
datetime |
Updated | filters on the platform, writable, computed |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver:
Changes of This Table, 26.0 to 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 more changes
+contact_updated_utc_timestamp(datetime)+contact_whatsapp_id(varchar2)+contact_whatsapp_username(varchar2)