Kostiantyn Sherman
Private message 
Offer work 
Ukraine
2 years back
available for hire
age 24 years
on the service 4 years
Rating
Successful projects
Average rating
Language proficiency level
Українська: fluent
Polski: advanced
English: upper-intermediate
Skills and abilities
Design & art
Services
Portfolio
-
6000 USD Online shop of decorations and accessories from Korea
Contextual Advertising
The situation:
A customer with his own online store of jewelry and accessories from Korea came to me, as well as two local sales points in the shopping centers of Dnipr and Kiev.At the beginning of the work of sales from the online store the customer actually did not have.The task was to bring the first sales and to date the cumulative (ROAS) > 400%.My actions:
1 Preparation
Having already experience working in this customs, I have done a thorough analysis of the competitors and the customer’s website to find the reason for the lack of orders.The main reason for the problems with sales we have identified the lack of product description.2 The launch
… When the site got the first lines, I launched an ad in Meta Ads.The first day we received a few orders, but later they found out that they were fake.This situation has not changed over a certain period of time until we have conducted a re-analysis of the site.After reviewing the landing machine we found materials that entertained the customer after the purchase, but could be perceived by the algorithms as "sensitive".I assumed that because of this Facebook could lower our advertiser rating, and show our ads less quality auditories.It was decided to remove this material, as well as to make a new business page, a advertising office and put a new Meta Pixel on the site.After that, the advertising results began to improve.
3 Full-scale war
After 24.02.2022 the online store ceased to sell its goods due to the armed aggression of Russia against Ukraine.We suspended our advertising activity and returned to it in June of the same year.It is worth understanding that as a result of the missile attacks and the marriage of the Russian military, the off-line store in Kiev was destroyed and agreed to close, and the store in Dnipr hardly occupied himself.As a source of traffic we chose Google Ads.After collecting the most targeted keywords and forming a feed of data, we started advertising in the Search Network and Google Shopping.4 Results
We are currently running advertising activities in Google Ads and Meta Ads.The customer changed the platform for the site to the Ukrainian analogue Shopify.Thanks to the gradual transition and the preparation of the advertising office, we managed to make this moment useless for the customer’s business.After the transition, the effectiveness of advertising campaigns and the site increased.The budgets have also increased, thanks to the effective implementation of which we have been able to get out on the ROAS >500% per month from both traffic sources.
-
Online store of women's underwear with sales all over the world
Contextual Advertising
How to increase the number of sales and the amount of income of an online underwear store with the help of Google Ads?
Situation:
"Dallianse" already had sales on Facebook and Instagram. The client wanted to scale further and test Google Ads as a source of traffic to attract customers. It was important to attract new customers, because the store had a promoted brand from which sales were constantly coming.
…
Task:
Increase the number of sales
Ensure payback of "cold" traffic from 250%
Test Google Ads as a source of traffic
What did I done:
1. Analysis
Conducted in-depth competitor analysis to understand the topic more deeply and collect keywords on competitors' brands to get some of their traffic. We analyzed the results from Facebook/Instagram Ads to understand which geo, which age, which gender and which triggers to use in creatives.
2. Preparing the account for launch
We set up Google Merchant Center, set up conversions for each stage of the funnel, connected triple veil to the Google Ads account.
We got banned a few days later because of the frankness of women's underwear. Unlocked Google Merchant Center, continued working on advertising.
3. Promotion
We set up search campaigns based on the brand of the store, based on the keywords by which the target audience searches and buys underwear, based on the names of competitors' stores.
We set up shopping only by brand to get conversions for brand campaigns as cheaply as possible.
Adjusted Performance Max campaigns, excluded the brand from them so that they focus on attracting new users. We used the option of automatically raising rates for new users.
4. Optimization
We disabled Performance Max for all products, because we did not receive a result that would correspond to the KPI. Products were segmented by income in order to set a separate rate for each separate segment of products.
Results:
Income from advertising in Google Ads: $20,697.85
Advertising budget: $7002.02
ROAS = 296%
-
Increase of customers on the online course
Contextual Advertising
How to earn $120,000/month on online learning through YouTube Ads
The situation:
We have a client who is selling earnings courses on YouTube through a free online marathon.
… They already had subordinates whose client was constantly rejoicing.All the work was done under a strict competition.The Task:
The customer came out of an invitation to give from 300 lies per day to $1.Under the conditions of using more than $7000 a month and deposit in the CRI I received an additional % to pay, and therefore I was interested in this.The December
In the first month of work I created offices, processed creativity and launched the first campaigns.I intended to test both target on auditories, expanded by optimized targeting and broad campaigns.After the launch of the advertisement, it began to give ice much less to the CRI.And although the quality of them was not high (many people refused to pay for the paid rate, although the entire marathon was overwhelmed), we covered this problem with the quantity.For work I used 12 video-resolutions in which the course speaker told about the strengths of the product addressing a different CA and offering a different value.
From 15 to 31 December:
Expenses = 1 171,63$
of 2 028
SRA = 0.57$
Sicked
In January, the customer wanted to move to a different form of advertising payment.In order not to waste time, we decided to create a second account, since to change the method of payment needed to stop the old for a certain time.In addition, the customer complained about a bad percentage of payment, and therefore it was necessary to change the tactics.I decided to give up the expanded targeting, which led to a significant decrease in costs and the amount of ice per day.However, thanks to the appearance of a second account I could test more hypotheses at the same time.The data of the remarketing auditors I transferred to both accounts so that they were taught each other, not parallel.In addition, the new office was to be optimized from 0, which significantly worsened the result for a certain period.Overall on the summit:
Expenses = 7 568,16$
Number of pages: 8 987
The price is 0.84$
July
In February, I agreed with the customer to give me information about the collection of ice.So the main KPI is ROAS, not CPA.Over the course of the month I tested a new video ad using an automatic ad rotation, as well as self-modifying the display of each creative.For the Late:
Expenses = 7 312,47$
Number of pages: 8267
Profited: 121 695,23$
by Berry
On the first day of March, I received two more accounts.One of the client's subordinates was dismissed, and I was transferred his accounts as the most rented of the employees.Having 4 client accounts under control, I again set the data exchange between all Google Ads accounts through Google Analytics to accelerate the learning of algorithms.Now I could use these accounts to conduct A/B tests, test new hypotheses and target auditories.I analyzed the campaigns left after the predecessor to take advantage of the best practices.I suggested the customer to download the customer base to the Google Ads office.Under these lists we created Look-a-like audiences, on which they immediately launched advertising.The customer recorded new video-creatives, which we also launched into work.In addition, we launched separate videos aimed at people who have already been on the site but have not registered for the course.for March:
Expenses = 22517,74$
Number of pages: 14496
earned: 265085,69$
-
Online store premium
Contextual Advertising
ROAS >19 during the war, or how to sell values through Google Ads ads
Increased profitability of marketing investments for the valise store
The Task:
… Scale Advertising Campaigns Without significant CPA Growth
The Decision:
1 .Audit
During the Google Ads audit, we found that a large number of campaigns on handbetting were launched.In addition, of the 10 active campaigns in the advertising office, only 4 were actually rented.Non-profit campaigns have been closed.The 2ndOptimization
A large scale of advertising campaign optimization has been carried out.We rejected general requests, and focused on more narrow search terms of the type "Product Category + Brand".Google Shopping is segmented by product and price categories.This was done to ensure that there was more control over the campaigns, shows and priority of certain categories of goods, and control over the volume of advertisements regarding the marginality of the goods displayed.3 .Scalation of advertising campaigns
We have decided that we will work with a profitability targeted investment strategy so that the scalability of advertising campaigns is gradual and without significant growth in CPA.The Results:
Used - 187 073,06
earned - 3 569 681,50
ROAS – 1908,17%
-
Clining in the Lions
Contextual Advertising
How to bring over 200 orders for picking in a month, spending only $448.95 on advertising.The situation:
I came to a customer who wanted to promote the services of the collection of apartments and commercial premises in Lviv.They had a website and advertising that did not give any results.The primary requirement was to give any order.My actions:
1 Preparation
Having already experience working in this field, I have done a thorough analysis of competitors and their sites to find the cause of the lack of orders.After analyzing more than 10 competitors, I wrote out the results in the table, and presented its customer, along with suggestions to improve our site.The client accepted my ideas and began to imply them.While the site was edited, I analyzed the target auditorium, collected keywords, wrote text announcements.I decided to divide the keywords for the type of services, and to launch a separate campaign for each service.This was done so that the budgets for each service were separate, and therefore - it was possible to control their shows, and change the priority.2 The launch
… Thus, I created campaigns for people looking for a housewife, B2B, furniture cleaner and after fire, robbery, etc.Once the site was ready, I set the conversions to the filled client form and the hot line call, and launched the advertisement.3 Optimization
In the process of work I used a strategy with a small number of keywords that were used according to the phrase correspondence, and were formulated as targeted as possible.Thus we showed exclusively to those people who searched for our services, withdrawing from search terms all the unnecessary.Through this, we were able to maximize budget expenses, and get the cheapest possible applications.This can be seen in the link table, where from 274 clicks we received 213 requests
-
Sales department on the outsource for infoprodukts
Social Media Advertising
The situation:
The customer wanted to protest the Meta-reklam as a source of traffic for the sales department that specializes in selling courses through telephone calls.The complexity lies in the fact that CA is a narrow segment of specialists who are prepared to launch their infoprodukt but do not have the skills/wish to sell.It was necessary to remove non-target applications already at the stage of the advertising display.The task:
Get a confirmed application
Budget – $150
… Protests of Meta-reklam as a source of traffic
The Decision:
Preparation for the launch
We have thoroughly analyzed the strengths of the service as well as the needs of the customers who have to close our service.In accordance with this, we created banner creatives that would fully transmit the value of the customer team.Also, a lot of work has been done for the optimization of the landing page, so that the advertising client is even more encouraged to leave the application.
The 2ndPromotion
The work began with setting up advertising campaigns that directed the customer to the landing page.Later, a campaign was added, in the framework of which a potential customer left the application just on Facebook.Specific auditories were immediately disabled, thanks to which we have reduced the reliability of false applications to the maximum.We also used the sounding auditories to make the people we need.3 .Optimization
They performed the optimization of advertising creativity, as well as targeting auditories.They also edited ads to protest a new way of communicating with a potential customer.The Results:
Spending: 4 013,43 or 106,45$
We received 2 confirmed ice for the main service, as well as 1 ice for the additional.The price of the ice is 1337,81 or 35,48$.
The total number of ice: 11
Price per ice: 364,86
-
The online gift box shop
Contextual Advertising
How thanks to Google Ads to sell gift packages for the amount of more
50,000/month
The situation:
… The customer has already had sales on Facebook and Instagram.The client wanted to protest Google Ads and scale through a new source of traffic.The country of sales is Ukraine.The average check is 900.The task:
Increase the number of sales
The price must not exceed 250.
Google Ads as a source of traffic
The Decision:
1 .Analysis
I analyzed competitors to understand what approaches to advertising are already on the market.Also, with the dialogue with the customer I better understood the product, its characteristics and the target auditorium.The analysis was also submitted to the results of Facebook and Instagram ads.During the analysis of the site in the eyes was that it was built on the "Tilda" movement, which has a Russian origin.In addition, due to the characteristics of the site building, it was impossible to optimize it to link advertisements of the type "Shopping".On these, as well as some other, tasks were indicated to the customer, and we decided together to look for a way out of this situation.The 2ndPreparation for launch
The project was not previously advertised through Google Ads, so from scratch the tools needed to work were created and set up.Conversions were set through Google Tag Manager, all data was transmitted to Google Analytics.The text, the promotion strategy and the semantic core were submitted.3 .Promotion
They set up search campaigns with a division on male and female sets.Re-marketing campaigns have been joined in the Context Media Network, which would return those who have not completed the order.It was an idea to set the campaigns for brand search queries, but it was timely to find a business from another field that had a very similar name.Therefore, this source of additional traffic had to be rejected.and 4.Optimization
After analyzing the effectiveness of all the campaigns, we decided to concentrate the budget on women’s products.They also created campaigns for the sale of new year packages, and gathered auditorium of people visiting websites similar to competitors.The main topic was the transition from "Tilda" and the connection of Shopping-campagnes.I paid attention to the proposal of the "Horoshop" movement, which has been in the fast and efficient transfer of online stores from "Tilda" to its platform.We decided to take advantage of the opportunity and launched the transition process.The Results:
Advertising budget: 92348,60
Conversion = 713
SRA = 129,52
Activity
| Latest proposals 10 | Budget | Added | Deadlines | Proposal | |
|---|---|---|---|---|---|
|
You need to share the goods in Google Shopping Google Merchant Center
90 USD
|
|||||
|
Advertising Advertising
90 USD
|
|||||
|
Start Advertising on Google Maps
406 USD
|
|||||
|
Adwords Traffic for the Website
451 USD
|
|||||
|
The Google Ads
1128 USD
|
|||||
|
Advertising on Google
417 USD
|
|||||
|
Google Ads / Facebook Ads for Dentistry
417 USD
|
|||||
|
Google Ads for the Internet Store
412 USD
|
|||||
|
PPC Specialist
135 USD
|
|||||
|
Advertising in Google
417 USD
|
