{"id":577,"date":"2019-07-23T21:05:17","date_gmt":"2019-07-23T21:05:17","guid":{"rendered":"https:\/\/www.digitaldatatactics.com\/?p=577"},"modified":"2020-09-17T21:16:34","modified_gmt":"2020-09-17T21:16:34","slug":"industry-docs-series-1-the-solution-design-reference-the-not-so-secret-sauce","status":"publish","type":"post","link":"https:\/\/www.digitaldatatactics.com\/index.php\/2019\/07\/23\/industry-docs-series-1-the-solution-design-reference-the-not-so-secret-sauce\/","title":{"rendered":"Industry Docs Series #1: the Solution Design Reference (the not-so-secret sauce)"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"alignright size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.digitaldatatactics.com\/wp\/wp-content\/uploads\/2020\/09\/33sticks_logo.png\" alt=\"33 Sticks Logo- Orange Circle with 3|3 in it\" class=\"wp-image-538\" width=\"110\" height=\"110\" srcset=\"https:\/\/www.digitaldatatactics.com\/wp\/wp-content\/uploads\/2020\/09\/33sticks_logo.png 441w, https:\/\/www.digitaldatatactics.com\/wp\/wp-content\/uploads\/2020\/09\/33sticks_logo-300x300.png 300w, https:\/\/www.digitaldatatactics.com\/wp\/wp-content\/uploads\/2020\/09\/33sticks_logo-150x150.png 150w\" sizes=\"(max-width: 110px) 100vw, 110px\" \/><\/figure><\/div>\n\n\n\n<p>(This is cross-posted from <a href=\"https:\/\/33sticks.com\/industry-docs-series-1-the-solution-design-reference-the-not-so-secret-sauce\/\" target=\"_blank\" rel=\"noreferrer noopener\">the 33 Sticks blog<\/a>)<\/p>\n\n\n\n<p>Almost every organization that uses Digital Analytics has some combination of the following documents:<\/p>\n\n\n\n<ul><li>Business Requirements Document<\/li><li>Solution Design Reference\/Variable Map<\/li><li>Technical Specifications<\/li><li>Validation Specifications\/QA Requirements<\/li><\/ul>\n\n\n\n<p>All of the consulting agencies use them and may even have their own special, unique versions of them. They\u2019re often heavily branded and may be closely guarded. And it can be very difficult to find a template or example as a starting point.<\/p>\n\n\n\n<p>In my 11 years as a consultant who focuses on Digital Analytics implementation, I\u2019ve been through MANY documentation templates. I\u2019ve used the (sometimes vigorously enforced) templates provided by whoever was my current employing agency; I\u2019ve used client\u2019s existing docs; I\u2019ve created and recreated my own templates dozens of times. I\u2019ve used Word documents, Google Sheets, txt\/js documents, Confluence\/Wiki pages, and (much to my chagrin) Powerpoint presentations (there\u2019s nothing wrong with Powerpoint for presentations, but it&nbsp;<em>really<\/em>&nbsp;isn\u2019t a technical documentation tool). I\u2019ve in turn shared out templates and examples both within agencies and more broadly in the industry, and I\u2019ve now decided it\u2019s time to stop hoarding documentation templates and examples, and share them publicly in&nbsp;<a href=\"https:\/\/github.com\/33-Sticks\/exampleFiles\" target=\"_blank\" rel=\"noreferrer noopener\">a git repo<\/a>, starting with the most foundational: the Variable Map (sometimes called a Solution Design Reference, or SDR).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The Variable Map<\/h2>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"alignright size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.digitaldatatactics.com\/wp\/wp-content\/uploads\/2020\/09\/pocketSDR.png\" alt=\"\" class=\"wp-image-578\" width=\"253\" height=\"254\" srcset=\"https:\/\/www.digitaldatatactics.com\/wp\/wp-content\/uploads\/2020\/09\/pocketSDR.png 506w, https:\/\/www.digitaldatatactics.com\/wp\/wp-content\/uploads\/2020\/09\/pocketSDR-300x300.png 300w, https:\/\/www.digitaldatatactics.com\/wp\/wp-content\/uploads\/2020\/09\/pocketSDR-150x150.png 150w\" sizes=\"(max-width: 253px) 100vw, 253px\" \/><\/figure><\/div>\n\n\n\n<p>You may or may not have a tech spec or a business requirements document, but I bet you have a document somewhere that lays out the mapping of your custom dimensions and metrics. Since Adobe Analytics has up to 250 custom eVars, 75 custom props, and up to 1000 custom events, it\u2019s practically essential to have a variable map. In fact, the need for a quick reference is why I created the&nbsp;<a href=\"https:\/\/www.digitaldatatactics.com\/index.php\/2017\/12\/04\/pocketsdr\/\">PocketSDR app<\/a>&nbsp;a few years ago (shameless plug) so you could use your phone to check what a variable was used for or what its settings are. But when planning\/maintaining an implementation, you need a global view of all your variables. This isn\u2019t a new idea: Adobe\u2019s&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/helpx.adobe.com\/analytics\/kb\/analytics-standard-implementation-guide.html\" target=\"_blank\">documentation<\/a>&nbsp;discusses it at a higher level, Chetan Gaikwad covered it&nbsp;<a rel=\"noreferrer noopener\" href=\"http:\/\/datamarklab.com\/solution-design-reference-adobe-analytics\/\" target=\"_blank\">on his blog<\/a>&nbsp;more recently, Jason Call&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/resources.observepoint.com\/blog\/7-steps-solution-design-data-governance\" target=\"_blank\">blogged<\/a>&nbsp;about this back in 2016,&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/analyticsdemystified.com\/analytics-strategy\/framework-digital-analytics-process\/\" target=\"_blank\">Analytics Demystified walked through it in 2015<\/a>, and even back in 2014,&nbsp;<a rel=\"noreferrer noopener\" href=\"http:\/\/numericanalytics.com\/why-a-simple-piece-of-documentation-is-the-key-to-analytics-success-the-solution-design-reference-is-actually-your-bff\/\" target=\"_blank\">Numeric Analytics discussed the importance of an SDR<\/a>. Yet if you want a template, example, or starting point, you still generally have to ask colleagues and friends to pass you one under the table, use one from a previous role\/org, or you just start from scratch. This is why 33 Sticks is making a generic SDR publicly available on&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/github.com\/33-Sticks\/exampleFiles\" target=\"_blank\">our git repo<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">The cats out of the bag<\/h3>\n\n\n\n<p>There are various reasons folks (including me) haven\u2019t done this in the past. For practitioners, there is (understandably) a hesitance to share what you are doing- you might not want your brand to be associated with how good\/not good your documentation is, and\/or you may not want to give your competitors any \u201chelp\u201d (more on that in an upcoming podcast). For agencies, there may be a desire to not show \u201cthe man behind the curtain\u201d, or they may believe (or at least want their clients to believe) that their documentation is special and unique.<\/p>\n\n\n\n<p><strong>So why am I sharing it?<\/strong><\/p>\n\n\n\n<ul><li>Because I don\u2019t think the format of my variable map is actually all that special- a variable map is a variable map (but that doesn\u2019t mean we should all have to start from scratch every time). This isn\u2019t intended to be the end-all-be-all of SDRs, but rather, as a starting point or an example for comparison. Any aspect of it might be boring\/obvious to you, overkill, or just not useful, but my hope is that there is at least a part of it that will be helpful.<br><\/li><li>Because while I DO think I have some tricks that make my SDRs easier to use, I recognize that most of those tricks are things I only know or do because someone in the industry has shared their knowledge with me, or a client let me experiment a bit to find what worked best.<br><\/li><li>Because 33 Sticks doesn\u2019t bill by the hour and I have no incentive to hoard \u201ceasy\u201d\/low-level tasks from my clients. If a client comes to me and says \u201cI used your blog post to get started on an SDR without you\u201d, I can say, \u201cGreat! That leaves us more time to get into more strategic work!\u201d<br><\/li><li>Because where I can&nbsp;<strong><em>REALLY<\/em><\/strong>&nbsp;offer value as a consultant isn\u2019t in the formatting\/data entry part of creating an SDR, but rather, in the thought we put into designing\/documenting solutions, and in how we help clients focus on goals and getting long-term value out of data so they don\u2019t get stuck in \u201cmaintenance mode.\u201d<br><\/li><li>And finally, because I\u2019m hoping to hear back from folks and learn from them about what they\u2019re doing the same or differently. We all benefit from opening up about our techniques.<br><\/li><\/ul>\n\n\n\n<p>Enough with the pedantry, let\u2019s get back to discussing how to create a good SDR.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SDR Best Practices<\/h3>\n\n\n\n<p>It\u2019s vitally important you keep your variable map in a centrally-accessible location. If I update a copy of the SDR on my hard drive, that doesn\u2019t benefit anyone but me, and by the time I merge it back into the \u201cglobal\u201d one, we may already have conflicts.<\/p>\n\n\n\n<p>It should go without saying, but keeping it updated is also a good idea. I actually view most types of Digital Analytics documentation as fitting into one of two categories: primarily useful at the beginning of an implementation, OR an ongoing, living document. Something like a Business Requirements Document COULD be a living document, but let\u2019s be honest: its primary value is in designing the solution, and it can have a high level of effort to keep it comprehensively up-to-date. Technical specifications for the data layer are usually a one-time deal: after it is implemented, it goes into an archive somewhere. But the simple variable map\u2026 THAT absolutely should be kept current and frequently referenced.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Tools for Creation\/Tracking<\/h3>\n\n\n\n<p>If you\u2019re already using Adobe Analytics, then you probably need to get an accurate and current list of your variables and their settings. Even if you have an SDR, you should check if it matches what\u2019s set up in your Analytics tool. You could always export your settings from within the Admin Console, but I\u2019ve found the format makes the output very difficult to use. I\u2019d recommend going with one of the many other great industry tools (all of which are free):<\/p>\n\n\n\n<ul><li>Adobe Consulting has a&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/spark.adobe.com\/page\/tnNQGNlfzta3b\/\" target=\"_blank\">Health Dashboard<\/a>&nbsp;that uses the Admin and Reporting APIs to not only pull down your settings, but show you the top values for each report and highlights recent changes in data.<br><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.observepoint.com\/observepoint-labs\/\" target=\"_blank\">Observepoint Labs<\/a>&nbsp;has a&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/gsuite.google.com\/marketplace\/app\/observepoint_labs\/816933922881\" target=\"_blank\">Google Sheets add-in that can generate an SDR for you<\/a>&nbsp;(you can even use it to update your admin settings through the Adobe Analytics Admin API).<br><\/li><li>Acronym has a&nbsp;<a href=\"https:\/\/tools.analytics.acronym.com\/get-report-suites\/\">handy Report Suite exporter tool<\/a>.<br><\/li><li>My friend\/former colleague Gene Jones has&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/reportsuites.com\/\" target=\"_blank\">a great tool for exporting your Report Suite Settings<\/a>.<br><\/li><li>If you use the&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/chrome.google.com\/webstore\/detail\/adobe-experience-cloud-de\/ocdmogmohccmeicdhlhhgepeaijenapj?hl=en\" target=\"_blank\">Adobe Experience Cloud Debugger<\/a>&nbsp;chrome extension and are logged in to the Experience Cloud, it will show you the friendly names of your variables directly in your beacon.<\/li><\/ul>\n\n\n\n<p>These tools are great for getting your existing settings, but they don\u2019t leave a lot of room for planning and documenting the full implementation aspects of your solution, so usually I use these as a source to copy my existing settings into my SDR.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">What should an SDR contain?<\/h3>\n\n\n\n<p>On&nbsp;<a href=\"https:\/\/github.com\/33-Sticks\/exampleFiles\/tree\/master\/SDRs%20and%20Variable%20Maps\" target=\"_blank\" rel=\"noreferrer noopener\">our git repo<\/a>, you\u2019ll see an Excel sheet that has a generic example Variable Map. Even if you have an SDR that you like already, take a look this example one- there may be some items you might get use of (plus this post will be much more interesting if you can see the columns I\u2019m talking about).<\/p>\n\n\n\n<p>Pretty much ALL Variable Maps have the following columns (and mine is no different):<\/p>\n\n\n\n<ul><li><strong>Variable\/Report Name (eg, \u201cInternal Search Terms\u201d)<\/strong><\/li><li><strong>Variable\/Report Number (eg, \u201ceVar1\u201d)<\/strong><\/li><li><strong>Description<\/strong><\/li><li><strong>Example Value<\/strong><\/li><li><strong>Variable Settings<\/strong><\/li><\/ul>\n\n\n\n<p>But over the years I\u2019ve found a few other columns can really make the variable map much more use-able and useful (and again, this all may make more sense if you download our SDR to have an example):<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>A \u201cSorting Order\u201d or Key<\/strong><\/h4>\n\n\n\n<p>If, like me, you love using tables, sorting, and filtering in Excel, you may discover that Excel doesn\u2019t know how to sort eVars, props and events: because it isn\u2019t fully a number or string, it thinks that the proper order is \u201ceVar1, eVar10, eVar2, eVar20\u201d. So if you\u2019ve sorted for some small task and want to get back to a sensible order, you pretty much have to do things manually. For this reason, I have a simple column that has nothing other than numbers indicating my ideal\/proper\/default order for my table.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Param<\/strong><\/h4>\n\n\n\n<p>This is for those who live their lives in analytics beacons rather than reports, like a QA team. It\u2019s nice to know that s.campaign is the variable, and it is named \u201cTracking Code\u201d in the reports, but it\u2019s not exactly obvious that if you\u2019re looking in a beacon, the value for s.campaign shows in the \u201cv0\u201d parameter.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Variable Type<\/strong><\/h4>\n\n\n\n<p>Again, I love me some Excel filtering, and I like being able to say \u201cshow me just my eVars\u201d or \u201cshow the out of the box events\u201d. It can also be handy for those not used to Adobe lingo (\u201cwhat the heck is an eVar?\u201d). So I have a column with something like the following possible values:<\/p>\n\n\n\n<ul><li>eVar- custom conversion dimension<\/li><li>event- custom metric (eg \u201cevent1\u201d)<\/li><li>event- predefined metric (eg \u201cscAdd\u201d, \u201cpurchase\u201d)<\/li><li>listVar- custom conversion dimension list (eg, \u201cs.list1\u201d)<\/li><li>predefined conversion dimension (eg, \u201cs.campaign\u201d)<\/li><li>predefined traffic dimension (eg, \u201cs.server\u201d)<\/li><li>products string<\/li><li>prop- custom traffic dimension<\/li><\/ul>\n\n\n\n<p>For things like this, where I have specific values I\u2019ll be using repeatedly, I\u2019ll keep an extra tab in the workbook titled \u201cworksheet config\u201d. Then I can use Excel\u2019s \u201cdata validation\u201d to pull a drop-down list from that tab.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Category<\/strong><\/h4>\n\n\n\n<p>This is my personal favorite- I use it every day. It\u2019s a way to sort\/group variables and metrics that are related to each other- eg, if you are using eVar1, eVar2, prop1, event1, and event2 all in some way to track internal search, it\u2019s nice to be able to filter by this column and get something like this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"724\" height=\"420\" src=\"https:\/\/www.digitaldatatactics.com\/wp\/wp-content\/uploads\/2020\/09\/categoryFilter.png\" alt=\"\" class=\"wp-image-581\" srcset=\"https:\/\/www.digitaldatatactics.com\/wp\/wp-content\/uploads\/2020\/09\/categoryFilter.png 724w, https:\/\/www.digitaldatatactics.com\/wp\/wp-content\/uploads\/2020\/09\/categoryFilter-300x174.png 300w\" sizes=\"(max-width: 724px) 100vw, 724px\" \/><\/figure>\n\n\n\n<p>The categories themselves are completely arbitrary and don\u2019t need to map to anything outside of the document (though you might choose to use them in your Tech Spec or even in workspaces). Here\u2019s a standard list I might use:<\/p>\n\n\n\n<ul><li>Content Identification<\/li><li>Internal Search<\/li><li>Products<\/li><li>Checkout<\/li><li>Visitor Segmentation<\/li><li>Traffic Sources<\/li><li>Authentication<\/li><li>Validation\/Troubleshooting<\/li><\/ul>\n\n\n\n<p>Again, I could create\/maintain this list in a single place on my \u201cworksheet config\u201d tab, then use \u201cData Validation\u201d to turn it into a drop-down list in my Variable Map.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Status<\/strong><\/h4>\n\n\n\n<p>This basically answers the question \u201cis this variable currently expected to be working in production?\u201d I usually have three possible values:<\/p>\n\n\n\n<ul><li>Implemented<\/li><li>Broken (or some euphemism for broken, like \u201cneeds work\u201d)<\/li><li>In progress<\/li><\/ul>\n\n\n\n<p><strong>Data Quality Notes<\/strong><\/p>\n\n\n\n<p>This is for, well, notes on Data Quality. Such as \u201cdidn\u2019t track for month of March\u201d or \u201chas odd values coming from PDP\u201d.<\/p>\n\n\n\n<p><strong>Last Validated<\/strong><\/p>\n\n\n\n<p>This is to keep track of how recently someone checked on the health of this variable\/metric. The hope is this will help prevent variables sitting around, unused, with bad data, for months or even years. I even add conditional formatting so if it has been more than 90 days, it turns red.<\/p>\n\n\n\n<p><strong>Scope<\/strong><\/p>\n\n\n\n<p>Where would I expect to see this variable\/metric? Is it set globally? Or maybe it happens on all cart adds?<\/p>\n\n\n\n<p><strong>Description<\/strong><\/p>\n\n\n\n<p>I\u2019m certainly not unique in having this column, and I\u2019m probably not unique in how many SDRs I\u2019ve seen where this column has not been kept up-to-date. I\u2019d like to stress the importance of this column, though- you may think the purpose of a variable is obvious, but almost every company I\u2019ve worked with has at least one item on their variable map where no current member of the analytics team has any idea what the original goal was.<\/p>\n\n\n\n<p>Ideally, the contents of this column would align with the \u201cDescription\u201d setting within the Admin Console for each variable, so that folks viewing the reports can understand how to use the data.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"317\" height=\"67\" src=\"https:\/\/www.digitaldatatactics.com\/wp\/wp-content\/uploads\/2020\/09\/variableDescriptionSetting.png\" alt=\"\" class=\"wp-image-579\" srcset=\"https:\/\/www.digitaldatatactics.com\/wp\/wp-content\/uploads\/2020\/09\/variableDescriptionSetting.png 317w, https:\/\/www.digitaldatatactics.com\/wp\/wp-content\/uploads\/2020\/09\/variableDescriptionSetting-300x63.png 300w\" sizes=\"(max-width: 317px) 100vw, 317px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"753\" height=\"258\" src=\"https:\/\/www.digitaldatatactics.com\/wp\/wp-content\/uploads\/2020\/09\/variableDescription.png\" alt=\"\" class=\"wp-image-580\" srcset=\"https:\/\/www.digitaldatatactics.com\/wp\/wp-content\/uploads\/2020\/09\/variableDescription.png 753w, https:\/\/www.digitaldatatactics.com\/wp\/wp-content\/uploads\/2020\/09\/variableDescription-300x103.png 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/><\/figure>\n\n\n\n<p>We ARE all setting and using those descriptions, right? RIGHT?<\/p>\n\n\n\n<p><strong>Logic\/Formatting and Example Value<\/strong><\/p>\n\n\n\n<p>Your Variable Map needs to have a place to detail the type of values you\u2019d expect in this report. This:<\/p>\n\n\n\n<ul><li>helps folks looking at the document to understand what each variable does (especially if you don\u2019t have stellar descriptions)<\/li><li>lets developers\/implementers know what sort of data to send in<\/li><li>provides a place to make sure values are consistent. For instance, if I have a variable for \u201cadd to cart location\u201d, there\u2019s no inherent reason why the value \u201cproduct details page\u201d would be more correct than \u201cproduct view\u201d\u2026 but I still only want to see ONE of those values in my report. If folks can look in my variable map and see that \u201cproduct details page\u201d is the value already in use, they won\u2019t go and invent a new value for the same thing).<\/li><\/ul>\n\n\n\n<p>I often find it a good exercise to run the&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/spark.adobe.com\/page\/tnNQGNlfzta3b\/\" target=\"_blank\">Adobe Consulting Health Dashboard<\/a>&nbsp;and grab the top few values from each variable to fill out this column.<\/p>\n\n\n\n<p><strong>Source Type<\/strong><\/p>\n\n\n\n<p>What method are we using to get the value for the data layer? I usually use Excel Data Validation to create this list:<\/p>\n\n\n\n<ul><li>query param<\/li><li>data layer<\/li><li>rule-based\/trigger-based (like for most events, which are usually manually entered into a TMS rule based on certain conditions)<\/li><li>analytics library (aka, plugins)<\/li><li>duplicate of another variable<\/li><\/ul>\n\n\n\n<p><strong>Dimension Source or Metric Trigger<\/strong><\/p>\n\n\n\n<p>This contains the details that complement the \u201csource type\u201d column: If it comes from query parameters, WHICH query parameter is it? If it comes from the data layer, what data layer object is it? If it\u2019s a metric, what in the data layer determines when to fire it (for instance, a prodView event doesn\u2019t map directly to a data layer object, but it does RELY on the data layer: we set it whenever the pageType data layer object is set to \u201cproduct details page\u201d.)<\/p>\n\n\n\n<p><strong>Variable Settings<\/strong><\/p>\n\n\n\n<p>This is something many SDRs have but can be a pain to keep consistent, because every variable type has different settings options:<\/p>\n\n\n\n<ul><li>events<ul><li>type<ul><li>counter (default)<\/li><li>numeric<\/li><li>currency<\/li><\/ul><\/li><li>polarity<ul><li>Up is good (default)<\/li><li>Up is bad<\/li><\/ul><\/li><li>visibility<ul><li>visible everywhere (default)<\/li><li>builders<\/li><li>hidden everywhere<\/li><\/ul><\/li><li>serialization<ul><li>always record event (default)<\/li><li>record once per visit<\/li><li>use serialization ID<\/li><\/ul><\/li><li>participation<ul><li>disabled (default)<\/li><li>enabled<\/li><\/ul><\/li><\/ul><\/li><li>eVars<ul><li>Expiration<ul><li>Visit (default)<\/li><li>Hit\/Page View<\/li><li>Event (like purchase)<\/li><li>Custom<\/li><li>Never<\/li><\/ul><\/li><li>Allocation (note: this is less relevant these days now that&nbsp;<a href=\"https:\/\/www.digitaldatatactics.com\/index.php\/2018\/01\/25\/followup-post-allocation-in-analysis-workspace\/\" target=\"_blank\" rel=\"noreferrer noopener\">allocation can be decided in workspace<\/a>)<ul><li>Most Recent (last) (default)<\/li><li>Original Value (first)<\/li><li>Linear<\/li><\/ul><\/li><li>Type<ul><li>Text string (default)<\/li><li>Counter<\/li><\/ul><\/li><li>Merchandising<ul><li>Disabled (default)<\/li><li>Product Syntax<\/li><li>Conversion Syntax<\/li><\/ul><\/li><li>Merchandising Binding Events<\/li><\/ul><\/li><li>Props<ul><li>List Prop<ul><li>Disabled (default)<\/li><li>Enabled<\/li><\/ul><\/li><li>List Prop Delimiter<\/li><li>Pathing<ul><li>Disabled (default)<\/li><li>Enabled<\/li><\/ul><\/li><li>Participation<ul><li>Disabled (default)<\/li><li>Enabled<\/li><\/ul><\/li><\/ul><\/li><\/ul>\n\n\n\n<p>As you can see, you\u2019d have to account for a lot of possible settings and combinations- I\u2019ve seen some SDRs with 30 columns dedicated just to variable settings. I tend to simplify and just have one column where I only call out any setting that differs from the default, such as \u201cExpires after 2 weeks\u201d or \u201cmerchandising: conversion syntax, binds on internal search event, product view, and cart add.\u201d<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Classifications<\/strong><\/h4>\n\n\n\n<p>This should list any classifications set up on this variable. This is a good one to keep updated, though I find many folks don\u2019t.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>GDPR Considerations<\/strong><\/h4>\n\n\n\n<p>Don\u2019t forget about government privacy regulations! Use this to flag items that will need to be accounted for in your privacy policies and procedures. Sometimes merely having the column can serve as a good reminder that privacy is something we need to consider when designing our solution.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>TMS Rule and TMS Element<\/strong><\/h4>\n\n\n\n<p>I find these very helpful in designing a solution, but I\u2019ll admit, they often fall by the wayside after an implementation is launched- and I don\u2019t even see that as a bad thing. Once configured, your TMS implementation should speak for itself. (This will be even more true when Adobe releases enhanced search functionality in Launch.)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Other tabs<\/h3>\n\n\n\n<p>Aside from the variable map, I try to always have a tab\/sheet for a Change Log. If nothing else, this can help with version control when someone had a local copy of the SDR that got off sync from the \u201cofficial\u201d one. It also lets you know who to contact if you have questions about a certain change that was made. I also use this to flag which changes have been accounted for in the Report suite Settings (eg, I may have set aside eVar2 for \u201cinternal search terms\u201d, but did I actually turn it on in the tool?)<\/p>\n\n\n\n<p>If you have many Report Suites, it may be helpful to have a tab that lists them all- their friendly name, their report suite ID, any relevant URLs\/Domains, and perhaps the business owner of that Report Suite.<\/p>\n\n\n\n<p>Also, if you have multiple report suites, you may want to add columns to the variable map or have a whole separate tab that compares variables across suites (the&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/reportsuites.com\/\" target=\"_blank\">Report Suite exporter<\/a>&nbsp;and&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/gsuite.google.com\/marketplace\/app\/observepoint_labs\/816933922881\" target=\"_blank\">the Observepoint SDR Builder<\/a>&nbsp;both have this built in).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What works for you?<\/h2>\n\n\n\n<p>As I said, I don\u2019t think my template is going to be the ultimate, universal SDR. I\u2019d love to know what has worked for other people- did I miss anything? Is there anything I\u2019m doing that I should do differently? Do you have a template you\u2019d like to share? I\u2019d love to hear from you!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>(This is cross-posted from the 33 Sticks blog) Almost every organization that uses Digital Analytics has some combination of the following documents: Business Requirements Document Solution Design Reference\/Variable Map Technical Specifications Validation Specifications\/QA Requirements All of the consulting agencies use them and may even have their own special, unique versions of them. They\u2019re often heavily &#8230; <a title=\"Industry Docs Series #1: the Solution Design Reference (the not-so-secret sauce)\" class=\"read-more\" href=\"https:\/\/www.digitaldatatactics.com\/index.php\/2019\/07\/23\/industry-docs-series-1-the-solution-design-reference-the-not-so-secret-sauce\/\" aria-label=\"Read more about Industry Docs Series #1: the Solution Design Reference (the not-so-secret sauce)\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[57,19,54,50,55],"_links":{"self":[{"href":"https:\/\/www.digitaldatatactics.com\/index.php\/wp-json\/wp\/v2\/posts\/577"}],"collection":[{"href":"https:\/\/www.digitaldatatactics.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.digitaldatatactics.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.digitaldatatactics.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.digitaldatatactics.com\/index.php\/wp-json\/wp\/v2\/comments?post=577"}],"version-history":[{"count":2,"href":"https:\/\/www.digitaldatatactics.com\/index.php\/wp-json\/wp\/v2\/posts\/577\/revisions"}],"predecessor-version":[{"id":588,"href":"https:\/\/www.digitaldatatactics.com\/index.php\/wp-json\/wp\/v2\/posts\/577\/revisions\/588"}],"wp:attachment":[{"href":"https:\/\/www.digitaldatatactics.com\/index.php\/wp-json\/wp\/v2\/media?parent=577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.digitaldatatactics.com\/index.php\/wp-json\/wp\/v2\/categories?post=577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.digitaldatatactics.com\/index.php\/wp-json\/wp\/v2\/tags?post=577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}