Scribd Logo
Upload

Welcome to Scribd!

  • 36 views

    4 B2 Students - Measuring ROI - II

    Uploaded by

    Minul Hasan
    The document contains tables and data showing weekly traffic and average traffic from Google and Bing searches over a 12 week period for a company's branded keyword searches. It also includes data on the company's cost per click, conversion rates, margins from conversions, and calculations of spend and revenue from ads. The normalized reduction in traffic attributed to ads from weeks 1-9 to weeks 10-12 was 1.62%. No spend occurred on ads for weeks 10-12, so there was $0 revenue and profit from ads.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    4 B2 Students - Measuring ROI - II

    Uploaded by

    Minul Hasan
    36 views3 pages
    The document contains tables and data showing weekly traffic and average traffic from Google and Bing searches over a 12 week period for a company's branded keyword searches. It also includes data on the company's cost per click, conversion rates, margins from conversions, and calculations of spend and revenue from ads. The normalized reduction in traffic attributed to ads from weeks 1-9 to weeks 10-12 was 1.62%. No spend occurred on ads for weeks 10-12, so there was $0 revenue and profit from ads.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains tables and data showing weekly traffic and average traffic from Google and Bing searches over a 12 week period for a company's branded keyword searches. It also includes data on the company's cost per click, conversion rates, margins from conversions, and calculations of spend and revenue from ads. The normalized reduction in traffic attributed to ads from weeks 1-9 to weeks 10-12 was 1.62%. No spend occurred on ads for weeks 10-12, so there was $0 revenue and profit from ads.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    36 views3 pages

    4 B2 Students - Measuring ROI - II

    Uploaded by

    Minul Hasan
    The document contains tables and data showing weekly traffic and average traffic from Google and Bing searches over a 12 week period for a company's branded keyword searches. It also includes data on the company's cost per click, conversion rates, margins from conversions, and calculations of spend and revenue from ads. The normalized reduction in traffic attributed to ads from weeks 1-9 to weeks 10-12 was 1.62%. No spend occurred on ads for weeks 10-12, so there was $0 revenue and profit from ads.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 3

    Table 1: Weekly traffic from Google by origin of click for branded keyword searches only

    Week 1 2 3 4
    Sponsored 32,269 31,951 32,143 31,417
    Organic 127,876 128,169 125,717 126,264
    Total 160,145 160,120 157,860 157,681

    Table 2: Weekly traffic from Bing by origin of click for branded keyword searches only
    Week 1 2 3 4
    Sponsored 3,965 3,984 3,960 3,952
    Organic 15,805 15,964 15,815 15,810
    Total 19,770 19,948 19,775 19,762

    Average weekly traffic


    1-9 Weeks 10-12 Weeks
    Google 156,585 148,477 -5.18%
    Bing 19,597 18,901 -3.55%

    Noramlized Reduction in Traffic (% of traffic attributable to ads) -1.62%


    Weekly Average Traffic Attributed to Ads

    Cost per click $0.60


    Conversion rate after arriving on website 12.00%
    Average margin per conversion $21
    Margin from a customer arrival on the website $2.52

    Weekly average traffic through Google Ads


    Effective number that switched from sponsored to organic

    Spend on Ads
    "Revenue" from actual/attributed traffic due to ads
    Profit of Ads
    ROI of ad spend
    5 6 7 8 9 10 11
    31,194 31,576 30,951 30,611 30,401 0 0
    123,871 124,053 126,105 123,064 121,637 150,188 148,658
    155,065 155,629 157,056 153,675 152,038 150,188 148,658

    5 6 7 8 9 10 11
    3,874 3,932 3,890 3,883 3,843 3,815 3,754
    15,633 15,797 15,462 15,309 15,499 15,185 15,159
    19,507 19,729 19,352 19,192 19,342 19,000 18,913

    7-9 Weeks 10-12 Weeks


    148,477
    18,901

    0.00%
    0

    $0.60
    12.00%
    $21
    $2.52

    0
    0

    $0
    0
    0
    #DIV/0!
    12
    0
    146,584
    146,584

    12
    3,754
    15,036
    18,790

    You might also like