T8.1: Implementation of a CRM / Joyeria RigoFrig platform Instructions:
Following the examples presented in the presentation of this module and with the data provided, determine the following: Press the following link to access the data for this task: RigoFrig What was the cost of the RigoFrig campaign? What was the return on investment (profit) of the campaign? Comment on the responses shown by the data: What strategy was most effective? Which group responded best? What recommendations would you make to the RigoFrig marketing team?
X ? X Tarea 8.1 RigoFrig (2) - Excel REVIEW VIEW OFFICE TAB FILE HOME INSERT PAGE LAYOUT FORMULAS DATA Sign in X Insert Calibri 11 Wrap Text Custom - . Z Sort & Find & Filter - Select Paste BIU A- Merge & Center- $ - % * Delete Format 4.0 .00 .00 0 Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells Editing M4 fic 0 F G H 1 J K L M N 0 P - Tarea 8.1 RigoFrig (1) 1 Tarea 8.1 RigoFrig (2) A B C E 1 Campaa Navidad - Joyeria RigoFrig (duracin 4 semanas) 2 Nombre cliente Genero Campaa por emai Emails enviado: Emails leidos 3 Maria Rivera F SI 4 1 4 Maite Solano F SI 4 2 5 Rita Cruz F SI 4 0 6 Luis Perez M SI 4 1 7 Roberto Maldonado M SI 1 0 8 Carlos Cruz M SI 4 0 9 Roberto Rivera M SI 4 1 10 Olga Robles F SI 4 2 11 Lourdes Zayas F SI 4 2 12 Jimena Ruiz F SI 4 4 3 13 Luis Prieto M SI 4 1 14 Herminio Navarrete M SI 4 0 0 15 Luisa Sarmientos F SI 4 0 16 Regla Roca F SI 4 1 17 Arlene Santos F SI 4 2 18 19 20 21 Costo estimado por email 25 centavos 22 Costo estimado por web banner $1.50 23 24 25 26 27 28 Entrada a website Compr Cantidad de la compr. Campaa web banne Anuncios al IP Addre entrada a website Compr Cantidad de la compra 0 0 SI $ 99.00 SI 3 0 NO $ 1 SI $ 125.00 SI 3 1 NO $ 0 0 NO $ SI 3 0 NO $ 0 NC $ - SI 3 0 NO $ 0 NO $ S 3 1 1 SI $ 99.00 0 NO $ SI 3 3 1 S $ 99.00 0 SI $ 99.00 SI 3 1 SI $ 99.00 0 SI $ 99.00 SI 3 1 NO $ NO $ SI 3 NO $ 1 SI $ 125.00 SI 3 0 NO $ 1 NO $ 3 1 SI $ 99.00 0 NO $ - SI 3 1 1 NO $ 0 $ SI 3 0 NO 0 NO $ 3 0 NO $ 1 SI $ 99.00 3 1 NO 2222552522225 299200022202222 Sheet1 READY 1 + 60% wl EN 01:58 p.m. 30/11/2020 X ? X Tarea 8.1 RigoFrig (2) - Excel REVIEW VIEW OFFICE TAB FILE HOME INSERT PAGE LAYOUT FORMULAS DATA Sign in X Insert Calibri 11 Wrap Text Custom - . Z Sort & Find & Filter - Select Paste BIU A- Merge & Center- $ - % * Delete Format 4.0 .00 .00 0 Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells Editing M4 fic 0 F G H 1 J K L M N 0 P - Tarea 8.1 RigoFrig (1) 1 Tarea 8.1 RigoFrig (2) A B C E 1 Campaa Navidad - Joyeria RigoFrig (duracin 4 semanas) 2 Nombre cliente Genero Campaa por emai Emails enviado: Emails leidos 3 Maria Rivera F SI 4 1 4 Maite Solano F SI 4 2 5 Rita Cruz F SI 4 0 6 Luis Perez M SI 4 1 7 Roberto Maldonado M SI 1 0 8 Carlos Cruz M SI 4 0 9 Roberto Rivera M SI 4 1 10 Olga Robles F SI 4 2 11 Lourdes Zayas F SI 4 2 12 Jimena Ruiz F SI 4 4 3 13 Luis Prieto M SI 4 1 14 Herminio Navarrete M SI 4 0 0 15 Luisa Sarmientos F SI 4 0 16 Regla Roca F SI 4 1 17 Arlene Santos F SI 4 2 18 19 20 21 Costo estimado por email 25 centavos 22 Costo estimado por web banner $1.50 23 24 25 26 27 28 Entrada a website Compr Cantidad de la compr. Campaa web banne Anuncios al IP Addre entrada a website Compr Cantidad de la compra 0 0 SI $ 99.00 SI 3 0 NO $ 1 SI $ 125.00 SI 3 1 NO $ 0 0 NO $ SI 3 0 NO $ 0 NC $ - SI 3 0 NO $ 0 NO $ S 3 1 1 SI $ 99.00 0 NO $ SI 3 3 1 S $ 99.00 0 SI $ 99.00 SI 3 1 SI $ 99.00 0 SI $ 99.00 SI 3 1 NO $ NO $ SI 3 NO $ 1 SI $ 125.00 SI 3 0 NO $ 1 NO $ 3 1 SI $ 99.00 0 NO $ - SI 3 1 1 NO $ 0 $ SI 3 0 NO 0 NO $ 3 0 NO $ 1 SI $ 99.00 3 1 NO 2222552522225 299200022202222 Sheet1 READY 1 + 60% wl EN 01:58 p.m. 30/11/2020
