Project: Automating Performance Marketing Data Extractions
Streamlining data integration and visualization for comprehensive performance marketing insights.
Client: E-commerce Business (Shopify Website and Amazon Marketplace)
Challenge
With the resident data analyst on maternity leave, the consumer marketing team needed someone who could quickly take over and manage all reporting needs. The goal was to automate the extraction of performance marketing data across multiple channels and sales platforms.
Solution
I automated the extraction of performance marketing data, including paid social, paid ads, and organic SEO for two sales channels: a Shopify website and the Amazon marketplace. Utilizing Funnel, I integrated data sources such as Facebook, LinkedIn, Instagram, X, Amazon Marketplace sales, and custom Google Sheet import data. This data was stored in Amazon S3 and visualized using Tableau.
When the company decided to adopt a minimizing loss approach, I transitioned all visualizations from Tableau to Looker Studio to provide free access to data for all team members.
Challenges:
Automating data reporting from numerous sources without technical support
Operating within a small team of 5 people as the sole person responsible for all reporting and analysis needs
Technical Details:
Tools Used: Funnel, Amazon S3, Tableau, Looker Studio
Data Sources: Facebook, LinkedIn, Instagram, X, Amazon Marketplace sales, custom Google Sheets
Responsibilities: Data integration, automation, visualization, and transition to Looker Studio
Impact:
Automation: Streamlined reporting for marketing and executive teams
Company-wide Access: Enabled company-wide awareness of the latest marketing and sales performance through free access to data in Looker Studio
