Google Search Term Analysis Tool
Developed for Ace Digital Marketing Ltd, this analytics tool transforms raw Google Ads search term data into actionable insights. It allows users to precisely track and analyse the performance of specific keyword sets within their broader campaign data.
Key features include:
- Automated processing of Google Ads search term reports
- Detailed breakdown of key metrics including:
- Cost per keyword set
- Click-through rates
- Impression share
- Conversion metrics
- Percentage of total campaign spend
Technical Implementation:
- Backend: Python for data processing and analysis
- Framework: Flask for API endpoints and server-side operations
- Frontend:
- Jinja2 for dynamic template rendering
- Custom CSS for responsive design
- Vanilla JavaScript for interactive features
This is an ongoing project, with more additions and improvements coming. This is currently an internal tool, so is password projected, but feel free to contact me if you would like to have a closer look.
Soren Outlet Shopify Store
This client wanted to showcase their clearance items. To keep things simple we decided on Shopify as their normal site was built on a custom CMS that is difficult to maintain and operate.
The process of building this site involved training/advice on how to operate a Shopify site.
Sam Frost Digital Marketing Website
Sam needed a new website for his digital marketing business. The old website used Strinkingly, while this new website was built as a custom coded site with Astro. We are currently transferring all the information over and doing final optimisation/checks.
Pipedrive to Active Campaign Note Sync Tool (Beta)
A specialized Python tool that synchronizes notes between Pipedrive and Active Campaign via their APIs. It maintains user attribution, timestamps, and deal context, enabling seamless CRM data migration.
This tool was custom-built to meet specific client requirements for data migration as other tools sent the notes to a single user in Active Campaign.
Pipedrive to Active Campaign Note Sync Tool (Beta)
A specialized Python tool that synchronizes notes between Pipedrive and Active Campaign via their APIs. It maintains user attribution, timestamps, and deal context, enabling seamless CRM data migration.
This tool was custom-built to meet specific client requirements for data migration as other tools sent the notes to a single user in Active Campaign.
Customer Lifetime Value Analysis Tool
A Python-based tool for analyzing customer purchasing behavior and predicting customer lifetime value using Bayesian statistical models.
This tool was built with the PyMC-Marketing library with some modifications to get it working with the customer's Shopify data/export.
Water Tank & Usage Calculator
This tool takes water usage data from a user and calculates the amount of water they use. It also gives them a recommended water tank size, along with some dynamically generated recommendations from the clients product range.
Artbox Gallery Shopify Store
This Shopify store was built for a local art gallery in Christchurch. Currently we are in the process of transferring over 10 years worth of content from the old Weebly site to this new store, including past current and past artworks, blog posts and more.
I have also had to train the business owner from scratch on how to operate and navigate a Shopify store.
Water Tank & Usage Calculator
This tool takes water usage data from a user and calculates the amount of water they use. It also gives them a recommended water tank size, along with some dynamically generated recommendations from the clients product range.
Water Tank & Usage Calculator
This tool takes water usage data from a user and calculates the amount of water they use. It also gives them a recommended water tank size, along with some dynamically generated recommendations from the clients product range.
