A Sudden Drop in User Engagement

disclaimer: I don’t work for Yammer, this is a public data case study, I’ve written it in a narrative format to make this case study more engaging to read.

It’s Monday morning…you sit down at your desk with a cup of coffee — your eyes barely open. Suddenly the head of product taps you on your shoulder and slams his laptop down on your desk.

“How did our weekly engagement drop 21% in a month?!”

Sighhhhhhh

You crack your knuckles, and put down your coffee — “let’s take a look”.

Line graph of weekly active users

Hmmm…at first glance it looks our weekly engagement levels have been steadily declining since July 28. At Yammer, we define ‘engagement’ as any interaction with the product that makes a “server call” (aka if the user clicked on something).

In general, most companies look at user engagement as one of their main KPIs (key performance indicators) for overall growth & health of their product.

To those who haven’t heard of us, Yammer is a social network for enterprises (similar to Workplace by Facebook). Employees can send messages, search the intranet, share documents, and post updates.

#user-engagement #data-visualization #case-study #data-science #data #visual studio code

What is GEEK

Buddha Community

Solwin Infotech

1620992479

How To Create User-Generated Content? [A Simple Guide To Grow Your Brand]

This is image title

In this digital world, online businesses aspire to catch the attention of users in a modern and smarter way. To achieve it, they need to traverse through new approaches. Here comes to spotlight is the user-generated content or UGC.

What is user-generated content?
“ It is the content by users for users.”

Generally, the UGC is the unbiased content created and published by the brand users, social media followers, fans, and influencers that highlight their experiences with the products or services. User-generated content has superseded other marketing trends and fallen into the advertising feeds of brands. Today, more than 86 percent of companies use user-generated content as part of their marketing strategy.

In this article, we have explained the ten best ideas to create wonderful user-generated content for your brand. Let’s start without any further ado.

Content From Social Media Platforms
In the year 2020, there are 3.81 million people actively using social media around the globe. That is the reason social media content matters. Whenever users look at the content on social media that is posted by an individual, then they may be influenced by their content. Perhaps, it can be used to gain more customers or followers on your social media platforms.

Generally, social media platforms help the brand to generate content for your users. Any user content that promotes your brand on the social media platform is the user-generated content for your business. When users create and share content on social media, they get 28% higher engagement than a standard company post.

Furthermore, you can embed your social media feed on your website also. you can use the Social Stream Designer WordPress plugin that will integrate various social media feeds from different social media platforms like Facebook, Twitter, Instagram, and many more. With this plugin, you can create a responsive wall on your WordPress website or blog in a few minutes. In addition to this, the plugin also provides more than 40 customization options to make your social stream feeds more attractive.

Consumer Survey
The customer survey provides powerful insights you need to make a better decision for your business. Moreover, it is great user-generated content that is useful for identifying unhappy consumers and those who like your product or service.

In general, surveys can be used to figure out attitudes, reactions, to evaluate customer satisfaction, estimate their opinions about different problems. Another benefit of customer surveys is that collecting outcomes can be quick. Within a few minutes, you can design and load a customer feedback survey and send it to your customers for their response. From the customer survey data, you can find your strengths, weaknesses, and get the right way to improve them to gain more customers.

Run Contests
A contest is a wonderful way to increase awareness about a product or service. Contest not just helps you to enhance the volume of user-generated content submissions, but they also help increase their quality. However, when you create a contest, it is important to keep things as simple as possible.

Additionally, it is the best way to convert your brand leads to valuable customers. The key to running a successful contest is to make sure that the reward is fair enough to motivate your participation. If the product is relevant to your participant, then chances are they were looking for it in the first place, and giving it to them for free just made you move forward ahead of your competitors. They will most likely purchase more if your product or service satisfies them.

Furthermore, running contests also improve the customer-brand relationship and allows more people to participate in it. It will drive a real result for your online business. If your WordPress website has Google Analytics, then track contest page visits, referral traffic, other website traffic, and many more.

