Analyze "Air World's" Sponsored Search Campaign

Instructions:

Based on the dataset for Air World's sponsored search advertising campaign in the "Air World - Sponsored Search Campaign Data.xlsx" file, you will prepare and analyze a table summarizing the data in the Air World spreadsheet by the "Search Engine Name" field according to the following specifications. Use the pivot table feature in Excel to create this table. The goal of this project part is to make you more capable of analyzing a large data set from a search engine campaign.

DATA SOURCE: https://docs.google.com/spreadsheets/d/1gh429BduH0R18Zi9Okqzpr6muGPpu6lN/edit?usp=sharing&ouid=101232969851934352973&rtpof=true&sd=true

• There should be a row for each unique entry in the "Search Engine Name" field.
• There should be a column for each of the following variables: Impressions, Clicks, Transactions, Click Charges (Cost), and Revenue.
• Each cell of the table should be the sum of that value for that search engine name.
• Include a Grand Total row which sums each of the five variables across all search engine names.

Search Engine Name	Impressions	Clicks	Transactions	Click Charges (cost)	Revenue
Google Search- US
MSN Bing - US
Google - Europe
MSN Bing- Europe
Grand Total

After you complete the table above, answer the following questions:

1. How much did Air World spend on the sponsored search advertising campaign?
2. How much revenue did Air World receive from the campaign?
3. What was the share of spending on Google US?
4. Which search engine produced the largest number of impressions of Air World's ads?