technical skills

SQL: Learn to Communicate with Databases

What is SQL? SQL, (sequel) or Structured Query Language according to Vault Analytics, “is the de facto standard coding language that is used to communicate with databases.” Or it can be thought of as another important coding language to know in the marketing industry. SQL communicates directly with databases, and through codes it can extract specific information. Running SQL queries are an easier, faster way to manage and filter through data than Excel.

How does SQL work? The article, Learn SQL The Hard Wayexplains how SQL understands the fields of tables, and can find data based on the contents of the fields. All SQL operations are based off of four general table commands:

  1. Create – inserting data into tables
  2. Read – query data in a table
  3. Update – change data in a table
  4. Delete – remove data from a table

Benefits of knowing how to leverage SQL:

  • Differentiate yourself when applying to jobs
  • Need to understand to execute projects
  • Speeds up process of finding information
  • Can better analyzing information and identify relationships within data
  • Fix your own problems with websites
  • Can create and execute your own marketing campaigns
  • Can communicate better with developers, designers and analysts

SQL 300

Living in a digital age, marketing now has large role online. And as a marketing student, learning technical skills that are applicable to the marketing field are important for me to know. Moz’s article Every Marketer Should be Technicalexpands on the importance of having technical skills. Moz suggests the following are important technical skills to know:

  • Databases & SQL
  • Web Technology
  • Web Development
  • Web Design & UX
  • Copywriting
  • Analytics
  • Forecasting/Statistics
  • Excel
  • Technical SEO
  • Content Platforms
  • Email Technology
  • E-Commerce Technology

tumblr_mtmt8mZVsG1su8bpzo2_500

If you didn’t post it, it didn’t happen… #DigiMark2pt3 #FirstPost

MARI SETIJONO — born and raised in the greater Seattle area, I am grateful to call the Pacific Northwest my home. Currently a senior at Western Washington University, I am working on obtaining my Bachelor’s Degree in Business Administration with a focus in marketing and a minor in communication. Can I stay in college forever? Just kidding, get me out of here… (just not back to my parents’ house)

This quarter I am enrolled in Digital Marketing, with Mark Staton, PhD. I am stoked to be taking this class; I have heard nothing but great things about it! Last year I had Staton as a professor for Principles of Marketing and he undoubtably was one of my favorite professors, which is also the primary reason why I wanted to take this class. His teaching style really appealed to my learning style, and with his use of case studies and examples he made everything applicable to “real life.”

In today’s and age, media is immensely integrated into our lives. To the point where “six out of every seven people in the world have Internet access,” according to Google’s Squared Online’s 2013 infographics on social media engagement. How dependent people, myself included, are on the Internet is almost frightening. “If you didn’t post it, it didn’t happen.” Hashtag, hashtag hashtag. People’s lives are exploited on the internet. Stalking people on the internet through social media is a daily occurring, nonchalant thing. What did you do for spring break? Oh wait, why did I ask? I already saw it all online.

facebook stalking gif
There are massive amounts of information that can be derived from Internet usage, and through analysis of web searches, key words, transactions, etcetera,  companies can learn or predict almost anything. For example, Target predicting pregnancies. Kind of creepy, huh? But brilliant! Which is also what makes this so interesting!

Because of this, I am really looking forward to learning more about digital marketing. More specifically, obtaining the technical skills, becoming Google Analytics Certified. This is also exciting because it was heavily talked about in Principles of Marketing.

With this rate of data analysis, look at what ordering pizza has the potential to be like!


Article: Knowledge and Skill Requirements for Marketing Jobs in the 21st Century

Through the analyzation of five different metropolitan areas, Atlanta, Chicago, Los Angeles, New York and Seattle, this article differentiates skill and knowledge requirements for entry-, lower-, middle-, and upper-level marketing jobs. This deemed to be a very insightful article, because I and I’m sure many of my fellow classmates are nearing graduation.

