Learn SQL for FREE!

SQL or Structured Query Language is becoming essential for marketers working for start ups.  It’s an easy way to control data

Two great reasons why learning SQL is a great idea according to Udemy.:

  • Learning SQL has literally DOUBLED or TRIPLED the speed at which our marketing team can learn & execute.
  • We don’t just learn faster. We learn cooler, more interesting shit.

SQL is all simple stuff once you get the hang of it. Check out these top ten most helpful SQL queries :

1. SELECT * FROM stuff;

This query grabs everything from the table and returns it. If you’re not careful with this query, you could find yourself paging through a long list of results.

2. SELECT COUNT(1) FROM stuff;

Here, the query gets just the number of rows in the table stuff. It’s useful if you have a lot of rows, and just want to make sure there is data there without filling your screen.

3. INSERT INTO stuff (name, age) VALUES (‘alan’, 28);

Inserting more data into a table is as easy as running this query. Specify the columns in the order you want to put the data in after the table name (like (name, age)) and then values you want after VALUES.

4. DELETE FROM stuff WHERE name = ‘alan’;

Deleting is as easy as specifying the WHERE-clause that you want to delete. It’s usually best to run SELECT * FROM stuff WHERE name = ‘alan’; first, to make sure you know what you’re deleting.

You can also use !=, <, >, <=, >= in a WHERE-clause.

5. UPDATE stuff SET age = 30 WHERE name = ‘alan’;

This updates alan‘s age to be 30 using the WHERE-clause. You can also change multiple items like UPDATE stuff SET age = 30, name = ‘george’ WHERE name = ‘alan’;

6. SELECT * FROM stuff WHERE name LIKE ‘%rg%’;

You can use this query to do a wildcard match on a column. In this example, it looks for any row that has rg in the column (like in george).

7. AND and OR

If you want to combine multiple WHERE-clauses together, just use AND and OR. You can run a query like this: SELECT * FROM stuff WHERE (name LIKE ‘%rg%’) AND (age > 25);

Placing parentheses around each item you are ‘ANDing’ or ‘ORing’ together is a good best practice.

8. SELECT name FROM stuff where age > 25;

With this query, you can select just one column — the name-column in this example. You can also grab two columns, with SELECT name, age FROM stuff where age > 25;

You can also rename columns: SELECT name AS n FROM stuff;

9. SQLite3: .schema stuff

PostgreSQL: \d stuff

MySQL: describe stuff;

If you need to discover the schema of the database — what columns it contains — you’ll need to use different queries, depending on which database engine you’re using.

10. EXPLAIN SELECT * FROM stuff;

This is an advanced query. It’s particularly useful if you need to figure out why a query is so slow.

You can use EXPLAIN before a SQL statement (or some variant), and it will break down the timings of the various parts of the query. It’s useful for debugging why a complicated query is slow. You can dig even deeper, depending on what database engine you’re using:

This is really easy to learn too. If you want to learn just go to:

https://www.udemy.com/mysql-database-for-beginners2/#dashboard

I’m in the middle of lessons right now and if I can do it, anyone can do it. It’s FREE to sign up and it’s simple.

This is their simple layout for their lesson guide.

SQL 1

And this is their lessons. You watch videos and take notes on the side. Super easy right?

SQL 2

Just visit https://www.udemy.com/mysql-database-for-beginners2/#dashboard to learn how.

Advertisements

AB Testing creates Progress

Are you like this guy?

ab testing skeptic
Then I’m going to have to side with Mr. Vader

 Have you never wanted to better your web traffic?

 

ab testing darth vader

If you don’t know what AB testing is then allow me to explain…

A/B testing is a method of marketing testing by which a baseline control sample is compared to a variety of single-variable test samples in order to improve response rates.

It is very easy to try. Just follow these simple steps explained below.

Begin by using Google’s Website Optimizerab testing step 1

Click on create new experiment to create your first AB test.ab testing step 2

For your first AB test, select the simplest way to start testing fast.

ab testing step 3

