IT 247

E-Commerce and Internet Marketing

TU BIM · Semester 7 · BIM curriculum effective from 2021

Requirement
required
Credits
3
Practice sets
5 sets

Practice sets and model questions

5 complete syllabus-aligned practice examinations with model-style questions and step-by-step solutions. Independently prepared by Paper Khoj, not issued by TU.

practice sets loaded.

Practice Set 1

Report problem

PAPER KHOJ

Practice Examination — Set 1

For BIM · Semester 7

Based on the prescribed TU Faculty of Management syllabus and examination structure

Independently prepared by Paper Khoj. This is not an official Tribhuvan University or Dean's Office question paper.

Course: IT 247 · E-Commerce and Internet Marketing

Level: Bachelor of Information Management (BIM) · Semester 7

Full Marks: 60

Time: 3 hrs.

Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks.

Group 'A'

Brief Answer Questions. Attempt all questions.

[5 × 2 = 10]
  1. [2]

    Define Headless Commerce and state its primary technological advantage.

    View model answerHide model answer

    Headless Commerce:

    An e-commerce architectural design where the frontend user interface (the “head” - built with modern frameworks like Vue/Nuxt or React/Next) is completely decoupled from the backend commerce logic and database engine (inventory, checkout, payments), communicating exclusively via REST or GraphQL APIs.

    • Primary Advantage: Total frontend UX design flexibility and ultra-fast page load performance across web, mobile apps, and smart devices without backend constraints.
  2. [2]

    State Google’s three Core Web Vitals metrics and what each measures.

    View model answerHide model answer

    Google Core Web Vitals:

    1. Largest Contentful Paint (LCP): Measures perceived page loading speed (time taken for the largest main content block to render, target: <2.5< 2.5 seconds).
    2. Interaction to Next Paint (INP): Measures user interactivity and responsiveness to user inputs like clicks and taps (target: <200< 200 milliseconds).
    3. Cumulative Layout Shift (CLS): Measures visual stability by quantifying unexpected layout shifts during page loading (target: <0.1< 0.1).
  3. [2]

    Write the formula for Return on Ad Spend (ROAS) and Customer Acquisition Cost (CAC).

    View model answerHide model answer

    Digital Marketing Formulas:

    • Return on Ad Spend (ROAS):
      ROAS=Total Revenue Generated from Ad CampaignTotal Advertising Spend\text{ROAS} = \frac{\text{Total Revenue Generated from Ad Campaign}}{\text{Total Advertising Spend}}
    • Customer Acquisition Cost (CAC):
      CAC=Total Marketing & Sales Expenses (Ads + Wages + Software)Total Number of New Customers Acquired\text{CAC} = \frac{\text{Total Marketing \& Sales Expenses (Ads + Wages + Software)}}{\text{Total Number of New Customers Acquired}}
  4. [2]

    What is Google Ad Rank and how is it determined in pay-per-click (PPC) auctions?

    View model answerHide model answer

    Google Ad Rank:

    The score used to determine where search ads are positioned on Google search results pages (or if they show at all).

    Formula:

    Ad Rank=f(Maximum CPC Bid,Quality Score,Ad Assets/Extensions Impact)\text{Ad Rank} = f(\text{Maximum CPC Bid}, \text{Quality Score}, \text{Ad Assets/Extensions Impact})
    Where Quality Score (scale 1 to 10) is evaluated based on Expected Click-Through Rate (CTR), Ad Relevance to keyword, and Landing Page Experience.

  5. [2]

    Differentiate between Universal Analytics (UA) and Google Analytics 4 (GA4) data models.

    View model answerHide model answer

    Universal Analytics vs. GA4:

    • Universal Analytics (Legacy): Session-based data model organizing hits into pageviews, e-commerce transactions, and user session durations within a 30-minute window.
    • Google Analytics 4 (Modern): Event-based data model where every interaction (page view, scroll, button click, video play, purchase) is recorded as a discrete event with flexible custom parameters.

Group 'B'

Short Answer Questions. Attempt any six questions.

