Portfolio

Some examples of things I can help you with. Also, the answer to the question “What do you do all day“?

I have used the below tools and tactics, among others, to achieve hyper-growth for my clients, multiply their ROI, increase their profitability and achieve their growth and marketing goals.

For every section below you will find a sample list of business questions and problems I have helped my clients answer and solve to help grow their business.

You will also find examples of dashboards and analyses I use to answer these questions. My work is data-driven and I use insights to help companies achieve growth.

Channel Optimization

PPC

PPC Optimal Bids

What is the optimal bid for our campaigns and what bid adjustments should we make?

Christos Visvardis image-1024x307 Portfolio
Example of automatic bid adjustments for maximizing profit. Dashboard here

Google Ads Day and Time Optimizations

What is the optimal day and time to run Google Ads in order to optimize performance?

Christos Visvardis image-1-1024x769 Portfolio
Which days and times do we get the best conversions rates? Dashboard here

Google Ads Impression Share

What is our impressions share for Google Ads? Are we losing conversions because we are not ranking or not optimizing our budget?

Christos Visvardis image-2-1024x492 Portfolio
Lost clicks and lost conversions for our budget based on impression share. Dashboard here

Google Ads Campaign Automation

What is the percentage of automation in our Google Ads campaigns and how can we improve it?

Christos Visvardis image-3-1024x449 Portfolio
Percentage of automations for Google ads campaigns visualized and recommendations for campaign optimization. Dashboard here

Google Ads Creative Optimization

Google Ads Creative optimization: which ad types perform better and how can we optimize them?

Christos Visvardis image-4-1024x386 Portfolio
Recommendations for Google Ads campaigns based on cost and lack of RSA. Dashboard here

Resources:

SEO

Trending Queries

What queries are trending right now so we can capitalize on them?

Christos Visvardis image-7-1024x587 Portfolio
Example queries report

Questions that users are asking (for content ideation)

What questions are people asking that are relevant to our website? Can we write content to answer these questions?

Christos Visvardis image-8-1024x587 Portfolio
What questions are people asking that we can write content for and bring traffic to the website?

Landing pages cannibalization

Are we cannibalizing our landing pages with multiple queries?

Christos Visvardis image-9-1024x410 Portfolio
Which landing pages appear in the search results for the same keyword? Can we avoid cannibalization? Example report

Share of Search

What is our share of search compared to competitors?

Christos Visvardis image-5-1024x414 Portfolio
Example share of search report

Image Search

Can we capitalize on image search? What images can bring traffic to the website?

Resources:

Google Updates impact on SEO

What is the impact of Google Updates on our SEO performance?

Christos Visvardis image-1024x553 Portfolio
Dashboard pulling Google’s updates to our SEO dashboard to easily identify issues that came up due to Google’s updates.

Paid Social

Optimal Frequency for Ads

What is the optimal frequency for our ads in order to avoid ad fatigue?

Christos Visvardis image-10 Portfolio
Optimal Frequency Report

Audience Saturation

Are we saturating our audiences? What is the percentage of new people that we’re reaching?

Christos Visvardis image-11 Portfolio
Audience saturation report

How should we allocate our budget?

Cost Curves/Diminishing Returns

What is the relationship between our spend and conversions and what is the point of diminishing returns?

Christos Visvardis image-15-1024x623 Portfolio
Cost curve that shows the conversions we get at every level of spend. You can notice the diminishing returns of the curve. Example Report

Marginal CPA

What is the marginal CPA (i.e. how much more are we paying for an extra conversions) for each level of spend?

Christos Visvardis image-16-1024x623 Portfolio
Marginal CPA vs average reported CPA. You can see that the marginal CPA increases a lot more than observed at the average CPA levels. Example Report

Budget Optimizer

How should I allocate my budget between paid channels?

Christos Visvardis image-17 Portfolio
Budget Optimizer, a tool I built in Python to help you allocate your budget based on cost curves and diminishing returns.

Resources:

What is the incremental return of channel/campaign X?

Causal Inference Test/Analysis

How do I measure the incrementality of a TV campaign? How do I measure incrementality if I can’t run a proper experiment?

Christos Visvardis image-18 Portfolio
Measuring incrementality using Google’s Causal Impact for cases where we cannot run a proper conversion lift/experiment. Check my code on GitHub

GeoLift Test

Can I measure the incrementality of a channel or campaign by splitting the test and control group by geographical area?

Christos Visvardis image-19 Portfolio
Incrementality experiment using Meta’s GeoLift. Check out my code on GitHub.

Incrementality/Lift Test

How can we measure the incrementality of a digital channel (conversion lift)?

Christos Visvardis image-21 Portfolio
Outline of a conversion lift test.

Resources:

Forecasting

CPM Price Forecast based on seasonality

Can we forecast CPM prices based on seasonality?

Christos Visvardis image-22 Portfolio
Forecasting CPM prices based on seasonality using Meta’s Prophet. Check out my code on Github.

Resources:

Attribution and Marketing Mix Modeling

Marketing Mix Model

What is the incremental contribution of each channel? How can we improve our attribution given the limitations of iOS14?

Christos Visvardis image-23 Portfolio
An MMM example using Meta’s Robyn to understand each channel’s contribution, their cost curves, and the ideal budget allocation. Check out my code on GitHub

Attribution Models

How can we improve our attribution?

Christos Visvardis image Portfolio
Comparison of Attribution models: First Touch, Last Touch, Linear and Data-Driven with Markov Chains

Resources:

Retention, LTV, Churn, Lead Generation

LTV, Retention, Churn

LTV Calculation/Cohort Analysis

What is the LTV of our clients?

Christos Visvardis image-24 Portfolio
Cohort Analysis for finding clients’ LTV. Check out code on GitHub

Aha Moment

What is the Aha Moment of our users?

Christos Visvardis image-25 Portfolio
Aha Moment analysis example

Resources:

Lead Quality and others

Lead Quality Scoring/Lead Pipeline Analysis

What is the quality of a lead based on the data we have at the time of the lead generation? How can we help the sales team select the highest quality leads and increase the lead quality?

Christos Visvardis image-12-1024x628 Portfolio
Example Lead Quality Score for each campaign
Christos Visvardis image-13-1024x381 Portfolio
Example Lead Pipeline Analysis

Sentiment Analysis

What is the emotional tone associated to the online reviews of our product?

Christos Visvardis image Portfolio

Example sentiment analysis of online reviews (GitHub)