Free Essay


In: Business and Management

Submitted By techgeek70
Words 4145
Pages 17
Excel Functions Every Community Manager Should Know
Tips for data manipulation from our Analysts

Excel Functions Every Community Manager Should Know
Tips for data manipulation from our Analysts Excel can be intimidating
Let’s face it, without functions Excel is just a wonderful way to store information. With functions, however, Excel becomes an amazing tool for manipulating and making sense out of large amounts of data. That’s why we love Excel so much. With a few little functions we can take a massive range of data, mine a wealth of information out of it, and turn the data into informed action items. Of course, the thought of trying to string together complex functions in Excel is enough to send anybody into a cold sweat. We couldn’t provide the depth of data or the level of insight offered in our reports without our awesome team of data Analysts who bring it all together. That’s why we asked them to walk us through some of the basic Excel functions they use on a daily basis – so that data ranges are easier to manipulate even if you’re not an Excel wizard. We created this list with community managers in mind, and we broke each function down in a way that’s easy to understand.

Our Analysts’ guide to Excel functions
So what exactly are Excel functions? Functions show a relation between a set of inputs and a set of outputs, where each input has exactly one output. In Excel, functions take the data from your workbook (the input) and turn them into information (the output) through a specific syntax. For example, you may be familiar with something like SUM.


The syntax of the function SUM is:

Syntax refers to the way the function is ordered, so that it returns a result. Each function starts with an equal sign (=) and are followed by the name of the function itself.

=SUM(this, plus this)

Example: =SUM(A1, A2)
This means that the cell you entered this function into will add the contents of cell A1 and A2. Pretty easy, right? Now, we’ll try something a little more complex. Say you want to find out how many days are in a given reporting period. You want to do this to figure out the average engagement within that period – say, Q1 of 2014. Without using a function, you could do this by entering the following into an Excel sheet:

The Syntax of the function DATE is:


The Syntax for the DAYS function is:

Here, you’re telling Excel to find out how many days there are between 1/1 and 4/1. You already have the dates in date format in certain cells, and Excel is just subtracting one date from another. Here, Excel accounts for the number of days in February (there were 28) and returns the value 90. There were 90 days in your reporting period. You can also do this using the DATE function. You might also use the DAYS function.


Note the specific way each date is formatted. In the first case, the date reads: year, month, day. In the second case, you must put the date in quotation marks.


These functions are all particularly useful when you’re trying to get a day count to average something like engagement over a period of time. You would use a function similar to:

=A1/(DAYS(“4/1/14”, “1/1/14”))
Where A1 is your engagement number and your date range is from January 1 to April 1. You can do the same thing with hours.

The Syntax for the HOUR function is:

=HOUR(“start time”, “end time”)

In the example above, the hour function returns the value 14 – the number of hours between 8:00 am, and 10:00 pm. The cells that are a time value are formatted as a time value in the number formatting options. Alternately, enter your time range into the function using quotation marks around the numbers like this:

=HOUR(“8:00 AM”,”10:00 PM”)
Now what if you want to find the week number of the year to compare two weeks worth of engagement? Use the WEEKNUM function to find out what number week (1-52) a certain day is on.

The Syntax for the WEEKNUM formula is:




Here, the date 3/14 falls in week 11 and the date 3/31 falls in week 14 shown on the calendar below.



The MONTH function can be used in a similar way. For a reporting period, MONTH is the function that allows you to, for example, determine that your highest engagement happened in “March”. These functions are pretty easy and chances are you’ve used them before; but you could do so much more with functions. You could tell Excel to discover the maximum engagement within a time frame for your Facebook Page, or ask for the handle of the Twitter user who has the most engagement. How do you do that?

Let’s ask the Analysts

The Analysts

Functions Lori Uses:
IF is probably the function I use most. Use this function when you have True/False criteria and you want to do one thing when the criteria are True and something different when the criteria are False.

Example: =IF(A1>10, “yes”, “no”)
In the above example, if the value in cell A1 is greater than 10, the function would return the word “yes”. This comes in handy when you want to find specific data. For instance, there is a report setting in the Simply Measured app where our customers can decide if they want to include User Posts in their Facebook Engagement. I use an IF statement to decide if I should use the function that includes User Posts in Engagement, or if I should use the function that excludes User Posts in Engagement. This comes in handy when you want to count or add cells based on specific data. COUNTIF lets you count items based on a set of criteria and SUMIF lets you sum items based on a set of criteria.