[6 × 5 = 30]
  1. [5]

    A digital merchant spends NPR 100,000 on a Google Search Ads campaign. The ad receives 50,000 impressions and 2,500 clicks. From these clicks, 100 users make a purchase, generating total revenue of NPR 500,000. Calculate: (a) Click-Through Rate (CTR), (b) Cost Per Click (CPC), (c) Conversion Rate, (d) Cost Per Acquisition (CPA), and (e) Return on Ad Spend (ROAS).

    View model answerHide model answer

    Digital Marketing Metrics Calculations:

    (a) Click-Through Rate (CTR):

    CTR=ClicksImpressions×100%=2,50050,000×100%=5.0%\text{CTR} = \frac{\text{Clicks}}{\text{Impressions}} \times 100\% = \frac{2,500}{50,000} \times 100\% = \mathbf{5.0\%}

    (b) Cost Per Click (CPC):

    CPC=Total Ad SpendTotal Clicks=NPR 100,0002,500=NPR 40.00\text{CPC} = \frac{\text{Total Ad Spend}}{\text{Total Clicks}} = \frac{\text{NPR } 100,000}{2,500} = \mathbf{\text{NPR } 40.00}

    (c) Conversion Rate:

    Conversion Rate=ConversionsTotal Clicks×100%=1002,500×100%=4.0%\text{Conversion Rate} = \frac{\text{Conversions}}{\text{Total Clicks}} \times 100\% = \frac{100}{2,500} \times 100\% = \mathbf{4.0\%}

    (d) Cost Per Acquisition (CPA):

    CPA=Total Ad SpendConversions=NPR 100,000100=NPR 1,000.00\text{CPA} = \frac{\text{Total Ad Spend}}{\text{Conversions}} = \frac{\text{NPR } 100,000}{100} = \mathbf{\text{NPR } 1,000.00}

    (e) Return on Ad Spend (ROAS):

    ROAS=Revenue GeneratedTotal Ad Spend=NPR 500,000NPR 100,000=5.0 (or 500%)\text{ROAS} = \frac{\text{Revenue Generated}}{\text{Total Ad Spend}} = \frac{\text{NPR } 500,000}{\text{NPR } 100,000} = \mathbf{5.0 \text{ (or 500\%)}}
    (Every NPR 1.00 spent on ads generated NPR 5.00 in gross revenue).

  2. [5]

    Explain the On-Page SEO optimization checklist for an e-commerce product page. How do title tags, structured schema markup, and image alt text influence organic search ranking?

    View model answerHide model answer

    On-Page SEO Checklist for E-Commerce:

    1. Title Tag & Meta Description:
      • Place primary commercial keywords at the beginning (e.g. Buy Dell XPS 13 Laptop in Nepal | Best Price at XYZ). Keep title under 60 characters and description under 155 characters with clear Call-to-Action.
    2. Product Schema Structured Data (JSON-LD):
      • Embed Schema.org Product markup detailing name, image, offers (price, priceCurrency: NPR, availability: InStock), and aggregateRating. This triggers Google Rich Snippets with star ratings in SERPs.
    3. Descriptive Image Alt Text & WebP Compression:
      • Provide keyword-rich alt tags (alt="Dell XPS 13 inch silver laptop keyboard") for screen readers and Google Image Search, compressing images to modern WebP format.
    4. Header Hierarchy & Content Depth:
      • Single <h1> for product title; <h2> and <h3> for technical specs, user reviews, and FAQs. Provide unique written product descriptions to prevent duplicate content penalties.
  3. [5]

    Discuss the customer journey through the Inbound Marketing Funnel: TOFU (Top of Funnel), MOFU (Middle of Funnel), and BOFU (Bottom of Funnel). Suggest appropriate digital content formats for each stage.

    View model answerHide model answer

    The Inbound Marketing Funnel:

    1. TOFU - Awareness Stage (Top of Funnel):

      • Customer Mindset: Experiencing symptoms of a problem; conducting broad educational research.
      • Content Formats: Educational blog articles, infographics, short explainer videos (TikTok/Reels), podcast interviews, and social media carousels.
    2. MOFU - Consideration Stage (Middle of Funnel):

      • Customer Mindset: Clearly defined their problem; actively evaluating different solution methods.
      • Content Formats: Comprehensive downloadable whitepapers, comparison guides, webinars, case study breakdowns, and ROI calculators.
    3. BOFU - Decision Stage (Bottom of Funnel):

      • Customer Mindset: Selected their solution category; deciding on the specific vendor or brand to purchase from.
      • Content Formats: Live product demonstrations, free trials, client testimonial videos, discount promo codes, and detailed customer reviews.
  4. [5]

    Explain the architectural flow of an online payment gateway integration in Nepal (e.g. Fonepay, eSewa, Khalti). How do server-to-server webhook verification and HMAC digital signatures ensure transactional integrity?

    View model answerHide model answer

    Payment Gateway Architectural Workflow:

    1. Checkout Initiation: Customer clicks “Pay with eSewa/Fonepay”; e-commerce server generates a unique Order ID and payment payload.
    2. Payload Cryptographic Signing (HMAC): The merchant server hashes parameters (Amount, Transaction ID, Merchant Code) using a private secret key via HMAC-SHA256, sending the signed payload to the payment gateway.
    3. User Authentication & Payment: User logs into the payment wallet portal, verifies transaction via OTP, and authorizes payment.
    4. Browser Redirect & Server-to-Server Webhook:
      • Browser redirects back to the merchant’s success URL.
      • Concurrently, the gateway server issues an asynchronous HTTP POST webhook callback directly to the merchant backend server.
    5. Webhook Integrity Verification:
      • The merchant server recalculates the HMAC signature of the incoming webhook payload using its secret key.
      • If signatures match and transaction status is confirmed with the gateway’s verification endpoint, the order is marked “Paid” in the database, preventing client-side browser spoofing.
  5. [5]

    Compare Search Engine Optimization (SEO) with Pay-Per-Click (PPC) Advertising. Under what circumstances should an e-commerce startup prioritize PPC over SEO?

    View model answerHide model answer

    SEO vs. PPC Comparison:

    Feature Search Engine Optimization (SEO) Pay-Per-Click (PPC) Advertising
    Cost Structure Organic; zero cost per click; requires continuous labor/content investment. Direct fee paid per click to ad network (Google/Meta).
    Speed of Results Long-term; takes 3 to 9 months to establish domain authority. Immediate; ads can display on top of SERPs within minutes.
    Traffic Longevity Sustainable; retains search visibility even if active work pauses. Ceases instantly the moment the advertising budget is depleted.
    Targeting Relies on keyword rankings and search intent matching. Granular audience targeting (demographics, device, retargeting).

    When an E-Commerce Startup Should Prioritize PPC:

    1. New Product Launch / Limited Seasonal Windows: Promoting short-term Dashain/Tihar festival offers where waiting months for organic SEO ranking is impractical.
    2. Immediate Cash Flow & Market Validation: Testing conversion rates on new product landing pages with immediate paid traffic before investing months in organic SEO content.
  6. [5]

    Discuss the legal and regulatory framework governing e-commerce in Nepal, including the Electronic Transactions Act 2063 and consumer protection provisions for digital sales.

    View model answerHide model answer

    E-Commerce Legal Framework in Nepal:

    1. Electronic Transactions Act (ETA) 2063:
      • Grants formal legal recognition to electronic records, digital signatures, and electronic communications equivalent to physical paper documents.
      • Criminalizes cyber crimes including unauthorized computer hacking, data theft, digital forgery, and financial cyber fraud.
    2. Consumer Protection Act 2075 Provisions:
      • Mandates that e-commerce merchants provide accurate product specifications, pricing, tax breakdowns, and manufacturing origins.
      • Prohibits deceptive advertising and guarantees consumers the legal right to return defective goods for a full refund.
    3. E-Commerce Bill & Online Business Registration:
      • Mandates that all commercial websites, social media sellers, and mobile marketplaces must formally register with the Department of Commerce, Supplies, and Consumer Protection, displaying PAN/VAT numbers prominently on their platforms.

