Calculated Values
Contents
Overview
Calculated Values execute an arbitrary expression to generate a custom value for inclusion in CSV exports, CRM integrations and search filters and results.
Expressions are written in Common Expression Language. CEL expressions can be tricky to write so don't hesitate to ask for help.
Note: Calculated Values are only available on the Enterprise plan.
Creating a Calculated Value
To create a Calculated Value, go to the Calculated Value page and click the Add New Calculated Value button. You'll need to provide the follow fields to define the Calculated Value and then click the Save button:
- Name: The name of the calculated value.
- Search Filter: Enable the checkbox to use the Calculated Value as a filter within Store Leads search.
- Expression: The expression that is evaluated against every domain. See some example expressions below.

Since expressions can be tricky to write, it helps to test the expression against a sample domain. To do so, simply click the Test Expression button.
Calculated Values in Search Results
To include Calculated Values in search results, click on the Calculated Values tab in the search result column picker. Then open the Calculated Values section and select the columns to include in search results.

Calculated Values as Search Filters
If the Search Filter option is enabled, the Calculated Value can be used as a filter for search results. Search filters are calculated nightly so you may have to wait up to 24 hours for the filter to become available. Depending on the expression, the filter may be available in Basic Search, Advanced Search or both.

Note: Using calculated values as a search filter is only available on the Enterprise plan.
Calculated Values in CSV Exports
To include Calculated Values in CSV exports, click on the Calculated Values tab in the Export dialog. Click the Add New Column button to add a one-time expression to the CSV export. Otherwise, you can address an expression in a saved Calculated Value.

