Media Reporting - Retail Media Analytics

Backend (.NET Utility)

About

A .NET console utility that automates monthly media reporting for retailers, aggregating search, category, product, and homepage metrics from Redshift and ElasticSearch into multi-tab CSV exports.

My Role

Automated monthly retail media reports for multiple retailers using Redshift and ElasticSearch. Generated multi-tab CSV outputs covering search terms, categories, product performance, and homepage metrics. Encapsulated retailer-specific logic via enums and query templates.

Core Capabilities

• Multi-retailer support via Retailer enum with per-chain query logic
• Five CSV tabs: CPG search terms, top search terms, category views, product performance, homepage views
• Redshift CTE queries with parameterized templates
• ElasticSearch REST queries for page views and click-through stats

Architecture

• .NET console app with Microsoft.Extensions.Configuration
• CsvHelper for input/output file handling
• Custom Redshift ODBC/SQL calls
• RestSharp for ElasticSearch queries

Tech Stack