Advanced: Integrations data

  Before you begin

This article is only about the data fed into APSIS One from existing integrations in your account.

For information on how to set up integrations, head over to our Integrations page to learn more.

Would you like to integrate with APSIS One?

Reach out to your APSIS Account Manager to get started.

 


 

About Integrations Data

In this article, you will find detailed information about the Events and Attributes collected and stored in your APSIS One Profiles related to your integration with Magento.

Continue reading to learn more about Profile data from existing integrations, or click an item on the left navigation to jump to a specific section.

To learn more about Attributes, head over to this article, and to learn more about Events, click here.

integrations1.jpg

 


 

Magento Profile Data

Here's an overview of the data collected by Magento and fed into your APSIS One account once you've set up your integration.

Magento's Profile data is available in all activities and features that allow you to work with Profile data, like the Profile View and the Segment Builder, for example.

Magento1.jpg

 

Click on an item below to expand.

Magento Attributes

Magento Attributes

The APSIS One Magento Integration tracks the following Attributes. Read more about APSIS One's Magento integration...

Magento: Customer
  • Gender: The gender of the customer. Text value.
  • Last Review Date: The date the last review was left by the customer. The date format currently supported is Unix time.
  • Billing Address Line 1: The first line of the billing address. Text value.
  • Billing State/Region: The state or region of the billing address. Text value.
  • Billing Company: The name of the billing company. Text value.
  • Abandon Cart Token: The unique token created for abandoned carts. Text value.
  • Created At: The date the customer was created. The date format currently supported is Unix time.
  • Last Logged in Date: The date the customer last logged in. The date format currently supported is Unix time.
  • Review Count: The number of reviews created by the customer. Number value.
  • Billing Address Line 2: The second line of the billing address. Text value.
  • Billing Country: The country of the billing address. Text value.
  • Delivery City: The city of the billing address. Text value.
  • Delivery Postcode: The postcode of the delivery address. Text value.
  • Title: The honorific title of the customer (Mr, Ms, Miss, etc.). Text value.
  • Customer ID: The ID of the customer. Number value.
  • Customer Group: The customer group to which the customer belongs. Text value.
  • Billing City: The city of the billing address. Text value.
  • Billing Postcode: The postcode of the billing address. Text value.
  • Billing Telephone: The telephone number of the billing address. Number value.
  • Delivery Address 1: The first line of the delivery address. Text value.
  • Delivery State: The state of the delivery address. Text value.
  • Delivery Telephone: The telephone number of the delivery address. Number value.
  • Delivery Company: The name of the delivery company. Text value.
  • Delivery Address 2: The second line of the delivery address. Text value.
  • Delivery Country: The country of the delivery address. Text value.
Magento: Common
  • Website Name: The name of the website associated with the Customer/Subscriber's Profile. Text value.
  • Store Name: The name of the store associated with the Customer/Subscriber's Profile. Text value.
  • Store ID: The ID of the store associated with the Customer/Subscriber's Profile. Number value.
  • Website ID: The ID of the website associated with the Customer/Subscriber's Profile. Number value.
Magento: Subscriber
  • Status Change At: The date that the status was changed. The date format currently supported is Unix time.
  • Subscriber ID: The ID of the subscriber. Number value.
  • Subscriber Status: The status of the subscriber. Text value.
Magento Events

Magento Events

Events are logged into APSIS One Profiles when visitors or customers perform an action related to the stores in the Magento account integrated with APSIS One.

Read more about APSIS One's Magento integration...

Click an item below to expand.

Customer Events

Abandoned Cart

The Profile has exited the website without purchasing the items they placed in the cart. By default, integration logs the Abandoned Cart Event after 15 minutes. You can adjust this time period in the integration's settings. 

Here are the types of data associated with this Event:

Cart ID: The ID of the cart in Magento.

Customer ID: The ID of the customer in Magento.

Created at: The date the Abandon Cart Event was created. The date format currently supported is Unix time.

Website Name: This the the name of the website associated with the Event.

Grand Total Amount: Refers to the total cost of the goods left in the cart. A number with decimals.

Items Count: This is the number of items left in the cart.

Currency Code: Refers to the three letter currency code of the items left in the cart. The currency code format is currently supported by ISO-4271, "SEK" or "DKK" for example.

Abandoned Cart Product

This Event is triggered when a customer has abandoned their cart and contains data from the abandoned cart. By default, Magento logs the Abandoned Cart Event after 15 minutes. You can adjust this time period in your Magento account.

Cart ID: The ID of the cart in Magento.

Product ID: The ID of the product in Magento.

SKU: This is the Product Stock Keeping Unit, the unique alphanumeric code associated with the product.

Name: Refers to the name of the product.

Product URL: Refers to the URL of the product associated with the Event.

Product Image URL: Refers to the URL of the image of the product associated with the Event.

Qty Ordered: This is the quantity of the products left in the cart. A number with decimals.

Price Amount: Refers to the product price per unit. A number with decimals.

Row Total Amount: If the customer carted more than one piece of this product, the total price for all pieces of the product carted. A number with decimals.

Wishlist Product

This Event is triggered when a customer adds a product to their wish list.

Here are the types of data associated with this Event:

Wishlist ID: This is the ID of the wish list created in Magento.

Wishlist Item ID: This is the ID of the item located in the wish list.

Wishlist Name: Refers to the name of the wish list.

Customer ID: This is the ID of the Customer in Magento that created the wish list.

Website Name: This is the name of the website associated with the Event.

Store Name: Refers to the name of the store where the wish list has been created.

Added At: The date the product was added to the wish list. The date format currently supported is Unix time.

Product ID: This is the Product ID of the item in the wish list.