An overall summary of the research findings were that advanced technical skills were a high requirement for all levels of jobs. It was interesting to learn that many of the skills necessary were not in the “marketing curriculum.” This also made me grateful for Western’s marketing program because I have learned about the importance of search engine optimization, pay-per-click and analytics — and am really hoping to expand that knowledge through this class. Marketing is not just advertisements, there is a lot more behind it. Where does market research come from? Analyzing data and behaviors.

This brings me back to the Target article. Through the use of analytics, they can predict consumers’ buying behaviors, and also analyze the company’s behaviors as well. With such information, marketers can distinguish purchase patterns and consumer’s purchase processes in order to predict future needs. It was very interesting to read that during pregnancy is the perfect time to try sway consumers out of their habits. You can learn almost anything about people through the analyzation of information. Having a technical skill set can really distinguish one in the job market.


Article: Forrester Interactive Marketing Forecast 2011 to 2016

Interactive marketing such as, social media, mobile and email marketing, online video, SEO (search engine optimization), and PPC (pay-per-click) are becoming the major player in advertising in comparison to traditional marketing tactics through mediums such as, television, direct mail, magazines, radio, newspapers and telemarketing. The article states that in 2016, it is predicted that $77 billion dollars will be spend on interactive marketing in the United States, which leads to be 35% of all advertisement spending.

This further shows how integrated different forms of media are in our lives. Referencing back to Squared Online’s infographics, an average of 5.2 hours are spend on social media globally. I’m also in a Communication Media Studies class, and we had an ice breaker to get to know the rest of class, by asking each other about our media involvement. Not a single person in the classroom grew up without a TV, and not one person didn’t have any social media platform. The majority of the class consumed more than three hours of social media per day.

I really enjoyed the statistics this article provided. It was dense with information, but the numbers and graphs really put the importance of interactive marketing into perspective. The importance of interactive marketing for a business is crucial. Companies need to have an online presence.

It is interesting to think how much goes into a good website, or good ads. When using Google, people generally don’t think about how the top search results get there, but most web-surfers would agree that the top results are always the cream of the crop. And then you learn that it was all on purpose, it was planned. It is a strategy. Either someone paid for the the ranking, or added some special words into their website for it to show up more. It’s almost as if it’s a crazy mind game. (Marketing is so cool)

google search rank meme


Article: State of Digital Marketing Talent

The gist of this article under my interpretation was basically “You are what you eat.” The  marketing industry is what it is made up of. Listed I have summarized the seven main findings of digital marketing talent discussed through this article in my own words:

1. There’s a digital marketing talent gap – Employee’s do not live up to employer’s expectations in all skill areas.

2. Employees are lacking necessary skills – Technical skills are important skills to have in the Marketing field. More specifically, knowledge of analytics, mobile marketing, and  marketing automation are needed.

3. It’s about who you know – With a large talent gap, it is deemed a hard task to differentiate between employee candidates. References will get you jobs.

4. Inadequate employee training leads to miss opportunities – Without established programs, organizations investments through their employees don’t result with substantial returns or benefits.

5. Inconsistency throughout an organization hinders the business as a whole – Because there are no industry-wide standards, businesses need to be clear and consistent through their expectations and requirements for employees, and their assessment criteria on these expectation and requirements. There needs to be a mutual understanding on clear and concise goals.

6. Have a good attitude – You get what you earn. Not everything is handed to you, and if you work hard, and are open minded it will eventually (hopefully) pay off.

7. Digital education programs need to be implemented for marketing students – the talent gap needs to bridged. What is taught in school should be applicable to real life.

After reading this article, I was sure happy I am enrolled in Western’s Marketing program! College is increasingly getting more expensive, with the goal of obtaining knowledge and skills that will (or at least should) help me in life. The main point of this article was that there is inadequate talent. Whether it be graduate students who didn’t learn the skills, or the organization isn’t teaching the skills,  there are skills lacking.

To tie all three articles together, digital marketing is the new “thing.” And more importantly the technical skills that contribute to digital marketing are crucial for the industry.

ron burgandy meme