This page contains information about your Web Push-related data views. For more information on Open Data - Data views, see Data views overview.
Web Push campaigns
View name: web_push_campaigns_[customer_ID] (where customer_ID is your Emarsys account ID)
This view shows you all your web push campaigns, including all language versions.
| Data field | Description | Type | |
|---|---|---|---|
| internal_campaign_id | The internal campaign’s unique identifier. | integer |
|
| customer_id | The customer’s unique identifier. | integer | |
| campaign_id | The campaign’s unique identifier per customer. | integer | |
| name | The campaign’s name. | string | |
| source | The campaign’s source record. | record | |
| type | The campaign source’s type. | string | |
| id | The campaign source’s unique identifier. | integer | |
| message | The campaign message’s record. | record | |
| language | The message language. | string | |
| title | The message title. | string | |
| body | The message body. | string | |
| domain_code | The domain’s unique code. | string | |
| domain | The domain name. | string | |
| settings | The campaign settings record. | record | |
| k | The setting key. | string | |
| v | The setting value. | string | |
| segment_id | The segment’s unique identifier. | integer | |
| recipient_source_id | The numeric ID of the selected recipient source (i.e. segment ID, contact list ID). | integer | |
| data | The campaign custom data (stringified JSON). | string | |
| launched_at | The timestamp indicating when the campaign was launched. | timestamp | |
| scheduled_at | The timestamp indicating when the campaign is scheduled. | timestamp | |
| created_at | The timestamp indicating when the campaign was created. |
timestamp | |
| deleted_at | The timestamp indicating when the campaign was deleted. |
timestamp | |
| event_time | The timestamp indicating when the campaign was triggered. |
timestamp | |
| loaded_at | The timestamp indicating when the campaign was loaded into the system. |
timestamp | |
| action_buttons | The campaign’s action button record. | record | |
| k | The action button key. | string | |
| v | The action button value. | string | |
| sending_limit | The campaign’s sending limit record. | record | |
| amount | The number of messages to be sent per time unit. | integer | |
| unit | The time unit that shall be applied to the given amount of messages (minutes). | string | |
| recipient_source_type | The type of the recipient source. | string | |
| recipient_source_id | The unique identifier of the recipient source. | integer | |
| status | The campaign’s status. | string | |
Web Push sends
View name: web_push_sends_[customer_ID] (where customer_ID is your Emarsys account ID)
This view shows you all information about your web push sends.
| Data field | Description | Type | ||
|---|---|---|---|---|
| customer_id | The customer’s unique identifier. | integer | ||
| campaign_id | The campaign’s unique identifier per customer. | integer | ||
| contact_id | The contact’s unique identifier. | integer | ||
| domain_code | The domain’s unique code. | string | ||
| domain | The domain name. | string | ||
| platform | The platform type (browser type). | string | ||
| push_token | The recipient push token. | string | ||
| client_id | The client’s unique identifier. | string | ||
| event_time | The timestamp indicating when the event was triggered. |
timestamp | ||
| loaded_at | The timestamp indicating when the event was loaded into the system. |
timestamp | ||
| treatments | The record of the treatments. | record | ||
| ui | The record of the UI treatment. | record | ||
| id | The unique identifier of the web push campaign. | integer | ||
| run_id | The unique identifier of the web push campaign’s run instance. | string | ||
| ui_test | The record of the UI test treatment. | record | ||
| id | The unique identifier of the web push campaign. | integer | ||
| run_id | The unique identifier of the web push campaign’s run instance. | string | ||
| rti | The record of the Interactions treatment. | record | ||
| id | The unique identifier of the Interactions program. | string | ||
| run_id | The identifier of the Interactions program run instance. | string | ||
| ac | The record of the Automation Center treatment. | record | ||
| id | The unique identifier of the Automation Center program. | integer | ||
| run_id | The identifier of the Automation Center program run instance. | string | ||
Web Push not sends
View name: web_push_not_sends_[customer_ID] (where customer_ID is your Emarsys account ID)
This view shows you which web push messages could not be sent.
| Data field | Description | Type | ||
|---|---|---|---|---|
| customer_id | The customer’s unique identifier. | integer | ||
| campaign_id | The campaign’s unique identifier per customer. | integer | ||
| contact_id | The contact’s unique identifier. | integer | ||
| domain_code | The domain’s unique code. | string | ||
| domain | The domain name. | string | ||
| platform | The platform type (browser type). | string | ||
| push_token | The recipient push token. | string | ||
| client_id | The client’s unique identifier. | string | ||
| error | The error record. | record | ||
| reason | The error reason. | string | ||
| code | The error code (usually the HTTP response status code). | string | ||
| event_time | The timestamp indicating when the event was triggered. |
timestamp | ||
| loaded_at | The timestamp indicating when the event was loaded into the system. |
timestamp | ||
| treatments | The record of the treatments. | record | ||
| ui | The record of the UI treatment. | record | ||
| id | The unique identifier of the web push campaign. | integer | ||
| run_id | The unique identifier of the web push campaign’s run instance. | string | ||
| ui_test | The record of the UI test treatment. | record | ||
| id | The unique identifier of the web push campaign. | integer | ||
| run_id | The unique identifier of the web push campaign’s run instance. | string | ||
| rti | The record of the Interactions treatment. | record | ||
| id | The unique identifier of the Interactions program. | string | ||
| run_id | The identifier of the Interactions program run instance. | string | ||
| ac | The record of the Automation Center treatment. | record | ||
| id | The unique identifier of the Automation Center program. | integer | ||
| run_id | The identifier of the Automation Center program run instance. | string | ||
Web Push clicks
View name: web_push_clicks_[customer_ID] (where customer_ID is your Emarsys account ID)
This view shows you the actual user actions on web push.
| Data field | Description | Type | ||
|---|---|---|---|---|
| customer_id | The customer’s unique identifier. | integer | ||
| contact_id | The contact’s unique identifier. |
integer | ||
| campaign_id | The campaign’s unique identifier per customer. | integer | ||
| client_id | The client’s unique identifier. | string | ||
| domain_code | The domain’s unique code. | string | ||
| domain | The domain name. | string | ||
| sdk_version | The SDK version used by the client. | string | ||
| treatments | The record of the treatments. | record | ||
| ui | The record of the UI treatment. | record | ||
| id | The unique identifier of the web push campaign. | integer | ||
| run_id | The unique identifier of the web push campaign’s run instance. | string | ||
| ui_test | The record of the UI test treatment. | record | ||
| id | The unique identifier of the web push campaign. | integer | ||
| run_id | The unique identifier of the web push campaign’s run instance. | string | ||
| rti | The record of the Interactions treatment. | record | ||
| id | The unique identifier of the Interactions program. | string | ||
| run_id | The identifier of the Interactions program run instance. | string | ||
| ac | The record of the Automation Center treatment. | record | ||
| id | The unique identifier of the Automation Center program. | integer | ||
| run_id | The identifier of the Automation Center program run instance. | string | ||
| event_time | The timestamp indicating when the event was triggered. |
timestamp | ||
| loaded_at | The timestamp indicating when the event was loaded into the system. |
timestamp | ||
| platform | The platform type (browser type). |
string | ||
Web Push custom events
View name: web_push_custom_events_[customer_ID] (where customer_ID is your Emarsys account ID)
This view shows you all your web push custom events.
| Data field | Description | Type | |
|---|---|---|---|
| customer_id | The customer’s unique identifier. | integer | |
| contact_id | The contact’s unique identifier. | integer |
|
| client_id | The client’s unique identifier. | string | |
| domain_code | The domain’s unique code. | string |
|
| domain | The domain name. | string |
|
| event_name | The name of the custom event. | string | |
| event_attributes | The additional attributes of the event. | record | |
| k | The key of the attrbute. | string | |
| v | The value of the attribute. | string | |
| sdk_version | The SDK version used by the client. | string | |
| event_time | The timestamp indicating when the event was triggered. | timestamp | |
| loaded_at | The timestamp indicating when the event was loaded into the system. | timestamp | |
| platform | The platform type (browser type). | string | |