Who: Lori Williams
Her story: Hi, I’m Lori! I took a long and winding road to end up at Simply Measured. It involved a LOT of school, a little bit of nonprofit work, and eventually giving in to the fact that I am a data nerd and a tech geek. I love building reports that make social data easier to understand and more useful for our customers.

Example: =COUNTIF(A2:A5,”apples”)
Here, Excel will count how many cells in the A column contain the value “apples”.

The syntax of the IF function is:

Example: =SUMIF(B2:B25,”>5”)
In this function, if the value of a cell in the B column is greater than 5, Excel will add those values together.

=IF(logic test, value if true, value if false)
The Syntax for SUMIF is:

=SUMIF(range, criteria)



You could find out how many Tweets you sent between April 10 and April 15 with COUNTIF. If you wanted to find the total engagement on those same Tweets, you would add up all the retweets, mentions, @replies and favorites in between those two dates using a SUMIF.

The Syntax for IFERROR is:

IFERROR tells Excel what value to show if there is a problem with a function. We use IFERROR so our reports look nice even when there isn’t much data. Say you have a calculation for the percent of Tumblr posts that were quotes, but for the time period you’re looking at, you didn’t make any posts. In Excel, 0 divided by 0 gives a #DIV/0 error. You would use IFERROR to show “0” instead of “#DIV/0”. Try it yourself, substituting “#DIV/O” for “value”, and “O” for “value_if_error”.

=IFERROR(value, value_if_error)

The Syntax for NETWORKDAYS is:

NETWORKDAYS counts the number of workdays between two dates. I use this one to find out things like how many days did it take us to create our last project? Or how many days have I worked at Simply Measured? The holidays value is optional; it’s a way to exclude dates whether or not they’re actually holidays. To do this, you would list those dates in a column, and add them as a range in parentheses to exclude them.

=NETWORKDAYS(start_date, end_date, [holidays])

These Excel functions are easy to use and allow you to pinpoint data that you can build on later!


Functions Deepti Uses:
MAX/MIN and LARGE/SMALL are some of the simplest Excel functions. MAX allows you to find the highest number in a range while MIN returns the lowest number. Let’s say you have the daily count of fans gained by a Facebook Page and want to find out the highest and lowest gain in fans. You can easily calculate that using the functions MAX and MIN. If the fans gained are listed in rows A1 to A30, the function for highest gain in fans would be =MAX(A1:A30) and the function for lowest gain in fans would be =MIN(A1:A30). LARGE and SMALL do something similar to MAX and MIN, but go a step further. Using LARGE and SMALL, you can choose where in the range you want to find your value. For example, if you wanted to find the 3rd largest number in a range, the function would be =LARGE(A1:A30, 3) and it would return the 3rd largest number in the range. Small does exactly the opposite. =SMALL(A1:A30, 3) returns the 3rd smallest number in the range. This is helpful in finding out data like which campaigns drove the most fan acquisition, or which Tweets had the highest engagement via mentions and retweets. The best part is: they’re easy to use!

Who: Deepti Dhanjani
Her story: I went from being a Simply Measured customer who used our reports to building awesome reports for others to use. I’ve always been better with numbers than with words and I love that I get to manipulate data into meaningful insights for our customers.

The Syntax for these functions is easy:

=MAX(range) =MIN(range)
Use the following syntax for these functions:

=LARGE(range, sort criteria) =SMALL(range, sort criteria)



Functions Vikram Uses:
The tools that I use quite often are actually a collection of similar functions: LEFT, RIGHT, MID, and SEARCH.

Who: Vikram Nayani
His Story: Hey there! My name is Vikram and I’m the newest addition to our incredible Analyst team. My main focus at Simply Measured is helping to create the reports that our customers love so much. Understanding our customer’s pain points and creating solutions that help alleviate them is an awesome feeling, and I love that I help make their lives a little easier.

for example: =RIGHT(“Simply Measured is the best”, 4) returns the word “best” =RIGHT(A1,4) returns the last four characters in the cell A1 =LEFT(“Simply Measured is the best”, 6) returns “Simply”
Here’s a visual example of how these functions work. =LEFT(I25,16) returns the first sixteen characters in the cell I25.

These same rules apply to the =LEFT function:

Similarly, you can choose to isolate text or data from the middle of the cell using the MID function.

=LEFT(from this text, this many letters)
The Syntax for RIGHT is:

=RIGHT(from this text, this many letters)
Syntax of MID:

Examples of Excel MID function: =MID(“hello”,2,3) returns “ell” =MID(“hello”,2,100) returns “ello” Obviously “hello” contains fewer than 100 characters. The MID function in our example would return up to 100 characters.

=MID(from this text, start here, return this many letters)