SKU: This is the Product Stock Keeping Unit, the unique alphanumeric code associated with the product.

Name: Refers to the name of the product in the wish list.

Product URL: Refers to the URL of the product associated with the Event.

Product Image URL: Refers to the URL of the image of the product associated with the Event.

Catalogue Price Amount: This is the price of the product in the catalogue. A number with decimals.

QTY: Refers to the quantity of the product added to the wish list. A number with decimals.

Currency Code: Refers to the three letter currency code of the items left in the cart. The currency code format is currently supported by ISO-4271, "SEK" or "DKK" for example.

Product Review

This Event is triggered when a customer leaves a product review and is confirmed by moderator.

Here are the types of data associated with this Event:

Review ID: This is the ID of the product review in Magento.

Customer ID: This is the ID of user in Magento who left the product review.

Created At: The date the product review was created. The date format currently supported is Unix time.

Website Name: This is the name of the website associated with the Event.

Store Name: This is the name of the store associated with the Event.

Nickname: This is the nickname selected by the customer when they leave their product review.

Review Title: This is the title of the product review.

Review Detail: Refers to the details of the product review.

Product ID: This is the ID of the product review. 

SKU: This refers to the Product Stock Keeping Unit, the unique alphanumeric code associated with the product that has been reviewed.

Name: The name of the product that has been reviewed.

Product URL: Refers to the URL of the product associated with the Event.

Product Image URL: Refers to the URL of the image of the product associated with the Event.

Product Image URL: Refers to the specific URL of the product image in the product review.

Catalogue Price Amount: This is the catalogue price of the product that has been reviewed. A number with decimals.

Rating Star Value: This refers to the number of stars the customer has given the product in the product review. The minimum star value is 1, and the maximum star value is 5.

Customer Becomes Subscriber

This Event is triggered when a customer becomes a subscriber.

Here are the types of data associated with this Event:

Subscriber ID: This is the ID of the subscriber.

Customer ID: This is the ID of the customer who has become a subscriber.

Register At: Refers to the date that the subscription was created. The date format currently supported is Unix time.

Website Name: This is the name of the website associated with the Event.

Store Name: This is the name of the store associated with the Event.

Customer Login

This Event is triggered when a customer logs in to their account.

Here are the types of data associated with this Event:

Customer ID: This is the ID of the customer who is logging into Magento. 

Login At: Refers to the date that the customer logged in. The date format currently supported is Unix time.

Last Logout At: Refers to the date that the customer last logged out. The date format currently supported is Unix time.

Last Visit At: Refers to the date that the customer last visited the website. The date format currently supported is Unix time.

Website Name: This is the name of the website associated with the Event.

Store Name: This is the name of the store associated with the Event.

 

Common Events

Order

This Event is triggered when a customer places an order.

Here are the types of data associated with this Event:

Order ID: This is the ID of the order in Magento.

Increment ID: This is the increment ID of the order in Magento.

Customer ID: This is the ID of the customer in Magento. If the order is placed by a guest subscriber, the ID will be 0.

Subscriber ID: This is the ID of the subscriber in Magento. If the order is placed by a customer, the ID will be 0.

Is Guest: A true or false, or boolean Attribute. If the order is placed by a guest, the Attribute will be true; if the order is placed by a customer who is not a guest, the Attribute will be false. The values are in lower case.

Created At: Refers to the date the order was created. The date format currently supported is Unix time.

Website Name: This is the name of the website associated with the Event.

Store Name: This is the name of the store associated with the Event.

Grand Total Amount: Refers to the grand total amount of the order placed. A number with decimals.

Shipping Amount: Refers to the cost of shipping in the order placed. A number with decimals.

Discount Amount: The amount that was discounted from the order. A number with decimals.

Shipping Method Name: This is the name of the shipping method of the order placed.

Payment Method Name: Refers to the method of payment the customer used to place the order.

Items Count: Refers to the number of products in the order.

Currency Code: Refers to the three letter currency code of the items left in the cart. The currency code format is currently supported by ISO-4271, "SEK" or "DKK" for example.

Order Product

This Event is triggered when a customer places an order, and contains information about individual product data.

Here are the types of data associated with this Event:

Order ID: This is the ID of the order in Magento.

Product ID: This is the ID of the product in Magento.

SKU: This refers to the Product Stock Keeping Unit, the unique alphanumeric code associated with the product that has been ordered.

Name: Refers to the name of the product that has been ordered.

Product URL: Refers to the URL of the product associated with the Event.

Product Image URL: Refers to the URL of the image of the product associated with the Event.

QTY Ordered: This is the quantity of the product ordered. A number with decimals.

Price Amount: Refers to the price per unit of the product ordered. A number with decimals.

Row Total Amount: If the customer carted more than one piece of this product, the total price for all pieces of the product carted. A number with decimals.

 

Subscriber Events

Subscriber Unsubscribes

This Event is triggered when a subscriber unsubscribes from Magento.

Here are the types of data associated with this Event:

Subscriber ID: This is the ID of the subscriber. 

Unsubscribe At: Refers to the date that the subscriber unsubscribed on Magento. The date format currently supported is Unix time.

Website Name: This is the name of the website associated with the Event.

Store Name: This is the name of the store associated with the Event.

Subscriber Registers as Customer

This Event is triggered when a subscriber registers as a customer.

Here are the types of data associated with this Event.

Subscriber ID: This is the ID of the subscriber who has registered as a customer. 

Customer ID: This is the ID of the customer.

Register At: Refers to the date that the subscriber registers as a customer. The date format currently supported is Unix time.

Website Name: This is the name of the website associated with the Event.

Store Name: This is the name of the store associated with the Event.

 


 

 

Was this article helpful?