In the modern business realm, data is the cornerstone of insightful decision-making and strategic maneuvering. For entities operating within the Salesforce ecosystem, the Salesforce Data Cloud emerges as a potent tool to harness the expansive data realm. One of its remarkable functionalities is the Website Ingestion feature, which allows businesses to ingest and structure website data effortlessly. In this endeavor, the utilization of JSON schema and XML sitemap plays a pivotal role, paving the path for seamless data ingestion and analysis.

At Hexlit, we specialize in unraveling the potential of Salesforce Data Cloud for our clientele, ensuring they ride the wave of data-driven operations. Let’s delve into a high-level walkthrough of how the Website Ingestion functionality can be set in motion:

Step 1: Understanding the Prerequisites

Before embarking on the website ingestion journey, ensure you have a clear understanding of the website structure, data points to be captured, and how they align with your Salesforce objectives.

Step 2: Crafting the JSON Schema

The JSON schema serves as the blueprint for your data ingestion process. It defines the structure, types, and validation rules for the data.


"type": "object",
"properties": {
"pageURL": {
"type": "string",
"format": "uri"
"pageTitle": {
"type": "string"
"metaDescription": {
"type": "string"
// ...other properties
"required": ["pageURL", "pageTitle"]

This rudimentary schema illustrates the setup for ingesting basic website data like the page URL, title, and meta description.

Step 3: Preparing the XML Sitemap

The XML sitemap guides the ingestion process on the pages to be crawled and analyzed. Ensure it is comprehensive and updated to reflect your website’s current structure.

<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="">
<!-- ...other URLs -->

Step 4: Configuring Website Ingestion in Salesforce Data Cloud

With the JSON schema and XML sitemap at hand, navigate to the Salesforce Data Cloud and configure the Website Ingestion settings. Upload the schema and sitemap, and define other necessary parameters to align with your data goals.

Step 5: Monitoring and Analyzing the Ingested Data

Once the ingestion process is set in motion, monitor its progress, and upon completion, dive into the analysis. Utilize the structured data to glean insights, refine strategies, and drive informed decisions.

This process elucidates a simplified pathway towards leveraging Website Ingestion functionality of Salesforce Data Cloud. At Hexlit, we extend our expertise to assist businesses in navigating this pathway, ensuring they are well-poised to capitalize on the data at their disposal. Through meticulous schema design, accurate sitemap preparation, and adept Salesforce Data Cloud configuration, we propel businesses into a data-empowered future.