---
schema_version: "1"
id: 0673e3ab55975edc862b1f1937b6619b338a3331f902b6cd8b76fb9e37863e1d
title: Custom Collaboration Template Sample JSON
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_crc_custom_collab_template_json.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_crc_custom_collab_template_json.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 6f841d39dbc59d85579243ae766bd82144e8a040ccc020893c98fb06caedcb9b
description: Copy the template code below or download it directly in Data 360 to begin creating your custom template. Fill in the required and optional fields with appropriate values.
products:
  - Data 360
release: "264"
---
# Custom Collaboration Template Sample JSON

Copy the template code below or download it directly in Data 360 to begin creating your custom template. Fill in the required and optional fields with appropriate values.

```
 "name": "CustomTemplateExample",
  "description": "Example of Clean Room Customized Templates",
  "tables": {
    "tableConfigs": [
      {
        "name": "Provider",
        "description": "Provider table for overlap use case.",
        "role": "Provider",
        "columns": [
          {
            "name": "SegmentName",
            "description": "Name of the segment.",
            "type": "STRING"
          },
          {
            "name": "Category",
            "description": "Category of the segment.",
            "type": "STRING"
          },
          {
            "name": "ParentCategory",
            "description": "Parent Category of the segment.",
            "type": "STRING"
          },
          {
            "name": "SegmentSize",
            "description": "Size of the segment.",
            "type": "INTEGER"
          },
          {
            "name": "MemberId",
            "description": "Member ID, only aggregation or join is allowed.",
            "type": "STRING"
          },
          {
            "name": "HashedEmailAddress",
            "description": "Contact ID hashed with SHA256.",
            "type": "HASHED_EMAIL"
          }
        ]
      },
      {
        "name": "Consumer",
        "description": "Consumer table.",
        "role": "Consumer",
        "columns": [
          {
            "name": "SegmentId",
            "description": "ID of the Segment.",
            "type": "STRING"
          },
          {
            "name": "SegmentName",
            "description": "Name of the segment.",
            "type": "STRING"
          },
          {
            "name": "SegmentSize",
            "description": "Size of the segment.",
            "type": "NUMBER"
          },
          {
            "name": "HashedEmailAddress",
            "description": "Contact ID hashed with SHA256.",
            "type": "HASHED_EMAIL"
          }
        ]
      }
    ]
  },
  "queries": {
    "queryConfigs": [
      {
        "name": "OverlapQuery",
        "useCase": "Overlap",
        "description": "Query to calculate the overlap between consumers and providers.",
        "type": "SQL",
        "source": "SELECT  Consumer.SegmentId AS Segment_Id__c,  Consumer.SegmentName AS Segment_Name__c,  Provider.SegmentName AS Provider_Segment_Name__c,  Provider.Category AS Provider_Segment_Category__c,  Provider.ParentCategory AS Provider_Segment_Parent_Category__c,  Provider.SegmentSize AS Provider_Segment_Size__c,  Consumer.SegmentSize AS Segment_Size__c,  COUNT(DISTINCT Provider.MemberId) AS Matching_Population_Count__c FROM  Consumer JOIN  Provider ON Consumer.HashedEmailAddress = Provider.HashedEmailAddress GROUP BY Consumer.SegmentId, Consumer.SegmentName, Provider.SegmentName, Provider.Category, Provider.ParentCategory, Provider.SegmentSize, Consumer.SegmentSize HAVING COUNT(DISTINCT Provider.MemberId) >= :threshold_count",
        "queryParameters": {
          "queryParamConfigs": [
            {
              "name": "threshold_count",
              "type": "INTEGER",
              "description": "The threshold count."
            }
          ]
        },
        "referencedTables": [
          "Consumer",
          "Provider"
        ]
      }
    ]
  }
}

```