Granular Data Center Overview in Marketing Cloud Intelligence
Thank you for reading this post, don't forget to subscribe!The Granular Data Center is an advanced feature tailored for ingesting detailed, raw data into the system. This data can reach a scale of hundreds of millions or even billions of rows due to its granularity. Unlike other data stream types, usage and pricing are based on terabytes of storage rather than row count. Ideal data types for Granular Data Center streams include keyword-level data, event-level data, logs, and precise geodata.
Granular Data Center streams generate corresponding tables of data specific to a workspace.
All data stored in the Granular Data Center fully complies with GDPR regulations and requirements.
The Granular Data Center is a premium feature. For inquiries about purchasing, please contact a Marketing Cloud Intelligence representative at Salesforce.
Deprovisioning the Granular Data Center add-on from an account triggers the following actions:
- The Granular Data Center tab disappears from the left pane.
Note: System admins and higher can still access the Granular Data Center for 90 days after unchecking the checkbox. Access will be unavailable after this period.
- Granular Data Center streams and retrievals cease and fail.
- Queries related to Granular Data Center data (from reports, widgets, or via API, including scheduled tasks) also stop and fail.
Note: System admins and higher can continue running SQL queries and exports for 90 days. After this period, all Granular Data Center data streams are automatically deleted, along with the data.
When retrieving data from the Granular Data Center, be mindful of these timeout limits:
- Direct retrievals: 1 hour
- SFMC granular data extensions: 2 hours
- Retrieval from Granular Data Center into another Granular Data Center: 40 minutes (with builder query), 1 hour (with SQL query)
- DB retrievals: 30 minutes
Enabling the Granular Data Center in a Workspace
Purchasing the Granular Data Center automatically activates it in the account, but an admin must enable it in the workspace to make the Granular Data Center tab visible.
Viewing Granular Data Center Data
The Granular Data Center landing page provides an overview of all created data streams in that workspace. Users can manage ingested data, aggregations, extracted data, share data streams, create queries, and more from this centralized location.
Creating Granular Data Center Data Streams
Generate a Granular Data Center data stream to ingest detailed data, such as event-level or keyword-level data.
Mapping Granular Data Center Data
Upon file upload or usage of a technical vendor, users are directed to a mapping preview screen where they can verify data identification, modify mapping, add mapping formulas, and more. Each uploaded dataset creates a dynamic table tailored to the loaded data type, impacting data load options and behavior.
Querying Granular Data Centers
Access and extract data from Granular Data Centers within your workspace. Users can also query Granular Data Centers in other workspaces via data sharing. Queries can be manually crafted using an SQL editor or created effortlessly with the Query Builder.
Visualizing Granular Data Center Data
The Entity-Relationship Diagram (ERD) visually represents tables and connections between specific dimensions. Each block symbolizes a table containing available fields, with lines denoting connections between tables based on specific dimensions.
Sharing Granular Data Centers
Relevant Granular Data Centers can be shared across workspaces within the same account.
Deleting Data from a Granular Data Center
To align with data protection regulations, users have the option to delete data from a Granular Data Center.
Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more
In Marc Benioff's own words How did salesforce.com grow from a start up in a rented apartment into the world's Read more
Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more
Following swiftly after last week's successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more
