profile-pic
Vetted Talent

Nagendra Singh Rawat

Vetted Talent

Performance Marketer with 4+ years of experience building a digital-first culture at a large corporation. Implemented new competitive analysis and consumer trend reports to increase quarterly sales by 25%. Conducting SEO, SMM, WhatsApp marketing campaigns, keyword research, DSP & SSP Advertising, etc, and successfully deploying a digital marketing budget of millions of rupees. This was done to achieve maximum ROI. Possess a deep understanding of search engine optimization and PPC for websites as well as expertise in creating relevant content.

  • Role

    Freelance Data Analyst & Marketing Specialist

  • Years of Experience

    5.3 years

  • Professional Portfolio

    View here

Skillsets

  • Scikit-learn
  • Plotly
  • Power BI
  • Precision
  • Python
  • Random Forest
  • Recall
  • Rest APIs
  • Rmse
  • Roc-auc
  • PCA
  • SciPy
  • Seaborn
  • SQL
  • StatsModels
  • Streamlit
  • Tableau
  • Vscode
  • XgBoost
  • Gradient Boosting
  • Colab
  • cross-validation
  • Decision Trees
  • Docker
  • Excel
  • F1
  • Feature selection
  • Git
  • Google Analytics
  • accuracy
  • Gridsearchcv
  • Jupyter
  • K-Means
  • Linear Regression
  • Logistic Regression
  • Matplotlib
  • NumPy
  • pandas

Vetted For

11Skills
  • Roles & Skills
  • Results
  • Details
  • icon-skill_image
    Digital Marketing & SEO Specialist (Remote)AI Screening
  • 71%
    icon-arrow-down
  • Skills assessed :Copywriting, EmailMarketing, Graphic Design, Adobe Creative Suite, Content Creation, Google Ads, Google Merchant Center, Looker Studio, Meta Ads, WordPress/Shopify, SEO
  • Score: 64/90

Professional Summary

5.3Years
  • Apr, 2023 - Present3 yr 1 month

    Freelance Data Analyst & Marketing Specialist

    iNSRawat.com
  • Mar, 2023 - Jun, 2023 3 months

    Digital Marketing Associate

    CarEager VMG
  • Mar, 2022 - Mar, 20231 yr

    Digital Marketing Manager

    Plants Kharido
  • Jan, 2020 - Dec, 20211 yr 11 months

    Digital Marketing Executive/Intern

    Multiple Organizations

Applications & Tools Known

  • icon-tool

    WordPress

  • icon-tool

    Amazon Advertising

  • icon-tool

    Google Tag Manager

  • icon-tool

    Google Ads

  • icon-tool

    ChatGPT

  • icon-tool

    Meta Ads Manager

  • icon-tool

    Meta Business Suite

  • icon-tool

    Google Analytics

  • icon-tool

    Twitter Ads

  • icon-tool

    Google Ad Manager

  • icon-tool

    Google Marketing Platform

  • icon-tool

    WhatsApp Marketing

  • icon-tool

    wordtune

  • icon-tool

    Bard

  • icon-tool

    Google Play Console

  • icon-tool

    Google Trends

  • icon-tool

    Canva

  • icon-tool

    BuzzSumo

  • icon-tool

    SEO

  • icon-tool

    SEM

  • icon-tool

    SMM

  • icon-tool

    PPC

  • icon-tool

    Data analysis

  • icon-tool

    Airtable

  • icon-tool

    Zoho

  • icon-tool

    Microsoft Teams

  • icon-tool

    Zoho Workplace

  • icon-tool

    zapier

  • icon-tool

    Google ad platforms

  • icon-tool

    YouTube Marketing

  • icon-tool

    Campaign Manager 360

  • icon-tool

    WooCommerce

  • icon-tool

    Facebook Ads Manager

  • icon-tool

    DV360

  • icon-tool

    Google My Business

  • icon-tool

    Google Analytics

  • icon-tool

    AdWords

  • icon-tool

    Instagram

  • icon-tool

    Facebook

  • icon-tool

    Facebook Ads Manager

  • icon-tool

    Google Analytics

  • icon-tool

    Google My Business

  • icon-tool

    DV360

