Stats

使用此端点从 Mautic 的数据库表中获取统计数据。

使用 Mautic API 库

您可以使用以下 :xref:`Mautic API Library 与此 API 进行交互，或者使用本文档中描述的各种 HTTP 端点。

<?php
use Mautic\MauticApi;
use Mautic\Auth\ApiAuth;

// ...
$initAuth = new ApiAuth();
$auth     = $initAuth->newAuth($settings);
$apiUrl   = "https://example.com";
$api      = new MauticApi();
$statsApi = $api->newApi("stats", $auth, $apiUrl);

获取统计表

检索所有可用统计表的列表及其列。

<?php

//...
$tables = $statsApi->get();

HTTP 请求

GET /stats

响应

当请求成功检索到统计表时，返回 200 OK。

{

“availableTables”: [
“asset_downloads”, “audit_log”, “campaign_lead_event_log”, “campaign_leads”, “channel_url_trackables”, “companies_leads”, “dynamic_content_lead_data”, “dynamic_content_stats”, “email_stat_replies”, “email_stats”, “email_stats_devices”, “form_submissions”, “ip_addresses”, “lead_categories”, “lead_companies_change_log”, “lead_devices”, “lead_donotcontact”, “lead_event_log”, “lead_frequencyrules”, “lead_lists_leads”, “lead_points_change_log”, “lead_stages_change_log”, “lead_utmtags”, “page_hits”, “page_redirects”, “point_lead_action_log”, “point_lead_event_log”, “push_notification_stats”, “sms_message_stats”, “stage_lead_action_log”, “video_hits”, “webhook_logs”

], “tableColumns”: {

“asset_downloads”: [
“asset_id”, “code”, “date_download”, “email_id”, “id”, “ip_id”, “lead_id”, “referer”, “source”, “source_id”, “tracking_id”

], “audit_log”: [

“action”, “bundle”, “date_added”, “details”, “id”, “ip_address”, “object”, “object_id”, “user_id”, “user_name”

], “campaign_lead_event_log”: [

“campaign_id”, “channel”, “channel_id”, “date_triggered”, “event_id”, “id”, “ip_id”, “is_scheduled”, “lead_id”, “metadata”, “non_action_path_taken”, “rotation”, “system_triggered”, “trigger_date”

], “campaign_leads”: [

“campaign_id”, “date_added”, “date_last_exited”, “lead_id”, “manually_added”, “manually_removed”, “rotation”

], “channel_url_trackables”: [

“channel”, “channel_id”, “hits”, “redirect_id”, “unique_hits”

], “companies_leads”: [

“company_id”, “date_added”, “is_primary”, “lead_id”, “manually_added”, “manually_removed”

], “dynamic_content_lead_data”: [

“date_added”, “dynamic_content_id”, “id”, “lead_id”, “slot”

], “dynamic_content_stats”: [

“date_sent”, “dynamic_content_id”, “id”, “last_sent”, “lead_id”, “sent_count”, “sent_details”, “source”, “source_id”, “tokens”

], “email_stat_replies”: [

“date_replied”, “id”, “message_id”, “stat_id”

], “email_stats”: [

“copy_id”, “date_read”, “date_sent”, “email_address”, “email_id”, “id”, “ip_id”, “is_failed”, “is_read”, “last_opened”, “lead_id”, “list_id”, “open_count”, “open_details”, “retry_count”, “source”, “source_id”, “tokens”, “tracking_hash”, “viewed_in_browser”

], “email_stats_devices”: [

“date_opened”, “device_id”, “id”, “ip_id”, “stat_id”

], “form_submissions”: [

“date_submitted”, “form_id”, “id”, “ip_id”, “lead_id”, “page_id”, “referer”, “tracking_id”

], “ip_addresses”: [

“id”, “ip_address”, “ip_details”

], “lead_categories”: [

“category_id”, “date_added”, “id”, “lead_id”, “manually_added”, “manually_removed”

], “lead_companies_change_log”: [

“action_name”, “company_id”, “date_added”, “event_name”, “id”, “lead_id”, “type”

], “lead_devices”: [

“client_info”, “date_added”, “device”, “device_brand”, “device_fingerprint”, “device_model”, “device_os_name”, “device_os_platform”, “device_os_shortname”, “device_os_version”, “id”, “lead_id”, “tracking_id”

], “lead_donotcontact”: [

“channel”, “channel_id”, “comments”, “date_added”, “id”, “lead_id”, “reason”

], “lead_event_log”: [

“action”, “bundle”, “date_added”, “id”, “lead_id”, “object”, “object_id”, “properties”, “user_id”, “user_name”

], “lead_frequencyrules”: [

“channel”, “date_added”, “frequency_number”, “frequency_time”, “id”, “lead_id”, “pause_from_date”, “pause_to_date”, “preferred_channel”

], “lead_lists_leads”: [

“date_added”, “leadlist_id”, “lead_id”, “manually_added”, “manually_removed”

], “lead_points_change_log”: [

“action_name”, “date_added”, “delta”, “event_name”, “id”, “ip_id”, “lead_id”, “type”

], “lead_stages_change_log”: [

“action_name”, “date_added”, “event_name”, “id”, “lead_id”, “stage_id”

], “lead_utmtags”: [

“date_added”, “id”, “lead_id”, “query”, “referer”, “remote_host”, “url”, “user_agent”, “utm_campaign”, “utm_content”, “utm_medium”, “utm_source”, “utm_term”

], “page_hits”: [

“browser_languages”, “city”, “code”, “country”, “date_hit”, “date_left”, “device_id”, “email_id”, “id”, “ip_id”, “isp”, “lead_id”, “organization”, “page_id”, “page_language”, “query”, “redirect_id”, “referer”, “region”, “remote_host”, “source”, “source_id”, “tracking_id”, “url”, “url_title”, “user_agent”

], “page_redirects”: [

“checked_out”, “checked_out_by”, “checked_out_by_user”, “created_by”, “created_by_user”, “date_added”, “date_modified”, “hits”, “id”, “is_published”, “modified_by”, “modified_by_user”, “redirect_id”, “unique_hits”, “url”

], “point_lead_action_log”: [

“date_fired”, “ip_id”, “lead_id”, “point_id”

], “point_lead_event_log”: [

“date_fired”, “event_id”, “ip_id”, “lead_id”

], “push_notification_stats”: [

“click_count”, “click_details”, “date_clicked”, “date_read”, “date_sent”, “id”, “ip_id”, “is_clicked”, “last_clicked”, “lead_id”, “list_id”, “notification_id”, “retry_count”, “source”, “source_id”, “tokens”, “tracking_hash”

], “sms_message_stats”: [

“date_sent”, “id”, “ip_id”, “lead_id”, “list_id”, “sms_id”, “source”, “source_id”, “tokens”, “tracking_hash”

], “stage_lead_action_log”: [

“date_fired”, “ip_id”, “lead_id”, “stage_id”

], “video_hits”: [

“browser_languages”, “channel”, “channel_id”, “city”, “code”, “country”, “date_hit”, “date_left”, “duration”, “guid”, “id”, “ip_id”, “isp”, “lead_id”, “organization”, “page_language”, “query”, “referer”, “region”, “remote_host”, “time_watched”, “url”, “user_agent”

], “webhook_logs”: [

“date_added”, “id”, “note”, “runtime”, “status_code”, “webhook_id”

]

}

}

Stats properties

Name	Type	Description
`availableTables`	array	List of available tables available for query through this endpoint
`tableColumns`	object	Object containing each table name as a key with an array of column names as the value

Get stats from a table

Retrieves rows from the specified statistical table.

<?php

$table = 'asset_downloads';
$start = 0;
$limit = 50;
$order = [
    [
        'col' => 'id',
        'dir' => 'asc'
    ]
];
$where = [
    [
        'col' => 'id',
        'expr' => 'gt',
        'val' => 3,
    ]
];

$stats = $statsApi->get($table, $start, $limit, $order, $where);

HTTP request

GET /stats/TABLE

Query parameters

Name	Type	Description
`start`	int	Row offset to start from. Defaults to 0.
`limit`	int	Number of rows to return. Defaults to 30.
`order`	array	Array of sorting definitions. Each definition has `col` for column name and `dir` for direction - `asc` or `desc`.
`where`	array	Array of filter conditions. Each condition has `col` for column name, `expr` for expression type, and `val` for the value.

The `expr` parameter in `$where` arrays

The expr parameter supports most methods from Doctrine’s ExpressionBuilder:

Method	Description
`eq`	Value equal to the specified input
`neq`	Value not equal to the specified input
`lt`	Value less than the specified input
`lte`	Value less than or equal to the specified input
`gt`	Value greater than the specified input
`gte`	Value greater than or equal to the specified input
`isNull`	Identification of fields with no data
`isNotNull`	Identification of fields with any data
`like`	Value matching a specific text pattern
`notLike`	Value not matching a specific text pattern
`in`	Match for any value within the specified array
`notIn`	Exclusion of all values within the specified array
`between`	Value falling between two specified inputs

Response

Returns 200 OK when the request successfully retrieves the stats from the table.

```json {

“total”: 1, “stats”: [

{
“id”: “1”, “asset_id”: “1”, “ip_id”: “1”, “lead_id”: “31”, “date_download”: “2023-06-30 08:51:22”, “code”: “200”, “tracking_id”: “b3259e7709f35b7428b7bffcbb3d1d713ac1526c”

}

]

}