Calculated Values in CRM Integrations
Calculated Values can also be used to write custom values to CRM Integrations. For more details, refer to our documentation for your CRM:
Example Expressions
Count the number of installed technologies:
has(_domain.technologies) ? _domain.technologies.size() : 0
Count the number of installed apps:
has(_domain.apps) ? _domain.apps.size() : 0
Count the number of technologies installed in the last 14 days:
has(_domain.technology_details) ? _domain.technology_details.filter(k, now - _domain.technology_details[k].installed_at < duration("336h") ).size() : 0
Count the number of apps installed in the last 14 days:
has(_domain.app_details) ? _domain.app_details.filter(k, now - _domain.app_details[k].installed_at < duration("336h") ).size() : 0
Determine whether a specific technology is installed:
has(_domain.technologies) ? _domain.technologies.contains('Affirm') : false
Filter list of technologies to only include specific technologies of interest (output as a comma-separated string):
has(_domain.technologies) ? _domain.technologies.filter(s, s in ['Collabstr', 'CreatorIQ'] ).join(',') : ''
Generate a list of unique apps and technologies installed on the domain.
Update: can now use the new app_and_tech_details attribute (see below).
( (has(_domain.technologies) ? _domain.technologies : []) + (has(_domain.app_details) ? _domain.app_details.map(k, has(_domain.app_details[k].technology) ? _domain.app_details[k].technology : _domain.app_details[k].name ) : []) ).unique().sort().join(',')
Generate a list of unique apps and technologies installed on the domain along with their install date.
(has(_domain.app_and_tech_details) ? _domain.app_and_tech_details.map(k, has(_domain.app_and_tech_details[k].installed_at) ? _domain.app_and_tech_details[k].name + "," + _domain.app_and_tech_details[k].installed_at.format("2006/01/02") : _domain.app_and_tech_details[k].name + ",unknown" ) : [] ).join(',')
Retrieving the name of the most-recently installed app or technology.
has(_domain.app_and_tech_details) && _domain.app_and_tech_details.size() > 0 ? _domain.app_and_tech_details.sort_by_installed_at("desc")[0].name : ''
Listing the titles of the 3 most recently published products.
_domain.product_search({"page_size": 3, "s": "published_at_unix"}).products.map(p, p.title)
Listing the titles of up to 3 products matching a search for "shoes" order by most recently published products.
_domain.product_search({"q": "shoes", "page_size": 3, "s": "published_at_unix"}).products.map(p, p.title)
Show the list (and count) of vendor attributes across all products sold at the store.
_domain.product_search({"fl": "vendor"}).aggregations.vendor.buckets
Available Attributes
The following attributes are available for use within expressions. Please get in touch if you need access to additional attributes within expressions.
{ "_domain": { "about_us_page_url": "https://www.khy.com/pages/about-us", "administrative_area_level_1": "California", "aliases": [ "ccdc23.myshopify.com" ], "alternates": null, "app_and_tech_details": { "AMP ‑ Back in Stock": { "all_names": [ "AMP ‑ Back in Stock", "Back in Stock: Restock Alerts", "AMP | Back in Stock" ], "categories": [ "stock alerts", "email marketing" ], "installed_at": "2023-11-22T12:26:00Z", "installed_at_sfdc": "2023-11-22T12:26:00+00:00", "name": "AMP ‑ Back in Stock", "platform": "shopify", "platform_install_rank": 71 }, "Accessibly": { "all_names": [ "Accessibly" ], "categories": [ "accessibility" ], "installed_at": "2024-04-11T17:38:16Z", "installed_at_sfdc": "2024-04-11T17:38:16+00:00", "name": "Accessibly", "platform": "shopify", "platform_install_rank": 167 }, "Afterpay": { "all_names": [ "Afterpay" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Afterpay" }, "Apple Pay": { "all_names": [ "Apple Pay" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Apple Pay" }, "Arrive": { "all_names": [ "Arrive" ], "installed_at": "2024-02-15T04:15:31Z", "installed_at_sfdc": "2024-02-15T04:15:31+00:00", "name": "Arrive" }, "Attentive": { "all_names": [ "Attentive" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Attentive", "uninstalled_at": "2024-01-24T01:42:00Z", "uninstalled_at_sfdc": "2024-01-24T01:42:00+00:00" }, "Baazarvoice": { "all_names": [ "Baazarvoice" ], "categories": [ "product reviews", "social trust - other" ], "installed_at": "2024-05-15T06:30:14Z", "installed_at_sfdc": "2024-05-15T06:30:14+00:00", "name": "Baazarvoice", "shopify_app": { "all_names": [ "Bazaarvoice Reviews \u0026 Photos", "Baazarvoice" ], "categories": [ "product reviews", "social trust - other" ], "installed_at": "2024-05-15T06:30:14Z", "installed_at_sfdc": "2024-05-15T06:30:14+00:00", "name": "Bazaarvoice Reviews \u0026 Photos", "platform": "shopify", "platform_install_rank": 609, "technology": "Baazarvoice" } }, "Cloudflare": { "all_names": [ "Cloudflare" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Cloudflare" }, "Cloudflare CDN": { "all_names": [ "Cloudflare CDN" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Cloudflare CDN" }, "Elevar": { "all_names": [ "Elevar" ], "installed_at": "2024-10-30T18:26:56Z", "installed_at_sfdc": "2024-10-30T18:26:56+00:00", "name": "Elevar" }, "Elevar Conversion Tracking": { "all_names": [ "Elevar Conversion Tracking" ], "categories": [ "ads", "analytics" ], "installed_at": "2024-10-30T18:26:56Z", "installed_at_sfdc": "2024-10-30T18:26:56+00:00", "name": "Elevar Conversion Tracking", "platform": "shopify", "platform_install_rank": 225 }, "Facebook Pixel": { "all_names": [ "Facebook Pixel" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Facebook Pixel", "uninstalled_at": "2024-07-02T01:09:11Z", "uninstalled_at_sfdc": "2024-07-02T01:09:11+00:00" }, "Geolocation": { "all_names": [ "Geolocation" ], "categories": [ "internationalization - other" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Geolocation", "platform": "shopify", "platform_install_rank": 5 }, "Giftnote Gift Messages \u0026 Cards": { "all_names": [ "Giftnote Gift Messages \u0026 Cards" ], "categories": [ "gift wrap and messages", "gift cards" ], "installed_at": "2025-03-02T12:57:38Z", "installed_at_sfdc": "2025-03-02T12:57:38+00:00", "name": "Giftnote Gift Messages \u0026 Cards", "platform": "shopify", "platform_install_rank": 1611 }, "Global-e": { "all_names": [ "Global-e" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Global-e" }, "Google Ads Pixel": { "all_names": [ "Google Ads Pixel" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Google Ads Pixel" }, "Google Adsense": { "all_names": [ "Google Adsense" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Google Adsense" }, "Google Pay": { "all_names": [ "Google Pay" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Google Pay" }, "Google Tag Manager": { "all_names": [ "Google Tag Manager" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Google Tag Manager" }, "Gorgias": { "all_names": [ "Gorgias" ], "categories": [ "chat", "helpdesk" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Gorgias", "shopify_app": { "all_names": [ "Gorgias: Helpdesk", " Chat \u0026 FAQ", "Gorgias: Helpdesk, Chat \u0026 FAQ", "Gorgias" ], "categories": [ "chat", "helpdesk" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Gorgias: Helpdesk, Chat \u0026 FAQ", "platform": "shopify", "platform_install_rank": 95, "technology": "Gorgias" } }, "Instafeed ‑ Instagram Feed": { "all_names": [ "Instafeed ‑ Instagram Feed" ], "categories": [ "social proof", "image gallery" ], "installed_at": "2024-11-27T12:09:31Z", "installed_at_sfdc": "2024-11-27T12:09:31+00:00", "name": "Instafeed ‑ Instagram Feed", "platform": "shopify", "platform_install_rank": 6 }, "Klarna": { "all_names": [ "Klarna" ], "categories": [ "banners", "advertising - other" ], "installed_at": "2024-11-27T12:09:31Z", "installed_at_sfdc": "2024-11-27T12:09:31+00:00", "name": "Klarna", "shopify_app": { "all_names": [ "Klarna On‑Site Messaging", "Klarna" ], "categories": [ "banners", "advertising - other" ], "installed_at": "2024-11-27T12:09:31Z", "installed_at_sfdc": "2024-11-27T12:09:31+00:00", "name": "Klarna On‑Site Messaging", "platform": "shopify", "platform_install_rank": 7, "technology": "Klarna" } }, "Klaviyo": { "all_names": [ "Klaviyo" ], "categories": [ "email marketing", "sms marketing" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Klaviyo", "shopify_app": { "all_names": [ "Klaviyo: Email Marketing \u0026 SMS", "Klaviyo" ], "categories": [ "email marketing", "sms marketing" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Klaviyo: Email Marketing \u0026 SMS", "platform": "shopify", "platform_install_rank": 3, "technology": "Klaviyo" } }, "Klaviyo Reviews": { "all_names": [ "Klaviyo Reviews" ], "categories": [ "product reviews" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Klaviyo Reviews", "platform": "shopify", "platform_install_rank": 205, "uninstalled_at": "2023-11-14T16:14:49Z", "uninstalled_at_sfdc": "2023-11-14T16:14:49+00:00" }, "Locksmith": { "all_names": [ "Locksmith" ], "categories": [ "accounts and login" ], "installed_at": "2024-10-16T23:36:14Z", "installed_at_sfdc": "2024-10-16T23:36:14+00:00", "name": "Locksmith", "platform": "shopify", "platform_install_rank": 118, "uninstalled_at": "2024-11-27T12:09:31Z", "uninstalled_at_sfdc": "2024-11-27T12:09:31+00:00" }, "Microsoft Clarity": { "all_names": [ "Microsoft Clarity" ], "installed_at": "2025-03-16T14:06:35Z", "installed_at_sfdc": "2025-03-16T14:06:35+00:00", "name": "Microsoft Clarity" }, "NoFraud": { "all_names": [ "NoFraud" ], "categories": [ "fraud" ], "installed_at": "2025-03-23T13:11:41Z", "installed_at_sfdc": "2025-03-23T13:11:41+00:00", "name": "NoFraud", "shopify_app": { "all_names": [ "NoFraud Fraud Protection", "NoFraud" ], "categories": [ "fraud" ], "installed_at": "2025-03-23T13:11:41Z", "installed_at_sfdc": "2025-03-23T13:11:41+00:00", "name": "NoFraud Fraud Protection", "platform": "shopify", "platform_install_rank": 260, "technology": "NoFraud" } }, "Okendo": { "all_names": [ "Okendo" ], "categories": [ "product reviews", "loyalty and rewards" ], "installed_at": "2024-04-19T03:37:05Z", "installed_at_sfdc": "2024-04-19T03:37:05+00:00", "name": "Okendo", "shopify_app": { "all_names": [ "Okendo: Reviews \u0026 Loyalty", "Okendo: Product Reviews \u0026 UGC", "Okendo" ], "categories": [ "product reviews", "loyalty and rewards" ], "installed_at": "2024-04-19T03:37:05Z", "installed_at_sfdc": "2024-04-19T03:37:05+00:00", "name": "Okendo: Reviews \u0026 Loyalty", "platform": "shopify", "platform_install_rank": 119, "technology": "Okendo" } }, "OneTrust Cookie Consent": { "all_names": [ "OneTrust Cookie Consent" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "OneTrust Cookie Consent", "uninstalled_at": "2024-05-15T06:30:14Z", "uninstalled_at_sfdc": "2024-05-15T06:30:14+00:00" }, "Optoro": { "all_names": [ "Optoro" ], "categories": [ "returns and exchanges", "orders - other" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Optoro", "shopify_app": { "all_names": [ "Optoro Returns \u0026 Exchanges", "Optoro" ], "categories": [ "returns and exchanges", "orders - other" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Optoro Returns \u0026 Exchanges", "platform": "shopify", "platform_install_rank": 3717, "technology": "Optoro" } }, "PayPal": { "all_names": [ "PayPal" ], "installed_at": "2024-08-05T12:41:05Z", "installed_at_sfdc": "2024-08-05T12:41:05+00:00", "name": "PayPal", "uninstalled_at": "2024-10-03T10:13:00Z", "uninstalled_at_sfdc": "2024-10-03T10:13:00+00:00" }, "PayPal Express Checkout": { "all_names": [ "PayPal Express Checkout" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "PayPal Express Checkout" }, "Route": { "all_names": [ "Route" ], "categories": [ "order tracking", "warranties and insurance" ], "installed_at": "2024-10-10T01:20:58Z", "installed_at_sfdc": "2024-10-10T01:20:58+00:00", "name": "Route", "shopify_app": { "all_names": [ "Route Protection and Tracking", "Route: Post‑Purchase Platform", "Route" ], "categories": [ "order tracking", "warranties and insurance" ], "installed_at": "2024-10-10T01:20:58Z", "installed_at_sfdc": "2024-10-10T01:20:58+00:00", "name": "Route Protection and Tracking", "platform": "shopify", "platform_install_rank": 141, "technology": "Route" } }, "Shop Pay": { "all_names": [ "Shop Pay" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Shop Pay" }, "Shopify Checkout Blocks": { "all_names": [ "Shopify Checkout Blocks", "Checkout Blocks" ], "categories": [ "checkout - other", "discounts" ], "installed_at": "2024-08-19T16:17:22Z", "installed_at_sfdc": "2024-08-19T16:17:22+00:00", "name": "Shopify Checkout Blocks", "platform": "shopify", "platform_install_rank": 153 }, "Shopify Fulfillment Network": { "all_names": [ "Shopify Fulfillment Network" ], "categories": [ "outsourced fulfillment", "fulfilling orders - other" ], "installed_at": "2023-11-22T12:26:00Z", "installed_at_sfdc": "2023-11-22T12:26:00+00:00", "name": "Shopify Fulfillment Network", "shopify_app": { "all_names": [ "Shopify Fulfillment Network" ], "categories": [ "outsourced fulfillment", "fulfilling orders - other" ], "installed_at": "2023-11-22T12:26:00Z", "installed_at_sfdc": "2023-11-22T12:26:00+00:00", "name": "Shopify Fulfillment Network", "platform": "shopify", "platform_install_rank": 2753, "technology": "Shopify Fulfillment Network", "uninstalled_at": "2023-12-12T14:25:05Z", "uninstalled_at_sfdc": "2023-12-12T14:25:05+00:00" }, "uninstalled_at": "2023-12-12T14:25:05Z", "uninstalled_at_sfdc": "2023-12-12T14:25:05+00:00" }, "Shopify Privacy \u0026 Compliance": { "all_names": [ "Shopify Privacy \u0026 Compliance" ], "categories": [ "privacy", "banners" ], "installed_at": "2024-05-15T06:30:14Z", "installed_at_sfdc": "2024-05-15T06:30:14+00:00", "name": "Shopify Privacy \u0026 Compliance", "platform": "shopify", "platform_install_rank": 135, "uninstalled_at": "2024-07-02T01:09:11Z", "uninstalled_at_sfdc": "2024-07-02T01:09:11+00:00" }, "TikTok Pixel": { "all_names": [ "TikTok Pixel" ], "installed_at": "2024-11-13T17:19:33Z", "installed_at_sfdc": "2024-11-13T17:19:33+00:00", "name": "TikTok Pixel" }, "Triple Whale": { "all_names": [ "Triple Whale" ], "categories": [ "analytics" ], "installed_at": "2024-07-29T19:28:55Z", "installed_at_sfdc": "2024-07-29T19:28:55+00:00", "name": "Triple Whale", "shopify_app": { "all_names": [ "Triple Whale Analytics", "Triple Whale" ], "categories": [ "analytics" ], "installed_at": "2024-07-29T19:28:55Z", "installed_at_sfdc": "2024-07-29T19:28:55+00:00", "name": "Triple Whale Analytics", "platform": "shopify", "platform_install_rank": 72, "technology": "Triple Whale" } }, "Unlimited Bundles \u0026 Discounts": { "all_names": [ "Unlimited Bundles \u0026 Discounts", "Revy Unlimit Bundles Discounts" ], "categories": [ "discounts", "product bundles" ], "installed_at": "2024-11-27T12:09:31Z", "installed_at_sfdc": "2024-11-27T12:09:31+00:00", "name": "Unlimited Bundles \u0026 Discounts", "platform": "shopify", "platform_install_rank": 115, "uninstalled_at": "2025-03-02T12:57:38Z", "uninstalled_at_sfdc": "2025-03-02T12:57:38+00:00" }, "Vimeo": { "all_names": [ "Vimeo" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Vimeo", "uninstalled_at": "2024-03-08T21:08:51Z", "uninstalled_at_sfdc": "2024-03-08T21:08:51+00:00" }, "YouTube Player": { "all_names": [ "YouTube Player" ], "installed_at": "2023-11-22T12:26:00Z", "installed_at_sfdc": "2023-11-22T12:26:00+00:00", "name": "YouTube Player", "uninstalled_at": "2024-01-02T23:29:17Z", "uninstalled_at_sfdc": "2024-01-02T23:29:17+00:00" } }, "app_details": { "1.accessibly-app": { "all_names": [ "Accessibly" ], "categories": [ "accessibility" ], "installed_at": "2024-04-11T17:38:16Z", "installed_at_sfdc": "2024-04-11T17:38:16+00:00", "name": "Accessibly", "platform": "shopify", "platform_install_rank": 167 }, "1.back-in-stock": { "all_names": [ "AMP ‑ Back in Stock", "Back in Stock: Restock Alerts", "AMP | Back in Stock" ], "categories": [ "stock alerts", "email marketing" ], "installed_at": "2023-11-22T12:26:00Z", "installed_at_sfdc": "2023-11-22T12:26:00+00:00", "name": "AMP ‑ Back in Stock", "platform": "shopify", "platform_install_rank": 71 }, "1.bazaarvoice-reviews-photos-social": { "all_names": [ "Bazaarvoice Reviews \u0026 Photos", "Baazarvoice" ], "categories": [ "product reviews", "social trust - other" ], "installed_at": "2024-05-15T06:30:14Z", "installed_at_sfdc": "2024-05-15T06:30:14+00:00", "name": "Bazaarvoice Reviews \u0026 Photos", "platform": "shopify", "platform_install_rank": 609, "technology": "Baazarvoice" }, "1.checkout-blocks": { "all_names": [ "Shopify Checkout Blocks", "Checkout Blocks" ], "categories": [ "checkout - other", "discounts" ], "installed_at": "2024-08-19T16:17:22Z", "installed_at_sfdc": "2024-08-19T16:17:22+00:00", "name": "Shopify Checkout Blocks", "platform": "shopify", "platform_install_rank": 153 }, "1.customer-privacy-banner": { "all_names": [ "Shopify Privacy \u0026 Compliance" ], "categories": [ "privacy", "banners" ], "installed_at": "2024-05-15T06:30:14Z", "installed_at_sfdc": "2024-05-15T06:30:14+00:00", "name": "Shopify Privacy \u0026 Compliance", "platform": "shopify", "platform_install_rank": 135, "uninstalled_at": "2024-07-02T01:09:11Z", "uninstalled_at_sfdc": "2024-07-02T01:09:11+00:00" }, "1.geolocation": { "all_names": [ "Geolocation" ], "categories": [ "internationalization - other" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Geolocation", "platform": "shopify", "platform_install_rank": 5 }, "1.giftnote": { "all_names": [ "Giftnote Gift Messages \u0026 Cards" ], "categories": [ "gift wrap and messages", "gift cards" ], "installed_at": "2025-03-02T12:57:38Z", "installed_at_sfdc": "2025-03-02T12:57:38+00:00", "name": "Giftnote Gift Messages \u0026 Cards", "platform": "shopify", "platform_install_rank": 1611 }, "1.gtm-datalayer-by-elevar": { "all_names": [ "Elevar Conversion Tracking" ], "categories": [ "ads", "analytics" ], "installed_at": "2024-10-30T18:26:56Z", "installed_at_sfdc": "2024-10-30T18:26:56+00:00", "name": "Elevar Conversion Tracking", "platform": "shopify", "platform_install_rank": 225 }, "1.helpdesk": { "all_names": [ "Gorgias: Helpdesk", " Chat \u0026 FAQ", "Gorgias: Helpdesk, Chat \u0026 FAQ", "Gorgias" ], "categories": [ "chat", "helpdesk" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Gorgias: Helpdesk, Chat \u0026 FAQ", "platform": "shopify", "platform_install_rank": 95, "technology": "Gorgias" }, "1.instafeed": { "all_names": [ "Instafeed ‑ Instagram Feed" ], "categories": [ "social proof", "image gallery" ], "installed_at": "2024-11-27T12:09:31Z", "installed_at_sfdc": "2024-11-27T12:09:31+00:00", "name": "Instafeed ‑ Instagram Feed", "platform": "shopify", "platform_install_rank": 6 }, "1.klarna-on-site-messaging": { "all_names": [ "Klarna On‑Site Messaging", "Klarna" ], "categories": [ "banners", "advertising - other" ], "installed_at": "2024-11-27T12:09:31Z", "installed_at_sfdc": "2024-11-27T12:09:31+00:00", "name": "Klarna On‑Site Messaging", "platform": "shopify", "platform_install_rank": 7, "technology": "Klarna" }, "1.klaviyo-email-marketing": { "all_names": [ "Klaviyo: Email Marketing \u0026 SMS", "Klaviyo" ], "categories": [ "email marketing", "sms marketing" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Klaviyo: Email Marketing \u0026 SMS", "platform": "shopify", "platform_install_rank": 3, "technology": "Klaviyo" }, "1.klaviyo-reviews": { "all_names": [ "Klaviyo Reviews" ], "categories": [ "product reviews" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Klaviyo Reviews", "platform": "shopify", "platform_install_rank": 205, "uninstalled_at": "2023-11-14T16:14:49Z", "uninstalled_at_sfdc": "2023-11-14T16:14:49+00:00" }, "1.locksmith": { "all_names": [ "Locksmith" ], "categories": [ "accounts and login" ], "installed_at": "2024-10-16T23:36:14Z", "installed_at_sfdc": "2024-10-16T23:36:14+00:00", "name": "Locksmith", "platform": "shopify", "platform_install_rank": 118, "uninstalled_at": "2024-11-27T12:09:31Z", "uninstalled_at_sfdc": "2024-11-27T12:09:31+00:00" }, "1.nofraud-chargeback-prevention-and-protection": { "all_names": [ "NoFraud Fraud Protection", "NoFraud" ], "categories": [ "fraud" ], "installed_at": "2025-03-23T13:11:41Z", "installed_at_sfdc": "2025-03-23T13:11:41+00:00", "name": "NoFraud Fraud Protection", "platform": "shopify", "platform_install_rank": 260, "technology": "NoFraud" }, "1.okendo-reviews": { "all_names": [ "Okendo: Reviews \u0026 Loyalty", "Okendo: Product Reviews \u0026 UGC", "Okendo" ], "categories": [ "product reviews", "loyalty and rewards" ], "installed_at": "2024-04-19T03:37:05Z", "installed_at_sfdc": "2024-04-19T03:37:05+00:00", "name": "Okendo: Reviews \u0026 Loyalty", "platform": "shopify", "platform_install_rank": 119, "technology": "Okendo" }, "1.optoro-returns": { "all_names": [ "Optoro Returns \u0026 Exchanges", "Optoro" ], "categories": [ "returns and exchanges", "orders - other" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Optoro Returns \u0026 Exchanges", "platform": "shopify", "platform_install_rank": 3717, "technology": "Optoro" }, "1.product-bundles-discounts-by-revy": { "all_names": [ "Unlimited Bundles \u0026 Discounts", "Revy Unlimit Bundles Discounts" ], "categories": [ "discounts", "product bundles" ], "installed_at": "2024-11-27T12:09:31Z", "installed_at_sfdc": "2024-11-27T12:09:31+00:00", "name": "Unlimited Bundles \u0026 Discounts", "platform": "shopify", "platform_install_rank": 115, "uninstalled_at": "2025-03-02T12:57:38Z", "uninstalled_at_sfdc": "2025-03-02T12:57:38+00:00" }, "1.route": { "all_names": [ "Route Protection and Tracking", "Route: Post‑Purchase Platform", "Route" ], "categories": [ "order tracking", "warranties and insurance" ], "installed_at": "2024-10-10T01:20:58Z", "installed_at_sfdc": "2024-10-10T01:20:58+00:00", "name": "Route Protection and Tracking", "platform": "shopify", "platform_install_rank": 141, "technology": "Route" }, "1.shopify-fulfillment-network": { "all_names": [ "Shopify Fulfillment Network" ], "categories": [ "outsourced fulfillment", "fulfilling orders - other" ], "installed_at": "2023-11-22T12:26:00Z", "installed_at_sfdc": "2023-11-22T12:26:00+00:00", "name": "Shopify Fulfillment Network", "platform": "shopify", "platform_install_rank": 2753, "technology": "Shopify Fulfillment Network", "uninstalled_at": "2023-12-12T14:25:05Z", "uninstalled_at_sfdc": "2023-12-12T14:25:05+00:00" }, "1.triplewhale-1": { "all_names": [ "Triple Whale Analytics", "Triple Whale" ], "categories": [ "analytics" ], "installed_at": "2024-07-29T19:28:55Z", "installed_at_sfdc": "2024-07-29T19:28:55+00:00", "name": "Triple Whale Analytics", "platform": "shopify", "platform_install_rank": 72, "technology": "Triple Whale" } }, "avg_price": 8877, "avg_price_usd": 8877, "avg_weight": 564, "brand_advocate_page_url": "https://www.khy.com/pages/collaborators", "brands_page_url": "", "categories": [ "/Apparel", "/Apparel/Women's Clothing", "/Apparel/Footwear" ], "city": "Culver City", "cluster_domains": [ "www.khy.com", "khy.co.il" ], "combined_followers": 223827, "contact_info": [ { "followers": 1441, "type": "twitter", "url": "https://twitter.com/khybrand", "value": "khybrand" }, { "followers": 0, "type": "facebook", "url": "https://www.facebook.com/khybrand", "value": "khybrand" }, { "followers": 0, "type": "instagram", "url": "https://www.instagram.com/kyliejenner", "value": "kyliejenner" }, { "followers": 0, "type": "linkedin", "url": "https://www.linkedin.com/company/khy-by-kylie-jenner", "value": "khy-by-kylie-jenner" }, { "type": "phone", "value": "+1 855-626-5655" }, { "type": "email", "value": "support@khy.com" }, { "followers": 223, "type": "pinterest", "url": "https://www.pinterest.com/khybrand", "value": "khybrand" }, { "followers": 163, "type": "youtube", "url": "https://www.youtube.com/@Khybrand", "value": "khybrand" }, { "followers": 222000, "type": "tiktok", "url": "https://www.tiktok.com/@khy", "value": "@khy" } ], "contact_page_url": "https://www.khy.com/pages/contact", "copyright": "K Brand, Inc", "country_code": "US", "currency_code": "USD", "estimated_page_views": 1248967, "estimated_sales": 140940978, "estimated_visits": 339447, "faq_page_url": "https://www.khy.com/pages/faq", "features": [ "Shopify POS", "Returns Page", "Gift Messaging", "Shopify Online Store 2.0", "New Shopify Checkout (2022)", "Accepts Gift Cards", "Contact Page", "Tracking or Returns", "International Shipping", "FAQ Page", "Brand Advocate Page", "Has Blog" ], "financing_page_url": "", "id": 165987665, "klaviyo_features": [ "Email Collection", "Phone Collection", "Click-to-Text Form" ], "language_code": "en", "localization_count": 0, "localizations": null, "max_price": 50000, "merchant_name": "Khy", "min_price": 2500, "name": "www.khy.com", "pinterest_followers": 223, "plan": "Shopify Plus", "platform": "shopify", "platform_rank": 1, "postal_code": "", "product_count": 707, "products_created_30": 0, "products_created_365": 513, "products_created_90": 36, "rank": 56, "retailer_page_url": "", "returns_page_url": "https://www.khy.com/pages/returns", "shopify_app_names": [ "Accessibly", "AMP ‑ Back in Stock", "Bazaarvoice Reviews \u0026 Photos", "Shopify Checkout Blocks", "Giftnote Gift Messages \u0026 Cards", "Elevar Conversion Tracking", "Gorgias: Helpdesk, Chat \u0026 FAQ", "Instafeed ‑ Instagram Feed", "Klarna On‑Site Messaging", "Klaviyo: Email Marketing \u0026 SMS", "NoFraud Fraud Protection", "Okendo: Reviews \u0026 Loyalty", "Optoro Returns \u0026 Exchanges", "Route Protection and Tracking", "Triple Whale Analytics" ], "shopify_app_tokens": [ "accessibly-app", "back-in-stock", "bazaarvoice-reviews-photos-social", "checkout-blocks", "giftnote", "gtm-datalayer-by-elevar", "helpdesk", "instafeed", "klarna-on-site-messaging", "klaviyo-email-marketing", "nofraud-chargeback-prevention-and-protection", "okendo-reviews", "optoro-returns", "route", "triplewhale-1" ], "state": "Active", "store_locator_page_url": "", "technologies": [ "Afterpay", "Apple Pay", "Arrive", "Baazarvoice", "Cloudflare", "Cloudflare CDN", "Elevar", "Global-e", "Google Ads Pixel", "Google Adsense", "Google Pay", "Google Tag Manager", "Gorgias", "Klarna", "Klaviyo", "Microsoft Clarity", "NoFraud", "Okendo", "Optoro", "PayPal Express Checkout", "Route", "Shop Pay", "TikTok Pixel", "Triple Whale" ], "technology_details": { "Afterpay": { "all_names": [ "Afterpay" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Afterpay" }, "Apple Pay": { "all_names": [ "Apple Pay" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Apple Pay" }, "Arrive": { "all_names": [ "Arrive" ], "installed_at": "2024-02-15T04:15:31Z", "installed_at_sfdc": "2024-02-15T04:15:31+00:00", "name": "Arrive" }, "Attentive": { "all_names": [ "Attentive" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Attentive", "uninstalled_at": "2024-01-24T01:42:00Z", "uninstalled_at_sfdc": "2024-01-24T01:42:00+00:00" }, "Baazarvoice": { "all_names": [ "Baazarvoice" ], "categories": [ "product reviews", "social trust - other" ], "installed_at": "2024-05-15T06:30:14Z", "installed_at_sfdc": "2024-05-15T06:30:14+00:00", "name": "Baazarvoice", "shopify_app": { "all_names": [ "Bazaarvoice Reviews \u0026 Photos", "Baazarvoice" ], "categories": [ "product reviews", "social trust - other" ], "installed_at": "2024-05-15T06:30:14Z", "installed_at_sfdc": "2024-05-15T06:30:14+00:00", "name": "Bazaarvoice Reviews \u0026 Photos", "platform": "shopify", "platform_install_rank": 609, "technology": "Baazarvoice" } }, "Cloudflare": { "all_names": [ "Cloudflare" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Cloudflare" }, "Cloudflare CDN": { "all_names": [ "Cloudflare CDN" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Cloudflare CDN" }, "Elevar": { "all_names": [ "Elevar" ], "installed_at": "2024-10-30T18:26:56Z", "installed_at_sfdc": "2024-10-30T18:26:56+00:00", "name": "Elevar" }, "Facebook Pixel": { "all_names": [ "Facebook Pixel" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Facebook Pixel", "uninstalled_at": "2024-07-02T01:09:11Z", "uninstalled_at_sfdc": "2024-07-02T01:09:11+00:00" }, "Global-e": { "all_names": [ "Global-e" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Global-e" }, "Google Ads Pixel": { "all_names": [ "Google Ads Pixel" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Google Ads Pixel" }, "Google Adsense": { "all_names": [ "Google Adsense" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Google Adsense" }, "Google Pay": { "all_names": [ "Google Pay" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Google Pay" }, "Google Tag Manager": { "all_names": [ "Google Tag Manager" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Google Tag Manager" }, "Gorgias": { "all_names": [ "Gorgias" ], "categories": [ "chat", "helpdesk" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Gorgias", "shopify_app": { "all_names": [ "Gorgias: Helpdesk", " Chat \u0026 FAQ", "Gorgias: Helpdesk, Chat \u0026 FAQ", "Gorgias" ], "categories": [ "chat", "helpdesk" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Gorgias: Helpdesk, Chat \u0026 FAQ", "platform": "shopify", "platform_install_rank": 95, "technology": "Gorgias" } }, "Klarna": { "all_names": [ "Klarna" ], "categories": [ "banners", "advertising - other" ], "installed_at": "2024-11-27T12:09:31Z", "installed_at_sfdc": "2024-11-27T12:09:31+00:00", "name": "Klarna", "shopify_app": { "all_names": [ "Klarna On‑Site Messaging", "Klarna" ], "categories": [ "banners", "advertising - other" ], "installed_at": "2024-11-27T12:09:31Z", "installed_at_sfdc": "2024-11-27T12:09:31+00:00", "name": "Klarna On‑Site Messaging", "platform": "shopify", "platform_install_rank": 7, "technology": "Klarna" } }, "Klaviyo": { "all_names": [ "Klaviyo" ], "categories": [ "email marketing", "sms marketing" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Klaviyo", "shopify_app": { "all_names": [ "Klaviyo: Email Marketing \u0026 SMS", "Klaviyo" ], "categories": [ "email marketing", "sms marketing" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Klaviyo: Email Marketing \u0026 SMS", "platform": "shopify", "platform_install_rank": 3, "technology": "Klaviyo" } }, "Microsoft Clarity": { "all_names": [ "Microsoft Clarity" ], "installed_at": "2025-03-16T14:06:35Z", "installed_at_sfdc": "2025-03-16T14:06:35+00:00", "name": "Microsoft Clarity" }, "NoFraud": { "all_names": [ "NoFraud" ], "categories": [ "fraud" ], "installed_at": "2025-03-23T13:11:41Z", "installed_at_sfdc": "2025-03-23T13:11:41+00:00", "name": "NoFraud", "shopify_app": { "all_names": [ "NoFraud Fraud Protection", "NoFraud" ], "categories": [ "fraud" ], "installed_at": "2025-03-23T13:11:41Z", "installed_at_sfdc": "2025-03-23T13:11:41+00:00", "name": "NoFraud Fraud Protection", "platform": "shopify", "platform_install_rank": 260, "technology": "NoFraud" } }, "Okendo": { "all_names": [ "Okendo" ], "categories": [ "product reviews", "loyalty and rewards" ], "installed_at": "2024-04-19T03:37:05Z", "installed_at_sfdc": "2024-04-19T03:37:05+00:00", "name": "Okendo", "shopify_app": { "all_names": [ "Okendo: Reviews \u0026 Loyalty", "Okendo: Product Reviews \u0026 UGC", "Okendo" ], "categories": [ "product reviews", "loyalty and rewards" ], "installed_at": "2024-04-19T03:37:05Z", "installed_at_sfdc": "2024-04-19T03:37:05+00:00", "name": "Okendo: Reviews \u0026 Loyalty", "platform": "shopify", "platform_install_rank": 119, "technology": "Okendo" } }, "OneTrust Cookie Consent": { "all_names": [ "OneTrust Cookie Consent" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "OneTrust Cookie Consent", "uninstalled_at": "2024-05-15T06:30:14Z", "uninstalled_at_sfdc": "2024-05-15T06:30:14+00:00" }, "Optoro": { "all_names": [ "Optoro" ], "categories": [ "returns and exchanges", "orders - other" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Optoro", "shopify_app": { "all_names": [ "Optoro Returns \u0026 Exchanges", "Optoro" ], "categories": [ "returns and exchanges", "orders - other" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Optoro Returns \u0026 Exchanges", "platform": "shopify", "platform_install_rank": 3717, "technology": "Optoro" } }, "PayPal": { "all_names": [ "PayPal" ], "installed_at": "2024-08-05T12:41:05Z", "installed_at_sfdc": "2024-08-05T12:41:05+00:00", "name": "PayPal", "uninstalled_at": "2024-10-03T10:13:00Z", "uninstalled_at_sfdc": "2024-10-03T10:13:00+00:00" }, "PayPal Express Checkout": { "all_names": [ "PayPal Express Checkout" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "PayPal Express Checkout" }, "Route": { "all_names": [ "Route" ], "categories": [ "order tracking", "warranties and insurance" ], "installed_at": "2024-10-10T01:20:58Z", "installed_at_sfdc": "2024-10-10T01:20:58+00:00", "name": "Route", "shopify_app": { "all_names": [ "Route Protection and Tracking", "Route: Post‑Purchase Platform", "Route" ], "categories": [ "order tracking", "warranties and insurance" ], "installed_at": "2024-10-10T01:20:58Z", "installed_at_sfdc": "2024-10-10T01:20:58+00:00", "name": "Route Protection and Tracking", "platform": "shopify", "platform_install_rank": 141, "technology": "Route" } }, "Shop Pay": { "all_names": [ "Shop Pay" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Shop Pay" }, "Shopify Fulfillment Network": { "all_names": [ "Shopify Fulfillment Network" ], "categories": [ "outsourced fulfillment", "fulfilling orders - other" ], "installed_at": "2023-11-22T12:26:00Z", "installed_at_sfdc": "2023-11-22T12:26:00+00:00", "name": "Shopify Fulfillment Network", "shopify_app": { "all_names": [ "Shopify Fulfillment Network" ], "categories": [ "outsourced fulfillment", "fulfilling orders - other" ], "installed_at": "2023-11-22T12:26:00Z", "installed_at_sfdc": "2023-11-22T12:26:00+00:00", "name": "Shopify Fulfillment Network", "platform": "shopify", "platform_install_rank": 2753, "technology": "Shopify Fulfillment Network", "uninstalled_at": "2023-12-12T14:25:05Z", "uninstalled_at_sfdc": "2023-12-12T14:25:05+00:00" }, "uninstalled_at": "2023-12-12T14:25:05Z", "uninstalled_at_sfdc": "2023-12-12T14:25:05+00:00" }, "TikTok Pixel": { "all_names": [ "TikTok Pixel" ], "installed_at": "2024-11-13T17:19:33Z", "installed_at_sfdc": "2024-11-13T17:19:33+00:00", "name": "TikTok Pixel" }, "Triple Whale": { "all_names": [ "Triple Whale" ], "categories": [ "analytics" ], "installed_at": "2024-07-29T19:28:55Z", "installed_at_sfdc": "2024-07-29T19:28:55+00:00", "name": "Triple Whale", "shopify_app": { "all_names": [ "Triple Whale Analytics", "Triple Whale" ], "categories": [ "analytics" ], "installed_at": "2024-07-29T19:28:55Z", "installed_at_sfdc": "2024-07-29T19:28:55+00:00", "name": "Triple Whale Analytics", "platform": "shopify", "platform_install_rank": 72, "technology": "Triple Whale" } }, "Vimeo": { "all_names": [ "Vimeo" ], "installed_at": "2023-11-04T04:40:27Z", "installed_at_sfdc": "2023-11-04T04:40:27+00:00", "name": "Vimeo", "uninstalled_at": "2024-03-08T21:08:51Z", "uninstalled_at_sfdc": "2024-03-08T21:08:51+00:00" }, "YouTube Player": { "all_names": [ "YouTube Player" ], "installed_at": "2023-11-22T12:26:00Z", "installed_at_sfdc": "2023-11-22T12:26:00+00:00", "name": "YouTube Player", "uninstalled_at": "2024-01-02T23:29:17Z", "uninstalled_at_sfdc": "2024-01-02T23:29:17+00:00" } }, "tiktok_followers": 222000, "tracking_page_url": "", "twitter_followers": 1441, "warranty_page_url": "", "youtube_followers": 163 }, "now": "2025-03-31T11:00:05.411657126Z" }
CRM Attributes
If a CRM integration is enabled, attributes from the CRM can be referenced within calculated values.
With the Salesforce integration, Account fields are accessible under the _salesforce key. For instance:
With the HubSpot integration, Company properties are accessible under the _hubspot key. For instance:
As an example, the following expression returns true for Salesforce Accounts that have a Parent record.
has(_salesforce.ParentId)
Note: To use CRM attributes, the attributes need to be synchronized from the CRM into the Store Leads database. This process can take a few hours. As a result, it is not possible to interactively test expressions referencing CRM attributes if the CRM attribute has not yet been referenced in another expression (since the attribute has not yet been synchronized to the Store Leads database).