ACCOUNTS_SEARCHCHANGEHISTORYEVENTS_CHANGES
- Last Updated: May 8, 2023
- 1 minute read
- DataDirect Connectors
- JDBC
- Documentation
Endpoint
https://analyticsadmin.googleapis.com/v1/accounts/{accountId}:searchChangeHistoryEvents
Parent Table
ACCOUNTS_SEARCHCHANGEHISTORYEVENTS
Columns
The ACCOUNTS_SEARCHCHANGEHISTORYEVENTS_CHANGES table contains the following columns. Columns marked with an asterisk comprise the primary key.
| Column Name | Data Type | Notes |
|---|---|---|
| ACCOUNTS_SEARCHCHANGEHISTORYEVENTS_ID* | VarChar(64) | References: ACCOUNTS_SEARCHCHANGEHISTORYEVENTS.ID |
| POSITION* | Integer | |
| ACCOUNTID | VarChar(64) | |
| ACTION | VarChar(23) | |
| RESOURCE | VarChar(64) | |
| RESOURCEAFTERCHANGE_ACCOUNT_CREATETIME | Timestamp(6) | |
| RESOURCEAFTERCHANGE_ACCOUNT_DELETED | Boolean | |
| RESOURCEAFTERCHANGE_ACCOUNT_DISPLAYNAME | VarChar(64) | |
| RESOURCEAFTERCHANGE_ACCOUNT_NAME | VarChar(64) | |
| RESOURCEAFTERCHANGE_ACCOUNT_REGIONCODE | VarChar(64) | |
| RESOURCEAFTERCHANGE_ACCOUNT_UPDATETIME | Timestamp(6) | |
| RESOURCEAFTERCHANGE_CONVERSIONEVENT_CREATETIME | VarChar(64) | |
| RESOURCEAFTERCHANGE_CONVERSIONEVENT_CUSTOM | Boolean | |
| RESOURCEAFTERCHANGE_CONVERSIONEVENT_DELETABLE | Boolean | |
| RESOURCEAFTERCHANGE_CONVERSIONEVENT_EVENTNAME | VarChar(64) | |
| RESOURCEAFTERCHANGE_CONVERSIONEVENT_NAME | VarChar(64) | |
| RESOURCEAFTERCHANGE_DATARETENTIONSETTINGS_EVENTDATARETENTION | VarChar(30) | |
| RESOURCEAFTERCHANGE_DATARETENTIONSETTINGS_NAME | VarChar(64) | |
| RESOURCEAFTERCHANGE_DATARETENTIONSETTINGS_RESETUSERDATAONNEWACTIVITY | Boolean | |
| RESOURCEAFTERCHANGE_DATASTREAM_ANDROIDAPPSTREAMDATA_FIREBASEAPPID | VarChar(64) | |
| RESOURCEAFTERCHANGE_DATASTREAM_ANDROIDAPPSTREAMDATA_PACKAGENAME | VarChar(64) | |
| RESOURCEAFTERCHANGE_DATASTREAM_CREATETIME | VarChar(64) | |
| RESOURCEAFTERCHANGE_DATASTREAM_DISPLAYNAME | VarChar(64) | |
| RESOURCEAFTERCHANGE_DATASTREAM_IOSAPPSTREAMDATA_BUNDLEID | VarChar(64) | |
| RESOURCEAFTERCHANGE_DATASTREAM_IOSAPPSTREAMDATA_FIREBASEAPPID | VarChar(64) | |
| RESOURCEAFTERCHANGE_DATASTREAM_NAME | VarChar(64) | |
| RESOURCEAFTERCHANGE_DATASTREAM_TYPE | VarChar(30) | |
| RESOURCEAFTERCHANGE_DATASTREAM_UPDATETIME | VarChar(64) | |
| RESOURCEAFTERCHANGE_DATASTREAM_WEBSTREAMDATA_DEFAULTURI | VarChar(64) | |
| RESOURCEAFTERCHANGE_DATASTREAM_WEBSTREAMDATA_FIREBASEAPPID | VarChar(64) | |
| RESOURCEAFTERCHANGE_DATASTREAM_WEBSTREAMDATA_MEASUREMENTID | VarChar(64) | |
| RESOURCEAFTERCHANGE_FIREBASELINK_CREATETIME | VarChar(64) | |
| RESOURCEAFTERCHANGE_FIREBASELINK_NAME | VarChar(64) | |
| RESOURCEAFTERCHANGE_FIREBASELINK_PROJECT | VarChar(64) | |
| RESOURCEAFTERCHANGE_GOOGLEADSLINK_ADSPERSONALIZATIONENABLED | Boolean | |
| RESOURCEAFTERCHANGE_GOOGLEADSLINK_CANMANAGECLIENTS | Boolean | |
| RESOURCEAFTERCHANGE_GOOGLEADSLINK_CREATETIME | VarChar(64) | |
| RESOURCEAFTERCHANGE_GOOGLEADSLINK_CREATOREMAILADDRESS | VarChar(64) | |
| RESOURCEAFTERCHANGE_GOOGLEADSLINK_CUSTOMERID | VarChar(64) | |
| RESOURCEAFTERCHANGE_GOOGLEADSLINK_NAME | VarChar(64) | |
| RESOURCEAFTERCHANGE_GOOGLEADSLINK_UPDATETIME | VarChar(64) | |
| RESOURCEAFTERCHANGE_MEASUREMENTPROTOCOLSECRET_DISPLAYNAME | VarChar(64) | |
| RESOURCEAFTERCHANGE_MEASUREMENTPROTOCOLSECRET_NAME | VarChar(64) | |
| RESOURCEAFTERCHANGE_MEASUREMENTPROTOCOLSECRET_SECRETVALUE | VarChar(64) | |
| RESOURCEAFTERCHANGE_PROPERTY_ACCOUNT | VarChar(64) | |
| RESOURCEAFTERCHANGE_PROPERTY_CREATETIME | VarChar(64) | |
| RESOURCEAFTERCHANGE_PROPERTY_CURRENCYCODE | VarChar(64) | |
| RESOURCEAFTERCHANGE_PROPERTY_DELETETIME | VarChar(64) | |
| RESOURCEAFTERCHANGE_PROPERTY_DISPLAYNAME | VarChar(64) | |
| RESOURCEAFTERCHANGE_PROPERTY_EXPIRETIME | VarChar(64) | |
| RESOURCEAFTERCHANGE_PROPERTY_INDUSTRYCATEGORY | VarChar(30) | |
| RESOURCEAFTERCHANGE_PROPERTY_NAME | VarChar(64) | |
| RESOURCEAFTERCHANGE_PROPERTY_PARENT | VarChar(64) | |
| RESOURCEAFTERCHANGE_PROPERTY_PROPERTYTYPE | VarChar(30) | |
| RESOURCEAFTERCHANGE_PROPERTY_SERVICELEVEL | VarChar(30) | |
| RESOURCEAFTERCHANGE_PROPERTY_TIMEZONE | VarChar(64) | |
| RESOURCEAFTERCHANGE_PROPERTY_UPDATETIME | VarChar(64) | |
| RESOURCEBEFORECHANGE_ACCOUNT_CREATETIME | Timestamp(6) | |
| RESOURCEBEFORECHANGE_ACCOUNT_DELETED | Boolean | |
| RESOURCEBEFORECHANGE_ACCOUNT_DISPLAYNAME | VarChar(64) | |
| RESOURCEBEFORECHANGE_ACCOUNT_NAME | VarChar(64) | |
| RESOURCEBEFORECHANGE_ACCOUNT_REGIONCODE | VarChar(64) | |
| RESOURCEBEFORECHANGE_ACCOUNT_UPDATETIME | Timestamp(6) | |
| RESOURCEBEFORECHANGE_CONVERSIONEVENT_CREATETIME | VarChar(64) | |
| RESOURCEBEFORECHANGE_CONVERSIONEVENT_CUSTOM | Boolean | |
| RESOURCEBEFORECHANGE_CONVERSIONEVENT_DELETABLE | Boolean | |
| RESOURCEBEFORECHANGE_CONVERSIONEVENT_EVENTNAME | VarChar(64) | |
| RESOURCEBEFORECHANGE_CONVERSIONEVENT_NAME | VarChar(64) | |
| RESOURCEBEFORECHANGE_DATARETENTIONSETTINGS_EVENTDATARETENTION | VarChar(30) | |
| RESOURCEBEFORECHANGE_DATARETENTIONSETTINGS_NAME | VarChar(64) | |
| RESOURCEBEFORECHANGE_DATARETENTIONSETTINGS_RESETUSERDATAONNEWACTIVITY | Boolean | |
| RESOURCEBEFORECHANGE_DATASTREAM_ANDROIDAPPSTREAMDATA_FIREBASEAPPID | VarChar(64) | |
| RESOURCEBEFORECHANGE_DATASTREAM_ANDROIDAPPSTREAMDATA_PACKAGENAME | VarChar(64) | |
| RESOURCEBEFORECHANGE_DATASTREAM_CREATETIME | VarChar(64) | |
| RESOURCEBEFORECHANGE_DATASTREAM_DISPLAYNAME | VarChar(64) | |
| RESOURCEBEFORECHANGE_DATASTREAM_IOSAPPSTREAMDATA_BUNDLEID | VarChar(64) | |
| RESOURCEBEFORECHANGE_DATASTREAM_IOSAPPSTREAMDATA_FIREBASEAPPID | VarChar(64) | |
| RESOURCEBEFORECHANGE_DATASTREAM_NAME | VarChar(64) | |
| RESOURCEBEFORECHANGE_DATASTREAM_TYPE | VarChar(30) | |
| RESOURCEBEFORECHANGE_DATASTREAM_UPDATETIME | VarChar(64) | |
| RESOURCEBEFORECHANGE_DATASTREAM_WEBSTREAMDATA_DEFAULTURI | VarChar(64) | |
| RESOURCEBEFORECHANGE_DATASTREAM_WEBSTREAMDATA_FIREBASEAPPID | VarChar(64) | |
| RESOURCEBEFORECHANGE_DATASTREAM_WEBSTREAMDATA_MEASUREMENTID | VarChar(64) | |
| RESOURCEBEFORECHANGE_FIREBASELINK_CREATETIME | VarChar(64) | |
| RESOURCEBEFORECHANGE_FIREBASELINK_NAME | VarChar(64) | |
| RESOURCEBEFORECHANGE_FIREBASELINK_PROJECT | VarChar(64) | |
| RESOURCEBEFORECHANGE_GOOGLEADSLINK_ADSPERSONALIZATIONENABLED | Boolean | |
| RESOURCEBEFORECHANGE_GOOGLEADSLINK_CANMANAGECLIENTS | Boolean | |
| RESOURCEBEFORECHANGE_GOOGLEADSLINK_CREATETIME | VarChar(64) | |
| RESOURCEBEFORECHANGE_GOOGLEADSLINK_CREATOREMAILADDRESS | VarChar(64) | |
| RESOURCEBEFORECHANGE_GOOGLEADSLINK_CUSTOMERID | VarChar(64) | |
| RESOURCEBEFORECHANGE_GOOGLEADSLINK_NAME | VarChar(64) | |
| RESOURCEBEFORECHANGE_GOOGLEADSLINK_UPDATETIME | VarChar(64) | |
| RESOURCEBEFORECHANGE_MEASUREMENTPROTOCOLSECRET_DISPLAYNAME | VarChar(64) | |
| RESOURCEBEFORECHANGE_MEASUREMENTPROTOCOLSECRET_NAME | VarChar(64) | |
| RESOURCEBEFORECHANGE_MEASUREMENTPROTOCOLSECRET_SECRETVALUE | VarChar(64) | |
| RESOURCEBEFORECHANGE_PROPERTY_ACCOUNT | VarChar(64) | |
| RESOURCEBEFORECHANGE_PROPERTY_CREATETIME | VarChar(64) | |
| RESOURCEBEFORECHANGE_PROPERTY_CURRENCYCODE | VarChar(64) | |
| RESOURCEBEFORECHANGE_PROPERTY_DELETETIME | VarChar(64) | |
| RESOURCEBEFORECHANGE_PROPERTY_DISPLAYNAME | VarChar(64) | |
| RESOURCEBEFORECHANGE_PROPERTY_EXPIRETIME | VarChar(64) | |
| RESOURCEBEFORECHANGE_PROPERTY_INDUSTRYCATEGORY | VarChar(30) | |
| RESOURCEBEFORECHANGE_PROPERTY_NAME | VarChar(64) | |
| RESOURCEBEFORECHANGE_PROPERTY_PARENT | VarChar(64) | |
| RESOURCEBEFORECHANGE_PROPERTY_PROPERTYTYPE | VarChar(30) | |
| RESOURCEBEFORECHANGE_PROPERTY_SERVICELEVEL | VarChar(30) | |
| RESOURCEBEFORECHANGE_PROPERTY_TIMEZONE | VarChar(64) | |
| RESOURCEBEFORECHANGE_PROPERTY_UPDATETIME | VarChar(64) |