Skip to main content


Showing posts from January, 2019

Sitecore Acronyms

If you are working with Sitecore technology, then you must be aware of some common Sitecore acronyms. So here is the list of some of the heavily used Sitecore acronyms: A/B Testing With A/B testing, you can test and validate your assumptions on a small group of your customers before you send the final email campaign to the rest. This ensures that you always send the most appealing and relevant email campaigns to your customers. CD - Content delivery The Content Delivery (CD) role handles requests from visitors across channels, determines which content to serve, and renders output in the relevant format for the channel. CM - Content Management (CM) The Content Management (CM) role enables authors to create, manage, and publish content. CMS – Content Management System A content management system is a software application that can be used to manage the creation and modification of digital content. CMSs are typically used for enterprise content management and web content management

Sitecore xDB Troubleshooting

Below are the some of the useful xDB troubleshooting reference: 1. Determine the interactions for each facet by month, run against your xDB shards: select facetKey, DATEPART(year,lastmodified) as ‘Year’, DATEPART(month,lastmodified) as ‘Month’, count(distinct interactionId) as ‘NumberOfInteractions’ from [xdb_collection].[InteractionFacets] group by facetKey, DATEPART(year,lastmodified), DATEPART(month,lastmodified) order by facetKey, DATEPART(year,lastmodified), DATEPART(month,lastmodified) 2. Determine the number of visits   by language and month, run against your reporting database: select SiteNameId, DimensionKey, DATEPART(year,[Date]) as ‘Year’, DATEPART(month,[Date]) as ‘Month’, sum(visits) as ‘NumberOfInteractions’ from [dbo].[Fact_LanguageMetrics] lm inner join [dbo].[DimensionKeys] dk on lm.DimensionKeyId = dk.DimensionKeyId group by SiteNameId, DimensionKey, DATEPART(year,[Date]), DATEPART(month,[Date]) order by SiteNameId, DimensionKey, DATEPART