You can also search for specific criteria within cells using the function SEARCH.

Examples of Excel SEARCH function: =SEARCH(“e”,”hello”,1) returns a value of 2, which is the location of “e” in the string “hello”. =SEARCH(“m”,”hello”,1) returns an “ERROR” warning because there is no “m” in “hello”)
So how are these helpful? Let’s use a real world example: by now we are all familiar with Gmail’s new tabbed interface. What if we wanted to tweak some of our emails to customers to make sure that they get put in the “Primary” tab and not the “Promotions” tab? The first step would likely be figuring out which of our contacts are Gmail users. To do this, we’ll use LEFT/RIGHT/MID and SEARCH. Any email ID contains 2 parts – user name and domain name. For example, in this email id - ImportantCustomer@gmail. com - Important Customer is the username and is the domain. The domain always starts after “@”, so we need to figure out a way to rule out that portion of the text. This is where our friends RIGHT and SEARCH come in (with a special appearance by LEN). LEN returns the length of any string of text.

The Syntax for this function is:

=SEARCH(this, in this text, [start here]).

Example: =LEN(“”) will return 28.
If you remember from the description, the Excel RIGHT function will let you cut a portion of text from the right side of the text.

Example: =RIGHT(“Long”,2) will give you ng.
To get the email domain name, we need to get all the letters to right of email ID after the“@” symbol. How do we find that position in text? We use the SEARCH function. The SEARCH function gives the location of one text in another.



Example: =SEARCH(“@”, “”,1) will return 19.
19 is the location of the “@” in “, when you start counting from position 1. SEARCH will return an error (#VALUE!) if the text you are trying to find is not available.

Example: =SEARCH(“c”, “Vikram”, 1) will return #VALUE! because there is no “c” in Vikram.
Now we know how these work, let’s go find the domain name from the e-mail address. Assuming cell A1 contains “”, the function for getting the domain name is:

=RIGHT(A1,LEN(A1)-SEARCH(“@”,A1,1)) This will return the value

(Go ahead and try it! Open up Excel and type the e-mail address in cell A1, and then the function anywhere else in the sheet.) So what did we just do? The LEN function gave us the total number of characters in our text. The SEARCH function then told us what position the @ symbol was located at in our text. If we subtract the two, we will get the total number of characters after the @ symbol, and then we put that into RIGHT in order to get the domain name (the number of characters after the “@” symbol). These functions have helped me out of plenty of text related Excel jams (they continue to do so, actually), and hopefully they’ll do the same for you. Happy Excel-ing!


Functions David Uses:
A lot of what a digital analyst does is quantitative, but virtually every piece of content we deal with is at least partially text--whether it’s a Tweet, an Instagram caption, a YouTube video title, or a username. A few basic tricks in dealing with text can make your life a lot easier. Let me introduce you to LEN and SUBSTITUTE. These two functions are great to have in your toolbox. LEN returns the number of characters in a string of text.

Who: David Lukas
His Story: I’m a Senior Analyst at Simply Measured. Before I came here, I worked in a variety of analyst roles in investment banking and asset management. I love being part of a company that is building real products that solve real problems, and the fact that we’re doing it with data and analytics pretty much makes it my dream job. I’m a Seattle native; I went to UW (woof!), and Alton Brown and Ron Swanson are two of my heroes.

SUBSTITUTE replaces a sequence of characters with another sequence of characters. It requires three inputs (called “arguments”): your reference text, the sequence of characters being replaced, and the sequence of characters you’re replacing it with.

The Syntax for LEN is:
Be careful, though—SUBSTITUTE is case-sensitive in deciding which strings to replace. So we’re having lots of fun measuring and replacing text strings, but if you put them together, LEN and SUBSTITUTE can do some pretty heavy lifting. For example, what if you want to know how many times a word or phrase occurs in a bunch of text? There isn’t a straightforward way to do that in Excel. SEARCH can tell you whether or not your word or phrase occurs, and what its relative position is, but it will only find the first occurrence. COUNTIFS can check for a text string across a range of cells and return a count of the cells that include the string, but again, it won’t tell you anything about multiple occurrences in a single cell. But check this out:

The Syntax for SUBSTITUTE is:

=SUBSTITUTE(text, “value to replace”, “value to replace it with”)



I know! I could have sworn Jim Mora said “playoffs” a dozen times, but it was only three! What we’re doing here might look confusing, but the hardest part is really just keeping the different sets of parentheses straight. It’s pretty simple if you break it into steps: 1. =LEN(B2) tells us the total number of characters in our original text. 2. =LEN(SUBSTITUTE(LOWER(B2),C2,””)) is taking our original text in B2, making it all lowercase using LOWER (to avoid the case-sensitivity issue mentioned above), searching it for the string in cell C2 (“playoffs”), and replacing every instance of that string with “”, which is essentially deleting it (yes, SUBSTITUTE can do that!). Now subtract 2) from 1). This number is equal to the total mentions of “playoffs” times the length of the word “playoffs.” Finally, we just divide the whole thing by LEN(C2), the number of characters in “playoffs”, to get the number of times our search term was mentioned. There are a ton of other ways you can use these two functions for operations that don’t directly involve string length or substitution. If you find yourself floundering with text parsing in Excel, and you intuitively know what it is you’re trying to accomplish but just can’t think of how to get there, there’s a decent chance that LEN, SUBSTITUTE, or both will be part of your solution.


