Case Studies:
A selection of automation projects delivered to publicly traded brands, start-ups and SMEs. Company names redacted.
Automated spreadsheet production for global electronics brand.
A data company came to Macro² with the requirements detailed in a contract with a public electronics brand. This brand required processing of data, across a combination of 40+ countries and categories. Each having weighting, specific calculations. The brand required 100s of excel spreadsheets in a specific format. This deliverable was due across quarterly waves, with severe deadlines. Macro² was able to produce a custom data pipeline: Using an automated Python pipeline to produce an intermediary data format, and a customisable VBA tool to produce the required excel tables for each wave. With this tooling a job requiring 1000s of employee hours, across several senior positions, became a 2-hour process, devoid of human error. The successful production of these custom deliverables resulted in extended contracts and continuing work, to this day.
Custom Python and JSON production software, Excel specifications for a public market research company.
This company employs 100s of 3rd party data employees to manually produce a specific form of data table. The process was clunky and would take days for each deliverable. As part of a companywide initiative to improve this process, a custom python tool, JSON generator and researcher friendly excel spec file was produced. The tooling helped reduce turnaround time to hours, meaning clients can receive deliverables in less than half the time and save the company 100s of hours per week. This increased profitability on all client projects and allowed for more aggressive sales proposals.
Custom quality assurance software for global retail and streaming brand.
A 3rd party data company was dealing with 2 household name companies, which many contractually required data checks. They had struggled to find an automation solutions to this so were wasting many in-house and outsourced hours manually checking data and still suffering from human error. We created a series of python tools to carry out many of the required checks, all with user friendly graphical user interface and detailed outputs. This reduced manual errors and freed up 100s of hours per month. This helped build stronger client relations and played a role in continued contracts.
LLM agents for translation and content checking company.
A company specialising in survey question translation and content checking came to Macro² looking for AI solutions. We implemented focused LLM agents for specific translation tasks and long-form content checking, incorporating chain-of-thought and tree-of-thought techniques to reduce hallucinations and improve consistency.
Social media automation, and Improved Ad targeting for growing ecommerce brand.
Implemented automation to generate content variations and schedule posts to social platforms, reducing manual effort and improving consistency of output. Macro² also helped optimise ad performance with statistical analysis and A/B testing plan, resulting in faster sales growth and greater ROAS.