Now Google’s wizard will explain the steps to you.

ab testing step 4

That is all the simple steps for creating your very first AB test. Now since it was so fun you are able to continue creating different AB tests until you get the results that you want.

If your still unsure if AB testing is right for you then check out this example and links below.

ab testing example

Related Links:

http://www.kaushik.net/avinash/lack-management-support-or-buy-in-embarrass-them/

http://unbounce.com/a-b-testing/for-skeptical-clients/

https://www.optimizely.com/ab-testing?utm_source=Google&utm_medium=cpc&utm_content=brand&utm_campaign=Brahman

Coding: Shifting Space and Time, Digitally

Coding allows you to create your own universe digitally. You can create content and customize it however you want.

coding 1

This is extremely helpful to businesses who wish to create or redesign their own webpage. Coding allows companies to share content in a fun way which will hopefully attract customers.

Coding meets Marketing

Coding is very helpful for marketers. When a company needs help with their webpages, they want marketers to find and solve the problem. This is done through AB testing which uses Coding and Google Analytics.

Marketers are asked to find a problem which may be as simple as getting more customers from looking at product online to purchasing online. Marketers then look at the companies traffic and find where most of the customers left their site, whether it be at the beginning of the purchasing process or the add to cart process. Marketers then use AB testing to find if they can increase traffic. This is done by re-coding the companies website and doing simple things of moving the add to cart button on the page or changing the background color or font.

coding 2

After companies change something in the website they then wait to see if the traffic improves or not and then change it again and again until they feel satisfied that the checkout process is efficient for the customers to purchase the companies products.

 

Useful Link

http://www.codecademy.com/

 

Paid media is losing the battle

There are three types of media: Paid, Owned, and Earned media.

media

Paid media is the most traditional of the three. Every television advertisement, billboard, radio ad, and newspaper advertisement you have ever seen have all been paid media. Now there is a new form of paid media. An integrated form. Paid media is now also advertisements on videos through Youtube and Hulu. There are also paid advertisements on the side of most websites like Facebook.

 

paid mediaEven though paid media is the oldest version of media and has integrated into digital media, it is still losing the battle to owned and earned media.

 

owned media

 

Owned media has become the second in command. Owned media is company websites and search engine optimization for brands. It is more popular that paid media because the customers that visit the company’s website or search for the company are more invested into the company compared to someone who saw an advertisement for State Farm on the side of Facebook.

 

earned media

Earned media has become the ruler of the three media types. Earned media is loyal followers of brands sharing their thoughts of those brands to the world. This is done through posting a comment about a brand on Facebook, tweeting about the brand, or writing a blog about the brand. This is the highest level of media because the customers are not only the most loyal but they are also freely expanding the reach of their favorite brands through social media.

 

Related Sources

Defining Earned, Owned And Paid Media

Integrating Owned, Earned & Paid Media For Better SEO

How Owned, Earned, and Paid media work together

Paid Media 101: Twitter Advertising

Do you even know what Content Marketing is?

Content marketing will change your business!

content-marketing1-1024x791

“Content marketing is a marketing technique of creating and distributing relevant and valuable content to attract, acquire, and engage a clearly defined and understood target audience – with the objective of driving profitable customer action,” (What is Content Marketing).

The point of content marketing is to understand your target audience in order to best represent your product to them in a way that will make them trust your company over other competing companies. There are three steps for a successful content marketing strategy.

  • Content
  • Social
  • Search

Possibly the most important step is content. Content is broadcasting information about your product to your target audience in a language that they will understand. The key part is knowing the lingo of the people that you are trying to reach.

Social is also important. Having content that can be shared through social media is huge. This allows followers to spread the word of your product. This is key to being searchable.

If your followers find your content excellent then they will share it with their followers which will make your content become searchable. The more your content is spread the more likely that it will be found using Google or another search engine.

Below is an example of a great content marketing strategy from Nike.

Nike

N