Functions Alex Uses:
We build all of our reports natively in Excel, so we have to use every tool in Excel’s workbench to make our reports as robust as possible. One of tools that we use constantly is the function combination INDEX/MATCH. If you’re familiar with the VLOOKUP function you already basically understand how INDEX/MATCH works. It looks for a value in one column of an array and finds the user-defined corresponding value in an adjacent column. However, this where the similarities end. The primary difference between the two operations is that INDEX/MATCH is really two combinations rather than one, and in almost every case INDEX/MATCH is superior to either VLOOKUP or it’s Luigi, HLOOKUP. Let’s start with the syntax of a typical INDEX/MATCH operation. Array is the column that you want to return data from, and row number will be the MATCH function. Lookup value is the key of the thing you are using to find corresponding information for, and lookup array is the column or array where that key value resides. The match type is optional, but usually we set it to 0 to specify we want an exact match. When we replace the row numbers argument in the INDEX function with MATCH, the result looks something like this:

Who: Alex Snider
His Story: My name is Alex Snider and I’m one of the Analysts here at Simply Measured. I’ve loved looking at charts and data since as long as I can remember and I came to Simply Measured with a background in electoral research and analysis. My (amazingly cool) job at Simply Measured is to help design and build reports that are fully dynamic and scalable. This means that our customers can guide their digital marketing programs with informed data.

=INDEX(array, MATCH(lookup value, lookup array, match type))
The MATCH function will return the row of the key that we want to find corresponding data for, and the INDEX will take care of actually moving across the row to find the corresponding data. This can be a bit confusing but TRUST ME, once you understand INDEX/MATCH you will never go back to VLOOKUP again! Let’s think of an example.

The syntax for INDEX is:

=INDEX(array, row numbers)
The syntax for MATCH is:

=MATCH(lookup value, lookup array, match type)

6.897 million

3.899 million

1.5957 million

Imagine a spreadsheet with two columns: in Column A are all 50 of the United States in alphabetical order. In Column B we have the population of each state. Now let’s say we want to know the population of Washington, but we are feeling particularly lazy today and can’t be bothered to scroll all the way down the page to find Washington so we want to use INDEX/MATCH to perform the work for us.

The function for this problem would read: =INDEX(B:B, MATCH(“Washington”,A:A,0))
The important thing to remember is that you always enter the column of data you want back FIRST. So why is INDEX/MATCH so much better than VLOOKUP if they essentially perform the same function? First, because INDEX/MATCH typically only looks at two columns to find the lookup data rather than an entire multi-column array, INDEX/MATCH can substantially lower the processing load on Excel. Another benefit is that, unlike VLOOKUP, INDEX/MATCH can work in any direction; you don’t need to have your identifying key on the left and then your lookup data on the right. INDEX/MATCH can work left-to-right, right-to-left, inside-to-outside, across space-time, etc. All you have to do is follow the rules (put the data you want returned FIRST) and it should work like a dream. Finally, because INDEX/MATCH doesn’t rely on the static column number arguments inherent in VLOOKUP, you never have to worry about adding/subtracting/rearranging columns and messing up your lookup argument. INDEX/MATCH couldn’t care less about the space between your key and what you’re trying to find, it just hones in on the data you want like a shark to blood. We use INDEX/MATCH extensively in our reports in a ton of different ways. A good use-case example that could be useful to a community manager is to help find the Tweet with the most engagement. Assume we have a column of all of our Tweets and a column with the engagement numbers of each Tweet.


The function for this example would be: =INDEX(tweet.engagement.column,MATCH(MAX(tweet.text.column),tweet.text.column,0))
By working in a MAX function into the MATCH element of the function, we can return the text of the Tweet that had the most (MAX) engagement. If you really want to be an Excel baller and step your data analysis up to the next level, INDEX/MATCH is an absolute must know!

