Market Semantics Processing Tool 2
4 .In the tab Parameters to remove the chosen cluster from the cluster https://take.ms/8f2ve (forecast possible cluster filters)
According to paragraph 1, the description of the manifestation
(description) to words (to bring everything to small letters, ) to a separate sheet with a structure
country_id - the country's id
word - word from the text of description
ad_count is the number of manifestations in which this word is found.The words are sorted by the alphabet from A to I.and 5.There is 2nd source of data requests with the data strutor
country_id - the country's id
Category_id - Aidi Category
Q - Request
Contact cnt - number of contacts
1.1.Un_Session querry(impression) - the number that made requests
Un_User querry(impression) - the number of unique users who make requests
1.3.Impression ad - the number of indications per request
Un_user Impression ad - the number of users who have seen the publications
3.Click ad - number of shows
4.Un_user Click ad - the number of users with views
Un_user Contact cnt - number of buyers
Impression-to-Contact - Conversion with display to contact
8.CTR - Conversion from display to click by display
Conv to Contact (Session)
a) Each request must include a cluster from the Cluster tab with a key (also from the Cluster tab) in the same request https://take.ms/yOmrE
b) Add to the cluster
Requests - we take from the Requests tab and summarize 1.1.Un_Session querry(impression) if the key is found in the request
Contact - we take from the Request tab and summarize 5.Contact cnt if the key is found in the request
The title will be shot by hands.
The status will be killed by hands.
6 .On a separate tab Description by key create a macro that according to a specific word (Word tab) / corner (the tab shows the descriptions of the ads
in format
country_id - the country's id
word - word from the text of description
ID - Iddy Revelation
Description - Text of the description of manifestation
Client's review of cooperation with Ivan Moroz
Market Semantics Processing Tool 2Thank you ! All in time and according to order.
Freelancer's review of cooperation with Y H
Market Semantics Processing Tool 2As always, it is clear and clear.
Thank you for the project
-
744 99 0 Hello to you,
I do it quality and quickly. Experience in Excel VBA over 5 years. You can see in the reviews.
I will be happy to help!
Current freelance projects in the category Desktop Apps
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 2 days 20 hours back ∙ 9 proposals |
Creation of software for generating cutting files for wooden puzzlesWe are looking for a developer to create software that automates the process of building cutting files for wooden jigsaw puzzles. Current Process Currently, each file is created manually by a designer in Adobe Illustrator. The file contains: the outer contour of the puzzle in… Desktop Apps ∙ 3 days 1 hour back ∙ 14 proposals |
Small edit on the website
16 USD
Need to update the offer agreement in the footer to a new one, the company has changed its regulations Task will take 20 minutes Web Programming, Desktop Apps ∙ 4 days 3 hours back ∙ 110 proposals |
Account reconciliation tool with the bank, cards, and accountantTechnical Assignment: Tool for Reconciling Accounts with Bank, Cards, and AccountantGeneral Goal A local tool (script/small application in Python) is needed, which is manually run once every 1-2 months on my computer and performs reconciliation between: Invoices I issued to… Python, Desktop Apps ∙ 6 days 10 hours back ∙ 44 proposals |
Add pauses of 10-30 seconds between sending emails.Hello! I am looking for an experienced 1C / BAS (BAF) programmer to promptly resolve a technical issue with email distribution.Problem essence: We use the accounting program BAF (Business Automation Framework), version 2.0. Once a month, there is a need to send about 300 emails… Web Programming, Desktop Apps ∙ 12 days 1 hour back ∙ 10 proposals |