Nike has embedded a modern format which allows customers to watch videos, hear amazing inspirational stories, search for content, and check out products. Possibly the most outstanding feature that Nike has embedded into their format is the little emblems of Facebook, Twitter, and Youtube which allow you to follow or like each story with the click of a button. This allows their brand to be shared around the world without any further effort to them beyond embedding those tiny emblems.

Outbrain-AdWeek-CM1

If you want to learn more about content marketing then check out these helpful links.

Social Media: The New Form of Word of Mouth… or should I say Word from Fingers

Social Media

  • Facebook
  • Twitter
  • Blogs

Social media allows us to communicate digitally as we are doing now. People are enabled to create, read, and respond to posts over the internet.

A few years ago this was only possible on computers, but now social media is everywhere. You are able to use your tablets or phones to communicate with your friends, family, and followers.

Word of MouthSocial Media

Once upon a time there was an ancient form of marketing called word of mouth where people spoke to one another about movies, food, clothing, and anything else that they had on their mind. Friends would get together and discuss what movies or concerts they wanted to see because they enjoyed the performers.

Then the invention of the telephone came about and people did not have to be side by side in order to communicate. Word of Mouth was able to travel faster than ever and long distance friends were able to tell one another their personal tastes.

Now a new creation has come forth and made Word of Mouth instantaneous. This creation is known as social media. Now immediately after someone gets out of the theater they are able to write a review and post it on their twitter letting all of their friends, family, and followers know what they thought of the movie. Or if someone is feeling like being obnoxious they can post their thoughts while in the theater. DO NOT DO THAT! IT IS EXTEREMELY ANNOYING!

Anyway, social media has transformed Word of Mouth into Word from Fingers. For instance, if you are a cat lover…Cats on Social Media

If you want to learn more about social media, here are some fun links to help you.

Links

Dayna Rothman, September 19, 2012, Accelerate Word of Mouth Marketing with Social Media Promotions, Referral, and Engagement Campaigns. Refer to http://blog.marketo.com/blog/2012/09/live-blog-df12-accelerate-word-of-mouth-marketing-with-social-media-promotions-referral-and-engagement-campaigns.html

Margaret Fong, Jan 10, 2012, The Power of Word of Mouth. Refer to http://blogs.ubc.ca/margaretsmarketingmix/2012/01/10/the-power-of-word-of-mouth/

Word of Mouth

Inbound Marketing: The New Form of Advertising!

Instead of the old boring print ads and radio commercials, marketers have moved on to a new digital form of advertising.

We call this Inbound Marketing!                                                              Inbound Marketing

Inbound Marketing is digital marketing where companies use SEO, blogging, social media, forums, and eBooks to advertise their products or services. Different companies will have different techniques of inbound marketing based on which consumers they are trying to reach. Some may stick mainly to social media sights which others will focus on blogs and forums. The hopes of inbound marketing is to reach consumers who are likely to want your product/ service through new interactive, digital, techniques.

Instead of someone looking at a coupon for Wal-Mart in a coupon book, they can now like Wal-Mart’s Facebook page and have updates on sales and coupons without having to search through coupon books. If someone has questions about their Xbox not running properly they can look online at forums and see what other people have experienced and how to fix the problem.

Inbound marketing is a fairly new technique which makes now a great time to get into the inbound marketing job field.

The goal for inbound marketers is to help “potential customers find your company – often before they are even looking to make a purchase – and then turning that early awareness into brand preference and, ultimately, into leads and revenue.”  (http://markstaton.files.wordpress.com/2013/09/inbound_marketing.pdf)

Some of the best techniques for inbound marketers are learning search engine optimization and Google analytics. Knowing these strategies will lead to a bright future in inbound marketing.

Inbound Marketing Stats

Sources

Marketo. Inbound, Amplify your Impact. Retrieved from http://markstaton.files.wordpress.com/2013/09/inbound_marketing.pdf. 10/2/2013

HubSpot. 2013 State of Inbound Marketing. Retrieved from http://markstaton.files.wordpress.com/2013/09/2013_stateofinboundmarketing_fullreport.pdf. 10/2/2013