Why use Excel tools?
As our Analysts have shown, Excel does an excellent job (pun intended!) of sorting and finding data, reducing the time it takes to analyze large amounts of information. Our reports are built in Excel because not only can you store significant amounts of data, but Excel will also help you pinpoint data trends that you otherwise may not have known. Excel gives you the option to build charts and graphs based on your data, in a way that tells your story across all your social media networks. Of course, don’t just take our word for it; try your hand at Excel magic on one of our free reports.


Simply Measured provides a measurement and reporting solution that aggregates social media data and web analytics from more than a dozen sources and presents it in a single dashboard. We’ve provided samples of reports used by more than 30 percent of the top 100 global brands and over 80,000 users who are Simply Measured customers. Answer questions about Facebook Page performance and engagement, as well as fans, posts, “Likes”, comments and engagement trends. Dig into the most effective posts and the impact they’ve had on your Page and your audience.

Request a Free 14 Day Trial

Want to try Simply Measured?


Similar Documents

Premium Essay


...focus inward on the organization’s needs instead of outward (the customer’s needs). • Product is aimed at everyone. • Firms want to profit through maximizing sales volume. • Promotion to achieve goals. 2. Describe some of the characteristics of a firm that would follow a marketing orientation. Marketing orientation is “a philosophy that assumes that a sale does not depend on an aggressive sales force but rather than on a customer’s decision to purchase a product; it is synonymous with the marketing concept.” • Unlike sales orientation, a firm would focus outward on the customers wants and needs. • The goal of a firm is to satisfy customers wants and needs and delivering superior value. • The target is specific groups of people. • Where sales orientation profits by sales volume, marketing orientation firms profit with good feedback from customers or customer satisfaction. • It’s more about marketing and less about selling (less persuasion). • Firms identify what customers want and have businesses give them what they want efficiently. 3. In what ways does McDonald's embody both a marketing and a societal marketing orientation? Do some internet research if necessary. McDonald’s embodies a marketing orientation by targeting specific groups like children, back in the 80s it was senior citizens, and in the 90s, it was “young urban professionals”. McDonald’s change as the market change. Back then, it started with catering to “quality, service, and cleanliness” (QSC)......

Words: 1110 - Pages: 5

Premium Essay


...oriented philosophy is so important. The phrase market-oriented is used in marketing conversations as an adjective describing a company with a marketing orientation. Market orientation more describes the company's approach to doing business. Market-oriented defines the company itself. If a company is market-oriented, its board and executive leadership believe that the best way to succeed is to prioritize the marketplace above products. This usually goes over well with customers, but the company also must have adequate research and development to provide what the market wants. Hence, a market-oriented organization is one whose actions are consistent with the marketing concept. Difference Between Marketing Orientation & Market Oriented by Neil Kokemuller, Demand Media Marketing is a management process and management support for marketing concept is very important element in success. If a company wants to be successful then it is market oriented. Marketing involves identifying the customer requirements and estimate the customer requirements in future. It requires planning which is very important process of marketing. To satisfy the needs the business should provide benefits – offering right marketing at right time at right place. Generally market based companies adopt strategic level marketing that defines the mission and long term objectives of the......

Words: 716 - Pages: 3

Premium Essay


... Marketing is the process of communicating the value of a product or service to customers. Marketing might sometimes be interpreted as the art of selling products, but selling is only a small fraction of marketing. As the term "Marketing" may replace "Advertising" it is the overall strategy and function of promoting a product or service to the customer. From a societal point of view, marketing is the link between a society’s material requirements and its economic patterns of response. Marketing satisfies these needs and wants through exchange processes and building long term relationships. The process of communicating the value of a product or service through positioning to customers. Marketing can be looked at as an organizational function and a set of processes for creating, delivering and communicating value to customers, and managing customer relationships in ways that benefit the organization and its shareholders. Marketing is the science of choosing target markets through market analysis and market segmentation, as well as understanding consumer buying behavior and providing superior customer value. There are five competing concepts under which organizations can choose to operate their business; the production concept, the product concept, the selling concept, the marketing concept, and the holistic marketing concept. The four components of holistic marketing are relationship marketing, internal marketing, integrated marketing, and socially responsive marketing.......

Words: 1759 - Pages: 8

Premium Essay


