EXCEL ANALYTICS

g. formatted and labeled appropriately) as if this was being showcased to the clientUSE CASE: DELL CLICK TO BUILD CAMPAIGNDell recently launched a new feature on their website that allows for faster and easier building of laptops. Digital ads were placed to create buzz for this new feature in hopes of getting consumers to build their own. Campaign has been live for one month and it is time to check in and see how the campaign is doing.Data collected is through 1st party tagging and is considered to be reliable. The analytics team has already checked data for accuracy.The data metrics you are provided with:•    Clicks: metric that indicates an individual has clicked on an ad they have been exposed to•    Impressions: metric that indicates an ad has been served to an individual•    Spend: the cost of placing the adThe data provided is already summarized by week start (Sunday – Monday) and site (where the ad was placed).Past campaigns are used to determine what a good performing campaign looks like. In this case, benchmarks for a good performing campaign has high click through rate or CTR (total clicks/total impressions) and low cost per click or CPC (total spend/total clicks). Previous benchmarks to compare to are 1% CTR and a $2.50 CPC.You are tasked to see how the campaign was trending weekly, provide insights if the campaign performed well and what happened weekly.1.    Question: What was the trend between clicks and spend? Are there any indications that if more is spent on advertising that we would see more clicks?Submission: Create both a table and a corresponding trended chart that best showcases this. Place insights and notes below the table and chart. Label the results into tab called “Question 1”2.    Question: What is the relationship between spend and impressions and how did this change weekly? Are there any indications that if more is spent on advertising that we would serve more ads?Submission: Create both a table and a corresponding trended chart that best showcases this. Place insights and notes below the table and chart. Label the results into tab called “Question 2”BONUS POINTS IF THIS IS DONE IN TABLEAU INSTEAD OF EXCEL!3.    Question: What is the relationship between spend and CTR and how did this change weekly? Are there any indications that if more is spent on advertising that we would also see higher CTRs?Submission: Create both a table and a corresponding trended chart that best showcases this. Place insights and notes below the table and chart. Label the results into tab called “Question 3”4.    Question: What is the relationship between CPC and CTR and how did this change weekly? What can we say about these metrics and how they compare to each other?Submission: Create both a table and a corresponding trended chart to showcase this. Place insights and notes below the table and chart. Label the results into tab called “Question 4”BONUS POINTS IF THIS IS DONE IN TABLEAU INSTEAD OF EXCEL!5.    Question: Put it all together, did the campaign beat benchmarks for CTR and CPC?Some thoughts you can discuss: Do a deeper dive into the various data cuts (weeks and site) to see what happened and how the campaign trended. What do you recommend should be done with the campaign for the future? Was it successful and if so what did the trends tell us? If it wasn’t successful what sites and weeks were problematic?Submission: Create any tables or charts that would showcase your answer. Place your insights and notes below your table and/or charts. Label the results into tab called “Question 5”