ContactAut: ActiveCampaign Contact Aut
read only
- Catalogus:
ActiveCampaign - Schema:
Views - Label: Contact Aut
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 ContactAut 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 |
|---|---|---|---|---|---|
adddate |
datetime |
Voeg Datum toe | filters on the platform, writable | ||
automation |
int64 |
Automation | filters on the platform, writable | ||
batchid |
varchar2 |
Batch ID | filters on the platform, writable | ||
complete |
int64 |
Voltooide Waarde | filters on the platform, writable | ||
completed |
int64 |
Completed | filters on the platform, writable | ||
completed |
int64 |
Voltooide Elementen | 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 |
Beste Stuur Tijdstip | filters on the platform, writable, computed | Hour of the day with the highest expected engagement. | |
contact_ |
datetime |
Datum Afgewezen | writable | ||
contact_ |
int64 |
Hard Afgewezen | writable | ||
contact_ |
int64 |
Zacht Afgewezen | writable | ||
contact_ |
datetime |
Created | filters on the platform, writable, computed | ||
contact_ |
int64 |
Gemaakt door | 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 |
Aangemaakte UTC-tijdstempel | filters on the platform, writable, computed | Moment of creation in UTC. | |
contact_ |
int64 |
Deleted | writable | ||
contact_ |
datetime |
Verwijderd op | filters on the platform, writable, computed | Moment of deletion. | |
contact_ |
datetime |
itgen_acn_edate | writable | ||
contact_ |
varchar2 |
E-mailadres | filters on the platform, writable | ||
contact_ |
varchar2 |
E-maildomein | writable | ||
contact_ |
varchar2 |
E-mail Lokaal | writable | ||
contact_ |
varchar2 |
Voornaam | 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-adres | writable | ||
contact_ |
varchar2 |
Achternaam | filters on the platform, writable | ||
contact_ |
datetime |
Laatste Klik Datum | filters on the platform, writable, computed | Moment the contact last clicked a link. | |
contact_ |
datetime |
Laatste Openingsdatum Mpp | filters on the platform, writable, computed | Moment of the last open attributed to Apple Mail Privacy Protection. | |
contact_ |
datetime |
Laatste Openingsdatum | 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 |
Organisatie ID | writable | ||
contact_ |
varchar2 |
Organisatienaam | filters on the platform, writable, computed | Name of the account the contact belongs to. | |
contact_ |
varchar2 |
Phone | filters on the platform, writable | ||
contact_ |
datetime |
Beoordelingsdatum | writable | ||
contact_ |
int64 |
Segment ID | writable | ||
contact_ |
int64 |
Verzonden Aantal | writable | ||
contact_ |
int64 |
SMS-toestemming | filters on the platform, writable, computed | Consent status for SMS. | |
contact_ |
datetime |
SMS-toestemming Bijgewerkt op | filters on the platform, writable, computed | Moment the SMS consent was last changed. | |
contact_ |
datetime |
Sociale Data Laatste Controle | writable | ||
contact_ |
varchar2 |
Browser Specificatie | writable | ||
contact_ |
datetime |
Laatst Bijgewerkt | filters on the platform, writable, computed | ||
contact_ |
int64 |
Bijgewerkt door | 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 |
Bijgewerkte UTC-tijdstempel | 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 | ||
lastblock |
int64 |
Laatste Blok | filters on the platform, writable | ||
lastdate |
datetime |
Laatste Datum | filters on the platform, writable | ||
lastlogid |
int64 |
Laatste Log ID | filters on the platform, writable | ||
remdate |
datetime |
Herinneringsdatum | filters on the platform, writable | ||
seriesid |
int64 |
Series ID | filters on the platform, writable | ||
startid |
int64 |
Start ID | filters on the platform, writable | ||
status |
int64 |
Status | filters on the platform, writable | ||
timespan |
int64 |
Timespan | filters on the platform, writable | ||
total |
int64 |
Totaal Aantal Elementen | 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)