...Assessment: MKC1 Market Environmental Variables Reading: Contemporary Marketing: Chapter 3 Questions: 1. How would you categorize Generation X using the five segments of the marketing environment? A: Competitive Environment B: Political-legal environment C: Economic environment D: Technological environment E: Social-cultural environment 2. Joe and Ryan both have storefronts in the local mall. Joe sells candies and Ryan sells pretzels. Are Joe and Ryan in direct competition with each other? A: Yes B: No Consumer Behavior and Marketing Reading: Contemporary Marketing: Chapter 5 Questions: 1. Rachel and Sarah’s parents always purchased groceries from the local Aldi marketplace. What is this type of behavior an example of? A: Cultural influences B: Social Influences C: Personal factors 2. Maryanne purchases Maxwell House coffee every two weeks from the grocery. What is this type of behavior an example of? A: Routinized Problem Solving B: Limited problem solving C: Extended problem solving 3. Aaron does research on several local colleges before applying to his first three choices. This is an example of: A: High – involvement purchase decision B: Low – involvement purchase decision Marketing Plans Reading: Contemporary Marketing: Chapter 2 + Ch. 2 Appendix Web sites: Questions: 1. Strategies are designed to meet......

Words: 8933 - Pages: 36

Premium Essay


...Defining Marketing Paper ShuMikki Stinson MKT/351 Thomas Collins August 26, 2013 Marketing is a tool that can help business owners to prosper with their product. Marketing can be defined as an instrument that is helpful to individuals to promote their goods in their unique way that other people items would not be an eye-catcher. It is vital to know that the key thing for every marketing tool that the individual uses will be used for the proper reasons. By the individual using marketing tools in the proper way, the individual will reach their marketing level in which they wish to be at. There are side effects when it comes to the marketing tools and the techniques which they do not work properly as it was intended too. There are numerous of definitions that relate to the marketing field. According to William D. Perreault, the author of Basic Marketing, the best definition of marketing is the performance of activities that seek to accomplish an organization’s objectives by anticipating customer or client needs and directing a flow of need satisfying goods and services from producer to customer or client. (William D. Perreault, 2011). Marketing is important because it can be a benefit for a business or a hardship. Respectable marketing methods can make a transformation between a concrete upsurges in sales to an impasse circumstances on a quality merchandise. Marketing can be as simple as having a general conversation, which is usually the case in the long run. Marketing......

Words: 767 - Pages: 4

Premium Essay


