Customer Report Data Aggregation & Visualization

Job ID: 38709173

Budget: $15 – $25 USD

I'm looking for a data analyst who can help me aggregate and visualize data for a customer report. The report needs to present their impressions and clicks from the advertising they purchased from our company. I'm looking for an easily replicable solution to copy paste these data sets from the different customers each month to send out monthly. As you can see from the linked workbooks, we receive just the raw data on the 2 different types of advertisements we do. Pivot tables require you to redo the table each time and are not easily copy/pasted.

Requirements:
- Data visualization: The report should primarily use charts and graphs to present the data.
- Delivery format: The final report needs to be in a PDF document.
- Metrics: The report should include specific metrics such as impressions, clicks, and the click-through rate.

Ideal Skills and Experience:
- Proficiency in data analysis and visualization.
- Experience in creating professional PDF reports.
- Ability to present complex data in an understandable and visually appealing way.