SEM if You Had to A-Level Coursework

Open, View, and/or
Download this Document

Total Length: 1874 words ( 6 double-spaced pages)

Total Sources: 0

Page 1 of 6



6. When would you suggest using negative match for keywords? Please give a specific example of a keyword and a related negative match.

The intent of using negative keywords is to trim back the number of items returned in a search, making the results delivered more relevant. The example shown below illustrates how a search of the New York Yankees could be made more relevant by removing the local New York football teams.

Negative keywords: New York Giants, New York Jets

7. Using the information provided in the attached Excel spreadsheet, please answer the following questions:

a. What is the clickthrough rate (CTR) for the keyword, Rock Band 2? Please illustrate the formula used to derive your answer.

CTR = (Clicks/Impressions) x 100

.15 = (16,797/110547) x 100

b. What is the CTR for the overall campaign?

.046 = (575,082/12,282,679) x 100

c. What is the CPC for the keyword, Xbox 360? Please illustrate the formula used to derive your answer.

Cost Per Click (CPC)

(Clicks/Cost) = CPC

28,564/$9,850.36 = $2.89

d. How many sales would it take to drive an $8 cost per acquisition (CPA) for the keyword, Rock Band 2, at the given spend level?

It would take 80 sales a day to drive an $8 cost per acquisition.

Stuck Writing Your "SEM if You Had To" A-Level Coursework?

View All Our Example SEM if You Had to A-Level Coursework

Have A Custom Example Essay Written



i. If the CPA increases to $11.00, what is your new max CPC?

$31.79

ii. What is the ROI based on a $5,402 profit?

32.5%

e. Given the attached campaign results, write an email to your client that highlights at least three insights or optimization recommendations for the account.

To: Client

Subject: SEM Optimization Recommendations

Based on an analysis of the current strategies and keywords in place, the following three recommendations are made for increasing SEM performance.

1. It is highly recommended that the existing keyword advertisements be re-written for a more optimized set of keywords. Existing keyword advertisements are not performing at a profitable level today as a result.

2. The entire Q4 Shopping Campaign is inefficient and needs to be revamped with more effective use of keywords and better use of cost-per-click bidding. This would drive up the CTR for the entire campaign, which is exceptionally low today.

3. Consider using negative keywords to more effectively guide keyword….....

Show More ⇣

     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"SEM If You Had To" (2013, February 25) Retrieved June 13, 2026, from
https://www.aceyourpaper.com/essays/sem-86223

Latest MLA Format (8th edition)

Copy Reference
"SEM If You Had To" 25 February 2013. Web.13 June. 2026. <
https://www.aceyourpaper.com/essays/sem-86223>

Latest Chicago Format (16th edition)

Copy Reference
"SEM If You Had To", 25 February 2013, Accessed.13 June. 2026,
https://www.aceyourpaper.com/essays/sem-86223
   

Open, View, and/or
Download this Document
order custom essay example