...*/introduction Critically evaluates the marketing planning process Discusses impediments to effective implementation of marketing plan Introduction The leading exponents of the marketing planning have been warned of the communications factors, operational, cultural and managerial in which frequently impede the effective implementation of the marketing planning programmers in the past two decades. (Cravens, 1998; Doyle, 1998; Greenley, 1982; Leeflang and de Mortanges, 1996; McDonald, 1992a, b; 1995; Piercy and Morgan, 1994; Jain, 1993; Simkin, 1996a, b; Verhage and Waarts, 1988). There have some specific guidance are offered in the recent years to assist marketing managers overcoming those internal organisational and in pre-empting forces (cf. Cravens, 1998; Dibb et al., 1996; Lings, 1999; Piercy, 1997; 1998; Simkin, 2000). Yet, the recent research has shows barriers to the implementation of programmes and marketing strategies. (Dibb and Simkin, 2001; Simkin, 2000). Another key barrier is indicating impeding the deployment of effective marketing practices used to be the lack in most marketing function or either in organisations. (cf. McDonald, 1992a, b; Piercy and Morgan, 1994). The research are shows this is a no longer to the case with the bulkiness businesses professing to have a marketing department undertaking not only promotion and customer research,but are relate to the Kotleresque textbook approach to marketing management (Dibb and Simkin, 1997;......

Words: 1580 - Pages: 7

Premium Essay


...Marketing MKT 421 Marketing According to “American Marketing Association” (2013), “Marketing is the activity, set of institutions, and processes for creating, communicating, delivering, and exchanging offerings that have value for customer, clients, partners, and society at large.” The American Marketing Society has grown to be the largest marketing associations in the world. The members work, teach, and study in the field of marketing across the globe. Another definition of marketing is according to “ Investors” (2013), “Marketing is an activity. Marketing activities and strategies result in making products available that satisfy customers while making profits for the companies that offer those products.” Organizations success lies in marketing and it is the heart of the success. The marketing introduces a product or service to potential customers. An organization can offer the best service or product in the industry but the potential customers would not know about it without marketing. Sales could crash and organizations may close without marketing. For a business to succeed the product or service that is provided needs to be known to the potential buyers. Getting the word out is important part of marketing in any organizational success. Product or service awareness is created by marketing strategies. If marketing is not used the potential customers will never be aware of the organizational offerings and the organization will not have the opportunity to......

Words: 776 - Pages: 4

Premium Essay


...MARKETING PLAN RESEARCH DEFINITION: A marketing plan is a business document written for the purpose of describing the current market position of a business and its marketing strategy for the period covered by the marketing plan. Marketing plans usually have a life of from one to five years. PURPOSE: The purpose of creating a marketing plan is to clearly show what steps will be undertaken to achieve the business' marketing objectives. CONTENT OF MARKETING: A marketing plan for a small business typically includes Small Business Administration Description of competitors, including the level of demand for the product or service and the strengths and weaknesses of competitors. 1. Description of the product or service, including special features 2. Marketing budget, including the advertising and promotional plan 3. Description of the business location, including advantages and disadvantages for marketing 4. Pricing strategy 5. Market Segmentation The main contents in marketing plan are: * Executive Summary Brief statement of goals and recommendations based on hard data. * Environmental Analysis Presents data on the market, product, competition, distribution, macro-environment. (Product fact book) S.P.I.N.S. Situation “Where am I”, Problem identification/Implications “What is happening”, Needs Assessment “Why is it happening”, Solutions “What can I do about it” Market Situation: Data on target market, size and growth for past......

Words: 579 - Pages: 3

Premium Essay


...ASB-1104 Introduction to Marketing Assignment 1 In view of the dynamic nature of the marketing environment, to what extent do you consider consumers to be, in practice, central to marketing activities? Name: ZHUOMING AN Student No: 500356688 Tutor: David James Introduction What is marketing? The answer is not changeless. There are some different definitions about marketing. The Chartered Institute of Marketing define that "Marketing is the management process responsible for identifying, anticipating and satisfying consumers' requirements profitably." (CIM). Taking a concern into this definition, it indicates that marketing begins before a product or service is developed. In additional, it also explain that marketing involves identifying an unsatisfied consumer need or want and determining if a profitable opportunity exists. Another definition is that “A social and managerial process by which individuals and groups obtain what they need and want through creating and exchanging products and value with others." (Kotler et al., 2005). The basic idea of this definition is that core to all marketing activities is customer satisfaction, which means marketing is an ongoing process as consumer demands and the environment is constantly changing. Products need to adapt as demands change. At the same time, marketing does not involve misleading, tricking or manipulation the customer. The Jobber also define the marketing is "The achievement of corporate goals through......

Words: 1933 - Pages: 8

Premium Essay


...Marketing is the process of communicating the value of a product or service to customers, for the purpose of selling that product or service. Marketing can be looked at as an organizational function and a set of processes for creating, delivering and communicating value to customers, and customer relationship management that also benefits the organization. Marketing is the science of choosing target markets through market analysis and market segmentation, as well as understanding consumer behavior and providing superior customer value. From a societal point of view, marketing is the link between a society’s material requirements and its economic patterns of response. Marketing satisfies these needs and wants through exchange processes and building long term relationships. Organizations may choose to operate a business under five competing concepts: the production concept, the product concept, the selling concept, the marketing concept, and the holistic marketing concept.[1] The four components of holistic marketing are relationship marketing, internal marketing, integrated marketing, and socially responsive marketing. The set of engagements necessary for successful marketing management includes capturing marketing insights, connecting with customers, building strong brands, shaping the market offerings, delivering and communicating value, creating long-term growth, and developing marketing strategies and plans.[2] Marketing may be defined in several ways, depending......

Words: 270 - Pages: 2

Premium Essay


...Omar Rochell Marketing MKT/421 April 7, 2011 Nikki Jackson Introduction Marketing is exposed to someone every day, even when they do not seem realize it. Driving down the roads you see billboards everywhere and that is part of marketing. Logos people were on their shirts and signs in the middle or on the sign of football fields are all part of marketing. Even when a child is marketing themselves to their parents to borrow the car or go to a party they are marketing themselves to their parents in exchange for the car or the party. A set of activities that will benefit both parties’ objectives is my own personal definition of marketing. This paper will be defining marketing in different perspectives. Discussing the importance of marketing in a organizational success will also be discussed with examples included from different organizations. As an organization it is important to know what marketing is and how to establish success. What is Marketing “Marketing is defined as the activity, set of institutions, and processes for creating, communicating, delivering, and exchanging offerings that will have value for customers, clients, partners, and society at large.”(American Marketing Association, 2011) Marketing is a process that helps links the consumer, customer, and public to information that will help identify and market opportunities. Marketing research will generate, and evaluate different types of market actions, monitor marketing performance, and help......

Words: 1088 - Pages: 5

Premium Essay


...How does Marketing affect the Global Economy Introduction: Nowadays, the development of global economy is closely related to the Marketing which involves some professional behaviour to sell or promote the goods. There are no possibilities to push the economic growth without the strategies of the Marketing, on the other hand, the Marketing cannot be separated from the global economy. During the financial crisis, the amounts of global transaction declined keeping company with the economic recession. In this case, it illustrates directly the interaction between the Marketing and the global economy. Not only does the Marketing play a fundamental role in the development of the micro companies’ economy, it is also irreplaceable for the progress of the society and the prosperity of the macro economy. However, it is hard to maintain the favourable condition between the Marketing and the global economy always. This essay is intended to explain what Marketing is and the affection to the global economy. Main body: Part 1: The conception and the meaning of the Marketing and the global economy A: The Marketing Philip Kotler once elaborated that Marketing is a social and managerial process by which individuals and groups obtain what they need and want through creating and exchanging products and value with other (1991). However, it is difficult to get an accurate principle of Marketing because of various interpretations from different researchers. To give some examples, referring......

Words: 1069 - Pages: 5

Premium Essay


...Marketing is an expansive area of expertise that encompasses many different areas, skills and job descriptions. According to Merriam-Webster, broken down to its basic form, marketing is defined as: “The activities involved in making people aware of a company’s products and making sure that the products are available to be bought.” Working in a marketing position involves showcasing a company in a positive light, showing why customers should purchase products and drawing in a targeted audience to consider goods and services. But what does a marketer do? Unfortunately there isn’t one set job description for everyone in this position. But we connected with marketing pros to give you a sneak peek at three common types of marketing. Taking a closer look at these options will help you determine if this field is right for you. 1. Digital marketing Digital marketing is just what it sounds like: marketing that’s gone digital! This type of marketing utilizes the internet and all things technology to get the word out about products, services or companies. Digital marketing has a slew of benefits, according to Don Crow, CEO of Verge Pipe Media. He says two of the most obvious advantages are scale and cost. “Considering 70 percent of all phones today are smartphones, it's increasingly important that brands and organizations think about how to connect with consumers on this increasingly important digital device,” Crow explains. There are many jobs that fall under the......

Words: 864 - Pages: 4

Premium Essay


...BTEC LEVEL 3 BUSINESS P1-Describe how marketing techniques are used to market products in two organizations Introduction In this task (P1) I will describe and explain how different marketing techniques are used to market products in two different organizations. The first one being Cotswold wildlife park and the second organization being Tesco. Using these two organizations I will describe the marketing techniques that they used to market products. Marketing 1) Marketing is the action, set of institutions, and processes for creating, communicating, delivering and exchanging offerings that have value for customers, clients, partners and the society at large. 2) Marketing is the social process by which individuals and groups obtain what they need and want through creating and exchanging products and values with others. 3) Marketing is traditionally the means by which an organization communicates to, connects with, and engages its target audience to convey the value of and ultimately sell its products and services. From the first definition of marketing, what I understand is that marketing is a process or activity that takes place by interacting directly to the customer or client. It is doing actions that will benefit the customer as well as the......