Group 'C'

Comprehensive Answer Questions. Attempt all questions.

[2 × 10 = 20]
  1. [10]

    An e-commerce fashion brand in Kathmandu has an average customer order value of NPR 3,000 with a gross margin of 40%. The customer repeats purchases 3 times a year and stays active for an average of 3 years. Marketing spends NPR 1,200 to acquire each new customer.

    (a) Calculate Customer Lifetime Value (CLV). (b) Calculate the CLV-to-CAC Ratio. (c) Evaluate whether this marketing model is economically viable (industry benchmark is CLV:CAC≥3:1CLV:CAC \ge 3:1). (d) Propose three strategic digital initiatives to increase CLV and two initiatives to reduce CAC.

    View model answerHide model answer

    (a) Customer Lifetime Value (CLV) Calculation:

    Given:

    • Average Order Value (AOVAOV) = NPR 3,000
    • Purchase Frequency (ff) = 3 orders per year
    • Customer Lifespan (tt) = 3 years
    • Gross Margin (GMGM) = 40%=0.4040\% = 0.40
    • Customer Acquisition Cost (CACCAC) = NPR 1,200

    Total lifetime orders = 3×3=93 \times 3 = 9 orders. Total lifetime revenue = 9×3,000=NPR 27,0009 \times 3,000 = \text{NPR } 27,000.

    CLV=Total Lifetime Revenue×Gross Margin=27,000×0.40=NPR 10,800\text{CLV} = \text{Total Lifetime Revenue} \times \text{Gross Margin} = 27,000 \times 0.40 = \mathbf{\text{NPR } 10,800}

    (Alternatively: Annual Profit=3,000×3×0.40=3,600  ⟹  CLV=3,600×3=NPR 10,800\text{Annual Profit} = 3,000 \times 3 \times 0.40 = 3,600 \implies \text{CLV} = 3,600 \times 3 = \text{NPR } 10,800).


    (b) CLV-to-CAC Ratio:

    Ratio=CLVCAC=NPR 10,800NPR 1,200=9.0:1\text{Ratio} = \frac{\text{CLV}}{\text{CAC}} = \frac{\text{NPR } 10,800}{\text{NPR } 1,200} = \mathbf{9.0 : 1}

    (c) Viability Evaluation:

    • Analysis: The calculated ratio of 9:1 vastly exceeds the healthy industry benchmark of 3:1.
    • Conclusion: The business model is exceptionally profitable and viable. In fact, a 9:1 ratio suggests that the company is substantially under-investing in customer acquisition and could aggressively increase its marketing budget to capture a larger market share without risking insolvency.

    (d) Strategic Growth Initiatives:

    Three Initiatives to Increase CLV:

    1. Tiered Loyalty Rewards Program: Offer points redeemable on future purchases to incentivize a 4th annual repeat order.
    2. AI-Powered Cross-Selling: Implement recommendation algorithms at checkout (“Complete the Look” with matching shoes/belts) to elevate Average Order Value from NPR 3,000 to NPR 3,600.
    3. Personalized Automated Email Re-engagement: Trigger automated post-purchase care sequences and seasonal replenishment alerts based on purchase intervals.

    Two Initiatives to Reduce CAC:

    1. Customer Referral Loop: Offer NPR 300 store credit to existing customers who refer friends who place their first order, lowering paid ad dependency.
    2. Organic SEO & Micro-Influencer Content: Build organic style guides and partner with niche local fashion creators for commission-based affiliate sales instead of expensive broad Meta ad campaigns.
  2. [10]

    Design an end-to-end Digital Marketing and Web Analytics Strategy for an online educational platform launching in Nepal. (a) Define buyer personas for students and corporate professionals, (b) Design the omni-channel acquisition strategy across SEO, Meta Ads, and Email marketing, (c) Design the GA4 tracking measurement framework (defining key custom events and conversion parameters), and (d) Map the multi-touch attribution model to evaluate ad effectiveness.

    View model answerHide model answer

    (a) Buyer Personas:

    1. Persona 1: ‘Career-Starter Bipul’ (University Student / Recent Graduate):
      • Demographics: Age 20–24, studying IT/Management in Kathmandu or Pokhara.
      • Pain Points: University curriculum is theoretical; lacks practical coding/analytical skills needed to pass technical job interviews.
      • Motivations: Affordable pricing, recognized certificates, internship placement assistance.
    2. Persona 2: ‘Upskilling Anita’ (Mid-level Corporate Professional):
      • Demographics: Age 28–38, working in banking or telecom.
      • Pain Points: Limited time; needs executive data analytics / cloud computing certifications to qualify for managerial promotions.
      • Motivations: Weekend/evening live classes, real-world case studies, executive peer networking.

    (b) Omni-Channel Acquisition Engine:

    • Search Engine Optimization (SEO): Create comprehensive syllabus guides, past question paper solutions, and tech career roadmaps targeting keywords like "best python data analytics course in nepal" and "tu bitm study materials".
    • Paid Meta & LinkedIn Campaigns: Target Bipul on Instagram with engaging video reels showcasing student project demos; target Anita on LinkedIn with career advancement whitepapers and alumni salary outcome infographics.
    • Automated Email Marketing Sequences: Deploy a 5-part automated email nurturing sequence offering a free introductory masterclass recording, syllabus PDF, and time-limited early-bird tuition discounts.

    (c) GA4 Measurement Framework (Custom Events):

    Event Name Trigger Condition Event Parameters Recorded Conversion Goal?
    syllabus_download User downloads course brochure PDF. course_name, user_category Micro-conversion
    demo_video_watch User watches >50%> 50\% of course preview video. video_title, duration_percent Engagement
    checkout_start User clicks ‘Enroll Now’ and selects payment option. course_id, price_npr, payment_method Milestone
    purchase_complete Successful payment verification via eSewa/Khalti. transaction_id, value, currency: NPR Primary Macro

    (d) Multi-Touch Attribution Modeling:

    • Limitation of Last-Click Attribution: Over-credits the final retargeting ad or direct brand search, completely ignoring the early educational blog post (SEO) or video ad that originally introduced the user to the platform.
    • Recommended Data-Driven Attribution: Utilizes machine learning to evaluate touchpoints across the entire multi-session user path: Organic Blog Read →\rightarrow Instagram Retargeting Ad Click →\rightarrow Email Course Demo →\rightarrow Direct Purchase. Distributes revenue credit proportionally to reflect each channel’s true contribution to conversion, preventing premature budget cuts to top-of-funnel channels.