Categories
Digital Marketing

benchmark your mysql db infra

#! /bin/sh

ssh db1

sudo hdparm -Tt /dev/sda
Categories
Android Bangalore Shoppre.com UX

ShoppRe.com – Android App – User Experience

ShoppRe.com provides Indian Sellers can sell the products across world with easy international shipping

Categories
Bangalore Brand Design Logo Design MSGQ

MSGQ – Open Source Solution for Digital SMS Marketing at Scale – Logo Design

Project Link: https://github.com/msgq/msgq

MSGQ Logo Design by Krutika Thakkar
Dark Version
1024x500 for Android Store Listing by Krutika Thakkar
1024×500 for Android Store Listing
Wordmark with Logo by Krutika Thakkar
Wordmark with Logo
400x400 Logo without Wordmark by Krutika Thakkar
400×400 Logo without Wordmark
MSGQ Wordmark without Logo by Krutika Thakkar
Wordmark without Logo

Single Color Logo
Single Color Logo

Black & While Logo
Black & While Logo
Categories
MySQL for Digital Marketing

mysqldump all databases

mysqldump --all-databases -u root -p > all-dbs.sql
Categories
MySQL for Digital Marketing

mysql check and optimize all table

mysqlcheck -c  -u root -p --all-databases
Categories
MySQL for Digital Marketing

List mysql database sort by size

cd /var/lib/mysql
sudo du --max-depth=1 -h | sort -h

In phpmyadmin

Categories
AWS Linode Linode vs AWS vs Google Cloud vs Azure MySQL for Digital Marketing

MySQL Full Server Migration with users and grants

# SSH to New DB Server
ssh db1.shopping.com

# Take dump
ssh ubuntu@old-db1.shopping.com 'mysqldump --all-databases -u root -p | gzip' | mysql -u root -p

References:

https://stackoverflow.com/questions/23519797/how-to-export-import-existing-user-with-its-privileges

Categories
Digital Marketing

MySQL Migration with rsync

# New MySQL Server
ssh ubuntu@db1.shopping.com
sudo systemctl start mysqld
cd /var/lib
sudo mv mysql myql-backup
sudo mkdir mysql

# rsync from existing db
sudo rsync ubuntu@old-db1.shopping.com:/var/lib/mysql /var/lib/mysql
sudo systemctl start mysqld

Issues:

https://support.severalnines.com/hc/en-us/community/posts/251222603-MySQL-Database-Migration-using-Rsync

Categories
2020 DevOps Guide for Startups

Building Architecture that migrates from one cloud to another in 5 minutes easily

FAQ

How to migrate mysql without downtime

  1. Setup new server

    setup a new server

  2. Install OmniMigrate

  3. Give old server root credentials

  4. Git new server root credentials

  5. Change dns

SAAS Apps Migration

which involves App, DB, Storage

Categories
Digital Marketing

Announcing the Adobe Digital Experience Partner of the Year Awards

https://theblog.adobe.com/announcing-the-adobe-digital-experience-partner-of-the-year-awards/

Categories
Digital Marketing

MySQL Database Best Practices

  • collation: utf8mb4_general_ci
  • increase query cache
  • use SSD
  • keep db in local network or same host(do not keep db server in USA, appserver in India)

Categories
2020 Yoast SEO with WordPress Guide

Simplify Author url with edit author plugin

Categories
2020 Yoast SEO with WordPress Guide ShoppreParcels.com

Yoast Breadcrumbs to Improve Search Appearance

Categories
2020 Yoast SEO with WordPress Guide

SEO Optimization with Yoast & WordPress

1. Writing Details in WordPress Category and Remove Category from URL and Heading

  • Install yoast seo plugin
  • Goto SEO -> Search Appearance -> Taxonomy
  • Remove category from URL and Save

Follow https://stackoverflow.com/questions/50822436/remove-category-from-header-title-on-category-pages-in-wordpress

2. Writing Content in Category page

  • Add one image for category
    • Keep image name relevant to seo keywords or article title
    • Write alt text, title, caption and description relevant to seo keywords

Make WhatsApp, FB, Twitter sharing friendly

  • In above image, if you like to see image in preview use same image width and height

For more seo optimization, follow yoast instructions

Nikkitha Shanker from Bangalore

//Author URI: http://stephanis.info

add_filter( 'the_content', 'add_ids_to_header_tags' );
function add_ids_to_header_tags( $content ) {

    $pattern = '#(?P<full_tag><(?P<tag_name>h\d)(?P<tag_extra>[^>]*)>(?P<tag_contents>[^<]*)</h\d>)#i';
    if ( preg_match_all( $pattern, $content, $matches, PREG_SET_ORDER ) ) {
        $find = array();
        $replace = array();
        foreach( $matches as $match ) {
            if ( strlen( $match['tag_extra'] ) && false !== stripos( $match['tag_extra'], 'id=' ) ) {
                continue;
            }
            $find[]    = $match['full_tag'];
            $id        = sanitize_title( $match['tag_contents'] );
            $id_attr   = sprintf( ' id="%s"', $id );
            $replace[] = sprintf( '<%1$s%2$s%3$s>%4$s</%1$s>', $match['tag_name'], $match['tag_extra'], $id_attr, $match['tag_contents']);
        }
        $content = str_replace( $find, $replace, $content );
    }
    return $content;
}

