{"id":100230,"date":"2025-05-19T11:09:09","date_gmt":"2025-05-19T05:39:09","guid":{"rendered":"https:\/\/cloudfoundation.com\/blog\/?p=100230"},"modified":"2025-05-19T11:43:25","modified_gmt":"2025-05-19T06:13:25","slug":"a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence","status":"publish","type":"post","link":"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/","title":{"rendered":"A Tutorial on Parent-Child Relationship in Marketing Cloud Intelligence"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.9.7&#8243;][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.9.7&#8243; title_font=&#8221;Times New Roman||||||||&#8221; title_text_align=&#8221;left&#8221; title_text_color=&#8221;#000000&#8243; title_font_size=&#8221;47&#8243; background_color=&#8221;RGBA(0,0,0,0)&#8221; background_enable_image=&#8221;off&#8221; custom_margin=&#8221;|||10%&#8221; title_font_size_tablet=&#8221;40&#8243; title_font_size_phone=&#8221;35&#8243; title_font_size_last_edited=&#8221;on|desktop&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;]<\/p><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Understanding_Overarching_Entities_in_Datorama\" >Understanding Overarching Entities in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#How_Datorama_Handles_Custom_Classifications\" >How Datorama Handles Custom Classifications<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Workspace-Level_Entities_in_Datorama\" >Workspace-Level Entities in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Mapping_Relationships_in_Datorama\" >Mapping Relationships in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Combining_Data_Streams_in_Datorama\" >Combining Data Streams in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Understanding_Datorama_for_Brand_Mapping\" >Understanding Datorama for Brand Mapping<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Understanding_Parent-Child_Relationships_in_Datorama\" >Understanding Parent-Child Relationships in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#How_to_Merge_Data_Streams_in_Datorama\" >How to Merge Data Streams in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Mapping_Attributes_in_Datorama\" >Mapping Attributes in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Visualising_Data_with_Datorama\" >Visualising Data with Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Advanced_Features_in_Datorama\" >Advanced Features in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Understanding_Hierarchy_in_Datorama\" >Understanding Hierarchy in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Parent-Child_Relationships_in_Datorama\" >Parent-Child Relationships in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Setting_Up_Parent-Child_Relationships_in_Datorama\" >Setting Up Parent-Child Relationships in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Applying_Join_Operations_in_Datorama\" >Applying Join Operations in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Visualising_Parent-Child_Data_in_Datorama\" >Visualising Parent-Child Data in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Exploring_Different_Parent-Child_Scenarios_in_Datorama\" >Exploring Different Parent-Child Scenarios in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Understanding_Datoramas_Parent-Child_Relationship\" >Understanding Datorama&#8217;s Parent-Child Relationship<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Hierarchies_in_Datorama\" >Hierarchies in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Editing_Parent-Child_Assignments_in_Datorama\" >Editing Parent-Child Assignments in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Applying_Hierarchy_Across_Entities_in_Datorama\" >Applying Hierarchy Across Entities in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#The_Importance_of_Hierarchy_in_Datorama\" >The Importance of Hierarchy in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Essential_Factors_in_Parent-Child_Structure\" >Essential Factors in Parent-Child Structure<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Validating_Parent-Child_Setup_in_Datorama\" >Validating Parent-Child Setup in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Understanding_Data_Streams_in_Datorama\" >Understanding Data Streams in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Maintaining_Hierarchies_in_Datorama\" >Maintaining Hierarchies in Datorama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#Handling_Attribute_Updates_in_Datorama\" >Handling Attribute Updates in Datorama<\/a><\/li><\/ul><\/nav><\/div>\n\n<h2><span class=\"ez-toc-section\" id=\"Understanding_Overarching_Entities_in_Datorama\"><\/span><strong><span>Understanding Overarching Entities in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Overarching entities in Datorama play a crucial role in classifying data shared across multiple streams within a data model, including search, social media, web, and programmatic sources, thereby providing seamless unification. <\/span><\/p>\n<p><span>Essentially, this ensures that sales data, plan data, and media insights all integrate seamlessly into a single, cohesive structure in Datorama.<\/span><\/p>\n<p><span>Datorama can help unify web <a href=\"https:\/\/cloudfoundation.com\/blog\/adobe-analytics-training\/\" target=\"_blank\" rel=\"noopener\"><strong>analytics with conversion data<\/strong><\/a> or Facebook ad insights.<\/span><\/p>\n<p><span>However, not all fields align seamlessly across data streams.<\/span><\/p>\n<p><span>By offering overarching entities that ensure your workspace stays organised while all points align without duplication or confusion.<\/span><br \/>\n<video poster=\"https:\/\/cloudfoundation.com\/blog\/wp-content\/plugins\/a3-lazy-load\/assets\/images\/lazy_placeholder.gif\" src=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/05\/Data-Classification-Overview.webm\" autoplay=\"autoplay\" loop=\"loop\" muted=\"\" width=\"800\" height=\"auto\"><\/video><\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_Datorama_Handles_Custom_Classifications\"><\/span><strong><span>How Datorama Handles Custom Classifications<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>The relationship between custom classifications and overarching entities in Datorama. <\/span><\/p>\n<p><span>Custom classifications function as attributes of your central entity.<\/span><\/p>\n<p><span>For instance, if the entity is Media Buy, then custom classification becomes its defining feature, ensuring clarity and preventing data mismatches in your streams.<\/span><\/p>\n<p><span>Datorama&#8217;s custom classifications can serve a multitude of functions. <\/span><\/p>\n<p><span>From linking media buys with specific brands or devices to matching device categories with ad data, these classifications ensure consistency across entities such as browser type, geolocation, or product category. <\/span><\/p>\n<p><span>Each attribute plays its part by providing clarity regarding qualities associated with an entity, such as browser type or geolocation information.<\/span>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Workspace-Level_Entities_in_Datorama\"><\/span><strong><span>Workspace-Level Entities in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>A key highlight of Datorama is its management of workspace-level entities. <\/span><\/p>\n<p><span>These entities exist independently of the data stream that introduced them. <\/span><\/p>\n<p><span>Even if you delete a data stream, the overarching entities remain intact. <\/span><\/p>\n<p><span>This design ensures that classifications remain consistent and accessible, preventing accidental data loss.<\/span><\/p>\n<p><span>For instance, attributes such as device category, browser, geo-targeting, or product details are tied to your workspace, not the individual streams. <\/span><\/p>\n<p><span>This gives you flexibility in managing your data without worrying about disrupting the overarching structure Datorama provides.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mapping_Relationships_in_Datorama\"><\/span><strong><span>Mapping Relationships in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Let&#8217;s examine mapping relationships within Datorama. <\/span><\/p>\n<p><span>A fundamental rule states that every custom classification must have one-to-one relationships with its central entity.<\/span><\/p>\n<p><span>For instance, media buy keys are linked exclusively with one brand without overlaps or multiple values being present.<\/span><\/p>\n<p><span><img decoding=\"async\" width=\"800\" height=\"1996\" src=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/05\/Datorama-Entity-Management.png\" alt=\"SalesForce Datorama Training\" class=\"size-medium aligncenter\"><\/span><\/p>\n<p><span>Datorama can facilitate complex data mappings efficiently while remaining clear through its structure, thanks to entities with many-to-many relationships, such as device categories or geolocations, which feature many attributes per entity. <\/span><\/p>\n<p><span>With such flexibility at their disposal, Datorama can effectively handle intricate mapping processes while maintaining a structured approach.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Combining_Data_Streams_in_Datorama\"><\/span><strong><span>Combining Data Streams in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Datorama makes connecting diverse data streams easy, think advertising datasets with media buy keys or social data with post-level details. <\/span><\/p>\n<p><span>All it takes to unite these streams for actionable insights is finding common ground between them.<\/span><\/p>\n<p><span>Datorama helps unify data streams by mapping attributes such as device categories or brands across them.<\/span><\/p>\n<p><span>For instance, mapping an attribute associated with a media buy key to an attribute within an ad dataset.<\/span><\/p>\n<p><span>Similarly, web <a href=\"https:\/\/cloudfoundation.com\/salesforce-crm-analytics-training\/\" target=\"_blank\" rel=\"noopener\"><strong>analytics data can match up<\/strong><\/a> with media insights by recognising shared attributes, making Datorama invaluable when it comes to unification efforts.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Understanding_Datorama_for_Brand_Mapping\"><\/span><strong><span>Understanding Datorama for Brand Mapping<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span><a href=\"https:\/\/cloudfoundation.com\/blog\/adobe-analytics-interview-questions\/\" target=\"_blank\" rel=\"noopener\"><strong>Working with Web Analytics data<\/strong><\/a> often presents me with the challenge of mapping brands to media using custom attributes. <\/span><\/p>\n<p><span>At first, this seems straightforward: connect the dots between brand and media using custom attributes, and everything should fall into place.<\/span><\/p>\n<p><span>However, when I check my Web Analytics data stream, I find no trace of media by custom, which creates roadblocks.<\/span><\/p>\n<p><span>Without media by custom attributes in Web Analytics, my plan quickly unravelled. <\/span><\/p>\n<p><span>Since they don&#8217;t exist there, my plan collapsed into chaos. <\/span><\/p>\n<p><span>That&#8217;s where Datorama proved invaluable. Datorama allows me to implement custom classifications that cover all data stream types.<\/span><\/p>\n<p><span>Initially, I extracted the brand from Web Analytics and mapped it to custom classification one.<\/span><\/p>\n<p><span>Simultaneously, I performed the same operation for ads by mapping both to this same custom classification. <\/span><\/p>\n<p><span>Custom classification serves as my bridge across different datasets by consistently representing my brand column across them all. <\/span><\/p>\n<p><span>When combined, the columns from media by campaign and Web Analytics merge seamlessly.<\/span><\/p>\n<p><span><img decoding=\"async\" width=\"800\" height=\"945\" src=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/05\/Brand-Mapping.png\" alt=\"SalesForce Datorama Training\" class=\"size-medium aligncenter\"><\/span><\/p>\n<p><span>Datorama makes classification simple.<\/span><\/p>\n<p><span>Once I provide Datorama with my list of brand categories, they ensure that each brand is classified accordingly, whether using ABC or ABB classification, to provide clarity and consistency across my data sets.<\/span><\/p>\n<p><span>Now it is crucial to realise Datorama allows mapping at multiple levels. <\/span><\/p>\n<p><span>I have previously established that brands are typically attributes of media by key, with direct ties connecting their custom classification to this relationship. <\/span><\/p>\n<p><span>Furthermore, each attribute will require its classification sheet so that all data points are appropriately categorised within Datorama&#8217;s structure.<\/span><\/p>\n<p><span>Practically, I utilise custom classification one level one as an additional layer of classification.<\/span><\/p>\n<p><span>Integrating all three data sets within Datorama enables me not only to classify but also to maintain hierarchical relationships within my data.<\/span><\/p>\n<p><span>Datorama&#8217;s classification system makes the transition seamless, and I can categorise all data streams effectively within its umbrella framework. <\/span><\/p>\n<p><span>With Datorama&#8217;s seamless management of classifications, my analytics workflow becomes streamlined and indispensable.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Understanding_Parent-Child_Relationships_in_Datorama\"><\/span><strong><span>Understanding Parent-Child Relationships in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Datorama&#8217;s parent-child feature can be an indispensable asset. <\/span><\/p>\n<p><span>Imagine two data streams that need to merge but lack a common thread. <\/span><\/p>\n<p><span>Datorama&#8217;s parent-child feature helps join these streams based on shared dimensions, seamlessly cutting measurements and dimensions across all dimensions.<\/span><br \/>\n<video poster=\"https:\/\/cloudfoundation.com\/blog\/wp-content\/plugins\/a3-lazy-load\/assets\/images\/lazy_placeholder.gif\" src=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/05\/Data-Stream-Merging.webm\" autoplay=\"autoplay\" loop=\"loop\" muted=\"\" width=\"800\" height=\"auto\"><\/video><\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_to_Merge_Data_Streams_in_Datorama\"><\/span><strong><span>How to Merge Data Streams in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Imagine two data streams sharing similarities, such as media by key. <\/span><\/p>\n<p><span>Datorama enables us to combine them into a single central pool of data by merging both streams into an aggregate parent-child structure, which simplifies the merging process.<\/span><\/p>\n<p><span>By uploading datasets containing details such as media by colour, tactic, and impressions to Datorama&#8217;s platform, you can effortlessly map these attributes, turning complex raw data into actionable insights.<\/span>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#064399&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#0095f2&#8243; background_color_gradient_end=&#8221;#7dbed8&#8243; background_color_gradient_direction=&#8221;92deg&#8221; background_color_gradient_start_position=&#8221;35%&#8221; background_color_gradient_end_position=&#8221;80%&#8221; transform_scale=&#8221;73%|62%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;-53px|-50px&#8221; transform_translate_linked=&#8221;off&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; link_option_url_new_window=&#8221;on&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/06\/SS_436-_Converted_-1.png&#8221; url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; url_new_window=&#8221;on&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_scale=&#8221;114%|112%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;25px|-4px&#8221; transform_translate_linked=&#8221;off&#8221; width=&#8221;98.1%&#8221; custom_margin=&#8221;|7px|||false|false&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;Georgia|700|||||||&#8221; text_font_size=&#8221;23px&#8221; text_line_height=&#8221;1.3em&#8221; header_font=&#8221;Georgia|700|||||||&#8221; header_font_size=&#8221;21px&#8221; header_letter_spacing=&#8221;-1px&#8221; header_line_height=&#8221;2em&#8221; transform_scale=&#8221;171%|159%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;40px|44px&#8221; transform_translate_linked=&#8221;off&#8221; transform_origin=&#8221;70%|50%&#8221; z_index=&#8221;-161&#8243; width=&#8221;100%&#8221; custom_margin=&#8221;|-215px||||&#8221; custom_padding=&#8221;|0px||||&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; link_option_url_new_window=&#8221;on&#8221;]<\/p>\n<h1 style=\"text-align: center;\"><span style=\"color: #ffffff;\">Datorama Training<\/span><\/h1>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Explore Course Content&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#0C71C3&#8243; button_bg_color=&#8221;#FFFFFF&#8221; button_font=&#8221;|700|||||||&#8221; transform_translate=&#8221;64px|65px&#8221; transform_translate_linked=&#8221;off&#8221;][\/et_pb_button][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2019\/06\/logo_resize_color.png&#8221; url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; url_new_window=&#8221;on&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_translate=&#8221;-36px|0px&#8221; transform_translate_linked=&#8221;off&#8221; custom_margin=&#8221;|||178px||&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mapping_Attributes_in_Datorama\"><\/span><strong><span>Mapping Attributes in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span><a href=\"https:\/\/cloudfoundation.com\/datorama-training\" target=\"_blank\" rel=\"noopener\"><strong>Datorama offers exceptional mapping<\/strong><\/a> capabilities. <\/span><\/p>\n<p><span>When I want to map unique attributes, such as media by colour, using custom attribute fields, they are indispensable for accurately assigning these unique identifiers to my shared data pool. <\/span><\/p>\n<p><span>Aligning all dimensions ensures accuracy. Datorama offers model field properties to further refine my data. <\/span><\/p>\n<p><span>I find changing display names of attributes, such as media by colour, easier for <a href=\"https:\/\/cloudfoundation.com\/blog\/workday-reporting-interview-question-and-answers\/\" target=\"_blank\" rel=\"noopener\"><strong>reporting and visualisation<\/strong><\/a> without impacting aggregate accuracy.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Visualising_Data_with_Datorama\"><\/span><strong><span>Visualising Data with Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Datorama makes visualising data simple. I found it effortless when merging streams without proper mapping.<\/span><\/p>\n<p><span>However, by setting default values during data harmonisation, Datorama ensures all dimensions and metrics align seamlessly and create coherent visuals.<\/span><\/p>\n<p><span><img decoding=\"async\" width=\"800\" height=\"3064\" src=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/05\/Datorama-Mapping.png\" alt=\"SalesForce Datorama Training\" class=\"size-medium aligncenter\"><\/span><\/p>\n<p><span><a href=\"https:\/\/cloudfoundation.com\/blog\/salesforce-datorama-certification\/\" target=\"_blank\" rel=\"noopener\"><strong>Datorama provides tools<\/strong><\/a> that enable me to combine datasets of clicks and impressions, along with media by colour, for analysis purposes. <\/span><\/p>\n<p><span>I regularly utilise Datorama&#8217;s platform to refine and verify our data for more in-depth, insightful analyses.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Advanced_Features_in_Datorama\"><\/span><strong><span>Advanced Features in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Datorama goes beyond simple merging; it optimises. <\/span><\/p>\n<p><span>By exploring parent-child relationships, I&#8217;ve managed to structure data in ways that eliminate redundancies while improving clarity. <\/span><\/p>\n<p><span>Attributes such as custom fields and model properties have also enhanced this experience.<\/span><\/p>\n<p><span>Datorama provides me with flexibility when managing text, dates and images within datasets. <\/span><\/p>\n<p><span>With its model field properties, I can fine-tune data accuracy across reports.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Understanding_Hierarchy_in_Datorama\"><\/span><strong><span>Understanding Hierarchy in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Datorama excels at organising data hierarchically, <a href=\"https:\/\/cloudfoundation.com\/blog\/data-modeling-interview-questions-and-answers\" target=\"_blank\" rel=\"noopener\"><strong>data modelling<\/strong><\/a> professionals know this well. <\/span><\/p>\n<p><span>At Datorama, data is organised with complete hierarchy classification systems in mind to ensure media buys, campaigns, and sites can all be appropriately classified.<\/span><\/p>\n<p><span>Datorama excels at managing complex data streams, including entire hierarchies that encompass media buys, campaigns, and site elements.<\/span><\/p>\n<p><span>This allows us to structure parent-child relationships for greater business efficiency.<\/span><\/p>\n<p><span>Datorama recognises that data streams with entire hierarchies tend to outshine those with lesser or no hierarchy. <\/span><\/p>\n<p><span>Accordingly, we refer to those data streams with complete hierarchies as parents, while any lacking hierarchies are referred to as children.<\/span><\/p>\n<p><span><img decoding=\"async\" width=\"800\" height=\"1066\" src=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/05\/Data-Hierarchy.png\" alt=\"SalesForce Datorama Training\" class=\"size-medium aligncenter\"><\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Parent-Child_Relationships_in_Datorama\"><\/span><strong><span>Parent-Child Relationships in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Datorama follows an inheritance model, where children inherit some or all of their parents&#8217; attributes. <\/span><\/p>\n<p><span>When a data stream includes both the media buy key and name, as well as the campaign key, name, and site key, along with site name information. <\/span><\/p>\n<p><span>It takes precedence over those that only contain this data, such as media buy key-only or media name-only data streams.<\/span><\/p>\n<p><span>Datorama uses default values when child data streams lack campaign or site values to maintain clean mapping within Datorama. <\/span><\/p>\n<p><span>When mapping occurs in Datorama without error, this ensures an efficient process.<\/span><\/p>\n<p><span>Datorama data structures cannot tolerate data streams with limited hierarchies taking control of an entirely hierarchical one, otherwise, errors and incorrect values will inevitably appear, dissolving their data structure altogether.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Setting_Up_Parent-Child_Relationships_in_Datorama\"><\/span><strong><span>Setting Up Parent-Child Relationships in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Establishing parent-child relationships within Datorama requires careful assessment. <\/span><\/p>\n<p><span>Consider two data streams, one with complex hierarchical structures and another that only contains media buy key and name pairs.<\/span><\/p>\n<p><span>Utilising Datorama&#8217;s parent-child feature, we identify an overarching hierarchical data stream as its parent to facilitate seamless attribute <a href=\"https:\/\/cloudfoundation.com\/blog\/workday-integration-training\/\" target=\"_blank\" rel=\"noopener\"><strong>integration across datasets<\/strong><\/a>.<\/span><\/p>\n<p><span>Datorama takes excellent care in mapping parent-child relationships correctly, and values will flow smoothly as expected if we match media buys with each other correctly.<\/span><br \/>\n<video poster=\"https:\/\/cloudfoundation.com\/blog\/wp-content\/plugins\/a3-lazy-load\/assets\/images\/lazy_placeholder.gif\" src=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/05\/Datorama-Hierarchy-Setup.webm\" autoplay=\"autoplay\" loop=\"loop\" muted=\"\" width=\"800\" height=\"auto\"><\/video><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Applying_Join_Operations_in_Datorama\"><\/span><strong><span>Applying Join Operations in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Datorama works similarly to Excel when setting up parent-child relationships by mapping IDs across <a href=\"https:\/\/cloudfoundation.com\/informatica-idq-training\/\" target=\"_blank\" rel=\"noopener\"><strong>datasets to ensure<\/strong><\/a> a proper hierarchy flow.<\/span><\/p>\n<p><span>Joins are central to Datorama&#8217;s set-up. Parent-child relationships serve as full outer joins that bring all relevant data together into an organised structure.<\/span><\/p>\n<p><span>Parent-child joins are essential in maintaining the hierarchy within Datorama and ensuring that media buy keys are aligned correctly, thereby preventing data loss or incorrect default values from taking effect.<\/span>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Visualising_Parent-Child_Data_in_Datorama\"><\/span><strong><span>Visualising Parent-Child Data in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Once parent-child relationships are set up in Datorama, data visualisation tools provide a quick way to explore them via media buy keys, attributes, impressions, and clicks. <\/span><\/p>\n<p><span>Incorporating Datorama&#8217;s visualisation tools further ensures all attributes, tactics and colours are correctly placed within their hierarchy.<\/span><\/p>\n<p><span>Given that Datorama doesn&#8217;t enforce hierarchy automatically, we need to apply strategic structuring techniques to assign appropriate parent-child relationships and analyse accurate data sets.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Exploring_Different_Parent-Child_Scenarios_in_Datorama\"><\/span><strong><span>Exploring Different Parent-Child Scenarios in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Datorama enables us to easily establish &#8220;parent-child relationships within entities,&#8221; aligning data streams for optimal performance. <\/span><\/p>\n<p><span>Another approach in Datorama is &#8220;parent-child mapping across datasets&#8221;.<\/span><\/p>\n<p><span><img decoding=\"async\" width=\"800\" height=\"2714\" src=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/05\/Datorama-Structure.png\" alt=\"SalesForce Datorama Training\" class=\"size-medium aligncenter\"><\/span><\/p>\n<p><span>By creating hierarchies within datasets, we ensure effective structuring.<\/span><\/p>\n<p><span>With Datorama&#8217;s Parent-Child feature, media buy keys, campaign attributes, and site relationships can be managed effortlessly for accurate analysis and reporting.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Understanding_Datoramas_Parent-Child_Relationship\"><\/span><strong><span>Understanding Datorama&#8217;s Parent-Child Relationship<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span><a href=\"https:\/\/cloudfoundation.com\/blog\/salesforce-datorama\/\" target=\"_blank\" rel=\"noopener\"><strong>Datorama simplifies data management<\/strong><\/a> with parent-child relationships, allowing for easy organisation of data streams by editing child streams directly, rather than editing parent streams. <\/span><\/p>\n<p><span>When editing, always focus on editing the child rather than the parent streams when working with streams of information.<\/span><\/p>\n<p>Let&#8217;s consider an example in which PC1 has been assigned as the parent and PC2 as its child; then, adjustments made through Datorama need to be refreshed before their changes take effect.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#064399&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#ff8c7c&#8221; background_color_gradient_end=&#8221;#e5ba4e&#8221; background_color_gradient_type=&#8221;radial&#8221; background_color_gradient_direction_radial=&#8221;top left&#8221; background_color_gradient_start_position=&#8221;35%&#8221; background_color_gradient_end_position=&#8221;80%&#8221; transform_scale=&#8221;74%|69%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;-53px|-50px&#8221; transform_translate_linked=&#8221;off&#8221; custom_margin=&#8221;||-5px||false|false&#8221; custom_padding=&#8221;|||2px|false|false&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; link_option_url_new_window=&#8221;on&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/06\/8423118_3895895.png&#8221; url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; url_new_window=&#8221;on&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;85.4%&#8221; custom_margin=&#8221;-31px||-24px||false|false&#8221; custom_padding=&#8221;|22px|0px||false|false&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;Georgia|700|||||||&#8221; text_font_size=&#8221;23px&#8221; text_line_height=&#8221;1.3em&#8221; header_font=&#8221;Georgia|700|||||||&#8221; header_font_size=&#8221;19px&#8221; header_letter_spacing=&#8221;-1px&#8221; header_line_height=&#8221;1.2em&#8221; transform_scale=&#8221;171%|159%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;40px|44px&#8221; transform_translate_linked=&#8221;off&#8221; transform_origin=&#8221;70%|50%&#8221; z_index=&#8221;-161&#8243; width=&#8221;100%&#8221; custom_margin=&#8221;|-215px||||&#8221; custom_padding=&#8221;|0px||||&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/&#8221; link_option_url_new_window=&#8221;on&#8221;]<\/p>\n<h1 style=\"text-align: center;\"><strong>Datorama Online <\/strong>Training<\/h1>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Up Coming Batches&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#E09900&#8243; button_bg_color=&#8221;#FFFFFF&#8221; button_font=&#8221;|700|||||||&#8221; transform_translate=&#8221;64px|65px&#8221; transform_translate_linked=&#8221;off&#8221; background_layout=&#8221;dark&#8221;][\/et_pb_button][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2019\/06\/logo_resize_color.png&#8221; url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; url_new_window=&#8221;on&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_translate=&#8221;-36px|0px&#8221; transform_translate_linked=&#8221;off&#8221; custom_margin=&#8221;|||178px||&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Hierarchies_in_Datorama\"><\/span><strong><span>Hierarchies in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Hierarchy plays an essential role in Datorama. Our data sets consist of media key, campaign name and impression data sets, while another one houses media key and click data sets.<\/span><\/p>\n<p><span>Parent datasets must have the most inclusive hierarchy to ensure accurate classification. <\/span><\/p>\n<p><span>A misplacement could cause misalignments, default values and data inconsistencies to arise.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Editing_Parent-Child_Assignments_in_Datorama\"><\/span><strong><span>Editing Parent-Child Assignments in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Datorama provides a tool for easily changing parent-child relationships by allowing you to select an alternative parent for any given entity. <\/span><\/p>\n<p><span>Incorrect hierarchies can result in missing attributes, causing default values to be applied in their place.<\/span><\/p>\n<p><span><img decoding=\"async\" width=\"800\" height=\"879\" src=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/05\/Hierarchy-Management.png\" alt=\"SalesForce Datorama Training\" class=\"size-medium aligncenter\"><\/span><\/p>\n<p><span>As soon as a hierarchy error arises, corrective action such as revising parent-child relations and refreshing ensures proper classification and <a href=\"https:\/\/cloudfoundation.com\/blog\/what-is-informatica-idq\" target=\"_blank\" rel=\"noopener\"><strong>data integrity<\/strong><\/a>.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Applying_Hierarchy_Across_Entities_in_Datorama\"><\/span><strong><span>Applying Hierarchy Across Entities in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Parent-child relationships across entities in Datorama operate similarly and should be carefully managed, taking into account the hierarchy. <\/span><\/p>\n<p><span>Data sets containing media key and campaign key <a href=\"https:\/\/cloudfoundation.com\/blog\/dimensional-data-modeling-training\/\" target=\"_blank\" rel=\"noopener\"><strong>dimensions must also be structured<\/strong><\/a> accurately for optimal use.<\/span><\/p>\n<p><span>Before creating relationships in Datorama, always determine your components and hierarchy to avoid fragmented or inconsistent data sets. If necessary, consult an expert outside of your organisation.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"The_Importance_of_Hierarchy_in_Datorama\"><\/span><strong><span>The Importance of Hierarchy in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Hierarchy remains at the core of data processing at Datorama, from categorisation through to distribution and storage. <\/span><\/p>\n<p><span>Parent-child relationships help organise data effectively for an ordered approach.<\/span><\/p>\n<p><span>Datorama emphasises hierarchy when conducting operations such as dimension overrides and entity attribute updates, further increasing data clarity and organisation.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Essential_Factors_in_Parent-Child_Structure\"><\/span><strong><span>Essential Factors in Parent-Child Structure<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Focus on setting up parent-child relationships on Datorama by considering three key components: data components, standard keys, and hierarchy.<\/span><span><\/span><br \/>\n<video poster=\"https:\/\/cloudfoundation.com\/blog\/wp-content\/plugins\/a3-lazy-load\/assets\/images\/lazy_placeholder.gif\" src=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/05\/Hierarchy-Framework.webm\" autoplay=\"autoplay\" loop=\"loop\" muted=\"\" width=\"800\" height=\"auto\"><\/video><br \/>\n<span>Understanding these components is integral in building strong relationships and maintaining well-defined data flows.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Validating_Parent-Child_Setup_in_Datorama\"><\/span><strong><span>Validating Parent-Child Setup in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Verification is key in creating successful parent-child relationships in Datorama. <\/span><\/p>\n<p><span>Always cross-check data associations and relationships using pivot tables for optimal alignment.<\/span><\/p>\n<p>Datorama provides continuous validation to minimise errors and maintain structured data, making it a helpful solution for hierarchical data management.[\/et_pb_text][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Understanding_Data_Streams_in_Datorama\"><\/span><strong><span>Understanding Data Streams in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Are You Working with Datorama and Wondering Why Your Data Is Updating Automatically? <\/span><\/p>\n<p><span>Let&#8217;s Make This Clear<\/span><\/p>\n<p><span>Datorama can automate the quick upload of Google Ads data. <\/span><\/p>\n<p><span>Perhaps your account manager provides it to you directly, or you need to upload it via direct downloads from Datorama. Datorama provides efficient uploads.<\/span><\/p>\n<p><span>Uploading data directly to a single stream, rather than creating multiple streams, ensures consistency when processing files. <\/span><\/p>\n<p><span>Instead of recreating new streams when updating files, updates are applied to existing streams, which keeps the hierarchy intact and saves time when updating datasets.<\/span><\/p>\n<p><span><img decoding=\"async\" width=\"800\" height=\"2990\" src=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/05\/Datorama-Data-Streams.png\" alt=\"SalesForce Datorama Training\" class=\"size-medium aligncenter\"><\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Maintaining_Hierarchies_in_Datorama\"><\/span><strong><span>Maintaining Hierarchies in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Datorama operates using hierarchies, meaning every time you add or alter columns or data structures, Datorama must properly map them to their hierarchy. <\/span><\/p>\n<p><span>Whenever changes are made, such as adding or removing columns from Datorama&#8217;s mapping system, revisions must be made so that it recognises their new hierarchy structure.<\/span><\/p>\n<p><span>Google Ads data has a well-established structure, with campaign, ad group, keywords, impressions, and clicks being just a few examples. <\/span><\/p>\n<p><span>When transitioning from June data to July data, update it within its current hierarchy without altering the dataset&#8217;s appearance.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Handling_Attribute_Updates_in_Datorama\"><\/span><strong><span>Handling Attribute Updates in Datorama<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span><a href=\"https:\/\/cloudfoundation.com\/blog\/datorama-interview-questions-answers\/\" target=\"_blank\" rel=\"noopener\"><strong>Datorama operates using hierarchies<\/strong><\/a>, so anytime you introduce new columns or modify data structures, they must be mapped adequately into Datorama&#8217;s schema.<\/span><\/p>\n<p><span><img decoding=\"async\" width=\"800\" height=\"1070\" src=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/05\/Attribute-Updates.png\" alt=\"SalesForce Datorama Training\" class=\"size-medium aligncenter\"><\/span><\/p>\n<p><span>If any columns are removed or added back in later, Datorama must adjust to reflect this new hierarchy by revoking any previously set mappings that don&#8217;t match its new look.<\/span><\/p>\n<p><span>Google Ads data has an established structure: campaigns, ad groups, keywords, impressions, and clicks are tracked over time in each month without alteration to this structure. <\/span><\/p>\n<p><span>When transitioning between June and July data, update it under its original hierarchy without making significant modifications.<\/span><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#064399&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#494fff&#8221; background_color_gradient_end=&#8221;#9ea6ff&#8221; background_color_gradient_type=&#8221;radial&#8221; background_color_gradient_direction_radial=&#8221;top left&#8221; background_color_gradient_start_position=&#8221;35%&#8221; background_color_gradient_end_position=&#8221;80%&#8221; transform_scale=&#8221;74%|71%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;-53px|-50px&#8221; transform_translate_linked=&#8221;off&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; link_option_url_new_window=&#8221;on&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/06\/Untitled-11.png&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_scale=&#8221;103%|103%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;11px|0px&#8221; transform_translate_linked=&#8221;off&#8221; custom_padding=&#8221;|88px||||&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;Georgia|700|||||||&#8221; text_text_color=&#8221;#FFFFFF&#8221; text_font_size=&#8221;23px&#8221; text_line_height=&#8221;1.3em&#8221; header_font=&#8221;Georgia|700|||||||&#8221; header_font_size=&#8221;19px&#8221; header_letter_spacing=&#8221;-1px&#8221; header_line_height=&#8221;1.2em&#8221; transform_scale=&#8221;171%|159%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;40px|44px&#8221; transform_translate_linked=&#8221;off&#8221; transform_origin=&#8221;70%|50%&#8221; z_index=&#8221;-161&#8243; width=&#8221;100%&#8221; custom_margin=&#8221;|-215px||||&#8221; custom_padding=&#8221;|0px||||&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; link_option_url_new_window=&#8221;on&#8221;]<\/p>\n<h1 style=\"text-align: center;\"><span style=\"color: #ffffff;\"><strong>Datorama Course Price<\/strong><\/span><\/h1>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Offer Price&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#0C71C3&#8243; button_bg_color=&#8221;#FFFFFF&#8221; button_font=&#8221;|700|||||||&#8221; transform_translate=&#8221;64px|65px&#8221; transform_translate_linked=&#8221;off&#8221;][\/et_pb_button][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2019\/06\/logo_resize_color.png&#8221; url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; url_new_window=&#8221;on&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_translate=&#8221;-36px|0px&#8221; transform_translate_linked=&#8221;off&#8221; custom_margin=&#8221;|||178px||&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_team_member name=&#8221;Sai Susmitha&#8221; position=&#8221;Author&#8221; image_url=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/03\/Sai-Susmitha.png&#8221; _builder_version=&#8221;4.9.7&#8243; header_level=&#8221;h5&#8243; header_font=&#8221;Titillium Web|700|||||||&#8221; body_font=&#8221;Titillium Web||||||||&#8221; body_font_size=&#8221;16&#8243;]<\/p>\n<p id=\"posted-message-container\" class=\"zcmsgcnt textL\" dir=\"auto\">The Journey of Personal Development is a Continuous path of learning and growth<\/p>\n<p>[\/et_pb_team_member][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.9.7&#8243;][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.9.7&#8243; title_font=&#8221;Times New Roman||||||||&#8221; title_text_align=&#8221;left&#8221; title_text_color=&#8221;#000000&#8243; title_font_size=&#8221;47&#8243; background_color=&#8221;RGBA(0,0,0,0)&#8221; background_enable_image=&#8221;off&#8221; custom_margin=&#8221;|||10%&#8221; title_font_size_tablet=&#8221;40&#8243; title_font_size_phone=&#8221;35&#8243; title_font_size_last_edited=&#8221;on|desktop&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;] Understanding Overarching Entities in Datorama Overarching [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":100231,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"2880","footnotes":""},"categories":[211],"tags":[],"class_list":{"0":"post-100230","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-salesforce"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>A Tutorial on Parent-Child Relationship in Marketing Cloud Intelligence<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A Tutorial on Parent-Child Relationship in Marketing Cloud Intelligence\" \/>\n<meta property=\"og:description\" content=\"[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.9.7&#8243;][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.9.7&#8243; title_font=&#8221;Times New Roman||||||||&#8221; title_text_align=&#8221;left&#8221; title_text_color=&#8221;#000000&#8243; title_font_size=&#8221;47&#8243; background_color=&#8221;RGBA(0,0,0,0)&#8221; background_enable_image=&#8221;off&#8221; custom_margin=&#8221;|||10%&#8221; title_font_size_tablet=&#8221;40&#8243; title_font_size_phone=&#8221;35&#8243; title_font_size_last_edited=&#8221;on|desktop&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;] Understanding Overarching Entities in Datorama Overarching [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/\" \/>\n<meta property=\"og:site_name\" content=\"CloudFoundation | Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-05-19T05:39:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-19T06:13:25+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/05\/Datorama-FI5.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"246\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"NAGENDRAG\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"NAGENDRAG\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"A Tutorial on Parent-Child Relationship in Marketing Cloud Intelligence","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/","og_locale":"en_US","og_type":"article","og_title":"A Tutorial on Parent-Child Relationship in Marketing Cloud Intelligence","og_description":"[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.9.7&#8243;][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.9.7&#8243; title_font=&#8221;Times New Roman||||||||&#8221; title_text_align=&#8221;left&#8221; title_text_color=&#8221;#000000&#8243; title_font_size=&#8221;47&#8243; background_color=&#8221;RGBA(0,0,0,0)&#8221; background_enable_image=&#8221;off&#8221; custom_margin=&#8221;|||10%&#8221; title_font_size_tablet=&#8221;40&#8243; title_font_size_phone=&#8221;35&#8243; title_font_size_last_edited=&#8221;on|desktop&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;] Understanding Overarching Entities in Datorama Overarching [&hellip;]","og_url":"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/","og_site_name":"CloudFoundation | Blog","article_published_time":"2025-05-19T05:39:09+00:00","article_modified_time":"2025-05-19T06:13:25+00:00","og_image":[{"width":500,"height":246,"url":"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/05\/Datorama-FI5.jpg","type":"image\/jpeg"}],"author":"NAGENDRAG","twitter_card":"summary_large_image","twitter_misc":{"Written by":"NAGENDRAG","Est. reading time":"15 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/","url":"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/","name":"A Tutorial on Parent-Child Relationship in Marketing Cloud Intelligence","isPartOf":{"@id":"https:\/\/cloudfoundation.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#primaryimage"},"image":{"@id":"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#primaryimage"},"thumbnailUrl":"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/05\/Datorama-FI5.jpg","datePublished":"2025-05-19T05:39:09+00:00","dateModified":"2025-05-19T06:13:25+00:00","author":{"@id":"https:\/\/cloudfoundation.com\/blog\/#\/schema\/person\/df6c7eba98f1bb15f2a100a9958266e4"},"breadcrumb":{"@id":"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#primaryimage","url":"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/05\/Datorama-FI5.jpg","contentUrl":"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/05\/Datorama-FI5.jpg","width":500,"height":246,"caption":"SalesForce Datorama"},{"@type":"BreadcrumbList","@id":"https:\/\/cloudfoundation.com\/blog\/a-tutorial-on-parent-child-relationship-in-marketing-cloud-intelligence\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cloudfoundation.com\/blog\/"},{"@type":"ListItem","position":2,"name":"A Tutorial on Parent-Child Relationship in Marketing Cloud Intelligence"}]},{"@type":"WebSite","@id":"https:\/\/cloudfoundation.com\/blog\/#website","url":"https:\/\/cloudfoundation.com\/blog\/","name":"CloudFoundation | Blog","description":"A New way of Learning","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cloudfoundation.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/cloudfoundation.com\/blog\/#\/schema\/person\/df6c7eba98f1bb15f2a100a9958266e4","name":"NAGENDRAG","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cloudfoundation.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/09e08ba1102807a876f2c00245d6b955f0a9f027b40c181e9cee0cd2d927f84a?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09e08ba1102807a876f2c00245d6b955f0a9f027b40c181e9cee0cd2d927f84a?s=96&d=wavatar&r=g","caption":"NAGENDRAG"},"url":"https:\/\/cloudfoundation.com\/blog\/author\/nagendrag\/"}]}},"_links":{"self":[{"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/posts\/100230","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/comments?post=100230"}],"version-history":[{"count":12,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/posts\/100230\/revisions"}],"predecessor-version":[{"id":100259,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/posts\/100230\/revisions\/100259"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/media\/100231"}],"wp:attachment":[{"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/media?parent=100230"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/categories?post=100230"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/tags?post=100230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}