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?

Try out the app I made to allocate budget optimally based on cost curves for marketing channels.

Christos Visvardis image-1-1024x761 Portfolio
The app takes the cost curves of different channels and optimizes the budget allocation based on them.
Christos Visvardis image-1024x667 Portfolio
This is an example budget allocation based on the optimizer.
Christos Visvardis image-2-1024x761 Portfolio
The chart also shows the optimal spend/conversions combination on each cost curve, denoted by a red dot on the chart above.

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
Christos Visvardis image-1024x474 Portfolio
App I made to run Causal Impact analyses for tests. Check the Causal Impact app here

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.

Check out the Apps I have made for GeoLift Power Analysis (i.e. which markets should I select for my test, for how long and with what budget?) and Geolift Post-Test Analysis (i.e what was the incrementality of the test vs the control group).

Christos Visvardis image-2-1024x512 Portfolio
GeoLift Power Analysis app to select test markets, test duration and budget.
Christos Visvardis image-3-1024x390 Portfolio
GeoLift Post-Test Analysis app to understand if your test was incremental or not.

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

Forecast App

Use the app below to forecast your conversions or other metrics that are important to your business. The app is based on Meta Prophet and uses trend, holidays and seasonality to forecast the metric.

Christos Visvardis image-3-1024x463 Portfolio
You can upload your data or use generated data to try out the app.
Christos Visvardis image-4-1024x403 Portfolio
You can select the forecast components like seasonality and holidays.
Christos Visvardis image-5-1024x403 Portfolio
The app will provide the forecast for a given period.
Christos Visvardis image-6-1024x405 Portfolio
You can also see the components like seasonality, trend and holidays.

Try out the Forecast app here.

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)

Pricing Analysis

What is the optimal price for our product?

Christos Visvardis image-1 Portfolio
Van Westendorp Price Sensitivity Analysis to find Optimal Price