<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by ROOM42 on Medium]]></title>
        <description><![CDATA[Stories by ROOM42 on Medium]]></description>
        <link>https://medium.com/@room42?source=rss-797a752f68ba------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/2*OccPL18odMGJCQP8JqW2jA.jpeg</url>
            <title>Stories by ROOM42 on Medium</title>
            <link>https://medium.com/@room42?source=rss-797a752f68ba------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 22:17:51 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@room42/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Google Analytics or End-to-End Analytics. What will work best for you?]]></title>
            <link>https://medium.com/@room42/google-analytics-or-end-to-end-analytics-what-will-work-best-for-you-3c3ad9b6cf35?source=rss-797a752f68ba------2</link>
            <guid isPermaLink="false">https://medium.com/p/3c3ad9b6cf35</guid>
            <category><![CDATA[marketing]]></category>
            <category><![CDATA[web-development]]></category>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[sales]]></category>
            <category><![CDATA[ecommerce]]></category>
            <dc:creator><![CDATA[ROOM42]]></dc:creator>
            <pubDate>Fri, 29 Nov 2019 14:37:17 GMT</pubDate>
            <atom:updated>2019-11-29T14:43:39.631Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>Google Analytics or End-to-End Analytics. What will work for you?</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*FZFPh2yZvIV6sxnFDKApvw.png" /></figure><p>If your business’s financial performance depends on online sales, you are probably already on the path of looking for stable analytical solutions. They help track data about user actions on your website, evaluate marketing effectiveness, and later make thought-throw decisions about your company’s future. In this article, we will talk about the exact cases where your company needs end-to-end analytics, and where you can succeed with just Google Analytics.</p><p>Google Analytics is the most popular and most used web-analytical instrument on the market. Despite the fact that its functionality is somewhat limited, GA can be a great choice for tracking user activity on simple web-pages where complicated marketing mechanics and advertising channels are not involved.</p><p>As for end-to-end analytics, it allows you to build attribution to evaluate the “weight” of each of the channels in the conversion chain, follow people’s actions on the website along with tracking their offline activity. All of these lead to unobvious insights about your audience. What are the advantages of each of the options? When do you need end-to-end, and when to consider Google Analytics as the best choice?</p><p><strong>Here are some of the advantages of Google Analytics</strong></p><ul><li>Simple integration. Most of the events can be set up using basic improvements in the code of the website or using Google Tag Manager;</li><li>User-friendly interface;</li><li>A large number of options for premade dashboards, for example, with the information about how many people came to your website from each of the channels, how many sessions were registered at certain periods of time, what are the bounce rates and how much time people spend on your website;</li><li>Relatively simple e-commerce section installation, where you would see the information about sales, customer journey, and revenues.</li></ul><p><strong>When Google Analytics is enough</strong></p><p>1. If the only conversion activity on your website is filling in the form, sending in contact details, a simple transaction or a one-click purchase. In this case, you can get away with the correct implementation of Google Analytics or Yandex Metrica’s counters, setting up the targets and tracking it later. Analytical systems will be enough for drawing basic conclusions about your audience and where it comes from.</p><p>2. If you only use one traffic channel. The minimum number of channels is the case when Google Analytics is the way to go: you don’t have to evaluate the contribution of each of the channels to the customer journey, thus you don’t need sophisticated analytical mechanisms.</p><p>3. If you don’t want to track your client’s offline activities. Google Analytics is a good option if you’re only interested in their direct interaction with the website. GA is the right tool if your business doesn’t imply user behavior analysis on third party platforms or offline activity.</p><p>And what happens if the whole process is more complicated? Customer journey consists of multiple consecutive conversions, traffic is coming from several channels, and to interact with clients you use services like CRM, payment widgets, or e-mail? In this case, we recommend considering end-to-end analytics.</p><p><strong>You will need end-to-end analytics:</strong></p><p><strong>1. If your customer journey requires outside-the-website actions</strong></p><p>If your business entails a complicated sales funnel, end-to-end analytics is crucial for the correct estimation of conversion. For example, for an online-story we can highlight the following conversions:</p><ul><li>Registration and authorization;</li><li>Scrolling through product cards;</li><li>Adding to favorites or to trash;</li><li>Several steps of filling in personal information;</li><li>Checkout: adding payment information, applying promo codes, choosing the delivery option and payment methods;</li><li>Confirmation of order via phone call or e-mail.</li></ul><p>In this scenario, you use several widgets for payment and newsletters along with CRM. The thing is, that when setting up “basic” analytics, the counters can only be installed on your website. Therefore, user actions away from the website become a blind spot. If you work with newsletters, offline sales, you have third party widgets, for example, payment systems, all of the information about them needed for future analysis will be stored in a united database.</p><p>Why can’t you just open analytical systems, apps, CRM and compare the numbers? Well, mostly because you will not be able to connect user IDs from multiple systems and track their actions correctly. End-to-end analytics is there for you when you need to see the same people coherently acting on the website, offline, and in the application.</p><p><strong>2. Plenty of marketing channels</strong></p><p>Large marketing budgets, various traffic channels, CRM for data collection, and newsletters are the signals to end-to-end analytics implementation. Why?</p><p>Before actually purchasing a good or service, your potential clients will see your ads on different marketing platforms. Here comes the question: which of these stages has contributed more to the conversion? The answer is in the attribution model that will be chosen. Where analytical systems only offer standardized versions of attribution models, such as first- and last-click, it can lead to wrong conclusions about channel effectiveness. To estimate each one of them right, you need end-to-end analytics. In <a href="https://room42.ru/en">Room42</a> we prefer to build our own custom attribution models.</p><p><strong>3. Several marketing mechanics</strong></p><p>Your marketing traffic isn’t just the reach or conversion campaigns, but it’s also your remarketing activity. It implies targeted campaigns with a specific audience that has already acted in a certain way: for example, looked at the items or fill in the forms. In this situation, end-to-end analytics will assist in the personalization of advertisements based on a complex set of data about each of the user segments.</p><p>Learn more about end-to-end analytics on our <a href="https://room42.ru/?utm_source=medium&amp;utm_medium=social&amp;utm_campaign=articles">website</a>.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3c3ad9b6cf35" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Top-7 instruments for digital marketers]]></title>
            <link>https://medium.com/@room42/top-7-instruments-for-digital-marketers-192a55792822?source=rss-797a752f68ba------2</link>
            <guid isPermaLink="false">https://medium.com/p/192a55792822</guid>
            <category><![CDATA[marketing]]></category>
            <category><![CDATA[advertising]]></category>
            <category><![CDATA[tools]]></category>
            <category><![CDATA[productivity]]></category>
            <category><![CDATA[apps]]></category>
            <dc:creator><![CDATA[ROOM42]]></dc:creator>
            <pubDate>Wed, 06 Nov 2019 09:39:11 GMT</pubDate>
            <atom:updated>2019-11-06T09:39:11.242Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*GlxJgyEpiVzZIdotvKWw3g.jpeg" /></figure><p>Analytics is not only about collecting data but about its’ further application in brand promotion. As giving advice about raising profits is impossible without marketing instruments, we’ve decided to ask our colleagues at Room42 about their favorites, and have picked out top-7 from what we’ve heard.</p><p><strong>Similarweb — website statistics</strong></p><p>With Similarweb you can look up general website statistics, for example, traffic volume, shares of separate advertising channels, and much more. You can either chose to use the extension which demonstrates the overall picture of traffic and user characteristics, or you can sign up for the paid service where the demonstrated data will be more detailed. Overall, Similarweb helps with insights on brand power, organic traffic, along with providing information about advertising costs in terms of different digital-channels.</p><p><strong>Note:</strong> Similarweb registers only desktop traffic</p><p><strong>Link:</strong><a href="https://www.similarweb.com/"> https://www.similarweb.com</a></p><p><strong>Differture — instrument to evaluate the effectiveness of your spendings</strong></p><p>With Differture you automatically import data about marketing expenses from Facebook, VK, MyTarget, or Yandex.direct to Google Analytics or any other database. You’ll need this when calculating marketing effectiveness and evaluating the influence of each of the channels on overall payback from investing in marketing. One more advantage is less time spent on data analysis. Differture makes you forget about “jumping” from one advertising channel to another trying to tie the information together: everything is collected into one table in Google Analytics or a separate database right after you download it.</p><p><strong>Link:</strong><a href="https://differture.com/"> Differture.com</a></p><p><strong>Semantica Extension — search engine for keywords</strong></p><p>It’s for everyone who works with contextual ads — with Semantica it’s easy to find the right words from WordStat to set up campaigns or compose media plans.</p><p><strong>Note:</strong> One of the downsides is that if you add the keys directly to the app, the frequency of the requests will not be displayed.</p><p><strong>Link:</strong><a href="https://chrome.google.com/webstore/detail/yandex-wordstat-assistant/nbihjogngdgindfodcjbelhgjdpmkolc?hl=ru"><strong> </strong>https://chrome.google.com/webstore/detail/yandex-wordstat-assistant/nbihjogngdgindfodcjbelhgjdpmkolc?hl=ru</a></p><p><strong>Ghostery Extension</strong></p><p>Here you can see all of the pixels and analytics counters that are on the website. Ghostery shows them to you right as you enter the website. Later, it will be less complicated for you to adjust the work you’ve planned with various instruments and to know, which pixels and counters are yet to be implemented. Will be useful for marketers who want to know what their client needs to add on their website, but don’t enjoy searching for the information manually.</p><p><strong>Link:</strong><a href="https://chrome.google.com/webstore/detail/the-great-suspender/klbibkeccnjlkjkiokjodocebajanakg?hl=ru"><strong> </strong>https://chrome.google.com/webstore/detail/the-great-suspender/klbibkeccnjlkjkiokjodocebajanakg?hl=ru</a></p><p><strong>Google Ads Editor &amp; Yandex.Direct Commander — editing and setting up advertising campaigns</strong></p><p>Convenient apps to conduct contextual ads. Both services function similarly and are made for the same activities, but different advertising channels. They’re simple-to-use but have their own features just like every tool out there.</p><p><strong>Link:</strong><a href="https://ads.google.com/intl/ru_ru/home/tools/ads-editor/"><strong> </strong>https://ads.google.com/intl/ru_ru/home/tools/ads-editor/</a><a href="https://yandex.ru/promo/commander/new?from=dirface14">https://yandex.ru/promo/commander/new?from=dirface14</a></p><p><strong>Publer — search engine for your competitors’ ads</strong></p><p>Publer shows you the visual ads of your competitors. Why do you need it? To understand evolving advertising trends in your field and critically assess your own ideas. Use it to avoid “copycatting” already existing tricks and to get insights for new campaigns.</p><p><strong>Link:</strong><a href="https://publer.pro/"> https://publer.pro</a></p><p><strong>Parser for finding Youtube-channels by keywords</strong></p><p>It composes lists of suitable Youtube-channels based on keywords and topics. As a result, you get comprehensive information about each of the videos, such as publishing date, video name, channel name, video id, its description and tags. It’s useful when setting up targeted campaigns, promotional videos, or banner ads for desktops.</p><p><strong>Link:</strong> <a href="https://habr.com/ru/post/443506/">https://habr.com/ru/post/443506/</a></p><p>Hopefully, you found this article useful. Please leave your top-instruments in the comments.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=192a55792822" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Storing data in 2019: trends, problems, and potential solutions in Panoply’s yearly report]]></title>
            <link>https://medium.com/@room42/storing-data-in-2019-trends-problems-and-potential-solutions-in-panoplys-yearly-report-3eabc9a26680?source=rss-797a752f68ba------2</link>
            <guid isPermaLink="false">https://medium.com/p/3eabc9a26680</guid>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[marketing]]></category>
            <category><![CDATA[market-research-reports]]></category>
            <category><![CDATA[statistics]]></category>
            <category><![CDATA[big-data]]></category>
            <dc:creator><![CDATA[ROOM42]]></dc:creator>
            <pubDate>Wed, 30 Oct 2019 12:17:00 GMT</pubDate>
            <atom:updated>2019-10-30T12:17:00.326Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/626/1*kbVc0Ynp9TzIxelmqLpSSw.jpeg" /></figure><p>We at Room42 work with data on a daily basis and try not to assume things, but to see the collected information first and make reasonable conclusions based on figures. As we saw Panoplys’ yearly report on data warehousing technologies, we ran quickly to take a look at it.</p><p>Data Warehouse Trends Report has been published since 2017. In their research, specialists from Panoply interview data-engineers, scientists, and IT experts from different spheres. The most important question is how qualified workers manage their data and if their experience is satisfying. This year they have talked to as much as 800 respondents who helped define the main complications and to realize that the market needs innovations the sooner, the better. You can read the original report <a href="https://learn.panoply.io/hubfs/Downloadable%20Content/Data_Warehouse_Trends_2019.pdf">here.</a></p><p>For those who don’t have the time to read it, we’ve summarized the key insights and are ready to tell you the main takeouts. Here is what we have managed to find out:</p><p><strong>Data warehouses are a must! (and they better be cloud-based)</strong></p><p>Professionals are moving further and further away from on-premise data warehouses. They’re looking for a cloud that would be user-friendly and fast. According to the poll, only about a third of all respondents still stick with the in-house storages (compared to 39% a year before). The rest prefer Redshift, Azure SQL Server, BigQuery and other SaaS-solutions.</p><p>In the last three years, the most popular service Redshift has lost much of its’ market share: in 2017, 60% of all experts claimed to have used it, but in 2019 this number went down to 40%. The “Other” option in the survey is gaining popularity: its share has grown by 13% since the last reporting period.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*sRASa_2-Tp4iinTg" /></figure><p>Source: Panoply Data Warehouse Trends Report © Panoply Ltd. 2019</p><p><strong>Current solutions are hard to use</strong></p><p>One of the main insights that we took away from this report was that existing tools are not user-friendly at all. They’re not suitable even for the best professionals and their goals. Moreover, up to 80% of employees from smaller and larger firms describe their experience with data warehouses as “difficult” or “very difficult”.</p><p>Interestingly, the number of unsatisfied people grows year by year and doesn’t promise any positive changes.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*f-gG379ShPbqxUJS" /></figure><p>Source: Panoply Data Warehouse Trends Report © Panoply Ltd. 2019</p><p>As we look at the respondent sample, we can observe that the problem is not in workers’ readiness to manage large amounts of data, but in the functionality of the solutions. Most of the interviewees are employed in finances, B2B, e-commerce, or state/local governments.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*XBmkuC57SIeo-H6X" /></figure><p>Source: Panoply Data Warehouse Trends Report © Panoply Ltd. 2019</p><p>As well as this, around 40% of them are working for larger businesses (up to 5000 people), and around 19% are employed by companies with 1000 to 5000 people.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/650/0*w0acW9vAY5iRDiRL" /></figure><p>Source: Panoply Data Warehouse Trends Report © Panoply Ltd. 2019</p><p><strong>What exactly do users hate about data warehouses?</strong></p><p>First and foremost, their complexity. This issue is common for the majority of the existing storage solutions: from Redshift to Azure SQL Server. The price and performance annoy users less frequently (from 14% to 22% of the time).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*hyq9553jQ5AoMibC" /></figure><p>Source: Panoply Data Warehouse Trends Report © Panoply Ltd. 2019</p><p>As for the general disappointment, all of the participating data warehouses show unimpressive results: from 50% to 64% of the respondents are upset about hanging or slow queries.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1020/0*3uigqpjGzH6b0J-e" /></figure><p>Source: Panoply Data Warehouse Trends Report © Panoply Ltd. 2019</p><p><strong>What does all of this mean?</strong></p><p>Endless (to say the least) opportunities for modernized, simple-to-use, fast data warehouse solutions in the game. Current market leaders seem to have given up on the existing problems, and the new players haven’t entered the competition just yet. So, the road to success for fresh ideas is wide open.</p><p>Luckily, there are inexpensive services such as <a href="https://differture.com/?utm_source=blog&amp;utm_campaign=articles&amp;utm_medium=content">Differture.com</a> which can assist in solving some of the issues in collecting, managing, and storing data.</p><p>We hope this article was helpful. Until next time!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3eabc9a26680" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Why do you need to start collecting raw data today?]]></title>
            <link>https://medium.com/@room42/why-do-you-need-to-start-collecting-raw-data-today-7b5866dbf10?source=rss-797a752f68ba------2</link>
            <guid isPermaLink="false">https://medium.com/p/7b5866dbf10</guid>
            <category><![CDATA[google]]></category>
            <category><![CDATA[advertising]]></category>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[marketing]]></category>
            <category><![CDATA[data]]></category>
            <dc:creator><![CDATA[ROOM42]]></dc:creator>
            <pubDate>Wed, 23 Oct 2019 17:24:57 GMT</pubDate>
            <atom:updated>2019-10-23T17:24:57.935Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5sBS6ZSr85zMDvB4kLQmyA.png" /></figure><p>Most of the time we work with aggregated data. What is it? It is transformed chunks of information composed from thousands of pieces of data. Usually, we use it to build charts and graphs, reports and dashboards. Aggregated data helps managers make decisions and draw conclusions about their businesses’ performance. We often see aggregated data in services like Google Analytics, where various pieces of information come together to build full pictures of trends.</p><p>But what should we do with raw data, meaning unprocessed content of hits? Turns out, raw data is just as useful as visual diagrams. Why? We’ll tell you in a second.</p><p><strong>To eliminate inaccuracy caused by sampling</strong></p><p>Sampling is a method, where to build a report, we use a small amount of data (which is “surprisingly” called a sample), proportional to the overall population. The results, in this case, are shown as if all of the data was taken into consideration when building dashboards. Sampling is widely exploited by services like Google Analytics and is used for processing larger amounts of data. Sampling could be useful in lots of different situations, however, it sometimes stands between users and objective conclusions. Here we have to understand that Google Analytics only illustrates trends and patterns — result of the analysis of a sample.</p><p>We certainly can avoid sampling by using the paid version of Google Analytics, but its price can go as high as 100.000$/year which is only affordable for large businesses. The same raw data could be obtained through much cheaper ETL- services.</p><p><strong>To set up targeted ads</strong></p><p>The composition of narrowed-down user lists and the formation of cohorts could only be done with raw data. For example, you want to highlight those who have been loyal to your brand in the past year and have purchased within your special offers periods. What do we have here? Different activities, different times, same clients. These people are hardly detachable from the rest of the customers, and that’s why you will need the retrospective information on the user activity to form needed segments for your targeted ads.</p><p>And what if you’re collecting audience for retargeting? Raw data is there for you to connect all the advertising networks and channels for your customers to come back to buy more or to leave a positive review of your service.</p><p><strong>To understand why data doesn’t match</strong></p><p>As we’ve already mentioned, Google Analytics is a tool that only evaluates trends, therefore, we can’t expect it to be 100% precise. Sometimes the information about spendings and clicks can differ: let’s say you’ve set up data transferring from one advertising channel via two different instruments. In this case, manual matching of data can reveal up to 30% discrepancy, which, of course, will be reflected in the final efficiency estimation.</p><p>You can be sure of the precision of the information only with raw data. It will indicate what went wrong, and you will have an opportunity to quickly react to any problems related to doubling or absent data.</p><p><strong>For custom analytics</strong></p><p>Using raw data, analysts can go into more depth, and thus optimization of internal mechanisms of the company have higher chances for success. Plus, initial data could be connected to data from other sources and you can draw conclusions based on them. If you need to analyze business-processes or evaluate the impact of advertising on offline sales, raw data will assist in using any of the data cuts and easily adapt it to your system.</p><p><strong>For safety</strong></p><p>Only raw data reveals where and when suspicious activities, such as too many daily registrations or awkward time frames between similar actions, took place on your website. Moreover, information about hits assists in catching bots and spam-filtering.</p><p><strong>To change providers and instruments</strong></p><p>While you store only aggregated data, you’re tied to certain contractors and systems. Right as you start collecting raw data, you’re free to switch from one system to another and from one partner to a different one.</p><p>What if you’re receiving data from your tracking provider in real-time, and the connection is suddenly lost? Raw data! It’s always available for downloading and doesn’t depend on the stable connection.</p><p><strong>For unlimited amounts of data</strong></p><p>Raw data can be collected in any volume without restrictions on the number of lines. Thus, when you need to “dig deeper” and see separate hits, raw data will come in handy.</p><p><strong>For special cases</strong></p><p>Before uniting data and make decisions based on it, we often have to get rid of some of the incorrect outcomes. For that, we need to access raw data, as with aggregated data, filtration is reduced. Typically, this “cleansing” is required when assessing the results of sociological research or polls.</p><p><strong>For simplicity</strong></p><p>Collecting raw data is easier than you may think — you just need one instrument for automized streaming, which will get the job done. Raw data can be helpful in all states of your company’s work process, that’s why you better start doing it now and use this information at any needed time.</p><p>Hopefully, the number of times we’ve mentioned “raw data” in this article has convinced you to go and collect it, and your businesses’ optimization will soon start showing desired results.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7b5866dbf10" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>