invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

ContactGeoIps: ActiveCampaign Contact Automations

read only

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

Kan alleen gegevens ophalen.

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 264
Aantal rijen per minuut bij volledige scan 13,400

Het resultaat kan op de client in de Cache worden opgeslagen.

Tabelkolommen

De kolommen van de tabel ContactGeoIps worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype 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 Beste Stuur Tijdstip filters on the platform, writable, computed Hour of the day with the highest expected engagement.
contact_bounced_date datetime Datum Afgewezen writable
contact_bounced_hard int64 Hard Afgewezen writable
contact_bounced_soft int64 Zacht Afgewezen writable
contact_cdate datetime Created filters on the platform, writable, computed
contact_created_by int64 Gemaakt door 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 Aangemaakte UTC-tijdstempel filters on the platform, writable, computed Moment of creation in UTC.
contact_deleted int64 Deleted writable
contact_deleted_at datetime Verwijderd op filters on the platform, writable, computed Moment of deletion.
contact_edate datetime itgen_acn_edate writable
contact_email varchar2 E-mailadres filters on the platform, writable
contact_email_domain varchar2 E-maildomein writable
contact_email_local varchar2 E-mail Lokaal writable
contact_firstName varchar2 Voornaam 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-adres writable
contact_lastName varchar2 Achternaam filters on the platform, writable
contact_last_click_date datetime Laatste Klik Datum filters on the platform, writable, computed Moment the contact last clicked a link.
contact_last_mpp_open_date datetime Laatste Openingsdatum Mpp filters on the platform, writable, computed Moment of the last open attributed to Apple Mail Privacy Protection.
contact_last_open_date datetime Laatste Openingsdatum 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 Organisatie ID writable
contact_orgname varchar2 Organisatienaam 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 Beoordelingsdatum writable
contact_segmentio_id int64 Segment ID writable
contact_sentcnt int64 Verzonden Aantal writable
contact_sms_consent int64 SMS-toestemming filters on the platform, writable, computed Consent status for SMS.
contact_sms_consent_updated_at datetime SMS-toestemming Bijgewerkt op filters on the platform, writable, computed Moment the SMS consent was last changed.
contact_socialdata_lastcheck datetime Sociale Data Laatste Controle writable
contact_ua varchar2 Browser Specificatie writable
contact_udate datetime Laatst Bijgewerkt filters on the platform, writable, computed
contact_updated_by int64 Bijgewerkt door 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 Bijgewerkte UTC-tijdstempel 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 Geografisch adres filters on the platform, writable
geoaddrid int64 Geo-adres-ID filters on the platform, writable
id int64 ID filters on the platform, writable, computed
ip4 varchar2 IPv4 Adres filters on the platform, writable
messageid int64 Bericht ID filters on the platform, writable
tstamp datetime Tstamp filters on the platform, writable

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

Wijzigingen in deze tabel, 26.0 tot 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 meer wijzigingen

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

Alle wisselingen van de Driver, 26.0 tot 27.0