Activity Data Reference
This page contains the details of each table: the schema, and a reference to understand the contents. Use this bookmarks to quickly find the specific table details you're looking for:
Activity Logs
A complete collection of logs for every event that happened in your CARTO organization
Schema
type
STRING
Identifies the specific event that occurred. Check the event reference for a list of possible values. Example: MapCreated
.
ts
TIMESTAMP
The timestamp of the event, in UTC.
data
JSON STRING
The payload with all the data associated with the event. Check the event reference for a list of possible values.
Event Reference
AccountBrandingDeleted
Contains the admin that produced the action
AccountBrandingUpdated
Contains the admin that modified the branding
AccountCreated
Your organization was created
Contains info about the industry customization, if any
AccountDeleted
Your organization was deleted
AccountDeletedUI
Contains infomation about the user who triggered the deletion
AccountRestored
Your organization was no longer suspended and can be accessed
AccountSuspended
Your organization was suspended and can't be accessed
AccountUpdated
Your organization was updated, typically metadata.
ActivityDataExportRequest
Contains info about the date ranges and the categories requested, as well as the user who requested it
AppCreated
Contains info about the user that created it, and the type + ID of OAuth Client
AppDeleted
Contains info about the user who deleted it, as well as which OAuth Client was deleted
AppGallerySelected
Contains info about which user opened which application
AppSelected
Contains info about which user and which application
AppUpdated
Contains info about which admin and which application, and whether the app is bookmarked at the homepage
ATInstallationFinished
Contains info about the provider and the AT version
ATInstallationStarted
Contains info about the provider and the AT version
ATUninstallFinished
Contains info about the provider
ATUninstallStarted
Contains info about the provider
BigQueryLocationUsage
Contains info about the location
BucketIntegrationCreated
Contains info about the provider and the admin who completed the integration
BucketIntegrationDeleted
Contains info about the provider and the admin who deleted the integration
BucketIntegrationUpdated
Contains info about the provider and the admin who updated the integration
BucketIntegrationVerificationFailed
Contains info about the provider, the admin who tried to validate, and the specific error
BuilderCustomAggResolution
Contains info about the map, the user and the aggregation type
BuilderDataExport
Contains info about the user, the map, the export type and the number of exported layers
BuilderMaskCreated
Contains info about the user, the map, and the type of mask created
BuilderQueryThisTable
Contains info about the user, the map, and the connection provider
BuilderRefreshDataSource
Contains info about the user, the map, and the connection provider
BuilderReportDownload
Contains info about the user and the map
BuilderURLParameterUsed
Contains info about the user, the map, and the URL parameters used
CartoAccessConsent
An admin gave or revoked consent for the CARTO Support Team to access the org
Contains info about the admin, the action (enable/disable) and the duration for the consent
CartoAIFeedback
Someone gave feedback to the AI agent in a Builder map
Contains info about the feedback type and the threadId of that AI interaction
CartoDWAccessGranted
Contains info about the user
CartoDWAccessRevoked
Contains info about the user
ChangeDatasource
A data source in Builder was swapped.
Contains info about the user, the type of swap, and the map ID containing the data source
ConnectionCreated
Contains info about the user, the provider, the connection privacy, and the connection method
ConnectionDeleted
Contains info about the user, the provider, the connection privacy, and the connection method
ConnectionProviderSelected
Contains info about the user and the connection provider
ConnectionUpdated
Contains info about the user, the provider, the connection privacy (including the previous value), and the connection method
ConnectionViewerCredentialsDeleted
Contains info about the user, the provider, the connection, and the credentials type
ConnectionViewerCredentialsUpdated
Contains info about the user, the provider, the connection, and the credentials type
CopyEmbedCode
Contains info about the user and the map
CopyMapId
An editor copied the map ID provided in a Builder map
Contains info about the user and the map
CopyMapLink
Contains info about the user and the map
DataExplorerItemBrowsed
Contains info about the user, the provider and the connection
DataExplorerItemsListed
Contains info about the FQN, the connection, the user, the provider, the privacy, and the object type/level/count
DataExplorerMapCreated
Contains info about the user, the provider, and the connection
DataExplorerWorkflowCreated
Contains info about the user, the provider, and the connection
DataSourceCreated
Contains info about the user, the provider, the source type, the connection and the map.
DataSourceUpdated
Contains info about the user, the provider, the source type, the connection and the map.
DataSourceDeleted
Contains info about the user, the provider, the source type, the connection and the map.
DemoMapCreated
A user created a new map from one of the demo map templates that appear when onboarding into CARTO
Contains info about the user, the map, the map privacy, and the specific demo map used
DemoMapDuplicated
A user duplicated a new map from one of the demo map templates that appear when onboarding into CARTO
Contains info about the user, and the specific demo map duplicated
DemoWorkflowCreated
A user created a new workflow from one of the demo map templates that appear when onboarding into CARTO
Contains info about the user, the workflow, the workflow privacy, and the specific demo workflow used
DemoWorkflowDuplicated
A user duplicated a new workflow from one of the demo map templates that appear when onboarding into CARTO
Contains info about the user, and the specific demo workflow duplicated
DOAccessIn
Contains info about the user, the dataset, and the provider
DOAccessInRequest
Contains info about the user, the requested dataset, and the requested provider
DOEntitlementCreated
Contains info about the user and the dataset
DOEntitlementUpdated
Contains info about the user and the dataset
DomainUpdated
Contains info about the old domain and the new domain
DOMapCreated
Contains info about the user and the provider
DOSampleEntitlementCreated
Contains info about the user and the dataset sample
DOSubscriptionRequested
Contains info about the user and the requested dataset
EmailSent
CARTO sent a transactional email to a user
Contains info about the list of recipient users and the subject of the email
FileImportCreated
Contains info about the user, the provider, the connection, and the import job ID
GeocodeLaunched
Contains info about the user, the provider, the geocoding type, and the connection
GroupCreated
Contains info about the admin that created the group, and the new group ID
GroupDeleted
Contains info about the group Id that was deleted, and the admin who deleted it
GroupUpdated
Contains info about the user that triggered the update and the group ID
HelpSidebarBlockClick
Contains info about the user, the context, and the specific help block
HelpSidebarOpened
Contains info about the user and the context
HelpSidebarSearchQuery
Contains info about the user and the context
HexColorColumnStyled
Contains info about the user and the map
HttpRequestConsumed
Contains info about the user and the URL requested
ImportStatusChanged
Contains info about the import job ID, the status, the elapsed time, the file type, and the schema detection mode
IntegrationCreated
Contains info about the admin and the integration type
IntegrationDeleted
Contains info about the admin and the integration type
IntegrationUpdated
Contains info about the admin and the integration type
IntegrationVerificationFailed
Contains info about the admin, the integration type, and the specific error
InvitationDeleted
Contains info about the admin who deleted the invite
InvitationSent
Contains info about the admin who sent the invite
InviteUsersMainMenuClicked
Contains info about the user
JoinRequestApproved
Contains info about the approved user
JoinRequestRejected
Contains info about the rejected user
LayerTypeChanged
Contains info about the user and the new layer type
LdsConsumed
Contains info about the user, the LDS service, the provider, the config, and the amount of LDS quota consumed
LdsRequestGotOverquota
Contains info about the user, the LDS service, the provider, the config, and the amount of LDS quota consumed
MapCreated
Contains info about the user, the map, the map privacy, and whether it's a demo map
MapDeleted
Contains info about the user, the map, the map privacy, and whether it's a demo map
MapDescriptionCreated
Contains info about the user
MapDescriptionUsed
Contains info about the user
MapDuplicated
Contains info about the user, the map, the map privacy, whether it's a demo map, and the new duplicated map ID
MapEditMode
Contains info about the user and the map
MapInstantiationInvalidated
Contains info about the user, the provider, the connection, and the specific source
MapLoadedEvent
Contains info about the user, the map, the map privacy, and whether it's a demo map
MapLocked
Contains info about the user, the map, the map privacy, and whether it's a demo map
MapPreviewMode
Contains info about the user and the map
MapPrivacyChanged
Contains info about the user, the map, the map privacy, the previous map privacy and whether it's a demo map
MapPublishUpdate
Contains info about the user and the map
MapsListed
Contains info about the user
MapSnapshotCreated
Contains info about the user, the map, the map privacy, and whether it's a demo map
MapTakeoverAccept
Contains info about the user, the map, the map privacy, and whether it's a demo map
MapTakeoverReject
Contains info about the user, the map, the map privacy, and whether it's a demo map
MapTakeoverRequest
Contains info about the user, the map, the map privacy, and whether it's a demo map
MapUnlocked
Contains info about the user, the map, the map privacy, and whether it's a demo map
MapUpdated
Contains info about the user, the map, the map privacy, and whether it's a demo map
MapUpdatesPublished
Contains info about the user, the map, and the specific widgets used
MeasureToolUsed
Contains info about the user and the map
NamedSourceCreated
Contains info about the user and the named source
NamedSourceDeleted
Contains info about the user and the named source
NamedSourceUpdated
Contains info about the user and the named source
ObjectMetadata
This event is fired every time a data resource (table or query) is used in CARTO
Contains info about the user, the FQN used, the provider and connection details, and metadata about this object
OnboardingCompleted
Contains info about the user
OnboardingItemChecked
Contains info about the user and the specific task
OnboardingOpened
Contains info about the user
OnboardingSkipped
Contains info about the user
OpenAPIAccessTokens
Contains info about the user
OpenApplications
Contains info about the user
OpenBuilderMap
Contains info about the user, the map, and the map privacy
OpenConnections
Contains info about the user
OpenDE
Contains info about the user
OpenDevelopers
Contains info about the user
OpenDO
Contains info about the user
OpenHomePage
Contains info about the user
OpenSettings
Contains info about the admin
OpenWorkflow
Contains info about the user and the specific workflow
OptimizeTableLaunched
Contains info about the user, the connection, and the FQN of the optimized table
QuotaUXTriggered
Contains info about the user, the specific quota, and the UI where this alert was raised
ResourceDeleted
Contains info about the user, the FQN of the deleted resource, and the connection used
ShowOnlyThis
Someone used the "Show only this layer" function in Builder
Contains info about the user and the map
SpatialColumnTypeDefined
A different Spatial Column (and type) was specified in a Builder map
Contains info about the user, the spatial type, and the spatial column name
SQLAnalysisCreated
Contains info about the user, the map, the analysis type, and additional metadata
SQLParameterCreated
Contains info about the user, the type of SQL parameter, and the map
SQLParameterUsed
Contains info about the user, the type of SQL parameter, the map, and the map privacy
SyncUserGroups
Contains info about the user, the added groups for that user, and the removed groups for that user
TableUsedDetails
The specified table resource was used somewhere in CARTO
Contains info about the user, the context, the FQN, the object type, the connection, and the provider
TableWidgetInteraction
Contains info about the user, the map, and the interaction type
TilesetCreated
Contains info about the user, the connection, and additional metadata
TokenCreated
Contains info about the user and the token
TokenDeleted
Contains info about the user and the token
TokenM2MCreated
Contains info about the user and the remaining M2M OAuth Tokens quota
TokenUpdated
Contains info about the user and the token
UserCreated
Contains info about the user, the method used to join, and additional organization information
UserDeleted
Contains info about the user and role of the deleted user
UserLogins
A user logged in
Contains info about the user
UserLogout
A user logged out manually from CARTO
Contains info about the user
UserRoleUpdated
Contains info about the user, their previous role, and the new role
UserUpdated
Contains info about the user
WorkflowApiExecuted
Contains info about the user, the workflow, and the provider
WorkflowCreated
Contains info about the user, the workflow, the privacy, the provider, and the connection
WorkflowDeleted
Contains info about the user, the deleted workflow, the privacy, the provider, and the connection
WorkflowDuplicated
Contains info about the user, the workflow, the privacy, the provider, the connection, and the new duplicated workflow ID
WorkflowExecutionComplete
Contains the user, the workflow, and very specific compehensive details about the workflow components used and their results
WorkflowMapCreated
Contains info about the user, the workflow, and the workflow component from where the map was crreated
WorkflowPrivacyChanged
Contains info about the user, the workflow, the original privacy, and the new privacy
WorkflowRun
Contains info about the user, the workflow, the provider, and the components used
WorkflowsAPIDisabled
Contains info about the user and the workflow
WorkflowsAPIEnabled
Contains info about the user and the workflow
WorkflowsExtensionInstalled
Contains info about the user and the installed extension name, author, and provider
WorkflowsExtensionUninstalled
Contains info about the user and the uninstalled extension name, author, and provider
WorkflowScheduleCreated
Contains info about the user, the provider, and the workflow
WorkflowScheduleDeleted
Contains info about the user, the provider, and the workflow
WorkflowScheduleUpdated
Contains info about the user, the provider, and the workflow
WorkflowsFileDeleted
Contains info about the user, the workflow, and the deleted file
WorkflowsFileLoaded
Contains info about the user, the workflow, and the deleted file
WorkflowsListed
Contains info about the user
WorkflowsResultCopied
Contains info about the user and the workflow
WorkflowsResultPaginationLengthChanged
Contains info about the user, the workflow, and the new pagination length
WorkflowsResultPaginationNavigationAction
Contains info about the user and the workflow
WorkflowsSQLExported
Contains info about the user and the workflow
WorkflowTemplateCreated
Someone created a workflow from a template
Contains info about the user, the connection provider, and the template title
WorkflowsTemplateExplored
Someone explored a Workflow template
Contains info about the user
WorkflowsVariableAdded
Contains info about the user, the workflow, and the variable type
WorkflowsVariableUsed
Contains info about the user, the workflow, and the component where the variable was used
WorkflowUpdated
Contains info about the user, the privacy, the connection, and the provider used
ZoomToLayer
Someone used the "Zoom to layer" function in a CARTO Builder map
Contains info about the user and the map
API Usage
A daily aggregation by user, API and component of your API usage, used to calculate your Usage Quota.
Schema
ts
TIMESTAMP
timestamp of the usage (daily)
user_id
STRING
User that produced the usage. Public means an unauthenticated user (eg: a public Builder map)
metric
STRING
A combination of API + method + client.
amount
NUMBER
quota_usage_weight
NUMBER
User List
A relationship between the ID and the email of all the current users in your organization, as well as their role and group membership.
Some events in the Activity Logs may contain a userId called public.
That user won't be present in this list, and it means that we weren't able to attribute the event to any known user. That happens, for example, in public maps available to anyone in the internet, or in custom applications that use your own login system.
Schema
user_id
STRING
Unique user identifier. The first part contains information about the authentication method:
- auth0|xxx
-> User/password
- google-oauth|xxx
-> Google sign-in
- saml-ACME|xxx
(or similar) -> ACME SSO
STRING
User email
created_at
TIMESTAMP
Date and time of the user creation
role
STRING
Current role of the user. Possible values: - Admin - Editor - Viewer
group_ids
STRING ARRAY
Group List
A relationship between the ID and the name of all the current groups in your organization
Schema
group_id
STRING
group_alias
STRING
Last updated
Was this helpful?