Check out our free Chrome Extension.

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
Define Calculated Value.

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.

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
Calculated Values 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.

Calculated Values as Search Filter
Calculated Values as Search Filter.

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
Calculated Values in CSV Exports.

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
The URL of the Domain's "About Us" page (if any).
_domain.administrative_area_level_1
The administrative_area_level_1 of the Domain (if known). This value often represents the state/province of the associated merchant's headquarters.
_domain.aliases
List of alias DNS domain names that refer to this Domain. Aliases are identified as other DNS domain names that point to the Domain through canonical links or redirects.
_domain.alternates
List of alternate DNS domain names for this Domain. Alternate domain names are localized versions of the domain for a specific locale. e.g., ca.merchant.com and uk.merchant.com. This is a map (also called a dictionary in some programming languages) of locale name to domain name.
_domain.avg_price
The average price of products sold on the Domain. Values in the minor unit of the Domain's currency (e.g., cents of USD). Only available for Shopify stores using the regular (non-headless) frontend.
_domain.avg_price_usd
The average price of products sold on the Domain in cents of USD. Only available for Shopify stores using the regular (non-headless) frontend.
_domain.avg_weight
The average weight of products (in grams) sold on the Domain. Only available for Shopify stores using the regular (non-headless) frontend.
_domain.app_details
A detailed list of Apps installed on the Domain. (e.g., [{ name: "Privy", platform: "shopify", installed_at: "2020-04-15T18:44:01Z", categories: ["Email marketing", "Pop-ups"] }])
_domain.brand_advocate_page_url
The URL of the Domain's "Brand Advocate" page (if any).
_domain.brands_page_url
The URL of the Domain's "Brands" page (if any).
_domain.categories
A list of the Domain's categories. (e.g., ["/Apparel/Footwear"])
_domain.city
The city of the Domain (if known). This value often represents the city of the associated merchant's headquarters.
_domain.cluster_domains
For merchants that have multiple domains (e.g., merchant.com, merchant.co.uk and merchant.com.au), cluster_domains contains a list Domain names that are in the same cluster.
_domain.cluster_domain_country_codes
For merchants that have multiple domains (e.g., merchant.com, merchant.co.uk and merchant.com.au), cluster_domain_country_codes contains a list of unique country codes for all domains in the cluster.
_domain.combined_followers
The sum of followers across all social media accounts.
_domain.contact_info
A list of emails, phones and social meida accounts associated with the store's website.
_domain.contact_page_url
The URL of the Domain's "Contact" page (if any).
_domain.copyright
The copyright text provided on the Domain's website (if any). This copyright text is difficult to extract and is not always accurate.
_domain.country_code
The 2-letter ISO country code of the Domain. Note that a small percentage of Domains are not country-specific (they sell to multiple countries) and these Domains do not have a country-code.
_domain.currency_code
The 3-letter ISO currency code of the Domain.
_domain.custom_matches
A list of custom match names that matched this domain.
_domain.estimated_page_views
The estimated total monthly page views for the Domain.
_domain.estimated_sales
The estimated total monthly sales for the merchant. Values in cents of USD.
_domain.estimated_visits
The estimated total monthly visits for the Domain.
_domain.faq_page_url
The URL of the Domain's "FAQ" page (if any).
_domain.features
A list of the Domain's features. (e.g., ["Contact Page", "Tracking Page"])
_domain.financing_page_url
The URL of the Domain's "Financing" page (if any).
_domain.name
The Domain name (e.g., www.fashionnova.com)
_domain.language_code
The 2-letter ISO 639-1 code for the language of content on the Domain's website. Value is blank is not known.
_domain.localization_count
The number of localizations on the Domain's website. Only known for Shopify stores using the standard frontend.
_domain.localizations
A list of the Domain's localizations, if known. (e.g., ["en-us", "en-ca", "fr-fr"]). Only known for Shopify stores using the standard frontend.
_domain.max_price
The price of the most expensive product sold on the Domain. Only available for Shopify stores using the regular (non-headless) frontend.
_domain.merchant_name
The name of the merchant that is selling on the Domain.
_domain.min_price
The price of the least expensive product sold on the Domain. Only available for Shopify stores using the regular (non-headless) frontend.
_domain.pinterest_followers
The number of followers for the Domain's Pinterest account.
_domain.plan
The name of the ecommerce platform's pricing plan that the merchant is using (if known). e.g., "Shopify Plus"
_domain.platform
The name of the ecommerce platform used by the Domain (e.g., shopifyA)
_domain.platform_rank
The rank of the Domain against all other Domains on the same ecommerce platforms. We rank ecommerce domains based on the popularity of each Domain (via traffic estimates) and the number and significance of links to each Domain.
_domain.postal_code
The postal code of the Domain (if known). This value is available for a very small subset of overall stores.
_domain.product_count
The number of products sold by the Domain. Product counts are precise for standard Shopify stores. For all other stores, product counts are an estimate.
_domain.product_search
Runs an arbitrary search for products sold by the Domain. Product search is only available for standard Shopify stores.
_domain.products_created_30
The number of products created in the last 30 days sold by the Domain. Only available for standard Shopify stores.
_domain.products_created_90
The number of products created in the last 90 days sold by the Domain. Only available for standard Shopify stores.
_domain.products_created_365
The number of products created in the last 365 days sold by the Domain. Only available for standard Shopify stores.
_domain.rank
The "world-wide" rank of the Domain (across all supported ecommerce platforms). We rank all ecommerce domains based on the popularity of each Domain (via traffic estimates) and the number and significance of links to each Domain.
_domain.retailer_page_url
The URL of the Domain's "Retailer" page (if any).
_domain.returns_page_url
The URL of the Domain's "Returns" page (if any).
_domain.shopify_app_names
A list of Shopify Apps installed on the Domain, identified by App name. (e.g., ["Privy", "Yotpo: Loyalty & Rewards"])
_domain.shopify_app_tokens
A list of Shopify Apps installed on the Domain, identified by App token. (e.g., ["privy", "swell"])
_domain.state
The state of the Domain. Can be one of the following values: Active, Inactive, Password Protected or Redirect.
_domain.store_locator_page_url
The URL of the Domain's "Store Locator" page (if any).
_domain.technologies
A list of technologies installed on the Domain. (e.g., ["Affirm", "Google Analytics"])
_domain.technology_details
A detailed list of technologies installed on the Domain. (e.g., [{ name: "Affirm", installed_at: "2020-04-15T18:44:01Z" }])
_domain.tiktok_followers
The number of followers for the Domain's TikTok account.
_domain.tracking_page_url
The URL of the Domain's "Tracking" page (if any).
_domain.twitter_followers
The number of followers for the Domain's Twitter account.
_domain.warranty_page_url
The URL of the Domain's "Warranty" page (if any).
_domain.youtube_followers
The number of followers for the Domain's YouTube account.
now
The current time. 
{
  "_domain": {
    "about_us_page_url": "https://www.khy.com/pages/about-us",
    "administrative_area_level_1": "California",
    "aliases": [
      "khy.is"
    ],
    "alternates": null,
    "app_and_tech_details": {
      "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": 170
      },
      "Afterpay": {
        "installed_at": "2023-11-04T04:40:27Z",
        "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
        "name": "Afterpay",
        "uninstalled_at": "2024-01-31T01:29:14Z",
        "uninstalled_at_sfdc": "2024-01-31T01:29:14+00:00"
      },
      "Apple Pay": {
        "installed_at": "2023-11-04T04:40:27Z",
        "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
        "name": "Apple Pay"
      },
      "Arrive": {
        "installed_at": "2024-02-15T04:15:31Z",
        "installed_at_sfdc": "2024-02-15T04:15:31+00:00",
        "name": "Arrive"
      },
      "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": {
        "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": {
          "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": 623,
          "technology": "Baazarvoice"
        }
      },
      "Back in Stock: Restock Alerts": {
        "categories": [
          "stock alerts",
          "email marketing"
        ],
        "installed_at": "2023-11-22T12:26:00Z",
        "installed_at_sfdc": "2023-11-22T12:26:00+00:00",
        "name": "Back in Stock: Restock Alerts",
        "platform": "shopify",
        "platform_install_rank": 65
      },
      "Checkout Blocks": {
        "categories": [
          "checkout - other",
          "discounts"
        ],
        "installed_at": "2024-08-19T16:17:22Z",
        "installed_at_sfdc": "2024-08-19T16:17:22+00:00",
        "name": "Checkout Blocks",
        "platform": "shopify",
        "platform_install_rank": 255
      },
      "Cloudflare": {
        "installed_at": "2023-11-04T04:40:27Z",
        "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
        "name": "Cloudflare"
      },
      "Cloudflare CDN": {
        "installed_at": "2023-11-04T04:40:27Z",
        "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
        "name": "Cloudflare CDN"
      },
      "Elevar": {
        "installed_at": "2024-10-30T18:26:56Z",
        "installed_at_sfdc": "2024-10-30T18:26:56+00:00",
        "name": "Elevar"
      },
      "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": 223
      },
      "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": {
        "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
      },
      "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": {
        "installed_at": "2023-11-04T04:40:27Z",
        "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
        "name": "Google Ads Pixel"
      },
      "Google Adsense": {
        "installed_at": "2023-11-04T04:40:27Z",
        "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
        "name": "Google Adsense"
      },
      "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": {
        "installed_at": "2023-11-04T04:40:27Z",
        "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
        "name": "Google Tag Manager"
      },
      "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": {
          "categories": [
            "chat",
            "helpdesk"
          ],
          "installed_at": "2023-11-04T04:40:27Z",
          "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
          "name": "Gorgias",
          "platform": "shopify",
          "platform_install_rank": 95,
          "technology": "Gorgias"
        }
      },
      "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": {
          "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": 4,
          "technology": "Klaviyo"
        }
      },
      "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": 246,
        "uninstalled_at": "2023-11-14T16:14:49Z",
        "uninstalled_at_sfdc": "2023-11-14T16:14:49+00:00"
      },
      "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": 124
      },
      "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": {
          "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": 128,
          "technology": "Okendo"
        }
      },
      "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": {
        "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": {
          "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": 3452,
          "technology": "Optoro"
        }
      },
      "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": {
        "installed_at": "2023-11-04T04:40:27Z",
        "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
        "name": "PayPal Express Checkout"
      },
      "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": {
          "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": 139,
          "technology": "Route"
        }
      },
      "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": {
        "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": {
          "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": 2844,
          "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": {
        "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": 123,
        "uninstalled_at": "2024-07-02T01:09:11Z",
        "uninstalled_at_sfdc": "2024-07-02T01:09:11+00:00"
      },
      "TikTok Pixel": {
        "installed_at": "2024-11-13T17:19:33Z",
        "installed_at_sfdc": "2024-11-13T17:19:33+00:00",
        "name": "TikTok Pixel"
      },
      "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": {
          "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": 78,
          "technology": "Triple Whale"
        }
      },
      "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": {
        "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": {
        "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": 170
      },
      "1.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": "Back in Stock: Restock Alerts",
        "platform": "shopify",
        "platform_install_rank": 65
      },
      "1.bazaarvoice-reviews-photos-social": {
        "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": 623,
        "technology": "Baazarvoice"
      },
      "1.checkout-blocks": {
        "categories": [
          "checkout - other",
          "discounts"
        ],
        "installed_at": "2024-08-19T16:17:22Z",
        "installed_at_sfdc": "2024-08-19T16:17:22+00:00",
        "name": "Checkout Blocks",
        "platform": "shopify",
        "platform_install_rank": 255
      },
      "1.customer-privacy-banner": {
        "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": 123,
        "uninstalled_at": "2024-07-02T01:09:11Z",
        "uninstalled_at_sfdc": "2024-07-02T01:09:11+00:00"
      },
      "1.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.gtm-datalayer-by-elevar": {
        "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": 223
      },
      "1.helpdesk": {
        "categories": [
          "chat",
          "helpdesk"
        ],
        "installed_at": "2023-11-04T04:40:27Z",
        "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
        "name": "Gorgias",
        "platform": "shopify",
        "platform_install_rank": 95,
        "technology": "Gorgias"
      },
      "1.klaviyo-email-marketing": {
        "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": 4,
        "technology": "Klaviyo"
      },
      "1.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": 246,
        "uninstalled_at": "2023-11-14T16:14:49Z",
        "uninstalled_at_sfdc": "2023-11-14T16:14:49+00:00"
      },
      "1.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": 124
      },
      "1.okendo-reviews": {
        "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": 128,
        "technology": "Okendo"
      },
      "1.optoro-returns": {
        "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": 3452,
        "technology": "Optoro"
      },
      "1.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": 139,
        "technology": "Route"
      },
      "1.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": 2844,
        "technology": "Shopify Fulfillment Network",
        "uninstalled_at": "2023-12-12T14:25:05Z",
        "uninstalled_at_sfdc": "2023-12-12T14:25:05+00:00"
      },
      "1.triplewhale-1": {
        "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": 78,
        "technology": "Triple Whale"
      }
    },
    "avg_price": 7326,
    "avg_price_usd": 7326,
    "avg_weight": 590,
    "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": 114740,
    "contact_info": [
      {
        "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": "pinterest",
        "url": "https://www.pinterest.com/khybrand",
        "value": "khybrand"
      },
      {
        "followers": 139,
        "type": "youtube",
        "url": "https://www.youtube.com/@Khybrand",
        "value": "khybrand"
      },
      {
        "followers": 114600,
        "type": "tiktok",
        "url": "https://www.tiktok.com/@khy",
        "value": "@khy"
      },
      {
        "followers": 1,
        "type": "twitter",
        "url": "https://twitter.com/khybrand",
        "value": "khybrand"
      },
      {
        "type": "email",
        "value": "support@khy.com"
      },
      {
        "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"
      }
    ],
    "contact_page_url": "https://www.khy.com/pages/contact",
    "copyright": "K Brand, Inc",
    "country_code": "US",
    "currency_code": "USD",
    "estimated_page_views": 1442265,
    "estimated_sales": 145909192,
    "estimated_visits": 393302,
    "faq_page_url": "https://www.khy.com/pages/faq",
    "features": [
      "Shopify POS",
      "Returns Page",
      "Shopify Online Store 2.0",
      "New Shopify Checkout (2022)",
      "Accepts Gift Cards",
      "Contact Page",
      "Tracking or Returns",
      "International Shipping",
      "Signature Required",
      "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": 0,
    "plan": "Shopify Plus",
    "platform": "shopify",
    "platform_rank": 5,
    "postal_code": "",
    "product_count": 599,
    "products_created_30": 0,
    "products_created_365": 523,
    "products_created_90": 94,
    "rank": 68,
    "retailer_page_url": "",
    "returns_page_url": "https://www.khy.com/pages/returns",
    "shopify_app_names": [
      "Accessibly",
      "Back in Stock: Restock Alerts",
      "Bazaarvoice Reviews \u0026 Photos",
      "Checkout Blocks",
      "Elevar Conversion Tracking",
      "Gorgias",
      "Klaviyo: Email Marketing \u0026 SMS",
      "Locksmith",
      "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",
      "gtm-datalayer-by-elevar",
      "helpdesk",
      "klaviyo-email-marketing",
      "locksmith",
      "okendo-reviews",
      "optoro-returns",
      "route",
      "triplewhale-1"
    ],
    "state": "Active",
    "store_locator_page_url": "",
    "technologies": [
      "Apple Pay",
      "Arrive",
      "Baazarvoice",
      "Cloudflare",
      "Cloudflare CDN",
      "Elevar",
      "Global-e",
      "Google Ads Pixel",
      "Google Adsense",
      "Google Pay",
      "Google Tag Manager",
      "Gorgias",
      "Klaviyo",
      "Okendo",
      "Optoro",
      "PayPal Express Checkout",
      "Route",
      "Shop Pay",
      "TikTok Pixel",
      "Triple Whale"
    ],
    "technology_details": {
      "Afterpay": {
        "installed_at": "2023-11-04T04:40:27Z",
        "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
        "name": "Afterpay",
        "uninstalled_at": "2024-01-31T01:29:14Z",
        "uninstalled_at_sfdc": "2024-01-31T01:29:14+00:00"
      },
      "Apple Pay": {
        "installed_at": "2023-11-04T04:40:27Z",
        "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
        "name": "Apple Pay"
      },
      "Arrive": {
        "installed_at": "2024-02-15T04:15:31Z",
        "installed_at_sfdc": "2024-02-15T04:15:31+00:00",
        "name": "Arrive"
      },
      "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": {
        "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": {
          "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": 623,
          "technology": "Baazarvoice"
        }
      },
      "Cloudflare": {
        "installed_at": "2023-11-04T04:40:27Z",
        "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
        "name": "Cloudflare"
      },
      "Cloudflare CDN": {
        "installed_at": "2023-11-04T04:40:27Z",
        "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
        "name": "Cloudflare CDN"
      },
      "Elevar": {
        "installed_at": "2024-10-30T18:26:56Z",
        "installed_at_sfdc": "2024-10-30T18:26:56+00:00",
        "name": "Elevar"
      },
      "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": {
        "installed_at": "2023-11-04T04:40:27Z",
        "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
        "name": "Global-e"
      },
      "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": {
        "installed_at": "2023-11-04T04:40:27Z",
        "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
        "name": "Google Adsense"
      },
      "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": {
        "installed_at": "2023-11-04T04:40:27Z",
        "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
        "name": "Google Tag Manager"
      },
      "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": {
          "categories": [
            "chat",
            "helpdesk"
          ],
          "installed_at": "2023-11-04T04:40:27Z",
          "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
          "name": "Gorgias",
          "platform": "shopify",
          "platform_install_rank": 95,
          "technology": "Gorgias"
        }
      },
      "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": {
          "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": 4,
          "technology": "Klaviyo"
        }
      },
      "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": {
          "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": 128,
          "technology": "Okendo"
        }
      },
      "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": {
        "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": {
          "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": 3452,
          "technology": "Optoro"
        }
      },
      "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": {
        "installed_at": "2023-11-04T04:40:27Z",
        "installed_at_sfdc": "2023-11-04T04:40:27+00:00",
        "name": "PayPal Express Checkout"
      },
      "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": {
          "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": 139,
          "technology": "Route"
        }
      },
      "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": {
        "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": {
          "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": 2844,
          "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": {
        "installed_at": "2024-11-13T17:19:33Z",
        "installed_at_sfdc": "2024-11-13T17:19:33+00:00",
        "name": "TikTok Pixel"
      },
      "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": {
          "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": 78,
          "technology": "Triple Whale"
        }
      },
      "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": {
        "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": 114600,
    "tracking_page_url": "",
    "twitter_followers": 1,
    "warranty_page_url": "",
    "youtube_followers": 139
  },
  "now": "2024-11-21T06:23:25.668086376Z"
}

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:

_salesforce.Id
Refers to the Id field on the Account SObject in Salesforce.
_salesforce.ParentId
Refers to the ParentId field on the Account SObject in Salesforce.

With the HubSpot integration, Company properties are accessible under the _hubspot key. For instance:

_hubspot.domain
Refers to the domain property on the Company record in HubSpot.

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).