<?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 Atul Semwal on Medium]]></title>
        <description><![CDATA[Stories by Atul Semwal on Medium]]></description>
        <link>https://medium.com/@atul-semwal?source=rss-ee3ef5dcbf3------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*8w556VK7NaQcYunIpywtxw.jpeg</url>
            <title>Stories by Atul Semwal on Medium</title>
            <link>https://medium.com/@atul-semwal?source=rss-ee3ef5dcbf3------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 02:17:31 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@atul-semwal/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[How to Calculate Bounces and Bounce Rate from Adobe Analytics Data Feed]]></title>
            <link>https://atul-semwal.medium.com/how-to-calculate-bounces-and-bounce-rate-from-adobe-analytics-data-feed-59b2aa22104f?source=rss-ee3ef5dcbf3------2</link>
            <guid isPermaLink="false">https://medium.com/p/59b2aa22104f</guid>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[clickstream-analytics]]></category>
            <category><![CDATA[data-feed]]></category>
            <category><![CDATA[adobe-analytics]]></category>
            <dc:creator><![CDATA[Atul Semwal]]></dc:creator>
            <pubDate>Mon, 15 May 2023 05:10:14 GMT</pubDate>
            <atom:updated>2024-01-16T06:54:54.323Z</atom:updated>
            <content:encoded><![CDATA[<p>If you have ever tried calculating bounces in a data feed, you might have noticed that the numbers do not match up with Adobe Analytics workspace bounces. In most of the Adobe community, the definition to calculate bounces is to filter only the visits with visit depth 1 (visit_page_num); meaning where visit_page_name = 1 and count the concatenation of post_visid_high, post_visid_low, visit_num, and visit_start_time_gmt.</p><p>Here’s an example SQL query:</p><pre>SELECT COUNT(CONCAT(post_visid_high, post_visid_low, visit_num, visit_start_time_gmt)) as bounces<br>FROM your_data_feed_name WHERE visit_page_num = 1</pre><p>However, this definition is only half correct and will give you the incorrect number. Selecting visit_page_num = 1 will give you the first hit of a visit, regardless of whether there have been more.</p><p>To understand this better, let’s look at some data:</p><figure><img alt="Adobe clickstream data" src="https://cdn-images-1.medium.com/max/952/1*v-Y-J4F9h41WIfGJy_jZbQ.png" /></figure><p>Even though there is only a single bounce in line item 5, the SQL query above will count two bounces (line item 1 and line item 5). However, Item 1 should not be considered a bounce because it had subsequent hits (2, 3, 4).</p><p>To get the correct number of bounces, you should do a group by on the concatenation of post_visid_high, post_visid_low, visit_num, and visit_start_time_gmt, then select the column having sum of visit_page_num = 1. Here’s an example SQL query:</p><pre>SELECT COUNT(*) as bounces<br>FROM your_data_feed_name<br>GROUP BY CONCAT(post_visid_high, post_visid_low, visit_num, visit_start_time_gmt) <br>HAVING SUM(visit_page_num) = 1</pre><p>If you want to get the bounces by date, you can use this SQL query:</p><pre>SELECT date, COUNT(*) as bounces FROM <br>  (<br>    SELECT CONVERT(DATE, date_time) AS date,<br>           COUNT(*) AS bounce<br>    FROM your_data_feed_name<br>    WHERE <br>      Convert(DATE, date_time) BETWEEN &#39;2023-01-01&#39; AND &#39;2023-01-30&#39;<br>    GROUP BY CONVERT(DATE, date_time),<br>             CONCAT([post_visid_high],[post_visid_low], [visit_num], [visit_start_time_gmt])<br>    HAVING SUM(visit_page_num) = 1<br> ) AS subquery<br> GROUP BY date</pre><p>Finally, if you want to calculate the bounce rate, you can use these SQL queries:</p><pre>  WITH CTE1 AS (<br>  SELECT YEAR(Convert(DATE, date)) AS year,<br>    MONTH(Convert(DATE, date)) AS month, COUNT(*) as bounces FROM <br>  (<br>    SELECT CONVERT(DATE, date_time) AS date,<br>           COUNT(*) AS bounce<br>    FROM your_data_feed_name<br>    GROUP BY CONVERT(DATE, date_time),<br>             CONCAT([post_visid_high],[post_visid_low], [visit_num], [visit_start_time_gmt])<br>    HAVING SUM(visit_page_num) = 1<br>  ) AS subquery<br>  GROUP BY <br>    YEAR(Convert(DATE, date)),<br>    MONTH(Convert(DATE, date))<br> ), <br> CTE2 AS (<br>  SELECT <br>    YEAR(Convert(DATE, date_time)) AS year,<br>    MONTH(Convert(DATE, date_time)) AS month,<br>    COUNT(*) AS entry<br>  FROM your_data_feed_name<br>  WHERE visit_page_num = 1<br>  GROUP BY <br>    YEAR(Convert(DATE, date_time)),<br>    MONTH(Convert(DATE, date_time))<br> )<br> SELECT <br>  CTE1.year,<br>  CTE1.month,<br>  cte1.bounces, cte2.entry,<br>  (CAST(CTE1.bounces AS decimal)/CTE2.entry) AS bounce_rate<br> FROM CTE1<br> JOIN CTE2 ON CTE1.year = CTE2.year AND CTE1.month = CTE2.month<br> ORDER BY CTE1.year, CTE1.month; </pre><p>Please keep in mind that the SQL queries provided may not be optimized for performance. The main reason to write this article is to provide a clear understanding of the logic behind calculating Adobe bounces.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=59b2aa22104f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How I Tracked a QR Code Campaign Without Server-Side Implementation or Redirects]]></title>
            <link>https://atul-semwal.medium.com/how-we-tracked-a-qr-code-campaign-without-server-side-implementation-or-redirects-d4ca17041592?source=rss-ee3ef5dcbf3------2</link>
            <guid isPermaLink="false">https://medium.com/p/d4ca17041592</guid>
            <category><![CDATA[adobe-analytics]]></category>
            <category><![CDATA[marketing]]></category>
            <category><![CDATA[adobe-launch]]></category>
            <dc:creator><![CDATA[Atul Semwal]]></dc:creator>
            <pubDate>Tue, 21 Feb 2023 14:30:50 GMT</pubDate>
            <atom:updated>2023-02-21T14:42:52.493Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>How I Tracked a QR Code Campaign Without Server-Side Implementation or Redirects</strong></p><p>As a marketing analyst, tracking the success of a campaign is crucial to understand what works and what doesn’t. That’s why I was tasked with finding a way to track the success of our upcoming conference campaign, which involved distributing a flyer with a QR code directing attendees to a landing page promoting a new campaign.</p><p>The challenge was to track the <a href="https://www.wordstream.com/blog/ws/2012/10/10/vanity-url#:~:text=Vanity%20URL%20Definition%3A%20A%20vanity,remember%2C%20use%2C%20and%20share.">vanity URL</a> in Adobe Analytics without doing server-side implementation or redirect. After some research and experimentation, I found a solution using processing rules.</p><p>Here’s how it works: suppose the vanity URL is <a href="http://www.fakeurl.com/">www.fakeurl.com</a>. Create a processing rule in Adobe Analytics with the following condition: if Page URL equals <a href="http://www.fakeurl.com/">www.fakeurl.com</a>, then the action is to overwrite the value of evar28 (our Campaign variable) with custom value “qr_code_campaign”. This allows us to track the success of the campaign by monitoring the evar28 variable in Adobe Analytics.</p><p>Now to test the processing rule, log in to Experience Platform Debugger and turn on “Show post-processed hits”. This allows us to see hits after processing rules are applied. It’s important to note that it took me around 8 minutes to see the processed hits.</p><figure><img alt="Adobe debugger" src="https://cdn-images-1.medium.com/max/1024/1*Gh9P8q0yFEFtGX_1bxnj8g.png" /></figure><p>By using this approach, we were able to track the success of the QR code campaign and gather valuable insights into its performance. We could see how many people landed on the page using QR code, and how many ultimately converted on our call-to-action.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d4ca17041592" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The Ultimate Guide to Ace your Software Developer Interview in 2021]]></title>
            <link>https://atul-semwal.medium.com/the-ultimate-guide-to-acing-your-faang-interview-in-2021-faa148d8060d?source=rss-ee3ef5dcbf3------2</link>
            <guid isPermaLink="false">https://medium.com/p/faa148d8060d</guid>
            <category><![CDATA[software-engineering]]></category>
            <category><![CDATA[software-development]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[interview]]></category>
            <category><![CDATA[coding]]></category>
            <dc:creator><![CDATA[Atul Semwal]]></dc:creator>
            <pubDate>Mon, 26 Apr 2021 17:23:19 GMT</pubDate>
            <atom:updated>2022-09-08T10:26:14.205Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="faang" src="https://cdn-images-1.medium.com/max/318/1*kL1zyMIlxWBkT0ySrJvcMw.png" /><figcaption>Image Source: Hourspent</figcaption></figure><h3>Prerequisites</h3><blockquote>Before we get to the interesting part, it is crucial to understand the fundamentals and syntax of a programming language. Just stick to a single language (C++, Java, Python, JavaScript, etc.) that you are most comfortable with, crack the interview in this language, and depending upon the job requirement, you can learn the rest as you go.<br>Most employers don’t mind as long as you can demonstrate proficiency in any one programming language. I’ve seen people switch to a different programming language in the middle of the interview. Don’t do that, it’s a waste of time. Choose one early on and stick with it.</blockquote><h3>Building Data Structure and Algorithm Foundation ( First 3 months)</h3><p>For the first three months, your focus should be entirely on grasping the concept of data structures and algorithms.</p><p>Below is a summary of almost all of the data structures and algorithms topics that you might encounter during a technical interview, along with a Trello board resource to help you get started on your study plan. The aim is to provide a starting point for you to develop your strategy rather than discuss each topic in depth. Part of your plan is to read the same topic from various resources to develop a deeper understanding of each topic. For example, Once you learn about binary search trees in <a href="https://www.geeksforgeeks.org/">Geeksforgeek</a>, read about it on I<a href="https://www.interviewbit.com/practice/">nterviewbit</a> too. Then do 2–3 practice questions. Once you feel comfortable enough, move on to the next topic.</p><p>These are the topics that you will need to cover within 12 weeks. You can crunch it down according to your learning speed.</p><p><strong>Week 1-</strong> Time And Space. Understanding the Space and Time Complexity.</p><p><strong>Week 2-</strong> Arrays and Primitives</p><p><strong>Week 3-</strong> Strings</p><p><strong>Week 4-</strong> Linked List</p><p><strong>Week 5-</strong> Searching And Sorting</p><p><strong>Week 6-</strong> Stack and Queues</p><p><strong>Week 7-</strong> Trees</p><p><strong>Week 8-</strong> Basic Graph Algorithms</p><p><strong>Week 9-</strong> Advance Graph Algorithms and Special Trees</p><p><strong>Week 10-</strong> Greedy Algorithms and Hash Tables</p><p><strong>Week 11-</strong> Recursion and Backtracking</p><p><strong>Week 12-</strong> Dynamic Programing</p><p>So, here’s how to tackle each week. Let’s assume you are in week 7, and learning about Trees. You must first understand what Trees are, as well as the different types of trees, and should be able to define class Node and Tree. You will also need to know how to do things like add, search and delete elements, as well as pre-order, in-order, post-order, and level-by-level traversal. Finally, put in some practice time on different Tree questions available on various websites, target the easy questions first. After you’ve gotten used to tackling easy questions, advance to medium and hard.</p><p>Use the <a href="https://trello.com/templates/personal/interview-study-tracker-5g9FvwSF">Trello board</a> to keep track of your progress. Use this to create your own study tracker.</p><h3>Stepping up the Game (Last 3 months)</h3><p>Now that you have been building the foundation for the last three months, it’s time to get real.</p><ul><li>Start solving harder questions, which are more likely to come up during coding interviews. Also, work on the area where you are facing difficulties.</li><li>Get involved in competitive programming and participate in contests. Competitive programming will not only help you sharpen your problem-solving abilities but also help you become a better programmer overall. Join these platforms ( <a href="https://www.facebook.com/codingcompetitions/hacker-cup/">Facebook Hacker Club</a>, <a href="https://channels.theinnovationenterprise.com/articles/google-announces-news-innovation-challenge-in-the-apac-region">Google APAC</a>, <a href="https://www.hackerrank.com/">Hackerrank</a>, <a href="https://www.codechef.com/">Codechef</a>, <a href="https://codeforces.com/">Codechef</a> ) and participate in their challenges.</li><li>Build projects, do research, or try contributing to open source projects. You will be judged based on your Linkedin profile, project, certification, Github, research papers, etc. So, while preparing, make sure you work on these things. It would add value to your CV.</li><li>Start solving coding problems on whiteboard or paper, to get used to it.</li><li>Go through the Design Principle to ensure that your code follows the industry’s best coding practices.</li></ul><figure><img alt="Never Give up" src="https://cdn-images-1.medium.com/max/672/1*piBzuiyD4W7-Yrp_ShCjhA.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@fossy?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Fab Lentz</a> on <a href="https://unsplash.com/s/photos/motivational-quotes?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><h3>Getting ready for Interviews (~Last 2 months)</h3><p>Generally, the FAANG do interviews on a rolling basis. Consider yourself screwed once all the spots have been filled. Thus, it is crucial to apply for FAANG positions as early as possible. Do the research to see when the positions open and apply immediately.</p><h4>1. Creating A Perfect Resume</h4><p>Six seconds, the amount of time you get to make the first impression on the recruiter before it is tossed into the accepted or rejected pile. Here are some top tips to ensure that yours isn’t tossed away.</p><ul><li>Keep the resume within one page and ensure that each sentence counts. Rule of thumb, 1-page resume for less than 5 years working experience.</li><li>Keep it plain and professional. Use a limited number of shades, preferably use black font color, with blue titles.</li><li>Use a font size that is easy to read and use classic fonts like Calibri, Times New Roman, or Cambria.</li><li>Check for spelling and grammar errors. Get someone else to proofread it too.</li><li>Be sure to use keywords on your resume. Most companies have keyword searchers for resumes. If your resume does not include certain keywords, it might get rejected automatically. For keywords:<br>a. Read the Job description.<br>b. Check the skills required.<br>c. Includes these words on your resume (Put it in bold to attract the recruiter’s attention.)</li></ul><h4>2. Cover Letter</h4><p>Generally, people don’t put much thought into the cover letter. Don’t be one of them. Avoid generic cover letters; the recruiter will immediately recognize one and reject it. Cover letters should be tailored according to a role applied and organization; refer to the job description. A well-written cover letter can make a huge difference.<br><strong>Tips:</strong></p><ul><li>Open strong and have a punchline. Something as “Let me draw your attention to two reasons why I’d be a great addition to your team.”</li><li>Be positive and use action words.</li><li>Quantify your achievement. For example, “my internal tool automated 100% of the device adapter code generator, thereby increasing productivity by 50%”.</li><li>You don’t want to bore the recruiter, so keep things short and non-repetitive.</li><li>Proofread it several times and have it checked by someone else too.</li></ul><p><strong>This </strong><a href="https://info.lse.ac.uk/current-students/careers/Assets/Documents/application-and-cv-brochure.pdf"><strong>guide</strong></a><strong> will come in handy while creating a CV or a Cover letter.</strong></p><h4>3. Getting Referrals</h4><p>Referrals are one of the best ways to fast-track a candidate to the offer they desire. Referrals account for less than 10% of submissions, but they account for 20% to 50% of final hires.<br>Jobs are ultimately a personal affair. You work with people &amp; gauge:</p><ul><li>How much do you like your co-workers (synergy &amp; chemistry)?</li><li>How skilled is each teammate in their allocated role?</li><li>What gaps there may be in the team’s skillsets?</li></ul><p>I want to stress that even though you may be interviewing for a technical position, there are many other factors that come into play when a team/employer is evaluating your employment prospects.</p><p>People trust people that they already trust. This is why referrals are the #1 way to get the job that you desire.</p><p>I definitely recommend reading <a href="https://haseebq.com/how-to-break-into-tech-job-hunting-and-interviews/">Haseeb Q’s guide</a>.</p><h3>Behavioral Interview</h3><p>The behavioral interview is an oft-overlooked yet absolutely crucial part of the interview process. I really like to stress that interviewing is a people process, and as such, it is crucial that you practice the interpersonal aspect of interviews in addition to the technical portion (this is more relevant to on-sites vs online screens).</p><p>We break the behavioral interview down into two topics:</p><ul><li>Building rapport with your interviewer</li><li>Using the<a href="https://www.themuse.com/advice/star-interview-method"> S.T.A.R.</a> method to have articulate responses to behavioral questions.</li></ul><h3>Technical Interview</h3><p><a href="https://docs.google.com/document/d/1th1hZE4ThhX2tD2lLSaUTAwwXVHjqzR1_d3LPyErVIc/edit">Here’s</a> an overview of what you’ll need to know in order to pass technical interviews. Few other resources that will help in preparation for the interview:</p><ul><li><a href="https://backtobackswe.com/checkout?plan=1%20Year%20Plan&amp;discount_code=MEDIUM10">Backtobackswe.com</a>( You can have a 10% discount using my link)</li><li><a href="https://www.algoexpert.io/product">Algoexpert.io</a></li><li><a href="https://www.interviewbit.com/practice/">Interviewbit.com</a></li><li><a href="https://www.amazon.in/gp/product/0984782869/ref=as_li_tl?ie=UTF8&amp;camp=3638&amp;creative=24630&amp;creativeASIN=0984782869&amp;linkCode=as2&amp;tag=200bcbd-21&amp;linkId=caeab036f5744fd90eb0ba79373d3dc5">Cracking the coding interview </a>(Read it 2 months before applying)</li></ul><h3>General tips</h3><ul><li>Build a proper routine. Your initial motivation will die within a month or so. A proper routine helps you stick to a plan, during days when you will not be dedicated enough. Prepare to be harsh on yourself. Scold yourself when you deviate from the routine.</li><li>Use the <a href="https://www.forbes.com/sites/bryancollinseurope/2020/03/03/the-pomodoro-technique/?sh=4c84d0823985">Pomodoro technique</a> to help with distraction.</li><li>Choose a perfect environment purely for studying. This is important because your brain soon learns that it is time to concentrate when you are in that spot. Pay careful attention to the lighting and the amount of distraction.</li><li>Make sure you do enough physical activities. Even desk exercise will do the work.</li></ul><h3>Resources</h3><p><a href="https://www.bigocheatsheet.com/">Big O Cheat Sheet</a></p><p><a href="https://www.facebook.com/careers/facebook-life/how-we-hire">Facebook hiring process</a></p><p><a href="https://www.amazon.jobs/en/landing_pages/interviewing-at-amazon">Amazon hiring process</a></p><p><a href="https://careers.google.com/how-we-hire/">Google hiring process</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=faa148d8060d" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>