Excel Data Analysis Assistance Needed - 07/09/2024 12:17 EDT

Hello,

I am working on a task in Excel and I need some help. The dataset I am working with is in a different language (not English), but there are only a few key columns, and I can explain them to you in English. The task is related to analyzing the conversion rate of different marketing campaigns.

Here’s the task:


In SheetN3, there is a dataset with product sales statistics by client, as of December 22. My goal is to calculate the **conversion rate** (how many client contacts were made per sale) based on different campaign logics, and find at least 3 key insights (findings) from this data analysis. I need to present these findings to management, explaining what results the campaigns are producing and what observations I can make based on the data.

I need to connect the data from Sheet 1 and Sheet 3 using the ClientID, to see which campaign logic was successful in generating a sale. Then, I need to calculate the conversion rate for each campaign logic and find insights.

Could you please help me figure out the best way to connect these datasets and calculate the conversion rate for each campaign logic?

**Here are the columns I’m working with:**

- **Sheet 1**:
- Column A: ClientID
- Column B: Contact Status
- Column C: Campaign Upload Date
- Column D: Branch (where the campaign was uploaded)
- Column E: Campaign Logic (which campaign was used)

- **Sheet 3**:
- Column A: ClientID
- Column B: Channel (where the product was sold)
- Column C: Branch (which branch sold the product)
- Column D: Sale Date (date of product sale)