Words: 2001 - Pages: 9

Premium Essay


...chapter 1 Marketing’s Role in the Global Economy When You Finish This Chapter, You Should 1. Know what marketing is and why you should learn about it. 2. Understand the difference between micro-marketing and macro-marketing. 3. Know why and how macromarketing systems develop. 4. Understand why marketing is crucial to economic development and our global economy. 5. Know why marketing special— ists—including middlemen and — facilitators—develop. 6. Know the marketing functions and who performs them. 7. Understand the important new terms (shown in red). www.mhhe. When it’s time to roll out of bed in the morning, does your General Electric alarm wake you with a buzzer—or by playing your favorite radio station? Is the station playing rock, classical, or country music—or perhaps a Red Cross ad asking you to contribute blood? Will you slip into your Levi’s jeans, your shirt from L. L. Bean, and your Reeboks, or does the day call for your Brooks Brothers interviewing suit? Will breakfast be Lender’s Bagels with cream cheese or Kellogg’s Frosted Flakes—made with grain from America’s heartland—or some extra large eggs and Oscar Mayer bacon cooked in a Panasonic microwave oven imported from Japan? Will you drink decaffeinated Maxwell House coffee—grown in Colombia—or some Tang instant juice? Will you eat at home or is this a day to meet a friend at the Marriott-run cafeteria—where you’ll pay someone else to serve your breakfast? After breakfast, will you head off to......

Words: 14069 - Pages: 57