You are tasked with combining the results of a campaign.There are two separate data sets for you to combine and summarize: Website Data and Keyword Search data.This is something marketers have to do because data can come from many places.It is your responsibility to know how to accurately combine them.

Data file with instructions:

Excel Assignment _MKTG_262DataFile_with_InstructionsRevised.xlsx

download

Summary Template Website Data Keyword Search Instructions: After you have combined the data sources, summarize the results into a table using the headers below. Apply VLOOKUP function in columns with column headers in blue, for each keyword in ranges (A6:A24), (B6:B24), (J6:124). (K6:K24). (L6-L24) Calculate the metrics in yellow using your combined data set. Keyword Visits Visitors Bounce Rate Minutes per Visit Pageviews per Visit CTR CPC Cost per Visit Impressions Clicks Cost bed bedroom furniture chair couch dresser furniture holt bed holt bedroom furniture holt chair holt couch holt dresser holt furniture holt livingroom furniture holt nightstand holt table livingroom furniture nightstand tableSummary Template Website Data Keyword Search Keyword Campaign Code Visits Visitors Bounces PVs Session Duration Bedroom - Nonbrand 3,592 2.912 1,259 4.504 107.708 bedroom furniture Bedroom - Nonbrand 3.506.13:3.346.254 2.107.687 6.521.40 191,091.871 chair Livingroom - Nonbrand 508 391 479.946 295.009 973.513 33,337,648 couch Livingroom - Nonbrand 681 629 643.492 395.536 1,305.24 44,697.693 dresser Bedroom - Nonbrand 1.622 73 1.548.74 975.496 3.018.29 88,442.666 furniture Livingroom - Nonbrand 2,455.90, 2.318.494 1,425.113 4,702.78 161,045.341 halt bed Bedroom - Brand 1.618 537 1,504.082 948.039 3,080.01 106,357.153 holt bedroom furniture Bedroom - Brand 1.675.72 1,357.226 981.536 3.188.84 3,412 holt chair Livingroom - Brand 155 246 146.543 86.279 303.661 11,612.279 holt couch Livingroom - Brand 235.695 222.483 130.989 461.02 17.629.846 holt dresser Bedroom - Brand 1.478.89 1,374.313 866.245 2.814.27 97,180.899 holt furniture Livingroom - Brand 612.721 578.373 340.524 1,198.48 45,831.095 holt livingroom furniture Livingroom - Brand 551 406 520.495 306.447 1,078.54 41,244.733 holt nightstand Bedroom - Brand $17.853 402.379 271.18 849.867 33.973.902 holt table Livingroom - Brand 103.932 98, 106 57.761 203.291 7,774.047 livingroom furniture Livingroom - Nonbrand 2.383.20: 2,946.771 2,018.317 5,179.49 145,197.483 nightstand Bedroom - Nonbrand 580 096 353.644 348.721 1,078.97 31.616.512 table Livingroom - Nonbrand 349 873 330.297 203.024 669.968 22,942.836Summary Template Website Data Keyword Search Keyword Campaign Code Impressions Clicks Cost bod Bedroom - Nonbrand 18173 1190 3.625.07 bedroom furniture Bedroom - Nonbrand 28327 1372 5.773.4 chair Livingroom - Nonbrand 10533 449 2,903.77 couch Livingroom - Nonbrand 14864 2,100.95 dresser Bedroom - Nonbrand 15357 2.770.81 furniture Livingroom - Nonbrand 46543 2169 7.724.18 halt bed Bedroom - Brand 34876 1217 4.388.79 holt bedroom furniture Bedroom - Brand 38713 1260 5.3993 holt chair Livingroom - Brand 357 1.351.59 holt couch Livingroom . Brand 11287 542 6,875.9 holt dresser Bedroom - Brand 8779 1112 4.324.34 holt furniture Livingroom - Brand 40609 1409 4.868.43 holt livingroom furniture Livingroom - Brand 11277 1268 3,800.01 holt nightstand Bedroom - Brand 3118 239 1,175.7 holt table Livingroom - Brand 3492 239 629.29 livingroom furniture Livingroom . Nonbrand 35875 1317 6.257.12 nightstand Bedroom - Nonbrand 3487 227 2.759.15 table Livingroom - Nonbrand 4984 309 1.068.38