In the last post I talked about the numbers behind any marketing campaign. Those numbers are very important as well as the way their organized. One of the tools that we talked about in my Information Technology Marketing class is pivot tables in Excel and how to interpreting the information.
On the table below I have input some numbers describing the year a marketing campaign was launched, the location, the increase in net revenue after the campaign had been out, the type of campaign and the cost.
|Year||Location||Net Revenue||Marketing campaign||Cost|
|2013||New York||$ 122,222.00||Social Media||$ 20,000.00|
|2012||California||$ 131,123.00||Commercial||$ 16,000.00|
|2012||Arizona||$ 212,311.00||Social Media||$ 15,000.00|
|2012||Nevada||$ 131,231.00||Social Media||$ 12,222.00|
|2011||California||$ 122,321.00||Online Ad||$ 22,323.00|
|2011||Oregon||$ 131,232.00||Commercial||$ 23,321.00|
The information is not really organize, but with the help of a pivot this can be easily organize in several ways, for example one of them is in the diagram below
|Row Labels||Sum of Net Revenue|
This table separates the marketing campaign from the rest of the headings and breaks the rows individually, now you can see how much money each campaign generated under net revenue of commercials, online ads and Social media not including the year, location or cost as well as the grand total of all of the campaign put together. This is only a minor example of what a pivot table can do.
I really encourage you to use the tool and take advantage of its benefits..