Stats from a table properties

Name	Type	Description
`total`	int	Total number of matching rows
`stats`	array	Array of row objects. Columns vary by table.

cURL example

When using cURL, encode the array parameters as query string. For example, to filter by id = 3:

curl "https://example.com/api/stats/asset_downloads?where%5B0%5D%5Bcol%5D=id&where%5B0%5D%5Bexpr%5D=eq&where%5B0%5D%5Bval%5D=3"

This query string is equivalent to:

<?php

$where = [
    [
        'col'  => 'id',
        'expr' => 'eq',
        'val'  => 3,
    ]
];

Available tables

The following tables are available through the Stats API. Tables require appropriate User permissions to access.

Contact statistics

Table	Description
`companies_leads`	Association between Contacts and Companies
`lead_categories`	Category assignments for Contacts
`lead_companies_change_log`	History of Contact and Company associations
`lead_devices`	Device information tracked for Contacts
`lead_donotcontact`	Do-not-contact preferences by Contact and Channel
`lead_event_log`	Activity log for Contact events
`lead_frequencyrules`	Contact frequency and Channel preferences
`lead_lists_leads`	Contact membership in Segments
`lead_points_change_log`	History of Contact Points changes
`lead_stages_change_log`	History of Contact Stage transitions
`lead_utmtags`	UTM parameters tracked for Contacts