Review And Testimonials
Customer reviews are a popular user-generated content strategy. One research found that around 68% of customers must see at least four reviews before trusting a brand. And, approximately 40 percent of consumers will stop using a business after they read negative reviews.

The business reviews help your consumers to make a buying decision without any hurdle. While you may decide to remove all the negative reviews about your business, those are still valuable user-generated content that provides honest opinions from real users. Customer feedback can help you with what needs to be improved with your products or services. This thing is not only beneficial to the next customer but your business as a whole.

This is image title

Reviews are powerful as the platform they are built upon. That is the reason it is important to gather reviews from third-party review websites like Google review, Facebook review, and many more, or direct reviews on a website. It is the most vital form of feedback that can help brands grow globally and motivate audience interactions.

However, you can also invite your customers to share their unique or successful testimonials. It is a great way to display your products while inspiring others to purchase from your website.

Video Content
A great video is a video that is enjoyed by visitors. These different types of videos, such as 360-degree product videos, product demo videos, animated videos, and corporate videos. The Facebook study has demonstrated that users spend 3x more time watching live videos than normal videos. With the live video, you can get more user-created content.

Moreover, Instagram videos create around 3x more comments rather than Instagram photo posts. Instagram videos generally include short videos posted by real customers on Instagram with the tag of a particular brand. Brands can repost the stories as user-generated content to engage more audiences and create valid promotions on social media.

Similarly, imagine you are browsing a YouTube channel, and you look at a brand being supported by some authentic customers through a small video. So, it will catch your attention. With the videos, they can tell you about the branded products, especially the unboxing videos displaying all the inside products and how well it works for them. That type of video is enough to create a sense of desire in the consumers.

#how to get more user generated content #importance of user generated content #user generated content #user generated content advantages #user generated content best practices #user generated content pros and cons

Zakary Schmeler

1598423580

A Sudden Drop in User Engagement

disclaimer: I don’t work for Yammer, this is a public data case study, I’ve written it in a narrative format to make this case study more engaging to read.

It’s Monday morning…you sit down at your desk with a cup of coffee — your eyes barely open. Suddenly the head of product taps you on your shoulder and slams his laptop down on your desk.

“How did our weekly engagement drop 21% in a month?!”

Sighhhhhhh

You crack your knuckles, and put down your coffee — “let’s take a look”.

Line graph of weekly active users

Hmmm…at first glance it looks our weekly engagement levels have been steadily declining since July 28. At Yammer, we define ‘engagement’ as any interaction with the product that makes a “server call” (aka if the user clicked on something).

In general, most companies look at user engagement as one of their main KPIs (key performance indicators) for overall growth & health of their product.

To those who haven’t heard of us, Yammer is a social network for enterprises (similar to Workplace by Facebook). Employees can send messages, search the intranet, share documents, and post updates.

#user-engagement #data-visualization #case-study #data-science #data #visual studio code

Cayla Erdman

1598439180

Find user who ran DROP statements – SQL Server

Introduction

Sometimes we need to track or find which user has **_DROPPED _**the table(s) from the Database. In this article, we will discuss the possible ways to track this situation.

I have a table already in my Database,

SELECT 
     [StudentId],
     [FirstName],
     [LastName]
FROM [StudentManagementSystem].[Students].[StudentDetails]

Fig 1. Results

Drop table

Now I am going to apply the Drop Statement to drop the table.

DROP TABLE [StudentManagementSystem].[Students].[StudentDetails]

Now the table is dropped, and if we run the SELECT statement for the above table, we will get an error as,

Fig 2. Invalid object Name

Option 1

The first option is by using the fn_dblog() function. fn_dblog() is undocumented functions in SQL Server. This function give the transaction logs records in the active part of the transaction log file for the current database.

SELECT 
     [Transaction Id],
     [Transaction Name],
     [Begin Time],
     SUSER_SNAME ([Transaction SID]) AS [User]
