![Logo Black.png]](https://help.opensend.com/hs-fs/hubfs/Logo%20Black.png?height=33&name=Logo%20Black.png){kind=small}
Understanding Opensend Reconnect Salesforce Marketing Cloud (SFMC) Metrics: Full Breakdown with Examples
Opensend Reconnect provides deep visibility into customer journeys by identifying and tracking user behavior across devices and browsers. Reconnect 2.0 sends enriched identity and commerce data to Salesforce Marketing Cloud (SFMC) as API events, enabling merchants to build powerful abandonment, reminder, and recovery journeys that integrate seamlessly with existing automation programs.
Reconnect Events in SFMC
Data Extensions
Within the Salesforce Marketing Cloud (SFMC), API Event data is stored in Data Extensions (DEs). Opensend uses two dedicated DEs to capture this information:
- Opensend Reconnect Event — stores the primary event-level data
- Opensend Reconnect Event Item — stores item-level details associated with each event, such as cart or product data
Opensend Reconnect Event
|
Name |
Type |
Length |
Nullable |
|
event_id |
Text |
255 |
No |
|
event_type |
Text |
500 |
No |
|
timestamp |
Number |
No |
|
|
cart_id |
Text |
500 |
Yes |
|
cart_url |
Text |
2048 |
Yes |
|
currency |
Text |
10 |
Yes |
|
value |
Text |
20 |
Yes |
|
page_location |
Text |
500 |
Yes |
|
page_title |
Text |
1000 |
Yes |
|
user_agent |
Text |
255 |
Yes |
|
user_ip |
Text |
30 |
Yes |
|
ref_id |
Text |
500 |
Yes |
|
|
Email Address |
254 |
Yes |
|
user_geolocation |
Text |
255 |
Yes |
|
checkout_id |
Text |
100 |
Yes |
|
checkout_url |
Text |
2048 |
Yes |
|
order_id |
Text |
100 |
Yes |
|
transaction_id |
Text |
100 |
Yes |
|
tax |
Text |
20 |
Yes |
|
discount |
Text |
20 |
Yes |
|
total_items |
Number |
Yes |
|
|
shipping |
Text |
2048 |
Yes |
|
billing |
Text |
2048 |
Yes |
Opensend Reconnect Event Item
|
Name |
Type |
Length |
Nullable |
|
id |
Text |
50 |
No |
|
event_id |
Text |
255 |
No |
|
price |
Text |
20 |
Yes |
|
item_id |
Text |
255 |
Yes |
|
quantity |
Number |
Yes |
|
|
image_url |
Text |
2048 |
Yes |
|
item_name |
Text |
500 |
Yes |
|
item_brand |
Text |
500 |
Yes |
|
item_variant |
Text |
500 |
Yes |
|
item_category |
Text |
500 |
Yes |
|
item_list |
Text |
500 |
Yes |
|
item_list2 |
Text |
500 |
Yes |
|
item_list3 |
Text |
500 |
Yes |
|
item_list4 |
Text |
500 |
Yes |
|
item_list5 |
Text |
500 |
Yes |
|
item_list6 |
Text |
500 |
Yes |
|
item_list7 |
Text |
500 |
Yes |
|
item_list8 |
Text |
500 |
Yes |
|
item_list9 |
Text |
500 |
Yes |
|
item_category2 |
Text |
500 |
Yes |
|
item_category3 |
Text |
500 |
Yes |
|
item_category4 |
Text |
500 |
Yes |
|
item_category5 |
Text |
500 |
Yes |
|
item_category6 |
Text |
500 |
Yes |
|
item_category7 |
Text |
500 |
Yes |
|
item_category8 |
Text |
500 |
Yes |
|
item_category9 |
Text |
500 |
Yes |
|
item_collection |
Text |
500 |
Yes |
|
item_collection2 |
Text |
500 |
Yes |
|
item_collection3 |
Text |
500 |
Yes |
|
item_collection4 |
Text |
500 |
Yes |
|
item_collection5 |
Text |
500 |
Yes |
|
item_collection6 |
Text |
500 |
Yes |
|
item_collection7 |
Text |
500 |
Yes |
|
item_collection8 |
Text |
500 |
Yes |
|
item_collection9 |
Text |
500 |
Yes |
|
url |
Text |
2048 |
Yes |
Supported Event Types
|
User Action |
SFMC Event Type |
|
Device/session identified |
Opensend Reconnect Device Profile Detected |
|
Viewed product |
Opensend Reconnect Viewed Product |
|
Added to cart |
Opensend Reconnect Added To Cart |
|
Started checkout |
Opensend Reconnect Started Checkout |
|
Placed order |
Opensend Reconnect Placed Order |
|
Viewed page |
Opensend Reconnect Viewed Page |
|
Viewed collection |
Opensend Reconnect Viewed Collection |
Each event contains rich metadata that powers personalization within SFMC templates and Journey flows.
-
Opensend Reconnect Device Profile Detected
What it means:
This event is triggered when a user is identified and added to the Reconnect identity pool via the Opensend integration. It enables cross-device and cross-browser tracking for both Shopify and non-Shopify clients.
Example data:
{
"event_id": "189a55f8-77b4-44c1-9dd0-f4900f43617e",
"event_type": "Opensend Reconnect Device Profile Detected",
"timestamp": "2025-12-24 10:35:31.528510",
"page_location": "https://kitty.opensend.co/products",
"page_title": "Cat Example",
"user_agent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36",
"user_ip": "212.32.50.27",
"ref_id": "",
"email": "EMAIL",
"user_geolocation": "Las Vegas, NV"
}
-
Opensend Reconnect Viewed Page
What it means:
Triggered when a page is viewed by a Reconnect-identified user. Available only for Shopify clients.
Example data:
{
"event_id": "da530920-0a4c-48bd-8a60-3dce62d79885",
"event_type": "Opensend Reconnect Viewed Page",
"timestamp": "2025-12-30 04:40:03.242302",
"page_location": "https://uvxsta-qu.myshopify.com/",
"page_title": "My Store",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36",
"user_ip": "207.244.89.161",
"ref_id": "",
"email": "EMAIL",
"user_geolocation": "Manassas, VA"
}
-
Opensend Reconnect Viewed Product
What it means:
Fired when a Reconnect-identified user views a product page. This metric is exclusive to Shopify clients.
Example data:
{
"event_id": "967499f9-97b6-420c-ab2b-d5e20be2bfa7",
"event_type": "Opensend Reconnect Viewed Product",
"timestamp": "2025-12-29 07:55:50.551333",
"cart_id": "hWN6z0UL04BgD87l0bkp6gBm?key=fa24b379cf41d48ef0ca0c9c92af8151",
"cart_url": "https://uvxsta-qu.myshopify.com/cart",
"currency": "USD",
"value": "10",
"page_location": "https://uvxsta-qu.myshopify.com/products/khanh-aldin-product?variant=45440236159164",
"page_title": "TEST PRODUCT – My Store",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36",
"user_ip": "207.244.89.162",
"ref_id": "",
"email": "EMAIL",
"user_geolocation": "Manassas, VA"
}
Associated Items in Item DE:
{
"event_id": "967499f9-97b6-420c-ab2b-d5e20be2bfa7",
"price": "10",
"item_id": "9061137449148",
"quantity": "1",
"image_url": "https://uvxsta-qu.myshopify.com/cdn/shop/files/Screenshot_1896.png?v=1763371527",
"item_name": "TEST PRODUCT",
"item_brand": "My Store",
"item_variant": "45440236159164",
"item_category": "Software",
"item_list": "Home page",
"item_category2": "Computer Software",
"item_category3": "Business & Productivity Software",
"item_category4": "Customer Relationship Management (CRM) Software",
"item_collection": "Home page",
"url": "https://uvxsta-qu.myshopify.com/products/khanh-aldin-product",
"id": "72c3163c-ee6f-4704-94db-898b68645615"
}
-
Opensend Reconnect Viewed Collection
What it means:
Triggered when a collection page is viewed by a Reconnect-identified user. Available only for Shopify clients.
Example data:
{
"event_id": "bdcfba7b-40d9-4a90-b050-ecad460a5b76",
"event_type": "Opensend Reconnect Viewed Collection",
"timestamp": "2025-12-30 04:38:14.400910",
"page_location": "https://uvxsta-qu.myshopify.com/collections/shirts",
"page_title": "Shirts – My Store",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36",
"user_ip": "207.244.89.161",
"ref_id": "",
"email": "EMAIL",
"user_geolocation": "Manassas, VA"
}
Associated Items in Item DE:
[
{
"event_id": "bdcfba7b-40d9-4a90-b050-ecad460a5b76",
"price": "50",
"item_id": "9108676411580",
"image_url": "//uvxsta-qu.myshopify.com/cdn/shop/files/short-sleeve-tshirt.webp?v=1767068653",
"item_name": "Short Sleeve T-shirt",
"item_brand": "My Store",
"item_variant": "45626216906940",
"item_category": "Apparel & Accessories",
"item_list": "Shirts",
"item_category2": "Clothing",
"item_category3": "Clothing Tops",
"item_category4": "T-Shirts",
"item_collection": "Shirts",
"url": "https://uvxsta-qu.myshopify.com/products/short-sleeve-t-shirt",
"id": "86948b0b-7406-409a-bbb3-23c13ba81085"
}
]
-
Opensend Reconnect Added to Cart
What it means:
Captured when a Reconnect user adds an item to their cart. This metric is only tracked for Shopify clients.
Example data:
{
"event_id": "9dda4680-9690-444e-8fa7-bdf6847984c9",
"event_type": "Opensend Reconnect Added to Cart",
"timestamp": "2025-12-29 08:14:49.938821",
"cart_id": "hWN6z3Fy3oxfwDRnv3Dn3CDK?key=eaa920281cee8e007fbe76e66cbb8ab9",
"cart_url": "https://uvxsta-qu.myshopify.com/cart",
"currency": "USD",
"value": "10",
"page_location": "https://uvxsta-qu.myshopify.com/products/khanh-aldin-product?variant=45440236159164",
"page_title": "TEST – My Store",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36",
"user_ip": "162.210.194.3",
"ref_id": "",
"email": "EMAIL",
"user_geolocation": "Manassas, VA"
}
Associated Items in Item DE:
{
"event_id": "9dda4680-9690-444e-8fa7-bdf6847984c9",
"price": "10",
"item_id": "9061137449148",
"quantity": "1",
"image_url": "https://cdn.shopify.com/s/files/1/0737/0424/3388/files/Screenshot_1896.png?v=1763371527",
"item_name": "TEST PRODUCT",
"item_brand": "My Store",
"item_variant": "45440236159164",
"item_category": "Software",
"item_list": "Home page",
"item_category2": "Computer Software",
"item_category3": "Business & Productivity Software",
"item_category4": "Customer Relationship Management (CRM) Software",
"item_collection": "Home page",
"url": "https://uvxsta-qu.myshopify.com/products/khanh-aldin-product?variant=45440236159164",
"id": "9d726342-479d-41c0-a21e-d7ff24469e6f"
}
-
Opensend Reconnect Started Checkout
What it means:
Logs when a user begins the checkout process. Only available for Shopify clients.
Example data:
{
"event_id": "c20cb434-a5ab-487f-ac86-bb40cbf40fb8",
"event_type": "Opensend Reconnect Started Checkout",
"timestamp": "2025-12-30 09:38:41.539995",
"cart_id": "hWN71Xe93XNy0lUEDRAUn6N0?key=196a5117bcd484233a8a0cbc2a42e062",
"currency": "USD",
"value": "110",
"page_location": "https://uvxsta-qu.myshopify.com/checkouts/cn/hWN71Xe93XNy0lUEDRAUn6N0/en-us?_r=AQAB8i01Uq_fvamzIOACk6VdyvmjnhpxkYpcUdBh7WAT",
"page_title": "Checkout - My Store",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36",
"user_ip": "207.244.89.161",
"ref_id": "",
"email": "EMAIL",
"user_geolocation": "Manassas, VA",
"checkout_id": "73736757ccf7787a64f801e5841e6104",
"checkout_url": "https://uvxsta-qu.myshopify.com/checkouts/cn/hWN71Xe93XNy0lUEDRAUn6N0/en-us?_r=AQAB8i01Uq_fvamzIOACk6VdyvmjnhpxkYpcUdBh7WAT"
}
Associated Items in Item DE:
[
{
"event_id": "c20cb434-a5ab-487f-ac86-bb40cbf40fb8",
"price": "50",
"item_id": "9108676411580",
"quantity": "2",
"image_url": "https://cdn.shopify.com/s/files/1/0737/0424/3388/files/short-sleeve-tshirt.webp?v=1767068653",
"item_name": "Short Sleeve T-shirt",
"item_brand": "My Store",
"item_variant": "45626216906940",
"item_category": "Apparel & Accessories",
"item_list": "Shirts",
"item_category2": "Clothing",
"item_category3": "Clothing Tops",
"item_category4": "T-Shirts",
"item_collection": "Shirts",
"url": "https://uvxsta-qu.myshopify.com/products/short-sleeve-t-shirt",
"id": "b7135c21-c167-4eca-b325-e37fdfae7b9b"
},
{
"event_id": "c20cb434-a5ab-487f-ac86-bb40cbf40fb8",
"price": "10",
"item_id": "9061137449148",
"quantity": "1",
"image_url": "https://cdn.shopify.com/s/files/1/0737/0424/3388/files/Screenshot_1896.png?v=1763371527",
"item_name": "KHANH ALDIN PRODUCT",
"item_brand": "My Store",
"item_variant": "45440236159164",
"item_category": "Software",
"item_list": "Home page",
"item_category2": "Computer Software",
"item_category3": "Business & Productivity Software",
"item_category4": "Customer Relationship Management (CRM) Software",
"item_collection": "Home page",
"url": "https://uvxsta-qu.myshopify.com/products/khanh-aldin-product",
"id": "8a012f72-7f87-406d-ad55-01f6fd8cb9f6"
}
]
-
Placed Order
What it means:
Triggered when a purchase is completed by a Reconnect-identified user. Available only for Shopify clients.
Example data:
{
"event_id": "553412b1-f778-48f7-8972-ed5cc09a0bde",
"event_type": "Opensend Reconnect Placed Order",
"timestamp": "2025-12-30 09:39:14.421254",
"cart_id": "hWN71Xe93XNy0lUEDRAUn6N0?key=196a5117bcd484233a8a0cbc2a42e062",
"currency": "USD",
"value": "110",
"page_location": "https://uvxsta-qu.myshopify.com/checkouts/cn/hWN71Xe93XNy0lUEDRAUn6N0/en-us/thank-you?_r=AQAB8i01Uq_fvamzIOACk6VdyvmjnhpxkYpcUdBh7WAT",
"page_title": "Thank you for your purchase! - My Store - Checkout",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36",
"user_ip": "207.244.89.161",
"ref_id": "",
"email": "EMAIL",
"user_geolocation": "Manassas, VA",
"checkout_id": "73736757ccf7787a64f801e5841e6104",
"order_id": "6211291742396",
"transaction_id": "gid://shopify/OrderTransaction/7673269780668",
"tax": "0",
"discount": "0",
"total_items": "2",
"shipping": "{\"address1\": \"2620 Regatta Dr, Suite 102\", \"address2\": null, \"city\": \"Las Vegas\", \"country\": \"US\", \"countryCode\": \"US\", \"firstName\": \"NGUYEN\", \"lastName\": \"DONG\", \"phone\": null, \"province\": \"NV\", \"provinceCode\": \"NV\", \"zip\": \"89128\"}",
"billing": "{\"address1\": \"2620 Regatta Dr, Suite 102\", \"address2\": null, \"city\": \"Las Vegas\", \"country\": \"US\", \"countryCode\": \"US\", \"firstName\": \"NGUYEN\", \"lastName\": \"DONG\", \"phone\": null, \"province\": \"NV\", \"provinceCode\": \"NV\", \"zip\": \"89128\"}"
}
Associated Items in Item DE:
[
{
"event_id": "553412b1-f778-48f7-8972-ed5cc09a0bde",
"price": "50",
"item_id": "9108676411580",
"quantity": "2",
"image_url": "https://cdn.shopify.com/s/files/1/0737/0424/3388/files/short-sleeve-tshirt.webp?v=1767068653",
"item_name": "Short Sleeve T-shirt",
"item_brand": "My Store",
"item_variant": "45626216906940",
"item_category": "Apparel & Accessories",
"item_list": "Shirts",
"item_category2": "Clothing",
"item_category3": "Clothing Tops",
"item_category4": "T-Shirts",
"item_collection": "Shirts",
"url": "https://uvxsta-qu.myshopify.com/products/short-sleeve-t-shirt",
"id": "708c09ba-afb9-4b73-9d15-85bcb9c6142c"
},
{
"event_id": "553412b1-f778-48f7-8972-ed5cc09a0bde",
"price": "10",
"item_id": "9061137449148",
"quantity": "1",
"image_url": "https://cdn.shopify.com/s/files/1/0737/0424/3388/files/Screenshot_1896.png?v=1763371527",
"item_name": "TEST PRODUCT",
"item_brand": "My Store",
"item_variant": "45440236159164",
"item_category": "Software",
"item_list": "Home page",
"item_category2": "Computer Software",
"item_category3": "Business & Productivity Software",
"item_category4": "Customer Relationship Management (CRM) Software",
"item_collection": "Home page",
"url": "https://uvxsta-qu.myshopify.com/products/khanh-aldin-product",
"id": "25d99395-f4e6-4e01-8007-12ddf6dd41a4"
}
]