Google sheets query another sheet jobs
I need someone skilled in search engine optimization, particularly for Google, to enhance the visibility of my study abroad website. I'm targeting a diverse spectrum of users, from high-school students to college students, to professionals who may be interested in international education opportunities. Here's what the project involves: - Developing and implementing effective SEO strategies to improve organic search rankings. Your detailed plan should target high-quality keywords that reflect our audience's inquiries. - Increasing website traffic is another goal. Your method should draw more visitors, specifically from our target audience. - Improving conversion rates. I'm interested not only in attracting more visitors but also in making s...
...whom the specified budget is not suitable, please do not respond to the project ** * Set up link personalization so that by clicking on a link sent from the site, the page opens only to the user to whom it was sent. If clicking on the link will enter the login information of another user, in this case it should not proceed. Configure the correct redirect to the necessary sites * insert a link to a document for download on one of the site pages (this document has already been generated and there is a download link on another page of the site) * Add generation of an invoice for using the site in pdf form (the form will be provided) with saving on the pages in the admin panel and on the user page. * Edit the account pages created in the admin panel, add a filter by user, m...
Hi Taras, here is the other project I was talking about, as alot of my posts there are a few parts to this. 1. is designing a layout of liners for a feeder, I will give you a reference image to go from 2. Is increasing the thickness of existing liners and ensuring they do not run into one another.
...need an Excel 365 PowerQuery script that can fetch daily market data and handle potential data source interruptions or changes. I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags. Key requirements: - The PowerQuery should be able to be refreshed with the google sheet. - It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to function, ideally providing a notification that...
I'm seeking an experienced app developer or team to bring my vision to life. This project involves creating an app for iOS, Android, and the Web that promotes seamless conversation amongst its users. Key Features: - Messaging: As a core component of this app, users should be able to easily and effectively communicate with one another. - User Profiles: Users should have the ability to create, customize, and manage their profiles. - Notifications: Users should receive updates and notifications relevant to their interactions on the app. User Registration: The app will require secure user registration and login features. This will require a deep understanding of data protection and encryption. Share some of your work. Ideal Candidate: ...
Create a form in google Sheets following the pre-determined options. The results of the answers must be recorded in a second tab
...do the Task We can define contact as C1or C2 or C3 or C4 or C5 or D1 or D2 or R1 or R2 Main Page: We can select by categories C1 C2 C3 C4 C5 D1 D2 R1 R2 We can select by date or by range of date we can select by zip code We can select by activity We can select by task number we can select by the way to do task Admin can give access to all contacts of 1 user to another user or to give contact of 1 client from 1 user to another user , or give contact of 1 client to more than 1 user. Admin can give contacts of a group of clients to 1 user or to more. In the main page we can login as admin or user 1 or user 2 user 3 and ...... User 1 or user 2 or.... can I have access only to the contacts, clients given by admin and to the contacts that the user enter by himself The main ...
I am in need of a professional that can set up a Site-to-Site EoIP tunnel using Mikrotik devices. About the Project: - The primary goal is to extend the current office network to another location. This will involve creating a secure, Site-to-Site connection. - High-level encryption is a crucial requirement for this project to ensure the security of data passing through the tunnel. Key Skills and Experience: - Profound understanding and experience in setting up network connections, especially Site-to-Site connections. - Expertise in Mikrotik devices and a proven track record in configuring EoIP tunnels. - In-depth knowledge of encryption protocols and practices, with an emphasis on high-level encryption. Note: Experience in handling similar projects will be a significant advanta...
...monetizes their services listings by charging $5/post. The post stays up for 30 days. Sellers post frequently to keep pushing their listing up to the top of search results. I want to do something similar, and also include the option to subscribe to more frequent monthly postings for a better price-per-post. This would mean I need 2 paths to purchase - one where anyone can post for $5/each and another where a user can create an account with a recurring subscription based on the number of posts they want per month. In this case they will need a simple dashboard for creating/editing listings and managing their subscription. I will also need your help customizing some of the theme design, such as page layout & UI, header, footer, and branding. I'll need some better function...
I'm looking for an experienced marketer to assist with the setup of a Google Ads campaign, targeted towards an international audience. The main objective of this campaign is to increase website traffic. Your tasks include but are not limited to: - Developing a strategic ad campaign. - Conducting thorough keyword research and optimization. - Creating engaging ad copies. - Eliminating negative words and restrictions -Monitor and maintain targeted audience and keywords The ideal candidate should have proven experience in setting up and managing Google Ads campaigns, excellent copywriting skills, and a strong understanding of keywords optimization. Previous work with international audiences would be a major plus. You should be able to deliver effectively with minimum supe...
I'm looking for a skilled social media manager with a special focus on Youtube & Google Ads. The primary goal of this project is to boost subscriptions and views. Key Responsibilities: - Develop and implement social media and community management strategies. - Create and curate engaging, interactive content for Youtube. - Monitor and respond promptly to user comments and feedback. - Analyze and report on social media performance metrics. Desired Skills: - Proven experience in social media management, especially Youtube . - Solid understanding of Google Ads and its role in boosting subscriptions and views. - Excellent communication and customer service skills. - Strong analytical abilities to interpret social media metrics and adjust strategies accordingly. At the ...
I need help with both setting up and troubleshooting my Google Adsense account for my website. I run a website that primarily features job listings and tender opportunities. I'm looking to monetize this site through Google Adsense, and I need an expert who can help me with both the initial setup and any troubleshooting that may be necessary to maximize my revenue. Key requirements include: - Setting up Google Adsense from scratch - Ensuring the account is properly linked to my site - Optimizing the placement of ads across the site - Troubleshooting any issues that may arise during the setup or maintenance of the account The ideal freelancer for this project would have: - Extensive experience with Google Adsense - A solid understanding of the nuances...
As a growing company, I'm looking for an experienced financial analyst who can help analyze the liabilities on our balance sheet - specifically debt, payroll liabilities, and accounts payable. Ideal candidates will have: - Extensive experience in financial analysis, particularly on balance sheets and liabilities - Deep understanding of debt analysis, payroll liabilities and accounts payable - Ability to provide actionable insights based on the analysis - Strong communication skills to explain complex financial data in a clear and concise manner
I'm seeking a talented professional who can create an engaging and persuasive PDF presentation and sell sheet for my beverage product. - I'm targeting adults, so the content must be tailored to this demographic. - The key selling points of my product are its natural ingredients, variety of flavors, and inspiration from Hispanic culture. These aspects should be effectively highlighted and presented in an appealing way. - The finished product should be in PDF format, making it easy to share and distribute. Ideal candidates for this project should have: - Prior experience in creating marketing materials for F&B products, especially beverages - Strong design skills, with the ability to create visually appealing and engaging content - An understanding of adult consumer pr...
I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow co...
I need a portfolio website. It should be designed to showcase my work samples in a detailed manner. The portfolio is to be based on a Google Doc. I'm open to suggestions on this, so feel free to share your thoughts. Ideal candidates will have: - Proficiency in web design and development - Experience in creating portfolio websites - Understanding of UX/UI principles - Excellent communication skills for suggesting and discussing features.
long term , full time flask developer needed to build ecommerce backend you should start right away should have proficiency in flask, jquery, ajax and mongodb budget INR 100 per hour, need to work for another 15 to 20 days
Seeking a skilled SEO expert who can help increase our already high traffic.
Hi Sage E., I noticed you posted a following project ( https://www.freelancer.com/projects/website-design/Build-website-top-another-site/details )
I want a python script that will check the balance of my four wallets inj1.... (injective blockchain), cosmos1.... (cosmos blockchain), osmo1.... (osmo blockchain) and juno1.... (juno blockchain) every 5 seconds. And in case the INJ balance increases, ATOM. OSMO or JUNO, then the entire balance will be transferred fully automatically to another wallet inj1...., cosmos1...., osmo1.... and juno1.....
This system ui has been modded and protected against sharing. It has been programmed somewhere to check the tid of the device using.... getprop cat sys/kernel/jp6/tid also it also checks the device serial number using: getprop for this app the values are the following: tid:E200680D00004006D693381E (for both above commands) serialnum: ...E200680D00004006D693381E serialnum - 1fbc4d46 I want the commands to check against these values to remain so that by editing these values to the tid and serial numbers of the specific device it will check against those numbers and operate if correct and lock out if not. I will also be able to change the switch code to be user specific, along with the location of the if it is kept in another ditectory.
...Users should be able to filter the data based on specific criteria to find the information they need efficiently. - **Pagination**: The grid should support pagination, allowing users to navigate through the data in chunks. The data for the grid will be provided through an existing API, so the successful candidate will need to have a solid understanding of API integration. User interaction is another key aspect of this project. I expect the grid to support the following interactions: - **Click on rows to view details**: Users should be able to click on a row to view more detailed information about that entry. - **Edit data directly in the grid**: The grid should allow users to modify the data directly within the grid and update the database accordingly. - **Select multiple row...
Hey- you worked with me in the past on a typographical photo. Wondering if you might do another photo of son? thanks, Meg
...marketer to set up and manage a Google Ads campaign aimed at generating leads from business professionals. Key requirements include: - Experience with Google Ads, specifically the Search Network - Proven track record in lead generation from similar target audience - Ability to craft compelling ad copy that resonates with business professionals - Structuring of the campaigns to reach maximum ROI Your work will primarily focus on: - Keyword research and selection to reach our target audience - Create effective ad copy and A/B testing - Regularly monitoring and optimizing the campaign for better results - Providing detailed reports outlining performance and your suggested changes The ideal freelancer will have a deep understanding of lead generation on Google Searc...
feasible? idea is, for example, build a website on top of another site that belongs to someone else. for example, is a paid member site. I would like to have a website .... say, , when people registered and paid for on , it leads them to with my login info, so MY people can search and browse through my site without knowing they are on match.com. Please include a detailed project proposal in your application, outlining your approach to this project. Experience in similar projects and a strong portfolio will be an advantage.
I have an existing PineScript indicator that requires the addition of buy and sell alert conditions. The project must be completed as soon as possible. Key Requirements: - Add buy and sell alerts to an existing PineScript indicator - Ensure the alerts are functional and accurate - Complete the project as soon as possible Only need alert when B label red o green appears, no need another alert! another alert ill decline the proyect Ideal Freelancer: - Experience in PineScript - Previous work with PineScript indicators and alerts - Ability to work effectively under a tight deadline i put the image there is need signals
...Virtual Assistant! Are you looking for a dynamic and rewarding opportunity to work as a virtual assistant? We're seeking talented individuals to join our team. Our jobs vary from time to time so if you are flexible and can manage more than one project at once. Please apply. Requirements: Basic computer skills Fluent in English Familiarity with CRMs Proficiency in Google Sheets and Docs Experience with Zoom and Google Meet, Slack, Hub staff, etc.. Professional and a very fast learner Responsibilities: Duties can be telemarketing, sales, social media manage, live chats, data research and more. Assist with various administrative tasks Manage calendars and appointments Respond to emails and phone calls Data entry and document management Othe...
I'm facing indexing issues with my website, and I need a professional to find out what's causing the problem and resolve it. Issues - Crawled - currently not indexed - Discovered - currently not indexed - Excluded by ‘noindex’ tag Note:- This is not a SEO Project so dont bid like anything , Try to read the issues and write how you can help and any past xprnce in such issues. Ideal Skills and Experience: - Proficiency in website indexing and sitemap troubleshooting. - Expertise in various content management systems. - Proven experience in resolving indexing issues caused by recent website changes. Please include past related project samples in your bid.
...mutually complete this task; we can leave each other nice comments and 5 stars for each? Look at feedback on my profile, feedback I left for many others. Here is the project: SINCERELY WOULD BE NICE TO MEET YOU PLEASE ANY THOUGHTS ? Please note project is due in two hours as this projects deadline, as this is needed if we can get some done - then we can talk about next steps and 5 stars and another job also. If this is a good one and we are "successful"; would need a couple others setup, but will handle one at a time? Can you do this for something reasonable in a couple hours? thoughts ?...
I'm looking for an Excel expert who can build a simple yet effective sheet for basic arithmetic calculations. Key requirements: - Perform basic arithmetic operations: The main functionality of the sheet should be to perform basic arithmetic operations such as addition and subtraction. - Real-time collaboration: The sheet should support real-time collaboration, where multiple users can edit the Excel file simultaneously. Ideal skills and experience: - Strong background in Excel: The freelancer should have a deep understanding of Excel and the ability to create formulas for basic arithmetic. - Real-time collaboration proficiency: Experience in implementing real-time collaboration features in Excel will be highly beneficial. - Attention to detail: It's c...
Seeking a skilled SEO expert who can help increase our already high traffic.
I'm urgently seeking a Google Play gift card voucher code worth 1000 INR to make an important purchase for my mother's medical operation. - I need this voucher within a day so your promptness is of utmost importance. - While the primary purpose is for an important purchase, I don't have a specific game or category in mind. The key is that the voucher can be used for any in-app purchase. I understand the urgency of this request and appreciate your help in advance.
I'm looking for a reliable and experienced data entry specialist who can assist me with entering data from images. The images will be directly uploaded to a website, and I need the data to be transcribed into various formats like Excel sheets, Word documents, and for copywriting purposes. Ideal Skills and Experience: - Prior experience with data entry from images - Proficiency in Excel and Word - Copywriting experience is a plus The primary goal of the project is to create a comprehensive database in various formats, so the ability to accurately transcribe and organize data is crucial. The chosen freelancer should have keen attention to detail and a high level of accuracy.
I'm looking for an experienced graphic designer to create a typographical photo of my son. I have the words I want to use. I want the words to blend in with the colors of the photos. EXAMPLES is given ( you can see the blended words but still readable. I just don't want words TYPED over a photo_ I wasted my time with another Freelancer that did that. Please don't bid it your price is over 20.00!!!! Key requirements include: - Deliverable in JPEG format. - Primarily for print usage. - Excellent with typography and photo manipulation. Ideal skills: - Typography expert. - Proficiency in graphic design tools. - Experience in creating print-ready files. Understanding of how to balance images and texts beautifully will be a plus. Narrative will be given upon proje...
...set up an automation system in Google Sheets for specific data from the NSE India website. Key Requirements: - Data Source: The data source will be '' - Data to be Integrated: Only the column titled '%CHNG IN OI' should be extracted. - Update Frequency: The automation should update the Google Sheets column once every day. - Data Display Format: The data in the Google Sheets should be displayed in percentage values. - Historical Data: No historical data tracking is required. The focus is solely on current updates from the source website. Ideal Skills: - Proficiency in Google Sheets and automation tools. - Experience with web scraping and data extraction. - Knowledge of data presentation and formatting in Go...
I'm searching for a skilled developer to perform the following tasks: - Link Firebase and Google Cloud Console to my Flutter app - Configure Firebase and Google Cloud Console to enable: - Data storage and retrieval - User authentication - Real-time updates - Ensure the Flutter app is compatible with both iOS and Android A proficiency in Flutter and PHP CodeIgniter is required. A deep understanding of Firebase and Google Cloud services is also necessary. Experience with successfully linking these platforms would be advantageous. I look forward to reviewing your bids for this specialist role.
...can set up and optimize Google Merchant Shopping Ads for my e-commerce website, Maxko.nl. I'm aiming to enhance my sales through this platform. Key Responsibilities: - Setting up Google Merchant Shopping Ads for - Conducting research on competitive keywords - Optimizing these ads to maximize ROI - Regularly monitoring and tweaking the campaigns for finer performance - Implementing conversion tracking to assess the effectiveness of the ads The ideal candidate should have: - A proven track record of setting up and managing Google Merchant Shopping Ads - Extensive experience in e-commerce and online marketing - Familiarity with 's e-commerce platform - Strong analytical and problem-solving skills - Demonstrable evidence of improving sales through Googl...
I need a skilled web developer to create a fully interactive website for a university project. Key Features: - Discussion Forums: The website should have a user-friendly and secure discussion forum feature where students can interact with one another, engage in academic discussions, and receive support. - Online Quizzes: The platform needs to offer online quizzes. This includes a user-friendly interface, automatic grading, and a progress tracking system for students. Target Audience: The main users of this website will be students. The website should be appealing and engaging to this demographic. Ideal Skills: - Proficient in web development with experience in creating interactive websites. - Knowledge of discussion forum and online quiz functionalities. - Prior experience in cr...
Hi Mohammad, You did for me a Realestate site (https://www.freelancer.com/projects/php/Website-for-selling-properties/reviews) some time ago. May we chat for a new project? I would need: - Exactly the same structure, but with some new content and for another domain. - Fix the old site, as after a server migration it does not work anymore.
I have a task for those skilled in data entry, particularly with respect to copy-pasting job. The work is to be done in Google Sheets, so excellent proficiency in Google Sheets is vital. The volume of data is less than 100 rows and columns total. Therefore, I'm also expecting a high level of accuracy and attention to detail. If you've been involved in similar projects previously, that'll be an added advantage, but it's not a must. Key Skills/Experience: - Excellent copy-pasting abilities - Proficiency in Google Sheets - High attention to detail - Previous experience in similar projects is a plus
Hello, I have a WordPress website with dokan and I want sellers to be able to obtain a donation, currently the site does it with a plugin but I want to keep a commission from those donations. It is acceptable to install another plugin. Currently it does this with a PayPal donation plugin and gravity forms. Write ragnar to know that you read the work, Knowledge of WordPress, Dokan and PayPal donations is essential.
I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including the Production number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the y...
You can see in this google drive folder: I have two spreadsheets: municipalities and duplicates. The duplicate spreadsheet contains all of the records in the municipalities spreadsheet that are considered a duplicate. I don't need any help determining a duplicate, that has already been determined. What I need is for someone to go through the rows in the duplicates sheet, and find those rows in the municipalities sheet, and highlight them. You can see an example of what I mean in the two images attached here. the 'duplicates_examples' image shows a series of duplicate lines, and the municipalities_duplicated image shows those lines highlighted in yellow. That is exactly what I am looking
Hello there, We will translate your Google Sheets (Crypto Ads for Spanish Translation) into Mexican Spanish. Thank you!
I am i...excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer should be able to commit to...
Complete on page and off page seo along with Google ads
I'm in need of a talented copywriter to handle a variety of projects. - The ideal candidate for this role is someone who has a strong command of the English language and the ability to create engaging, compelling copy that will resonate with my target audience. - I'm looking for someone who has experience writing for a variety of mediums, including web content, social media, and marketing materials. - You should be able to adapt your writing style to suit different platforms and audiences, and have a good understanding of SEO principles. - It would be a bonus if you have experience writing for business professionals or young adults. If you're a creative, detail-oriented copywriter with a passion for engaging your readers, I'd love to hear from you.
...Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal ca...
I'm looking for a skilled freelancer who can help me with importing product data from XML sheets. The data needs to be imported into multiple Prestashop faced search feature tables. Key project details: - I need the product information to be imported - The data needs to be updated daily and in real-time - Multilingual support is not required, so a single language is sufficient Ideal Skills and Experience - Proficiency in working with XML data and importing it into systems - Expertise in Prestashop and its search feature tables - Experience with real-time data updates in web applications - Strong problem-solving skills and attention to detail Import data from xml sheets into multiple prestashop faced search feature table. Here's an outline of the tasks Script t...
