invantive documentation
Invantive SupportforenAnmelden / Eintragen

ContactGeoIps: ActiveCampaign Contact Automations

Diese Seite ist in Ihrer Sprache noch nicht verfügbar; es wird die Originalversion angezeigt.

read only

  • Catalog: ActiveCampaign
  • Schema: Views
  • Label: Contact Automations

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 ContactGeoIps 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
campaignid int64 Campaignid 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 Best Send Hour filters on the platform, writable, computed Hour of the day with the highest expected engagement.
contact_bounced_date datetime Bounced Date writable
contact_bounced_hard int64 Bounced Hard writable
contact_bounced_soft int64 Bounced Soft writable
contact_cdate datetime Created filters on the platform, writable, computed
contact_created_by int64 Created by 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 Created UTC Timestamp filters on the platform, writable, computed Moment of creation in UTC.
contact_deleted int64 Deleted writable
contact_deleted_at datetime Deleted At filters on the platform, writable, computed Moment of deletion.
contact_edate datetime itgen_acn_edate writable
contact_email varchar2 Email Address filters on the platform, writable
contact_email_domain varchar2 Email Domain writable
contact_email_local varchar2 Email Local writable
contact_firstName varchar2 First Name 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 IP Address writable
contact_lastName varchar2 Last Name filters on the platform, writable
contact_last_click_date datetime Last Click Date filters on the platform, writable, computed Moment the contact last clicked a link.
contact_last_mpp_open_date datetime Last Mpp Open Date filters on the platform, writable, computed Moment of the last open attributed to Apple Mail Privacy Protection.
contact_last_open_date datetime Last Open Date filters on the platform, writable, computed Moment the contact last opened a message.
contact_mpp_tracking int64 MPP Tracking 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 Organisation ID writable
contact_orgname varchar2 Organisation Name 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 Rating Date writable
contact_segmentio_id int64 Segment ID writable
contact_sentcnt int64 Sent Count writable
contact_sms_consent int64 SMS Consent filters on the platform, writable, computed Consent status for SMS.
contact_sms_consent_updated_at datetime SMS Consent Updated at filters on the platform, writable, computed Moment the SMS consent was last changed.
contact_socialdata_lastcheck datetime Social Data Last Check writable
contact_ua varchar2 User Agent writable
contact_udate datetime Last Updated filters on the platform, writable, computed
contact_updated_by int64 Updated by 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 Updated UTC Timestamp 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.
geoAddress int64 Geo Address filters on the platform, writable
geoaddrid int64 Geo Address ID filters on the platform, writable
id int64 ID filters on the platform, writable, computed
ip4 varchar2 IPv4 Address filters on the platform, writable
messageid int64 Message ID filters on the platform, writable
tstamp datetime Tstamp filters on the platform, writable

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

Änderungen an dieser Tabelle, 26.0 bis 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 weitere Änderungen

  • + contact_updated_utc_timestamp (datetime)
  • + contact_whatsapp_id (varchar2)
  • + contact_whatsapp_username (varchar2)

Alle Treiberwechsel, 26.0 bis 27.0