Work History

5.3Years

Freelance Data Analyst & Marketing Specialist

iNSRawat.com
Apr, 2023 - Present3 yr 1 month
    Built automated looker studio dashboards analyzing 15+ KPIs across channels, improving decisions and increasing client ROI by 25% through statistical analysis. Developed Python automation scripts for ETL processes, reducing manual data collection by 35% and improving data quality through validation workflows. Conducted consumer behavior analysis using EDA on 50,000+ records, identifying key purchase patterns and churn indicators. Implemented A/B testing framework with hypothesis testing (p-values, confidence intervals) resulting in 18% conversion improvement.

Digital Marketing Associate

CarEager VMG
Mar, 2023 - Jun, 2023 3 months
    Analyzed sales funnel data using data-driven strategies resulting in 25% sales increase through predictive modeling and segmentation. Designed custom Excel dashboards with advanced formulas and pivot tables for management reporting, integrating Google Analytics for real-time KPI tracking. Performed cohort analysis on customer acquisition, calculating retention rates and lifetime value metrics.

Digital Marketing Manager

Plants Kharido
Mar, 2022 - Mar, 20231 yr
    Achieved 6x ROI through data-driven budget optimization using statistical analysis to allocate Rs.5L+ monthly spend across channels (Google Ads, Facebook, Instagram). Managed comprehensive e-commerce analytics using Google Analytics/SQL, implementing real-time dashboards tracking 20+ metrics. Conducted funnel analysis identifying 3 critical drop-off points, implementing A/B tested solutions improving checkout completion by 22%. Performed customer segmentation using RFM analysis and clustering, identifying 4 personas enabling personalized campaigns with 30% higher engagement.

Digital Marketing Executive/Intern

Multiple Organizations
Jan, 2020 - Dec, 20211 yr 11 months
    Managed multi-channel campaigns for 5+ clients, analyzing performance data using Google Analytics/Excel to optimize SEO, PPC, social strategies. Developed comprehensive ROI dashboards tracking 10+ metrics using pivot tables for client presentations. Improved data validation processes, implementing systematic workflows reducing errors by 40%.

Achievements

  • Increased client's website traffic by 20% and improved conversion rates by 25% in the first quarter
  • 25% increase in quarterly sales at CarEager
  • 6X increase in conversations at CarEager
  • Increased repeat buying from 20% to 35% at Plants Kharido Pvt Ltd
  • Executed strategies to optimize diverse paid marketing channels resulting in increased ROI & boosted website traffic
  • Enhanced market share by 25% through strategic analysis using SWOT & competitor benchmarking tools
  • Achieved 6x ROI within 6 months in E-commerce
  • Developed robust conditional Email & Whatsapp campaigns that improved retention
  • Enhanced online sales by 25%, drove a 50% increase in website traffic, & attracted 100 new customers
  • Enhanced engagement, reach, & conversion rate by 20%, 30%, & 25%, respectively, through Meta pixel integration
  • Increased ROI & boosted website traffic at iNSRawat.Com
  • Increased sales by 25% at CarEager
  • Achieved 6x ROI within 6 months at Plants Kharido pvt ltd
  • Increased revenue 25%
  • Increased sales 25%
  • 6X increase in conversations
  • 25% increase in quarterly sales
  • 6x ROI within 6 months
  • INR800,000 monthly revenue
  • Enhanced online sales by 25%
  • 50% increase in website traffic
  • Attracted 100 new customers
  • Enhanced engagement, reach, & conversion rate by 20%, 30%, & 25%

Testimonial

Plants Kharido & Digital Sampark

Amit Kumar