https://wordpress.stackexchange.com/questions/94663/dynamically-add-id-to-heading-tags

https://wordpress.org/support/topic/increase-headers-h1-h2-h3etc-as-needed/

Categories
2020 Quora Guide

2020 Marketing Guide for Quora.

If you want to find some new clients try taking a different approach.

Have you ever given a thought to understanding the pain points of your customer? What if I tell you that solving their problems can help you win them as your customers?

Good content marketing is all about solving problems. It not only helps build a rapport of your brand in the market, but it also makes you a great problem solver in the respective field. It builds up your authority.

An incredible way to drive sales is to attract the target audience by answering their questions directly.

You can find such questions related to your field all across the Internet; however, one platform where you can find questions abundantly is none other but Quora. It is a great platform for such interactions.

Why Consider Quora?

Firstly, because writing an answer on Quora is relatively easier than writing a complete blog post.

Secondly, a Quora answer can be more insightful and can be easily shared on Facebook or Twitter compared to a blog post.

Because, when you share a link of a blog as a Tweet or a Facebook post, there is a small chance that people will prefer to click compared to a Quora answer.

Also, Quora has a higher search rank which means your answers will more likely appear on Google Search than a blog,

So what does an ideal Quora answer look like to the audience?

Well, if you ask me, anything that isn’t less than 150 words or does not exceed 1000 words is a good enough answer to go on Quora.

At an average, people usually sum up their answers in 400–500 words.

Based on the questions that you address and how adequately you include your business links in the answer becomes a deciding factor to help you earn some good profitable leads in your businesses.

Why Should You Use Quora to Generate Traffic?

Here’s a quick breakdown of the main benefits of promoting your blog on Quora:

1. Increase Website Referral Traffic for Free

First and foremost, referral traffic is from users who come to your website by clicking a link from another site.

Did I mention that referral traffic is completely free?

Unlike paid traffic acquired through ads, you don’t have to spend a single dime on referral traffic.

Unlike paid traffic acquired through ads, you don’t have to spend a single dime on referral traffic.

Of course, Quora gives you an option to run ads and accelerate your results. This brings us to the next benefit of using Quora as a traffic generation channel.

2. Traffic From Day 1

If you know what you’re doing, you can turn Quora into a traffic-driving machine for your blog in a single day.

One option is to build a Quora ad campaign and have your brand appear to users who ask about relevant topics. I recommend this route if you have funds to spare and if you already got your feet wet on pay-per-click or PPC advertising.

You can also get clicks as soon as you start if you have a well-planned Quora marketing strategy.

Why am I so confident?

Because, with Quora, you can position your content right in front of your ideal audience.

This leads us to the next point.

3. Hyper-Targeted Content Promotion

Want to promote your content to marketing managers or full-time bloggers? How about teachers, lawyers, or doctors?

On Quora, you can laser-target your content promotions to anyone you like.

The trick is to view the “Stats and Log” page of the questions you’re trying to answer. This can be found on the ‘More’ menu.

This will reveal the complete history of the Quora post, including when it was posted and who asked the question.

Fortunately, most users make it a point to include complete details of their profession on their profile — making it possible to generate high-quality leads from Quora.

Although you may find a few users who ask questions anonymously, the chances of that are slim.

4. Promote Other Types of Content

Quora not only allows text-based answers — you may also include videos, images, social media handles, quotes, and customized links to your content.

You know what that means, right?

5. Build Your Brand Authority

Whether or not you choose to include various content types in your answers, being active on Quora positions yourself as the blogger who knows your stuff.

Sure, it won’t happen overnight. But if you remain consistent in the quality of information you provide the Quora community, you’re well on your way there.

6. Get Noticed by Other Publications

If you fancy guest blogging or being interviewed by top publications, Quora will help pave a way for you.

In case you didn’t notice, authoritative marketers, agencies, fellow bloggers, and even executives also utilize Quora as a promotion channel.

Showcasing your knowledge through cohesive and insightful answers is one way to get their attention. You can also interact with them by leaving comments on their answers.

7. Never-Ending Stream of Content Ideas

As a blogger, you should know how tough it is to come up with fresh content ideas on a regular basis.

Quora might be the answer to your problems with its never-ending ending pool of content ideas waiting for you to discover. For every post, it provides a network of related questions that you can use in your next blog post.

Using the search bar, entering a couple of keywords may also help you generate ideas right off the bat. While most of the suggestions need some refining, it shouldn’t be hard to tweak them into usable content titles.

How to Get Traffic From Quora

Pumped to get started with Quora marketing? Then let me show you how to use Quora to get traffic.

Step 1: Pick the Right Interests

Upon creating your account, Quora will ask you to specify your fields of interest, which will be added to your feed. This will make it easy for you to find relevant questions to answer later on, so be sure to choose everything aligned with your niche.

