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.
![Define Calculated Value](/img/help/calculated-value-form.png)
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 in Search Results](/img/product/domain-list-customize-columns-calculated-values.png)
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.
![Calculated Values as Search Filter](/img/product/domain-filter-calculated-value.png)
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 CSV Exports](/img/help/calculated-value-export.png)
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 : ''
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.fashionnova.com/pages/about-us", "administrative_area_level_1": "California", "aliases": [ "www.jutouzi.com", "www.novababe.info" ], "alternates": { "en-CL": "www.fashionnova.com", "en-MX": "www.fashionnova.com", "en-US": "www.fashionnova.com", "es-CL": "www.fashionnova.com", "es-MX": "www.fashionnova.com", "x-default": "www.fashionnova.com" }, "app_and_tech_details": { "Afterpay": { "installed_at": "2021-09-16T15:16:02Z", "installed_at_sfdc": "2021-09-16T15:16:02+00:00", "name": "Afterpay" }, "Algolia": { "installed_at": "2023-06-13T13:21:30Z", "installed_at_sfdc": "2023-06-13T13:21:30+00:00", "name": "Algolia" }, "Amazon Pay": { "name": "Amazon Pay", "uninstalled_at": "2023-10-20T21:05:54Z", "uninstalled_at_sfdc": "2023-10-20T21:05:54+00:00" }, "Apple Pay": { "installed_at": "2020-11-10T18:20:48Z", "installed_at_sfdc": "2020-11-10T18:20:48+00:00", "name": "Apple Pay" }, "Arrive": { "installed_at": "2020-11-19T07:39:35Z", "installed_at_sfdc": "2020-11-19T07:39:35+00:00", "name": "Arrive" }, "Attentive": { "installed_at": "2020-10-08T19:53:51Z", "installed_at_sfdc": "2020-10-08T19:53:51+00:00", "name": "Attentive" }, "Back in Stock: Restock Alerts": { "categories": [ "stock alerts", "email marketing" ], "name": "Back in Stock: Restock Alerts", "platform": "shopify", "uninstalled_at": "2021-02-13T04:36:22Z", "uninstalled_at_sfdc": "2021-02-13T04:36:22+00:00" }, "Bing Ads": { "installed_at": "2024-02-23T07:17:15Z", "installed_at_sfdc": "2024-02-23T07:17:15+00:00", "name": "Bing Ads" }, "Blotout": { "installed_at": "2024-02-23T07:17:15Z", "installed_at_sfdc": "2024-02-23T07:17:15+00:00", "name": "Blotout" }, "Cloudflare": { "installed_at": "2023-10-31T22:31:04Z", "installed_at_sfdc": "2023-10-31T22:31:04+00:00", "name": "Cloudflare" }, "Cloudflare CDN": { "installed_at": "2021-06-08T15:41:52Z", "installed_at_sfdc": "2021-06-08T15:41:52+00:00", "name": "Cloudflare CDN" }, "Contentful": { "installed_at": "2024-05-15T23:28:28Z", "installed_at_sfdc": "2024-05-15T23:28:28+00:00", "name": "Contentful" }, "Crazy Egg": { "categories": [ "analytics" ], "name": "Crazy Egg", "platform": "shopify", "uninstalled_at": "2023-03-14T23:48:08Z", "uninstalled_at_sfdc": "2023-03-14T23:48:08+00:00" }, "Criteo": { "installed_at": "2022-06-14T14:05:48Z", "installed_at_sfdc": "2022-06-14T14:05:48+00:00", "name": "Criteo" }, "Email Marketing ‑ Amplified": { "categories": [ "marketing", "conversion" ], "name": "Email Marketing ‑ Amplified", "platform": "shopify", "uninstalled_at": "2020-08-14T14:15:54Z", "uninstalled_at_sfdc": "2020-08-14T14:15:54+00:00" }, "Facebook Messenger Chat": { "categories": [ "chat" ], "name": "Facebook Messenger Chat", "platform": "shopify", "uninstalled_at": "2023-02-28T21:09:09Z", "uninstalled_at_sfdc": "2023-02-28T21:09:09+00:00" }, "Facebook Messenger Marketing": { "categories": [ "chat", "support - other" ], "name": "Facebook Messenger Marketing", "platform": "shopify", "uninstalled_at": "2023-03-29T19:06:55Z", "uninstalled_at_sfdc": "2023-03-29T19:06:55+00:00" }, "Facebook Pixel": { "installed_at": "2022-02-08T04:48:21Z", "installed_at_sfdc": "2022-02-08T04:48:21+00:00", "name": "Facebook Pixel" }, "Flow Commerce": { "installed_at": "2024-02-23T07:17:15Z", "installed_at_sfdc": "2024-02-23T07:17:15+00:00", "name": "Flow Commerce" }, "Foursixty Shoppable Social UGC": { "categories": [ "social proof" ], "installed_at": "2019-01-22T04:17:14Z", "installed_at_sfdc": "2019-01-22T04:17:14+00:00", "name": "Foursixty Shoppable Social UGC", "platform": "shopify" }, "FullStory": { "name": "FullStory", "uninstalled_at": "2022-12-17T08:11:17Z", "uninstalled_at_sfdc": "2022-12-17T08:11:17+00:00" }, "GRIN": { "installed_at": "2022-08-05T23:52:55Z", "installed_at_sfdc": "2022-08-05T23:52:55+00:00", "name": "GRIN" }, "Gatsby Influencer Marketing": { "installed_at": "2023-11-23T20:31:53Z", "installed_at_sfdc": "2023-11-23T20:31:53+00:00", "name": "Gatsby Influencer Marketing" }, "Geolocation": { "categories": [ "internationalization - other" ], "installed_at": "2022-07-05T04:19:59Z", "installed_at_sfdc": "2022-07-05T04:19:59+00:00", "name": "Geolocation", "platform": "shopify" }, "Google Ads Pixel": { "installed_at": "2022-01-31T11:06:52Z", "installed_at_sfdc": "2022-01-31T11:06:52+00:00", "name": "Google Ads Pixel" }, "Google Adsense": { "installed_at": "2022-01-31T11:06:52Z", "installed_at_sfdc": "2022-01-31T11:06:52+00:00", "name": "Google Adsense" }, "Google Analytics": { "installed_at": "2020-02-14T06:30:20Z", "installed_at_sfdc": "2020-02-14T06:30:20+00:00", "name": "Google Analytics" }, "Google Analytics Enhanced Ecommerce": { "name": "Google Analytics Enhanced Ecommerce", "uninstalled_at": "2022-07-27T16:46:59Z", "uninstalled_at_sfdc": "2022-07-27T16:46:59+00:00" }, "Google Optimize": { "name": "Google Optimize", "uninstalled_at": "2023-12-13T18:07:46Z", "uninstalled_at_sfdc": "2023-12-13T18:07:46+00:00" }, "Google Pay": { "installed_at": "2020-11-05T14:25:59Z", "installed_at_sfdc": "2020-11-05T14:25:59+00:00", "name": "Google Pay" }, "Google Tag Manager": { "installed_at": "2020-02-14T06:30:20Z", "installed_at_sfdc": "2020-02-14T06:30:20+00:00", "name": "Google Tag Manager" }, "Happy Returns": { "name": "Happy Returns", "uninstalled_at": "2020-05-18T18:06:19Z", "uninstalled_at_sfdc": "2020-05-18T18:06:19+00:00" }, "Heap Analytics": { "name": "Heap Analytics", "uninstalled_at": "2020-05-21T12:21:02Z", "uninstalled_at_sfdc": "2020-05-21T12:21:02+00:00" }, "Instant Search Plus": { "name": "Instant Search Plus", "uninstalled_at": "2022-10-01T00:54:59Z", "uninstalled_at_sfdc": "2022-10-01T00:54:59+00:00" }, "Iubenda": { "categories": [ "pop-ups", "cookie consent" ], "name": "GDPR Legal Cookie by iubenda", "platform": "shopify", "technology": "Iubenda", "uninstalled_at": "2023-02-28T21:09:09Z", "uninstalled_at_sfdc": "2023-02-28T21:09:09+00:00" }, "Justuno Pop Ups \u0026 Conversion": { "categories": [ "store design", "marketing", "sales and conversion optimization", "reporting" ], "name": "Justuno Pop Ups \u0026 Conversion", "platform": "shopify", "uninstalled_at": "2019-12-27T17:57:59Z", "uninstalled_at_sfdc": "2019-12-27T17:57:59+00:00" }, "Klarna": { "installed_at": "2024-05-23T06:32:08Z", "installed_at_sfdc": "2024-05-23T06:32:08+00:00", "name": "Klarna" }, "Klaviyo": { "installed_at": "2023-12-05T11:02:17Z", "installed_at_sfdc": "2023-12-05T11:02:17+00:00", "name": "Klaviyo" }, "Narvar": { "installed_at": "2020-02-14T06:30:20Z", "installed_at_sfdc": "2020-02-14T06:30:20+00:00", "name": "Narvar" }, "Noibu": { "name": "Noibu", "uninstalled_at": "2022-10-11T22:14:49Z", "uninstalled_at_sfdc": "2022-10-11T22:14:49+00:00" }, "Nosto": { "installed_at": "2020-03-27T23:54:33Z", "installed_at_sfdc": "2020-03-27T23:54:33+00:00", "name": "Nosto" }, "Optimizely": { "installed_at": "2024-01-25T00:20:12Z", "installed_at_sfdc": "2024-01-25T00:20:12+00:00", "name": "Optimizely" }, "PayPal": { "installed_at": "2023-10-31T22:31:04Z", "installed_at_sfdc": "2023-10-31T22:31:04+00:00", "name": "PayPal" }, "PayPal Express Checkout": { "installed_at": "2020-11-05T20:16:20Z", "installed_at_sfdc": "2020-11-05T20:16:20+00:00", "name": "PayPal Express Checkout" }, "Pinterest Pixel": { "installed_at": "2022-01-31T11:06:52Z", "installed_at_sfdc": "2022-01-31T11:06:52+00:00", "name": "Pinterest Pixel" }, "PushOwl \u0026 Brevo: Email, Push": { "categories": [ "email marketing", "web push" ], "installed_at": "2019-01-22T04:17:14Z", "installed_at_sfdc": "2019-01-22T04:17:14+00:00", "name": "PushOwl \u0026 Brevo: Email, Push", "platform": "shopify" }, "QuadPay": { "installed_at": "2020-03-05T05:20:36Z", "installed_at_sfdc": "2020-03-05T05:20:36+00:00", "name": "QuadPay" }, "Reddit Pixel": { "name": "Reddit Pixel", "uninstalled_at": "2024-04-19T12:08:41Z", "uninstalled_at_sfdc": "2024-04-19T12:08:41+00:00" }, "ReturnLogic": { "name": "ReturnLogic", "uninstalled_at": "2020-05-18T18:06:19Z", "uninstalled_at_sfdc": "2020-05-18T18:06:19+00:00" }, "SEO Manager | venntov": { "categories": [ "seo" ], "name": "SEO Manager | venntov", "platform": "shopify", "uninstalled_at": "2019-12-27T17:57:59Z", "uninstalled_at_sfdc": "2019-12-27T17:57:59+00:00" }, "Sailthru": { "installed_at": "2021-12-17T20:43:58Z", "installed_at_sfdc": "2021-12-17T20:43:58+00:00", "name": "Sailthru" }, "Sanity.io": { "installed_at": "2023-11-23T20:31:53Z", "installed_at_sfdc": "2023-11-23T20:31:53+00:00", "name": "Sanity.io" }, "Share Lab": { "categories": [ "store design", "marketing", "customer service" ], "name": "Share Lab", "platform": "shopify", "uninstalled_at": "2023-02-28T21:09:09Z", "uninstalled_at_sfdc": "2023-02-28T21:09:09+00:00" }, "Shop Pay": { "installed_at": "2021-01-01T18:56:09Z", "installed_at_sfdc": "2021-01-01T18:56:09+00:00", "name": "Shop Pay" }, "Shopify Fulfillment Network": { "name": "Shopify Fulfillment Network", "uninstalled_at": "2023-12-13T18:07:46Z", "uninstalled_at_sfdc": "2023-12-13T18:07:46+00:00" }, "Signifyd": { "installed_at": "2024-02-23T07:17:15Z", "installed_at_sfdc": "2024-02-23T07:17:15+00:00", "name": "Signifyd" }, "Snap Pixel": { "installed_at": "2022-01-31T11:06:52Z", "installed_at_sfdc": "2022-01-31T11:06:52+00:00", "name": "Snap Pixel" }, "SpeedCurve LUX": { "name": "SpeedCurve LUX", "uninstalled_at": "2023-02-03T03:41:51Z", "uninstalled_at_sfdc": "2023-02-03T03:41:51+00:00" }, "Talkable": { "name": "Talkable", "uninstalled_at": "2023-07-25T08:27:21Z", "uninstalled_at_sfdc": "2023-07-25T08:27:21+00:00" }, "Tapcart": { "installed_at": "2020-05-13T06:01:35Z", "installed_at_sfdc": "2020-05-13T06:01:35+00:00", "name": "Tapcart" }, "TikTok Pixel": { "installed_at": "2021-12-09T22:10:08Z", "installed_at_sfdc": "2021-12-09T22:10:08+00:00", "name": "TikTok Pixel" }, "Twitter Pixel": { "name": "Twitter Pixel", "uninstalled_at": "2024-04-19T12:08:41Z", "uninstalled_at_sfdc": "2024-04-19T12:08:41+00:00" }, "Vimeo": { "installed_at": "2022-10-01T00:54:59Z", "installed_at_sfdc": "2022-10-01T00:54:59+00:00", "name": "Vimeo" }, "WisePops": { "installed_at": "2024-02-23T07:17:15Z", "installed_at_sfdc": "2024-02-23T07:17:15+00:00", "name": "WisePops" }, "Wishlist Plus": { "categories": [ "wishlists", "email marketing" ], "installed_at": "2024-05-15T23:28:28Z", "installed_at_sfdc": "2024-05-15T23:28:28+00:00", "name": "Wishlist Plus", "platform": "shopify" }, "Wunderkind": { "installed_at": "2023-02-28T21:09:09Z", "installed_at_sfdc": "2023-02-28T21:09:09+00:00", "name": "Wunderkind" }, "Yotpo": { "installed_at": "2024-05-15T23:28:28Z", "installed_at_sfdc": "2024-05-15T23:28:28+00:00", "name": "Yotpo" }, "Yotpo Product Reviews \u0026 UGC": { "categories": [ "product reviews" ], "installed_at": "2019-01-22T04:17:14Z", "installed_at_sfdc": "2019-01-22T04:17:14+00:00", "name": "Yotpo Product Reviews \u0026 UGC", "platform": "shopify" }, "Yottaa": { "installed_at": "2020-04-15T18:44:01Z", "installed_at_sfdc": "2020-04-15T18:44:01+00:00", "name": "Yottaa" }, "YouTube Player": { "installed_at": "2023-11-23T20:31:53Z", "installed_at_sfdc": "2023-11-23T20:31:53+00:00", "name": "YouTube Player" }, "Zendesk": { "installed_at": "2020-05-22T18:53:07Z", "installed_at_sfdc": "2020-05-22T18:53:07+00:00", "name": "Zendesk" }, "reCAPTCHA": { "installed_at": "2021-01-01T18:50:15Z", "installed_at_sfdc": "2021-01-01T18:50:15+00:00", "name": "reCAPTCHA" } }, "app_details": { "1.algolia-search": { "categories": [ "search and filters", "upsell and cross-sell" ], "installed_at": "2023-06-13T13:21:30Z", "installed_at_sfdc": "2023-06-13T13:21:30+00:00", "name": "Algolia AI Search \u0026 Discovery", "platform": "shopify", "technology": "Algolia" }, "1.attentive": { "categories": [ "email marketing", "sms marketing" ], "installed_at": "2024-04-30T09:01:38Z", "installed_at_sfdc": "2024-04-30T09:01:38+00:00", "name": "Attentive: SMS + MMS Marketing", "platform": "shopify", "technology": "Attentive" }, "1.back-in-stock": { "categories": [ "stock alerts", "email marketing" ], "name": "Back in Stock: Restock Alerts", "platform": "shopify", "uninstalled_at": "2021-02-13T04:36:22Z", "uninstalled_at_sfdc": "2021-02-13T04:36:22+00:00" }, "1.consistent-cart": { "categories": [ "marketing", "conversion" ], "name": "Email Marketing ‑ Amplified", "platform": "shopify", "uninstalled_at": "2020-08-14T14:15:54Z", "uninstalled_at_sfdc": "2020-08-14T14:15:54+00:00" }, "1.crazy-egg": { "categories": [ "analytics" ], "name": "Crazy Egg", "platform": "shopify", "uninstalled_at": "2023-03-14T23:48:08Z", "uninstalled_at_sfdc": "2023-03-14T23:48:08+00:00" }, "1.edgetag": { "categories": [ "analytics", "ads" ], "installed_at": "2024-02-23T07:17:15Z", "installed_at_sfdc": "2024-02-23T07:17:15+00:00", "name": "Blotout EdgeTag", "platform": "shopify", "technology": "Blotout" }, "1.facebook-messenger-support": { "categories": [ "chat" ], "name": "Facebook Messenger Chat", "platform": "shopify", "uninstalled_at": "2023-02-28T21:09:09Z", "uninstalled_at_sfdc": "2023-02-28T21:09:09+00:00" }, "1.foursixty": { "categories": [ "social proof" ], "installed_at": "2019-01-22T04:17:14Z", "installed_at_sfdc": "2019-01-22T04:17:14+00:00", "name": "Foursixty Shoppable Social UGC", "platform": "shopify" }, "1.gatsby": { "categories": [ "email marketing", "giveaways and contests" ], "installed_at": "2023-11-23T20:31:53Z", "installed_at_sfdc": "2023-11-23T20:31:53+00:00", "name": "Gatsby: Growth From Community", "platform": "shopify", "technology": "Gatsby Influencer Marketing" }, "1.gdpr-legal-cookie": { "categories": [ "pop-ups", "cookie consent" ], "name": "GDPR Legal Cookie by iubenda", "platform": "shopify", "technology": "Iubenda", "uninstalled_at": "2023-02-28T21:09:09Z", "uninstalled_at_sfdc": "2023-02-28T21:09:09+00:00" }, "1.geolocation": { "categories": [ "internationalization - other" ], "installed_at": "2022-07-05T04:19:59Z", "installed_at_sfdc": "2022-07-05T04:19:59+00:00", "name": "Geolocation", "platform": "shopify" }, "1.instant-search": { "categories": [ "search and filters", "upsell and cross-sell" ], "name": "Fast Simon Search and Filters", "platform": "shopify", "technology": "Instant Search Plus", "uninstalled_at": "2022-10-01T00:54:59Z", "uninstalled_at_sfdc": "2022-10-01T00:54:59+00:00" }, "1.justuno-social-email-leads": { "categories": [ "store design", "marketing", "sales and conversion optimization", "reporting" ], "name": "Justuno Pop Ups \u0026 Conversion", "platform": "shopify", "uninstalled_at": "2019-12-27T17:57:59Z", "uninstalled_at_sfdc": "2019-12-27T17:57:59+00:00" }, "1.klarna-on-site-messaging": { "categories": [ "banners", "advertising - other" ], "installed_at": "2024-05-23T06:32:08Z", "installed_at_sfdc": "2024-05-23T06:32:08+00:00", "name": "Klarna On‑Site Messaging", "platform": "shopify", "technology": "Klarna" }, "1.klaviyo-email-marketing": { "categories": [ "email marketing", "sms marketing" ], "installed_at": "2023-12-05T11:02:17Z", "installed_at_sfdc": "2023-12-05T11:02:17+00:00", "name": "Klaviyo: Email Marketing \u0026 SMS", "platform": "shopify", "technology": "Klaviyo" }, "1.narvar-returns": { "categories": [ "returns and exchanges" ], "installed_at": "2022-05-02T18:13:34Z", "installed_at_sfdc": "2022-05-02T18:13:34+00:00", "name": "Narvar Return and Exchange", "platform": "shopify", "technology": "Narvar" }, "1.nosto-personalization-for-shopify": { "categories": [ "search and filters", "upsell and cross-sell" ], "installed_at": "2022-07-12T05:55:00Z", "installed_at_sfdc": "2022-07-12T05:55:00+00:00", "name": "Nosto", "platform": "shopify", "technology": "Nosto" }, "1.pop-up-builder-wisepops": { "categories": [ "pop-ups" ], "installed_at": "2024-02-23T07:17:15Z", "installed_at_sfdc": "2024-02-23T07:17:15+00:00", "name": "Wisepops: Popups \u0026 Notif 2024", "platform": "shopify", "technology": "WisePops" }, "1.pushowl": { "categories": [ "email marketing", "web push" ], "installed_at": "2019-01-22T04:17:14Z", "installed_at_sfdc": "2019-01-22T04:17:14+00:00", "name": "PushOwl \u0026 Brevo: Email, Push", "platform": "shopify" }, "1.rapid-insite": { "categories": [ "seo" ], "installed_at": "2020-11-10T18:20:48Z", "installed_at_sfdc": "2020-11-10T18:20:48+00:00", "name": "YOTTAA Insights", "platform": "shopify", "technology": "Yottaa" }, "1.seo-meta-manager": { "categories": [ "seo" ], "name": "SEO Manager | venntov", "platform": "shopify", "uninstalled_at": "2019-12-27T17:57:59Z", "uninstalled_at_sfdc": "2019-12-27T17:57:59+00:00" }, "1.share-lab": { "categories": [ "store design", "marketing", "customer service" ], "name": "Share Lab", "platform": "shopify", "uninstalled_at": "2023-02-28T21:09:09Z", "uninstalled_at_sfdc": "2023-02-28T21:09:09+00:00" }, "1.shopify-fulfillment-network": { "categories": [ "outsourced fulfillment", "fulfilling orders - other" ], "name": "Shopify Fulfillment Network", "platform": "shopify", "technology": "Shopify Fulfillment Network", "uninstalled_at": "2023-12-13T18:07:46Z", "uninstalled_at_sfdc": "2023-12-13T18:07:46+00:00" }, "1.shopify-mobile-apps": { "categories": [ "mobile app builder" ], "installed_at": "2021-04-28T03:43:18Z", "installed_at_sfdc": "2021-04-28T03:43:18+00:00", "name": "Tapcart ‑ Mobile App Builder", "platform": "shopify", "technology": "Tapcart" }, "1.shopmessage": { "categories": [ "chat", "support - other" ], "name": "Facebook Messenger Marketing", "platform": "shopify", "uninstalled_at": "2023-03-29T19:06:55Z", "uninstalled_at_sfdc": "2023-03-29T19:06:55+00:00" }, "1.signifyd": { "categories": [ "fraud" ], "installed_at": "2019-11-19T08:27:40Z", "installed_at_sfdc": "2019-11-19T08:27:40+00:00", "name": "Signifyd", "platform": "shopify", "technology": "Signifyd" }, "1.swym-relay": { "categories": [ "wishlists", "email marketing" ], "installed_at": "2024-05-15T23:28:28Z", "installed_at_sfdc": "2024-05-15T23:28:28+00:00", "name": "Wishlist Plus", "platform": "shopify" }, "1.yotpo-social-reviews": { "categories": [ "product reviews" ], "installed_at": "2019-01-22T04:17:14Z", "installed_at_sfdc": "2019-01-22T04:17:14+00:00", "name": "Yotpo Product Reviews \u0026 UGC", "platform": "shopify" }, "1.zendesk": { "categories": [ "helpdesk" ], "installed_at": "2022-10-11T22:14:49Z", "installed_at_sfdc": "2022-10-11T22:14:49+00:00", "name": "Zendesk", "platform": "shopify", "technology": "Zendesk" } }, "avg_price": 1652, "avg_price_usd": 1652, "avg_weight": 298, "brand_advocate_page_url": "", "brands_page_url": "", "categories": [ "/Apparel" ], "city": "Vernon", "cluster_domains": [ "www.fashionnova.com", "fashionnova.group", "fashionnova.accountant" ], "combined_followers": 5037199, "contact_page_url": "https://www.fashionnova.com/pages/contact-us", "country_code": "US", "currency_code": "USD", "estimated_page_views": 51949457, "estimated_sales": 4031335608, "estimated_visits": 17603203, "faq_page_url": "", "features": [ "Shopify POS", "Returns Page", "Shopify Online Store 2.0", "Has iOS App", "Has Android App", "New Shopify Checkout (2022)", "Accepts Gift Cards", "Contact Page", "Tracking or Returns", "Tracking Page", "Has Blog", "Has CMS" ], "financing_page_url": "", "klaviyo_features": [], "language_code": "en", "localization_count": 4, "localizations": [ "en-cl", "en-mx", "es-cl", "es-mx" ], "max_price": 50000, "merchant_name": "Fashion Nova", "min_price": 148, "name": "www.fashionnova.com", "pinterest_followers": 873900, "plan": "Shopify Plus", "platform": "shopify", "platform_rank": 2, "postal_code": "", "product_count": 226613, "rank": 153, "retailer_page_url": "", "returns_page_url": "https://www.fashionnova.com/pages/i-have-a-problem-with-my-return", "shopify_app_names": [ "Algolia AI Search \u0026 Discovery", "Attentive: SMS + MMS Marketing", "Blotout EdgeTag", "Foursixty Shoppable Social UGC", "Gatsby: Growth From Community", "Geolocation", "Klarna On‑Site Messaging", "Klaviyo: Email Marketing \u0026 SMS", "Narvar Return and Exchange", "Nosto", "Wisepops: Popups \u0026 Notif 2024", "PushOwl \u0026 Brevo: Email, Push", "YOTTAA Insights", "Tapcart ‑ Mobile App Builder", "Signifyd", "Wishlist Plus", "Yotpo Product Reviews \u0026 UGC", "Zendesk" ], "shopify_app_tokens": [ "algolia-search", "attentive", "edgetag", "foursixty", "gatsby", "geolocation", "klarna-on-site-messaging", "klaviyo-email-marketing", "narvar-returns", "nosto-personalization-for-shopify", "pop-up-builder-wisepops", "pushowl", "rapid-insite", "shopify-mobile-apps", "signifyd", "swym-relay", "yotpo-social-reviews", "zendesk" ], "state": "Active", "store_locator_page_url": "", "technologies": [ "Afterpay", "Algolia", "Apple Pay", "Arrive", "Attentive", "Bing Ads", "Blotout", "Cloudflare", "Cloudflare CDN", "Contentful", "Criteo", "Facebook Pixel", "Flow Commerce", "GRIN", "Gatsby Influencer Marketing", "Google Ads Pixel", "Google Adsense", "Google Analytics", "Google Pay", "Google Tag Manager", "Klarna", "Klaviyo", "Narvar", "Nosto", "Optimizely", "PayPal", "PayPal Express Checkout", "Pinterest Pixel", "QuadPay", "Sailthru", "Sanity.io", "Shop Pay", "Signifyd", "Snap Pixel", "Tapcart", "TikTok Pixel", "Vimeo", "WisePops", "Wunderkind", "Yotpo", "Yottaa", "YouTube Player", "Zendesk", "reCAPTCHA" ], "technology_details": { "Afterpay": { "installed_at": "2021-09-16T15:16:02Z", "installed_at_sfdc": "2021-09-16T15:16:02+00:00", "name": "Afterpay" }, "Algolia": { "installed_at": "2023-06-13T13:21:30Z", "installed_at_sfdc": "2023-06-13T13:21:30+00:00", "name": "Algolia" }, "Amazon Pay": { "name": "Amazon Pay", "uninstalled_at": "2023-10-20T21:05:54Z", "uninstalled_at_sfdc": "2023-10-20T21:05:54+00:00" }, "Apple Pay": { "installed_at": "2020-11-10T18:20:48Z", "installed_at_sfdc": "2020-11-10T18:20:48+00:00", "name": "Apple Pay" }, "Arrive": { "installed_at": "2020-11-19T07:39:35Z", "installed_at_sfdc": "2020-11-19T07:39:35+00:00", "name": "Arrive" }, "Attentive": { "installed_at": "2020-10-08T19:53:51Z", "installed_at_sfdc": "2020-10-08T19:53:51+00:00", "name": "Attentive" }, "Bing Ads": { "installed_at": "2024-02-23T07:17:15Z", "installed_at_sfdc": "2024-02-23T07:17:15+00:00", "name": "Bing Ads" }, "Blotout": { "installed_at": "2024-02-23T07:17:15Z", "installed_at_sfdc": "2024-02-23T07:17:15+00:00", "name": "Blotout" }, "Cloudflare": { "installed_at": "2023-10-31T22:31:04Z", "installed_at_sfdc": "2023-10-31T22:31:04+00:00", "name": "Cloudflare" }, "Cloudflare CDN": { "installed_at": "2021-06-08T15:41:52Z", "installed_at_sfdc": "2021-06-08T15:41:52+00:00", "name": "Cloudflare CDN" }, "Contentful": { "installed_at": "2024-05-15T23:28:28Z", "installed_at_sfdc": "2024-05-15T23:28:28+00:00", "name": "Contentful" }, "Criteo": { "installed_at": "2022-06-14T14:05:48Z", "installed_at_sfdc": "2022-06-14T14:05:48+00:00", "name": "Criteo" }, "Facebook Pixel": { "installed_at": "2022-02-08T04:48:21Z", "installed_at_sfdc": "2022-02-08T04:48:21+00:00", "name": "Facebook Pixel" }, "Flow Commerce": { "installed_at": "2024-02-23T07:17:15Z", "installed_at_sfdc": "2024-02-23T07:17:15+00:00", "name": "Flow Commerce" }, "FullStory": { "name": "FullStory", "uninstalled_at": "2022-12-17T08:11:17Z", "uninstalled_at_sfdc": "2022-12-17T08:11:17+00:00" }, "GRIN": { "installed_at": "2022-08-05T23:52:55Z", "installed_at_sfdc": "2022-08-05T23:52:55+00:00", "name": "GRIN" }, "Gatsby Influencer Marketing": { "installed_at": "2023-11-23T20:31:53Z", "installed_at_sfdc": "2023-11-23T20:31:53+00:00", "name": "Gatsby Influencer Marketing" }, "Google Ads Pixel": { "installed_at": "2022-01-31T11:06:52Z", "installed_at_sfdc": "2022-01-31T11:06:52+00:00", "name": "Google Ads Pixel" }, "Google Adsense": { "installed_at": "2022-01-31T11:06:52Z", "installed_at_sfdc": "2022-01-31T11:06:52+00:00", "name": "Google Adsense" }, "Google Analytics": { "installed_at": "2020-02-14T06:30:20Z", "installed_at_sfdc": "2020-02-14T06:30:20+00:00", "name": "Google Analytics" }, "Google Analytics Enhanced Ecommerce": { "name": "Google Analytics Enhanced Ecommerce", "uninstalled_at": "2022-07-27T16:46:59Z", "uninstalled_at_sfdc": "2022-07-27T16:46:59+00:00" }, "Google Optimize": { "name": "Google Optimize", "uninstalled_at": "2023-12-13T18:07:46Z", "uninstalled_at_sfdc": "2023-12-13T18:07:46+00:00" }, "Google Pay": { "installed_at": "2020-11-05T14:25:59Z", "installed_at_sfdc": "2020-11-05T14:25:59+00:00", "name": "Google Pay" }, "Google Tag Manager": { "installed_at": "2020-02-14T06:30:20Z", "installed_at_sfdc": "2020-02-14T06:30:20+00:00", "name": "Google Tag Manager" }, "Happy Returns": { "name": "Happy Returns", "uninstalled_at": "2020-05-18T18:06:19Z", "uninstalled_at_sfdc": "2020-05-18T18:06:19+00:00" }, "Heap Analytics": { "name": "Heap Analytics", "uninstalled_at": "2020-05-21T12:21:02Z", "uninstalled_at_sfdc": "2020-05-21T12:21:02+00:00" }, "Instant Search Plus": { "name": "Instant Search Plus", "uninstalled_at": "2022-10-01T00:54:59Z", "uninstalled_at_sfdc": "2022-10-01T00:54:59+00:00" }, "Klarna": { "installed_at": "2024-05-23T06:32:08Z", "installed_at_sfdc": "2024-05-23T06:32:08+00:00", "name": "Klarna" }, "Klaviyo": { "installed_at": "2023-12-05T11:02:17Z", "installed_at_sfdc": "2023-12-05T11:02:17+00:00", "name": "Klaviyo" }, "Narvar": { "installed_at": "2020-02-14T06:30:20Z", "installed_at_sfdc": "2020-02-14T06:30:20+00:00", "name": "Narvar" }, "Noibu": { "name": "Noibu", "uninstalled_at": "2022-10-11T22:14:49Z", "uninstalled_at_sfdc": "2022-10-11T22:14:49+00:00" }, "Nosto": { "installed_at": "2020-03-27T23:54:33Z", "installed_at_sfdc": "2020-03-27T23:54:33+00:00", "name": "Nosto" }, "Optimizely": { "installed_at": "2024-01-25T00:20:12Z", "installed_at_sfdc": "2024-01-25T00:20:12+00:00", "name": "Optimizely" }, "PayPal": { "installed_at": "2023-10-31T22:31:04Z", "installed_at_sfdc": "2023-10-31T22:31:04+00:00", "name": "PayPal" }, "PayPal Express Checkout": { "installed_at": "2020-11-05T20:16:20Z", "installed_at_sfdc": "2020-11-05T20:16:20+00:00", "name": "PayPal Express Checkout" }, "Pinterest Pixel": { "installed_at": "2022-01-31T11:06:52Z", "installed_at_sfdc": "2022-01-31T11:06:52+00:00", "name": "Pinterest Pixel" }, "QuadPay": { "installed_at": "2020-03-05T05:20:36Z", "installed_at_sfdc": "2020-03-05T05:20:36+00:00", "name": "QuadPay" }, "Reddit Pixel": { "name": "Reddit Pixel", "uninstalled_at": "2024-04-19T12:08:41Z", "uninstalled_at_sfdc": "2024-04-19T12:08:41+00:00" }, "ReturnLogic": { "name": "ReturnLogic", "uninstalled_at": "2020-05-18T18:06:19Z", "uninstalled_at_sfdc": "2020-05-18T18:06:19+00:00" }, "Sailthru": { "installed_at": "2021-12-17T20:43:58Z", "installed_at_sfdc": "2021-12-17T20:43:58+00:00", "name": "Sailthru" }, "Sanity.io": { "installed_at": "2023-11-23T20:31:53Z", "installed_at_sfdc": "2023-11-23T20:31:53+00:00", "name": "Sanity.io" }, "Shop Pay": { "installed_at": "2021-01-01T18:56:09Z", "installed_at_sfdc": "2021-01-01T18:56:09+00:00", "name": "Shop Pay" }, "Shopify Fulfillment Network": { "name": "Shopify Fulfillment Network", "uninstalled_at": "2023-12-13T18:07:46Z", "uninstalled_at_sfdc": "2023-12-13T18:07:46+00:00" }, "Signifyd": { "installed_at": "2024-02-23T07:17:15Z", "installed_at_sfdc": "2024-02-23T07:17:15+00:00", "name": "Signifyd" }, "Snap Pixel": { "installed_at": "2022-01-31T11:06:52Z", "installed_at_sfdc": "2022-01-31T11:06:52+00:00", "name": "Snap Pixel" }, "SpeedCurve LUX": { "name": "SpeedCurve LUX", "uninstalled_at": "2023-02-03T03:41:51Z", "uninstalled_at_sfdc": "2023-02-03T03:41:51+00:00" }, "Talkable": { "name": "Talkable", "uninstalled_at": "2023-07-25T08:27:21Z", "uninstalled_at_sfdc": "2023-07-25T08:27:21+00:00" }, "Tapcart": { "installed_at": "2020-05-13T06:01:35Z", "installed_at_sfdc": "2020-05-13T06:01:35+00:00", "name": "Tapcart" }, "TikTok Pixel": { "installed_at": "2021-12-09T22:10:08Z", "installed_at_sfdc": "2021-12-09T22:10:08+00:00", "name": "TikTok Pixel" }, "Twitter Pixel": { "name": "Twitter Pixel", "uninstalled_at": "2024-04-19T12:08:41Z", "uninstalled_at_sfdc": "2024-04-19T12:08:41+00:00" }, "Vimeo": { "installed_at": "2022-10-01T00:54:59Z", "installed_at_sfdc": "2022-10-01T00:54:59+00:00", "name": "Vimeo" }, "WisePops": { "installed_at": "2024-02-23T07:17:15Z", "installed_at_sfdc": "2024-02-23T07:17:15+00:00", "name": "WisePops" }, "Wunderkind": { "name": "Wunderkind", "uninstalled_at": "2023-02-28T21:09:09Z", "uninstalled_at_sfdc": "2023-02-28T21:09:09+00:00" }, "Yotpo": { "installed_at": "2024-05-15T23:28:28Z", "installed_at_sfdc": "2024-05-15T23:28:28+00:00", "name": "Yotpo" }, "Yottaa": { "installed_at": "2020-04-15T18:44:01Z", "installed_at_sfdc": "2020-04-15T18:44:01+00:00", "name": "Yottaa" }, "YouTube Player": { "installed_at": "2023-11-23T20:31:53Z", "installed_at_sfdc": "2023-11-23T20:31:53+00:00", "name": "YouTube Player" }, "Zendesk": { "installed_at": "2020-05-22T18:53:07Z", "installed_at_sfdc": "2020-05-22T18:53:07+00:00", "name": "Zendesk" }, "reCAPTCHA": { "installed_at": "2021-01-01T18:50:15Z", "installed_at_sfdc": "2021-01-01T18:50:15+00:00", "name": "reCAPTCHA" } }, "tiktok_followers": 4099999, "tracking_page_url": "https://www.fashionnova.com/pages/shipping-options", "twitter_followers": 0, "warranty_page_url": "", "youtube_followers": 63300 }, "now": "2024-07-27T00:31:59.19017Z" }
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).