`companies_leads`

Association between Contacts and Companies.

Column	Type	Description
`company_id`	int	ID of the Company
`date_added`	datetime	Date and time when Mautic created the association
`is_primary`	boolean	Primary status - `1` or `true` indicates the primary Company for the Contact
`lead_id`	int	ID of the Contact
`manually_added`	boolean	Whether a User added the association manually
`manually_removed`	boolean	Whether a User removed the association manually

`lead_categories`

```

Category assignments for Contacts.

Column	Type	Description
`category_id`	int	ID of the Category
`date_added`	datetime	Date and time when Mautic assigned the Category
`id`	int	Primary key
`lead_id`	int	ID of the Contact
`manually_added`	boolean	Whether a User added the Category manually
`manually_removed`	boolean	Whether a User removed the Category manually

`lead_companies_change_log`

History of Contact and Company associations.

Column	Type	Description
`action_name`	string	Name of the action performed
`company_id`	int	ID of the Company
`date_added`	datetime	Date and time of the change
`event_name`	string	Name of the event that triggered the change
`id`	int	Primary key
`lead_id`	int	ID of the Contact
`type`	string	Type of change

`lead_devices`

Device information tracked for Contacts.

Column	Type	Description
`client_info`	string	Client information
`date_added`	datetime	Date and time when Mautic first tracked the device
`device`	string	Device type
`device_brand`	string	Device manufacturer or brand
`device_fingerprint`	string	Unique device fingerprint
`device_model`	string	Device model name
`device_os_name`	string	Operating system name
`device_os_platform`	string	Operating system platform
`device_os_shortname`	string	Abbreviated operating system name
`device_os_version`	string	Operating system version
`id`	int	Primary key
`lead_id`	int	ID of the Contact
`tracking_id`	string	Tracking identifier for the device

`lead_donotcontact`

Do-not-contact preferences by Contact and Channel.

- Column
  - Type
  - Description
- - channel
  - string
  - Communication Channel such as email or sms
- - channel_id
  - int
  - ID of the specific Channel item
- - comments
  - string
  - Additional comments about the do-not-contact entry
- - date_added
  - datetime
  - Date and time when Mautic added the preference
- - id
  - int
  - Primary key
- - lead_id
  - int
  - ID of the Contact
- - reason
  - int
  - Reason code for the do-not-contact status

`lead_event_log`

Contact 事件的活动日志。

Column	Type	Description
`action`	string	Action that the system performed
`bundle`	string	Mautic bundle that triggered the event
`date_added`	datetime	Date and time of the event
`id`	int	Primary key
`lead_id`	int	ID of the Contact
`object`	string	Object type involved in the event
`object_id`	int	ID of the object
`properties`	string	Additional event properties in JSON format
`user_id`	int	ID of the User who triggered the event
`user_name`	string	Name of the User who triggered the event

`lead_frequencyrules`

联系频率和渠道偏好设置。

Column	Type	Description
`channel`	string	Communication Channel
`date_added`	datetime	Date and time when Mautic created the rule
`frequency_number`	int	Maximum number of messages allowed
`frequency_time`	string	Time period for the frequency limit
`id`	int	Primary key
`lead_id`	int	ID of the Contact
`pause_from_date`	datetime	Start date for communication pause
`pause_to_date`	datetime	End date for communication pause
`preferred_channel`	boolean	Preferred Channel for the Contact

`lead_lists_leads`

联系人在分群中的成员关系。

Column	Type	Description
`date_added`	datetime	Date and time when Mautic added the Contact to the Segment
`leadlist_id`	int	ID of the Segment
`lead_id`	int	ID of the Contact
`manually_added`	boolean	Whether a User added the Contact manually
`manually_removed`	boolean	Whether a User removed the Contact manually

`lead_points_change_log`

联系人积分变更历史记录。

Column	Type	Description
`action_name`	string	Name of the action that changed the Points
`date_added`	datetime	Date and time of the Points change
`delta`	int	Number of Points added or removed
`event_name`	string	Name of the event that triggered the change
`id`	int	Primary key
`ip_id`	int	ID of the IP address associated with the change
`lead_id`	int	ID of the Contact
`type`	string	Type of Points change

`lead_stages_change_log`

History of Contact Stage transitions.

Column	Type	Description
`action_name`	string	Name of the action that changed the Stage
`date_added`	datetime	Date and time of the Stage change
`event_name`	string	Name of the event that triggered the change
`id`	int	Primary key
`lead_id`	int	ID of the Contact
`stage_id`	int	ID of the Stage

`lead_utmtags`

UTM parameters tracked for Contacts.

Column	Type	Description
`date_added`	datetime	Date and time when Mautic tracked the UTM data
`id`	int	Primary key
`lead_id`	int	ID of the Contact
`query`	string	Full query string from the URL
`referer`	string	Referring URL
`remote_host`	string	Remote host name
`url`	string	Full URL visited
`user_agent`	string	User agent string
`utm_campaign`	string	UTM Campaign parameter value
`utm_content`	string	UTM Content parameter value
`utm_medium`	string	UTM Medium parameter value
`utm_source`	string	UTM Source parameter value
`utm_term`	string	UTM Term parameter value

Asset statistics

Table	Description
`asset_downloads`	Asset download events

`asset_downloads`

Asset download events.

- Column
  - Type
  - Description
- - asset_id
  - int
  - 下载的资源的 ID
- - code
  - string
  - HTTP 响应码
- - date_download
  - datetime
  - 下载日期和时间
- - email_id
  - int
  - 包含资源链接的电子邮件的 ID
- - id
  - int
  - 主键
- - ip_id
  - int
  - IP 地址的 ID
- - lead_id
  - int
  - 下载资源的联系人的 ID
- - referer
  - string
  - 引用 URL
- - source
  - string
  - 下载来源
- - source_id
  - int
  - 来源项的 ID
- - tracking_id
  - string
  - 跟踪标识符

活动统计信息

表格	Description
`campaign_leads`	Campaigns 中的联系人
`campaign_lead_event_log`	Campaign 事件的执行日志

`campaign_leads`

Campaigns 中的联系人。

Column	Type	Description
`campaign_id`	int	Campaign 的 ID
`date_added`	datetime	Mautic 将联系人添加到 Campaign 的日期和时间
`date_last_exited`	datetime	联系人上次退出 Campaign 的日期和时间
`lead_id`	int	联系人的 ID
`manually_added`	boolean	用户是否手动添加了联系人
`manually_removed`	boolean	用户是否手动删除了联系人
`rotation`	int	联系人经过 Campaign 的次数

`campaign_lead_event_log`

Campaign 事件的执行日志。

- Column
  - Type
  - Description
- - campaign_id
  - int
  - Campaign ID
- - channel
  - string
  - Communication Channel used
- - channel_id
  - int
  - ID of the Channel item
- - date_triggered
  - datetime
  - Date and time when Mautic triggered the event
- - event_id
  - int
  - ID of the Campaign Event
- - id
  - int
  - Primary key
- - ip_id
  - int
  - ID of the IP address
- - is_scheduled
  - boolean
  - Scheduling status - 1 or true indicates Mautic scheduled the Event execution
- - lead_id
  - int
  - ID of the Contact
- - metadata
  - string
  - Additional event metadata in JSON format
- - non_action_path_taken
  - boolean
  - Path status - 1 or true indicates the Contact took the non-action path
- - rotation
  - int
  - Number of times the Contact went through the Campaign
- - system_triggered
  - boolean
  - Whether the system automatically triggered the event
- - trigger_date
  - datetime
  - Scheduled trigger date and time

Email statistics

Table	Description
`email_stats`	Email send, open, and click statistics
`email_stats_devices`	Device information for Email opens
`email_stat_replies`	Email reply tracking

`email_stats`

Email send, open, and click statistics.

- Column
  - Type
  - Description
- - copy_id
  - int
  - ID of the Email copy
- - date_read
  - datetime
  - Date and time when the Contact first read the Email
- - date_sent
  - datetime
  - Date and time when Mautic sent the Email
- - email_address
  - string
  - Recipient Email address
- - email_id
  - int
  - ID of the Email
- - id
  - int
  - Primary key
- - ip_id
  - int
  - ID of the IP address that opened the Email
- - is_failed
  - boolean
  - Delivery status - 1 or true indicates the Email delivery failed
- - is_read
  - boolean
  - Read status - 1 or true indicates the Contact read the Email
- - last_opened
  - datetime
  - Date and time when the Contact last opened the Email
- - lead_id
  - int
  - ID of the Contact
- - list_id
  - int
  - ID of the Segment that received the Email
- - open_count
  - int
  - Number of times the Contact opened the Email
- - open_details
  - string
  - Details about Email opens in JSON format
- - retry_count
  - int
  - Number of delivery retry attempts
- - source
  - string
  - Source of the Email send
- - source_id
  - int
  - ID of the source item
- - tokens
  - string
  - Token values used in the Email in JSON format
- - tracking_hash
  - string
  - Unique hash for tracking this Email send
- - viewed_in_browser
  - boolean
  - Browser view status - 1 or true indicates the Contact viewed the Email in a browser

`email_stats_devices`

Device information for Email opens.

Column	Type	Description
`date_opened`	datetime	Date and time when the Contact opened the Email on the device
`device_id`	int	ID of the device
`id`	int	Primary key
`ip_id`	int	ID of the IP address
`stat_id`	int	ID of the Email stat record

`email_stat_replies`

Email reply tracking.

Column	Type	Description
`date_replied`	datetime	Date and time when Mautic received the reply
`id`	int	Primary key
`message_id`	string	Email message ID from the reply
`stat_id`	int	ID of the Email stat record

Form statistics

Table	Description
`form_submissions`	Form submission records

`form_submissions`

Form submission records.

- Column
  - Type
  - Description
- - date_submitted
  - datetime
  - Date and time when the Contact submitted the Form
- - form_id
  - int
  - ID of the Form
- - id
  - int
  - Primary key
- - ip_id
  - int
  - ID of the IP address
- - lead_id
  - int
  - ID of the Contact who submitted the Form
- - page_id
  - int
  - ID of the Landing Page containing the Form
- - referer
  - string
  - Referring URL
- - tracking_id
  - string
  - Tracking identifier

Page statistics

Table	Description
`page_hits`	Web page visit tracking
`page_redirects`	Redirect URL hit tracking
`video_hits`	Video viewing analytics
`channel_url_trackables`	Cross-Channel URL tracking

`page_hits`

Web page visit tracking.

Column	Type	Description
`browser_languages`	string	Browser language preferences
`city`	string	City from geolocation
`code`	string	HTTP response code
`country`	string	Country from geolocation
`date_hit`	datetime	Date and time of the page visit
`date_left`	datetime	Date and time when the visitor left the page
`device_id`	int	ID of the device
`email_id`	int	ID of the Email that contained the page link
`id`	int	Primary key
`ip_id`	int	ID of the IP address
`isp`	string	Internet service provider
`lead_id`	int	ID of the Contact
`organization`	string	Organization from IP lookup
`page_id`	int	ID of the Landing Page
`page_language`	string	Language of the page
`query`	string	Query string from the URL
`redirect_id`	int	ID of the redirect if applicable
`referer`	string	Referring URL
`region`	string	Region or state from geolocation
`remote_host`	string	Remote host name
`source`	string	Source of the page hit
`source_id`	int	ID of the source item
`tracking_id`	string	Tracking identifier
`url`	string	Full URL visited
`url_title`	string	Title of the visited page
`user_agent`	string	User agent string

`page_redirects`

Redirect URL hit tracking.

- Column
  - Type
  - Description
- - checked_out
  - datetime
  - 用户检出重定向以进行编辑的日期和时间。
- - checked_out_by
  - int
  - 检出重定向用户的 ID。
- - checked_out_by_user
  - string
  - 检出重定向用户的姓名。
- - created_by
  - int
  - 创建重定向用户的 ID。
- - created_by_user
  - string
  - 创建重定向用户的姓名。
- - date_added
  - datetime
  - 用户创建重定向的日期和时间。
- - date_modified
  - datetime
  - 用户上次修改重定向的日期和时间。
- - hits
  - int
  - 总访问次数。
- - id
  - int
  - 主键。
- - is_published
  - boolean
  - 发布状态 - 1 或 true 启用重定向。
- - modified_by
  - int
  - 上次修改重定向用户的 ID。
- - modified_by_user
  - string
  - 上次修改重定向用户的姓名。
- - redirect_id
  - string
  - 唯一重定向标识符。
- - unique_hits
  - int
  - 独立访问次数。
- - url
  - string
  - 重定向的目标 URL。

`video_hits`

视频观看分析。

- Column
  - Type
  - Description
- - browser_languages
  - string
  - 浏览器语言偏好设置
- - channel
  - string
  - 通信渠道
- - channel_id
  - int
  - 渠道项的 ID
- - city
  - string
  - 来自地理位置的城市
- - code
  - string
  - HTTP 响应代码
- - country
  - string
  - 来自地理位置的国家
- - date_hit
  - datetime
  - 联系人访问视频的日期和时间
- - date_left
  - datetime
  - 观众离开的日期和时间
- - duration
  - int
  - 视频的总时长，单位为秒
- - guid
  - string
  - 视频的全局唯一标识符
- - id
  - int
  - 主键
- - ip_id
  - int
  - IP 地址的 ID
- - isp
  - string
  - 互联网服务提供商
- - lead_id
  - int
  - 联系人的 ID
- - organization
  - string
  - 来自 IP 查询的组织
- - page_language
  - string
  - 包含视频的页面的语言
- - query
  - string
  - URL 中的查询字符串
- - referer
  - string
  - 引用 URL
- - region
  - string
  - 来自地理位置的区域或州
- - remote_host
  - string
  - 远程主机名
- - time_watched
  - int
  - 观看视频的时间，单位为秒
- - url
  - string
  - 视频的 URL
- - user_agent
  - string
  - 用户代理字符串

`channel_url_trackables`

跨渠道 URL 跟踪。

Column	Type	Description
`channel`	string	通信渠道
`channel_id`	int	渠道项的 ID
`hits`	int	总访问次数
`redirect_id`	int	重定向的 ID
`unique_hits`	int	唯一访问次数

点统计

Table	Description
`point_lead_action_log`	点操作的执行日志
`point_lead_event_log`	点触发器事件的执行日志

`point_lead_action_log`

点操作的执行日志。

Column	Type	Description
`date_fired`	datetime	Mautic 执行点操作的日期和时间
`ip_id`	int	IP 地址的 ID
`lead_id`	int	联系人的 ID
`point_id`	int	点操作的 ID

`point_lead_event_log`

点触发器事件的执行日志。

- Column
  - Type
  - Description
- - date_fired
  - datetime
  - Mautic 执行 Point Trigger 事件的日期和时间
- - event_id
  - int
  - Point Trigger 事件的 ID
- - ip_id
  - int
  - IP 地址的 ID
- - lead_id
  - int
  - 联系人的 ID

Stage 统计信息

Table	Description
`stage_lead_action_log`	Stage 分配日志

`stage_lead_action_log`

Stage 分配日志。

Column	Type	Description
`date_fired`	datetime	Mautic 分配 Stage 的日期和时间
`ip_id`	int	IP 地址的 ID
`lead_id`	int	联系人的 ID
`stage_id`	int	Stage 的 ID

Dynamic Content 统计信息

Table	Description
`dynamic_content_stats`	Dynamic Content 显示统计信息
`dynamic_content_lead_data`	联系人级别的 Dynamic Content 交互数据

`dynamic_content_stats`

Dynamic Content 显示统计信息。

Column	Type	Description
`date_sent`	datetime	Mautic 首次发送 Dynamic Content 的日期和时间
`dynamic_content_id`	int	Dynamic Content 项的 ID
`id`	int	主键
`last_sent`	datetime	Mautic 最后发送 Dynamic Content 的日期和时间
`lead_id`	int	联系人的 ID
`sent_count`	int	Mautic 发送 Dynamic Content 的次数
`sent_details`	string	关于 Dynamic Content 发送的详细信息，以 JSON 格式存储
`source`	string	Dynamic Content 显示的来源
`source_id`	int	来源项的 ID
`tokens`	string	在 JSON 格式中使用的令牌值

`dynamic_content_lead_data`

联系人级别的 Dynamic Content 交互数据。

Column	Type	Description
`date_added`	datetime	Mautic 记录交互的日期和时间
`dynamic_content_id`	int	Dynamic Content 项的 ID
`id`	int	主键
`lead_id`	int	联系人的 ID
`slot`	string	Mautic 显示 Dynamic Content 的槽名称

Notification 统计信息

Table	Description
`push_notification_stats`	Push Notification 的发送和参与度

`push_notification_stats`

推送通知的发送和参与度统计。

Column	Type	Description
`click_count`	int	联系人点击通知的次数
`click_details`	string	关于点击的详细信息，以 JSON 格式存储
`date_clicked`	datetime	联系人首次点击通知的日期和时间
`date_read`	datetime	联系人阅读通知的日期和时间
`date_sent`	datetime	Mautic 发送通知的日期和时间
`id`	int	主键
`ip_id`	int	IP 地址的 ID
`is_clicked`	boolean	点击状态 - `1` 或 `true` 表示联系人点击了通知
`last_clicked`	datetime	联系人最后一次点击通知的日期和时间
`lead_id`	int	联系人的 ID
`list_id`	int	接收通知的分组的 ID
`notification_id`	int	推送通知的 ID
`retry_count`	int	发送重试次数
`source`	string	通知发送的来源
`source_id`	int	来源项的 ID
`tokens`	string	用于 JSON 格式的令牌值
`tracking_hash`	string	用于跟踪此通知发送的唯一哈希值

短信统计

Table	Description
`sms_message_stats`	短信发送统计信息

`sms_message_stats`

短信发送统计信息。

Column	Type	Description
`date_sent`	datetime	Mautic 发送短信的日期和时间
`id`	int	主键
`ip_id`	int	IP 地址的 ID
`lead_id`	int	联系人的 ID
`list_id`	int	接收短信的分组的 ID
`sms_id`	int	短信消息的 ID
`source`	string	短信发送的来源
`source_id`	int	来源项的 ID
`tokens`	string	用于 JSON 格式的令牌值
`tracking_hash`	string	用于跟踪此短信发送的唯一哈希值

系统统计

Table	Description
`audit_log`	用户操作的系统范围审计记录
`ip_addresses`	包含地理位置数据的 IP 地址注册表
`webhook_logs`	Webhook 执行日志

`audit_log`

用户操作的系统范围审计记录。

Column	Type	Description
`action`	string	系统执行的操作
`bundle`	string	触发该操作的 Mautic bundle
`date_added`	datetime	操作的时间和日期
`details`	string	关于该操作的附加详细信息，以 JSON 格式存储
`id`	int	主键
`ip_address`	string	执行操作用户的 IP 地址
`object`	string	用户执行的操作所影响的对象类型
`object_id`	int	受影响对象的 ID
`user_id`	int	执行操作用户的 ID
`user_name`	string	执行操作用户的姓名

`ip_addresses`

包含地理位置数据的 IP 地址注册表。

Column	Type	Description
`id`	int	主键
`ip_address`	string	IP 地址
`ip_details`	string	地理位置和其他详细信息，以 JSON 格式存储

`webhook_logs`

Webhook 执行日志。

Column	Type	Description
`date_added`	datetime	Mautic 执行 webhook 的时间和日期
`id`	int	主键
`note`	string	关于 webhook 执行的备注
`runtime`	float	执行时间，以秒为单位
`status_code`	int	HTTP 响应状态码
`webhook_id`	int	Webhook 的 ID

使用 Mautic API 库

获取统计表

HTTP 请求

响应

Stats properties

Get stats from a table

HTTP request

Query parameters

The expr parameter in $where arrays

Response

Stats from a table properties

cURL example

Available tables

Contact statistics

companies_leads

lead_categories

lead_companies_change_log

lead_devices

lead_donotcontact

lead_event_log

lead_frequencyrules

lead_lists_leads

lead_points_change_log

lead_stages_change_log

lead_utmtags

Asset statistics

asset_downloads

活动统计信息

campaign_leads

campaign_lead_event_log