I had the pleasure of working with Nagendra on various projects involving Marketing, Brand Strategy, SEO, Google Ads, and Facebook Ads. Nagendra expertise in these areas truly sets him apart. His strategic insights, coupled with a deep understanding of digital marketing trends, contributed significantly to the success of our campaigns. Narendra proficiency in Maven was particularly noteworthy, and his ability to optimize results exceeded our expectations. He is not only knowledgeable but also dedicated, consistently delivering high-quality work within specified timelines. I highly recommend Narender for anyone seeking a skilled professional in the realm of marketing and advertising. His commitment to excellence and results-driven approach make him a valuable asset to any project.

Major Projects

5Projects

Customer Behavior Prediction

    Built end-to-end ML pipeline for e-commerce churn prediction; performed EDA, engineered features, trained classification models, optimized XGBoost, and deployed Streamlit app.

Marketing Analytics Dashboard

    Designed automated ETL pipeline extracting data from multiple sources; developed SQL queries and interactive Tableau dashboards for real-time KPI reporting.

House Sale Price Prediction

    Developed regression model predicting house prices using feature engineering and ensemble models; addressed multicollinearity and created interpretable outputs.

Data Cleaning & Visualization

    Processed large bike-share dataset; performed data cleaning, temporal analysis, and created interactive Tableau dashboards as part of Google Data Analytics capstone.

Supermarket Loyalty Prediction

    Built predictive model forecasting customer spending; performed feature engineering, cross-validation, and hyperparameter optimization under exam conditions.

Education

  • Bachelor of Science

    H.N.B. Garhwal University
  • Data Science Career Track

    DataCamp (2025)
  • Google Data Analytics Professional Specialization

    Coursera (2025)
  • Data Fundamentals & Getting Started with Data

    IBM SkillsBuild (2025)

Certifications

  • Campaign manager 360 Certification Exam

    Google (Jul, 2022)
    Credential ID : 766131
  • Google ads - Search Certification

    Google (Jan, 2024)
    Credential ID : 255476238
    Credential URL : Click here to view
  • Certified digital marketer by google

  • Content marketing certified by hubspot academy

  • Business communication masterclass certificate from upgrad

  • Digital advertising certified by hubspot academy

  • Business communication masterclass certificate by upgrad

  • Creative writing trainings certified by internshala