You need to select at least 10 topics before you can complete your registration.

Step 2: Start with a Killer Profile Bio

Just like with social media marketing, you need an awesome author bio to establish a solid presence on Quora.

A good chunk of your profile’s configuration involves basic steps, like adding your profile photo and filling in your name. What you need to pay attention to, however, are your credentials and description.

Your description doesn’t have to be an entire article’s worth of words — just keep it short, straightforward, and impactful.

You can simply enumerate your job experience, what you do, and maybe a couple of your hobbies. You can also list down the websites you’ve been featured in if you’ve been actively guest blogging.

Your profile should also contain links to relevant pages, such as your website or social media profiles.

Whenever other Quora users visit your profile, they’re all asking the same questions:

Who is this person and why should I trust him?

Your Quora profile should address those doubts with a complete record of your credentials. All these can be found and edited at the right-most section of your profile.

If you work for a popular company, be sure to select the official Quora “topic” for your company.

Remember, Quora doesn’t have business pages — even for big-name brands — per se. Rather, companies are treated as topics that users can follow and form discussions around.

For example, if you are a tech blogger working as a software engineer on Facebook, you may select either the topic for the company or the core product itself.

If your brand isn’t registered as a Quora topic yet, you can do so yourself by scrolling to the bottom of the list and clicking ‘Create Topic.’

This takes us to the next step you should take.

Step 3: Create a Topic for Your Brand

After you create your brand’s topic on Quora, you should be able to find it in the search suggestions. Go ahead and click on it to view your topic page.

Unlike Quora profiles, you can’t write a description for your brand topic. You can only add an official topic photo, modify the name, manage topic “aliases,” and merge it with existing topics.

To manage your topic’s aliases, click the three-dot settings button, select ‘Manage,’ and click ‘Add Alias.’

Aliases help users find your topic through common misspellings, abbreviations, and alternative spellings for your brand

Step 4: Perform Content Research

Once your profile and brand topic are all set, it’s time to get to work.

Quora is an excellent source of content ideas that your target audience wants to read about. However, not all questions are made the same.

Some questions are already saturated with answers while others barely get any attention at all. What you want to answer are posts that have a ton of followers with only a few answers to match the demand.

That’s why finding the right questions is one of the new skills you should refine if you want to learn how to use Quora effectively.

You can find these metrics by navigating to one of the topic pages on your feed and going to the ‘Answer’ tab.

As a rule of thumb, try to find questions with an answer-follower ratio of 1:5. That means a post with at least five followers and one answer or less, which maximizes your chances of getting the high votes.

Step 5: Use the Question to Develop a Full-Fledged Article

Your next step is to plan and craft top-notch content that answers the question in detail.

Ideally, you already have a couple of blog posts that align with the topic at hand. If not, take this as an opportunity to write exactly what the Quora user is looking for.

In relation to the example above, you can write something about the best marketing strategies for startups with some examples. You may also create a listicle of successful startups while highlighting the strategies that spearheaded their marketing.

It’s all about providing value not just through knowledge alone, but actionable steps that can position your brand as the go-to source of information.

Step 6: Write Quora Answers Like a Pro

Got your content ready?

Great — the next step is to naturally insert the link to your content in your answer.

Since you crafted the content specifically for this question, it should blend in nicely. You just need to focus on the quality of your answer, which will help you get more upvotes, exposure, and traffic.

Here are surefire ways to guarantee this:

  • Use Visual Content
    Just like your regular blog posts, Quora answers with visual content have a better chance of snagging the audience’s attention. These can be screenshots, infographics, YouTube videos, and so on.
  • Be Exhaustive
    Remember that Quora marketing has become competitive due to the platform’s ever-increasing popularity. If you are to answer a question, cover as much ground as possible and give users no reason to look for other answers.
  • Use Proper Formatting
    To improve the readability of your answer, break down sections into subheadings. You can also create bulleted or numbered list to enumerate relevant information.
  • Write Using Natural Language
    Quora answers never need to be structured like full-fledged articles with thousands of words. Try to use simple language, be direct, and be conversational to connect with users on a more emotional level.
  • Be Careful with Links
    Lastly, while you have the option to insert a link to a landing page, only do so if it makes sense. You don’t want your answer to look self-serving by containing lots of promotional links.

The final step is to answer similar questions while providing the same link to your content. Just like before, pick the questions carefully and write your answers differently each time.

Putting it all together, here’s a quick look at how I write my Quora answers:

You can read the complete answer here: https://www.quora.com/What-will-be-the-courier-charges-from-India-to-the-USA/answer/Nakul-Chandra-9

Conclusion

As long as there are questions to be answered, Q&A websites like Quora are powerful tools for companies and business alike.

Hopefully, this article can guide you on your way to build a strong quora marketing strategy

Categories
2020 Quora Guide

OmniCampaign for Quora Managment

Website: https://omni.shoppredigital.com/omnicampaign

Categories
2020 Quora Guide

Quora Basics

  • Getting Started with Quora Marketing
  • Creating Backlinks with Quora Marketing