FROM fn_dblog (NULL, NULL)
WHERE [Transaction Name] = 'DROPOBJ'
GO

Fig 3. List of Users who has dropped the tables

When we run the above statements in the respective Database, it will list the results of users and the tables dropped. The result column Transaction SID holds the user name.

#sql server #dropped table #find user dropped table #sql query #sql

I am Developer

1597487472

Country State City Dropdown list in PHP MySQL PHP

Here, i will show you how to populate country state city in dropdown list in php mysql using ajax.

Country State City Dropdown List in PHP using Ajax

You can use the below given steps to retrieve and display country, state and city in dropdown list in PHP MySQL database using jQuery ajax onchange:

Step 1: Create Country State City Table
Step 2: Insert Data Into Country State City Table
Step 3: Create DB Connection PHP File
Step 4: Create Html Form For Display Country, State and City Dropdown
Step 5: Get States by Selected Country from MySQL Database in Dropdown List using PHP script
Step 6: Get Cities by Selected State from MySQL Database in DropDown List using PHP script

https://www.tutsmake.com/country-state-city-database-in-mysql-php-ajax/

#country state city drop down list in php mysql #country state city database in mysql php #country state city drop down list using ajax in php #country state city drop down list using ajax in php demo #country state city drop down list using ajax php example #country state city drop down list in php mysql ajax

Nina Diana

1578050760

10 Best Vue Drag and Drop Component For Your App

Vue Drag and drop is a feature of many interactive web apps. It provides an intuitive way for users to manipulate their data. Adding drag and drop feature is easy to add to Vue.js apps.

Here are 10 vue drop components that contribute to the flexibility of your vue application.

1. Vue.Draggable

Vue component (Vue.js 2.0) or directive (Vue.js 1.0) allowing drag-and-drop and synchronization with view model array.

Based on and offering all features of Sortable.js

Vue.Draggable

Demo: https://sortablejs.github.io/Vue.Draggable/#/simple

Download: https://github.com/SortableJS/Vue.Draggable/archive/master.zip

2. realtime-kanban-vue

Real-time kanban board built with Vue.js and powered by Hamoni Sync.

realtime-kanban-vue

Demo: https://dev.to/pmbanugo/real-time-kanban-board-with-vuejs-and-hamoni-sync-52kg

Download: https://github.com/pmbanugo/realtime-kanban-vue/archive/master.zip

3. vue-nestable

Drag & drop hierarchical list made as a vue component.

Goals

A simple vue component to create a draggable list to customizable items
Reorder items by dragging them above an other item
Intuitively nest items by dragging right
Fully customizable, ships with no css
Everything is configurable: item identifier, max nesting level, threshold for nesting

vue-nestable

Demo: https://rhwilr.github.io/vue-nestable/

Download: https://github.com/rhwilr/vue-nestable/archive/master.zip

4. VueDraggable

VueJS directive for drag and drop.

Native HTML5 drag and drop implementation made for VueJS.

VueDraggable

Demo: https://vivify-ideas.github.io/vue-draggable/

Download: https://github.com/Vivify-Ideas/vue-draggable/archive/master.zip

5. vue-grid-layout

vue-grid-layout is a grid layout system, like Gridster, for Vue.js. Heavily inspired in React-Grid-Layout

vue-grid-layout

Demo: https://jbaysolutions.github.io/vue-grid-layout/examples/01-basic.html

Download: https://github.com/jbaysolutions/vue-grid-layout/archive/master.zip

6. vue-drag-tree

It’s a tree components(Vue2.x) that allow you to drag and drop the node to exchange their data .

Feature

Double click on an node to turn it into a folder
Drag and Drop the tree node, even between two different levels
Controls whether a particular node can be dragged and whether the node can be plugged into other nodes
Append/Remove Node in any level (#TODO)

vue-drag-tree