Interests

  • Cricket
  • Internet Surfing
  • Learning
  • Podcast Listening
  • Reading
  • Trekking
  • Travelling
  • AI-interview Questions & Answers

    Could you help me understand about your background and myself, Nava, I'm from the current area, currently residing in Gurgaon NCR. I have been working in the digital marketing space for 5 plus years, where I've worked for different kinds of organizations and started my career as an intern, then slowly and steadily grew to become a digital marketing manager. I have handled a team of 15 people who used to handle all digital marketing tasks, like SEO, on-page activities, paid marketing, such as Google Ads, Facebook Ads, Meta Ads, LinkedIn Ads, Twitter Ads, and other kinds of ads. I also handled ABM marketing through the WhatsApp channel and email marketing, as well as social media marketing. Currently, I have run campaigns worth more than 2 crores of Indian rupees on paid marketing, specifically on Google and Meta Ads, and for SEO, I've worked with different organizations. You can also see my resume for more details. Currently, I'm working as a freelancer, getting clients from Upwork and Fiber, and helping international clients, including those from Austria, the UK, and the US. I'm currently providing 6 to 8 times the return on ad spend (ROAS) through paid marketing. I'm running campaigns on Google, finding their niche audience, targeting specific locations, and helping them generate leads or make purchases from e-commerce sites or SaaS-based products. I'm providing all these services. I'm looking forward to helping you as well, giving my 100% knowledge and expertise, and generating revenue and growth together.

    There's my phone. How do you determine my net target keyword for a Google Ad campaign? So, it's based on our campaign, definitely, what kind of campaign we're running, what kind, and the second one is our goal. What kind of goal we have, like, if running a campaign for generating leads, for that's supposed for MBA college students, to get their admission to a university. So we will target people. The audience size would be around 22 to 25, or 27, and the targeted location will depend on the ad location, where we are based, and where the universe we will target people who just graduated from university and looking for a master's in business administration or MBA, and finance, or kind of thing, whatever that campaign goes will be. And we will target those kinds of keywords, research those kinds of keywords, through tools like Keyword Planner, and Google Suggest, currently, you can use AI tools like ChatGPT and Gemini Meta. G Meta AI as well. So, this kind of tool could help you to get the kinds of keywords that are currently trending in the market. You can also check Google Trends in your particular location and particular industry you're targeting, and get relevant keywords and add most keywords into phrase match and exact match. Don't use broad match. It could cost you much and will not get the kind of quality leads you want through your ad campaign. So, these kinds of things you have to look at your audience, your location, these things matter. You also have to look at demographics, whether it's based on customer income or location, all kinds of things. These are the things you have to target, and you could also use dynamic keywords in your Google Ads. In dynamic keywords, you can add location or particular keywords related to US services, all kinds of things. Yeah. This thing helps to target the best audience and find our relevant audience and get.

    relevant conversion as well. Explain how we would execute 10 sites SEO strategically to avoid penalties. So, we have to do backlinks for that, upsides of SEO. And we'll need to find the right kind of backlinks, on websites related to our industrial services. So we have to go to platforms that provide these kinds of services. We can find that through online research, doing research on what kind of interests we're targeting, who our ideal audience is, such as news agencies or blogging sites, guest blogging, social bookmarking, business listings, and these kinds of things. So, we have to target exactly those, and we need to provide our backlink provider with email messaging where we'll talk about our products and services. We're targeting these kinds of audiences, you can check our blog, we provide these kinds of services or products, or we're looking forward to getting backlinks through your news agency or channel or whatever platform they are. We need to reach out to them, if it's paid and you think it will boost your overall traffic and conversion, you could use paid boosting apps, paid volume bookmarking or block backlinks as well. You could generate, and there are plenty of free backlink providers with great domain authority and page authority. This kind of thing. So we have to target page authority, domain authority, and also check the monthly organic traffic the website provides. Which we are targeting to get backlinks through their side. These kinds of things we have to consider.

    Explain how would you connect an SEO to a large ecommerce website. There are a lot of tools, which also provide free SEO returns through free SEO tools or you could use paid SEO tools like Semrush or UberSuggest. These kinds of tools provide all in all SEO. And if you want to use free tools, you can use Screaming Frog, which provides around 500 free audits where you can check all your tags are working perfectly fine or if there are anything missing. Technically, errors or tag errors on pages, your errors like missing title, missing image alt text, or missing descriptions, or tags, or other kinds of things. Is your schema markup correct or not providing information about your business or your article or what kind of schema markup you are providing for particular pages or section of your website? These are things you can check through and similar ways, we also provide free SEO audits where you can check all these activities. And you can check manually as well. Manually, it will take time. You have to check all these things manually through website speed, Google core web vital. Are they following all these things or kind of things? You have to check all these. If you are using paid tools like Semrush or etcetera or Ubersuggest, it will help you better and faster to audit your website and what is missing. Is your coding right? Is your JavaScript properly working or is it providing a timer to your website speed and slowing your website? You have to check all these things. If you are using your WooCommerce site, you can use plugins which provide faster website. There are a lot of plugins which boost and enhance your website speed. You can check all these plugins, such as WP Rocket and other plugins as well. It's a paid plugin, WP Rocket, but there are all other plugins as well which provide free speed and faster website as well. You can check all these things on your WooCommerce platform or website, you can speed up your website and reduce your unused JavaScript through the plugin, which you can use to pay for your plugin as well.

    What's starting to improve the length and scope of website region design is dependent on the platform you're using to build your website. Are you using a CMS platform like WordPress or Shopify, or are you building your website from scratch using a framework like React or Angular? It depends on your website, and then you need to provide essential information about SEO-related on-page or off-page SEO to your web developer, who is designing your website and coordinate with them on each task related to your website, whether it's creating your home page, other pages of your website, and blog page. You need to correctly use all the measures of SEO, whether it's your headline, hero page, or service page, call to action page, and other things. You have to clearly mention your website services or product in a simple way that users can understand, and make sure your website is user-friendly and easy to scroll and understand. You have to include these things and add things like providing services, sign-up forms, and other things related to your website services or product, like your hero page, main page, or call to action page, testimonials page, or work portfolio page, like what work you have done. You have to include these all things and add things like providing schema markup or other tools like adding analytics tools to your website, Google Analytics and Google Ad platform, implementing all these tags through GTM, or you can add them through GTM as well. Now all these tags and schema markup are other tags related to SEO. You have to add them properly in a way that Google's core web vitals have instructed and given the opportunity to execute these things in the right way. These are the things you have to maintain and improve. And most importantly, your content should be related to your customer, which provides clear information. You have to make content that is clear and related to your customer.

    When optimizing product building in Google Merchant Center to improve Google Shopping performance, if you're using WordPress with WooCommerce, you can simply add through WooCommerce into your Google Merchant Center and add an automated feed through your merchant, through your website to Merchant Center. And whatever changes you make in your website will automatically implement those changes in Merchant Center as well. The same thing goes for Shopify. But if you're using a custom-made website through different kinds of things, you could use the Merchant Center API for a dynamic feed or you can use Google Sheets, make a Google Sheet and provide all these feeds through that. We will add all these things related to ecommerce products, SEO-related product feeds, like, firstly, title your product title and product image, and attribute description about the product meta description. Or what kind of specific feature or kind of service, feature your product is providing, your unique selling point and these kinds of things. And you can use to add your review which you got through Google My Business or Trustpilot or another website, Amazon. You can add these reviews as well, customer reviews and testimonials. These things will definitely improve your overall Merchant Center product feed, which will also help search engine result pages to appear your product on search engine results pages and improve your quality of traffic and conversion as well. These are the things you can implement through Merchant Center or you can directly make similar changes to your website as well, whatever changes you want to provide for your customers.

    So, an example of a time when I saw the effectiveness of everything will tell you is, as I said, I used a different organization structure. One example of my organization was Branch Creator, where I worked as a digital marketing manager or director. Because I was a founding member of Branch Credit, we used SendGrid tools to do email marketing and WhatsApp marketing. I created templates using Graphite and template. Mostly, the Graphite team created templates, but sometimes if they were busy, they couldn't do that. So I used to create templates through tools like Canva and Photoshop, which I have a little knowledge of Photoshop, but I can use Canva as an expert. I used to generate graphics for related or personal campaigns. Like if we were giving a 10% off for a particular time period or a festival offer or a Black Friday offer. So we created that kind of template, an email template or WhatsApp template, where we used our best ad copy to generate conversion through that kind of template and layered a call to action as well. So, yeah, I had run these kinds of things and mentioned our brand and brand line, like what our brand represents. So, yeah, these things I have used and generated conversion as well, and run successfully, generating around 40 to 60% conversion rate. I mean, 30 to 40% of conversion rate through email marketing and WhatsApp marketing. Right? You know, there is a direct conversion with the client. Not third parties are involved in that kind of conversion. So, yeah, that's why we could get a greater conversion rate as well.

    How do you manage the success of a Meta advertising campaign and what it means? So, a Meta advertising campaign includes the kind of campaign you are running. If you are running a sales campaign, it will depend on how many purchases you get from a particular campaign, running for a particular time period, and these kinds of things. If you are running a lead campaign, it will depend on how many leads you have generated through that particular campaign. If you are running a branding and awareness campaign, it will depend on how many people you have reached. There are different kinds of measurements to measure any campaign on Meta. If I talk about a sales campaign, it will depend on the kind of targeted audience and location, and the behavioral targeting you are using. Are you targeting people who are related to your product or interested in buying your product? These kinds of things matter on Instagram. In Instagram, interest, behavior, and profession are the things you can target. You can also use remarketing by targeting similar audiences and other kinds of things. These kinds of things can help you understand better and also use catchy and well-written ad copy, graphics, which create attention to customers or grab attention by telling customers there is something different about the product or services you are providing. You can also use some graphics of your previous results, like your reviews, and you can also use video ads. You can target your particular audience on different platforms on Meta, and you can check which platform is working better for you. And you can boost that platform by giving more budget to that particular platform, likely targeting this area on Instagram or Meta, Facebook, or the Messenger app? Which one is giving you a better conversion or website visit or whatever your campaign goals are. So it depends on that. If you are getting better results, you can improve and increase your budget as well. If you are not getting results, you have to check your audience and the targeted audience you have, their behavior, their interest, or their professional audience. These kinds of things will help you optimize your campaign better and get better results.

    How would you handle the technical aspect of creating Shopify with a 3rd party ERP system? Showing a smooth order. There are two kinds of systems in Shopify. First, you can use an ERP system plugin, which provides data from the ERP system we are using or a plugin in our Shopify store. You can find these as well, and you can check whether you want to go with a free plugin or a paid plugin. Another one is the ERP software we are using. We could also coordinate with the software team. The software product we are using could be coordinated with them, and we could get it integrated with Shopify so we could do it manually by adding their Shopify app to our Shopify website and integrating that with the smooth, providing API and other software through Shopify's API and integrating it smoothly. I have integrated a couple of tools in my Shopify website previously. So if I talk about the tools I have added, one was LiveChat, which is a chatbot. I contacted the LineCheck team and coordinated with one of their team members, and they provided all the details about the integration and other things. If you find their app or plugin in Shopify, you could directly check all the instructions given by the app or plugin and implement them based on the instructions given by the particular platform or service. You could also do it manually using tools like JPR and other integration tools that connect directly to our ERP system if we are using a different ERP system or these kinds of things. So, these are the things that could help us integrate smoothly with our 3rd party ERP system and ensure a smooth process of all services and the ERP system as well.

    What advanced feature of Google Analytics do we find in this report? And so, currently, they have removed GA 3 and Universal Analytics. So it's the new one, GA 4 Google Analytics. So they are most of the time I use the engagement portion of the tool, where I find monetization and other kinds of tools and to check all the demographics. If I talk about the engagement tool, where you find what kind of engagement you are getting from website visits or buying someone buying your product or services or sign up forms or whatever your goal is to generate revenue or services you are providing. It depends on these kinds of things. The most useful tool I am using is the one where there is a text section as well, where you can find tools like demographic and behavior. The people visiting your website, are they mostly male or female? And the location you are targeting, the behavior, like, how much time they are spending on your platform. What is your average time spent of your customer on your website, bounce rate? These kinds of things. I use most of these tools to get a deep type of analysis of our product or services or website where we are getting some wrong if we are not getting enough traffic for conversion. So these kinds of things help us to analyze all these data and give a better create a better strategy before depending on our previous data to target our relevant audience, which will boost our conversion and our revenue as well.

    The integration of a chatbot for customer engagement on a digital platform is highly dependent on the platform being used to create the website. If we're using a platform like WordPress or Shopify, there are plenty of plug-ins available that provide three Android tools as well. One of the plug-ins I know is a new one, there's a new name for it. New plug-ins, like, provide all these tools to your website, WordPress website, and they use all these current, latest AI platforms, whether it's GPT models or cloud models or Gemini models or Meta AI models, these kinds of things. They integrate all these things so you can do that as well, and you can also create your own through ChatGPT or other platforms, or you can use plenty of ChatGPT plug-ins that provide integration to your chatbot, or you can use third-party professionals who have already provided similar services to other businesses as well. You can also check their previous client reviews and other testimonials as well. If I talk about high-end chatbots and different kinds of chatbots, I've used WhatsApp or other social media all-in-one Meta social media chatbot or other AI chatbots, I've used LiveChat and GeoHaptic. And one other tool we use is 3Portal, which provides this kind of thing, and they coordinate with our team and implement this integration with our customers to engage better and more effectively with our customers. Yeah. These chatbots could help us generate more conversions and revenue and overall grow our businesses.