<?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 Otuekong Emmanuel  on Medium]]></title>
        <description><![CDATA[Stories by Otuekong Emmanuel  on Medium]]></description>
        <link>https://medium.com/@shieldemmanuel22?source=rss-40bfb1a64a80------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*qE-WsHbquWqkrQN6</url>
            <title>Stories by Otuekong Emmanuel  on Medium</title>
            <link>https://medium.com/@shieldemmanuel22?source=rss-40bfb1a64a80------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 19:23:01 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@shieldemmanuel22/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[INSTAGRAM USER ANALYTICS]]></title>
            <link>https://medium.com/@shieldemmanuel22/instagram-user-analytics-f661f354af92?source=rss-40bfb1a64a80------2</link>
            <guid isPermaLink="false">https://medium.com/p/f661f354af92</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[instgaram]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Otuekong Emmanuel ]]></dc:creator>
            <pubDate>Fri, 29 Dec 2023 21:56:37 GMT</pubDate>
            <atom:updated>2023-12-29T21:56:37.599Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/303/1*3IKiLcFrNuJBwvHg_eB0aQ.jpeg" /></figure><h3><strong>OVERVIEW:</strong></h3><p>User analytics is the process by which we track how users engage and interact with our digital product(software or mobile application) in an attempt to derive business insights for marketing, product and development teams.</p><p>These insights are then used by teams across the business to launch a new marketing campaign, decide on features to build for an app, track the success of the application by measuring users engagement and improve the experience altogether while helping the business grow.</p><p><strong>BUSINESS PROBLEM</strong></p><p><strong>A)Marketing</strong>: The marketing team wants to launch some campaigns, and they need your help with the following</p><p><strong>1.Rewarding Most loyal users:</strong> People who have been using the platform for the longest time.</p><p><strong>Task:</strong> Find the 5 oldest users of Instagram from the database provided</p><p><strong>2.Remind inactive users to start posting:</strong> By sending promotional emails to post their first photo.</p><p><strong>Task:</strong> Find users who have never posted a Sigle photo on Instagram</p><p><strong>3.Declaring Contest Winner:</strong> The team started a contest and the user who get the most likes on a single photo will win the contest now there wish to declare the winner.</p><p><strong>Task:</strong> Identify the winner of the contest and provide their details to the team</p><p><strong>4.Hashtag Researching</strong>: A partner brand wants to know which hashtags to use in the post to reach the most people on the platform</p><p><strong>Task</strong>: Identify and suggest the top most commonly used hashtags on the platform</p><p><strong>5.Launch AD Campaign:</strong> The team wants to know, which day would be the best day to launch ADs.</p><p><strong>Task:</strong> What day of the week do most users register on? Provide insights on when to schedule an ad campaign.</p><p><strong>B) Investors Metrics:</strong> Our investors wants to know if Instagram is performing well and is not becoming redundant like Facebook, they want to access the app on the following grounds</p><p><strong>1:User engagement:</strong> Are users still as active and post on Instagram or they are making fewer posts</p><p><strong>Task</strong>: Provide how many times does average user post on Instagram. Also, provide the total number of photos on Instagram/total number of users</p><p><strong>Dataset:</strong> The data is stored inside Microsoft azure sql database the data contains a total dataset of 7 columns namely “comments, follows, likes, photo_tags, photos,tags, users”</p><p><strong>Here are some questions that we’d like to be able to answer:</strong></p><p>-1. Find the oldest users of the Instagram from the database provided</p><p>-2.Find users who have not posted a single photo on Instagram.</p><p>-3.identify the winner of the contest and provide their details to the team the person with the most like on a single photo</p><p>-4.Identify and suggest 5 commonly used hashtags on the platform</p><p>-5 What day of the week do most users register on? Provide insights on when to schedule ads campaign</p><p>-6 Provide how many times does the average user post on Instagram, also provide the total number of photos on Instagram/total number of users</p><p><strong>INSIGHTS:</strong></p><p><strong>1.The most loyal and oldest users of the platform that deserve rewards are the following;</strong></p><p>-Darby Herzog, joined the platform on 2016–05–06</p><p>-Emilio Bernier52, joined the platform on 2016–05–06</p><p>-Elenor88, joined the platform on 2016–05–14</p><p>Nicole71, joined the platform on 2016–05–14</p><p>Jordyn.Jacobson2, joined the platform on 2016–05–14</p><p><strong>2.The following are users who have not posted a single photo</strong></p><pre>Aniya_Hackett	    </pre><pre>Kasandra_Homenick<br>Jaclyn81	        <br>Rocio33	            <br>Maxwell.Halvorson	<br>Tierra.Trantow	    <br>Pearl7	            <br>Ollie_Ledner37	   <br>Mckenna17	        <br>David.Osinski47	    <br>Morgan.Kassulke	    <br>Linnea59	        <br>Duane60        <br>Julien_Schmidt	    <br>Mike.Auer39      <br>Franco_Keebler64<br>Nia_Haag	        <br>Hulda.Macejkovic<br>Leslie67	        <br>Janelle.Nikolaus81	<br>Darby_Herzog	    <br>Esther.Zulauf61  	<br>Bartholome.Bernhard<br>Jessyca_West	    <br>Esmeralda.Mraz57	<br>Bethany20</pre><p><strong>3. The person with the most like on a single photo</strong></p><p>The winner is Zack_Kemmer93 with a maximum likes of 48</p><p><strong>4.The 5 commonly used hashtags is the following with their number of tag count**</strong></p><p>smile 59 beach 42 party 39 fun 38 lol 24 food 24 concert 24 hair 23 happy 22 dreamy 20</p><p><strong>5.The best day of the week to run ads campaign is the day we have most users registration which are</strong>;<strong> Sunday</strong> with a registration count of 16 and <strong>Thursday</strong> with a registration count of 16</p><p><strong>6.The average user post on Instagram, and the total number of photos on Instagram/total number of users is;</strong></p><p>total_photos 257</p><p>total_users 74</p><p>average_posts_per_user 3.472972972972</p><p><strong>RECOMMENDATIONS</strong></p><p>1.From the above analysis the market team has to step up publicity to draw more users. users who have not posted any single photos should be sent promotional emails.</p><p>2.Also the top trending hashtags should be use to gain more visibility on the application.</p><p>Thank you!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f661f354af92" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[**Unlocking Business Growth with Product Analytics: My Pendo X Journey**]]></title>
            <link>https://medium.com/@shieldemmanuel22/unlocking-business-growth-with-product-analytics-my-pendo-x-journey-5e4f705659f6?source=rss-40bfb1a64a80------2</link>
            <guid isPermaLink="false">https://medium.com/p/5e4f705659f6</guid>
            <category><![CDATA[product-analysis]]></category>
            <category><![CDATA[product-analyst]]></category>
            <category><![CDATA[product-analytics]]></category>
            <category><![CDATA[product-analytics-tools]]></category>
            <dc:creator><![CDATA[Otuekong Emmanuel ]]></dc:creator>
            <pubDate>Tue, 24 Oct 2023 23:14:57 GMT</pubDate>
            <atom:updated>2023-10-24T23:14:57.782Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PlB6AleLz92oM_GNgpC-9g.png" /></figure><p>I am thrilled to share my recent journey with the Pendo X Product Analytics course and how it has enriched my skillset as a Data/Product Analyst. These newfound skills promise to play a pivotal role in driving business growth and innovation.</p><p>As we navigate the digital landscape, data has become the cornerstone of decision-making in businesses of all sizes. Leveraging this data effectively can provide invaluable insights, and this is where product analytics takes the lead. My journey with Pendo X has not only deepened my understanding of this field but also expanded my repertoire of skills.</p><p>**1. Data Collection and Analysis:**</p><p>Through the course, I have honed my ability to collect and analyze data comprehensively. I now have the tools to gather user interactions, track customer journeys, and distill meaningful insights from the information at hand. This skill will help me better understand customer behavior, preferences, and pain points.</p><p>**2. User Segmentation:**</p><p>Segmentation is a powerful technique for targeting specific user groups. I have learned to create and analyze segments based on common characteristics, which is instrumental in tailoring products to meet the unique needs of different user groups. This segmentation approach promises to enhance user experiences and drive user engagement.</p><p>**3. Prioritizing Features and Improvements:**</p><p>One of the most significant takeaways has been the ability to make informed decisions regarding feature prioritization. I now have the tools to identify what users value most, which helps in focusing development efforts on high-impact features and improvements. This ensures that our product aligns with customer expectations.</p><p>**4. Measuring Adoption and Success:**</p><p>Being able to measure feature adoption and success is paramount. Pendo X has equipped me to monitor how users interact with our product, measure feature usage, and understand what truly resonates with our audience. This data-driven approach helps in refining and optimizing the product continually.</p><p>**5. Aha Moments and Retention Strategies:**</p><p>Learning to identify and act upon “aha moments” has been a revelation. These are the pivotal points in a user’s journey that lead to satisfaction and retention. Armed with this knowledge, I can craft strategies that not only onboard users effectively but also keep them engaged for the long term.</p><p>As a Data/Product Analyst, these skills are my toolkit for generating actionable insights that drive decision-making and fuel business growth. The data-backed decisions I can now make are the key to not only meeting but exceeding customer expectations, which translates directly to increased customer satisfaction, brand loyalty, and, ultimately, revenue.</p><p>In a rapidly evolving digital landscape, the ability to harness the power of data and product analytics is no longer a luxury; it’s a necessity. Pendo X has not only equipped me with these capabilities but also inspired me to stay at the forefront of innovation in my role.</p><p>The journey with Pendo X has been transformative, and I am excited to leverage these skills to drive business growth, delight our customers, and make a meaningful impact. I look forward to the challenges and opportunities that lie ahead and am eager to contribute to the success of our organization.</p><p>#PendoX #ProductAnalytics #DataAnalysis #BusinessGrowth #CustomerSatisfaction</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5e4f705659f6" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>