Data Analysis Examples
Below are some examples of different data analyses that I regularly run. Naturally, these values are also tied to revenue, so I can’t share that. I also make use of various dashboards - custom-coded ones for my usage and Tableau for team ones. You can see an example on my Customer Intelligence page.
Customer Acquisition
The following data was collected using Google Tag Manager to capture and Google Analytics 4 to process. Graphs were generated in Sheets.
MailChimp performance
Below are graphs of the email opening rate over a timeframe. The data was collected using a custom script to extract information from the MailChimp API. Other analyses were also run to investigate each campaign's sales performance by time, click-through rate by time, and AB-test results (email subject line, email headers, content type, etc.).
Financials
Of course, I can’t share examples of financial data analyses. I collect the data from Google Tag Manager, Google Analytics 4, Google Search Console, Amplitude, Google Ads, Reddit Ads, Meta Ads, and Amazon Ads. Standard reports I generate include:
Bottom-line
Revenue
Ad Spend
Return on Ad Spend (ROAS)
Traffic
Web Traffic
Cost per visitor
Sign-ups
Engagement
Sign-ups
Cost per sign-up
Free Trials
Cost per Free Trial
Ads
Cost per Click (CPC)
Click-Through Rate (CTR)
Cost per Engagement (CPE)
Cost per Mille (CPM)