Native Advertising & Sponsored Content: Widget CPC, Engaged Visits, Scroll Depth, Publisher Packages & Disclosure Rules
Judge sponsored traffic by what readers do, not by what a click costs. You will turn views, clicks and spend of recommendation-widget headlines into CTR, CPC and cost per 1,000 views, measure the gap between clicks and landing sessions, define an engaged visit and compare CPC with cost per engaged visit, follow readers down the page with scroll-depth curves, roll placements up by publisher, device and position, price flat-fee sponsored articles with guarantees and make-good credits, compare publisher rate cards, connect engaged visits to orders and ROAS, read conversion lag and attribution windows, spot headlines that win clicks they cannot keep, plan bids, budgets and delivery, claim credits for invalid traffic, test headlines for significance, track creative fatigue, audit disclosure labels, compare sponsored reading with an editorial benchmark, build a what-if grid and finish with a six-month dashboard, all in 20 hands-on labs with fictional Wickerby Kitchen Supply data, every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course teaches the arithmetic of native advertising and sponsored content in 20 interactive spreadsheet labs. You work for Wickerby Kitchen Supply, a fictional online shop for cookware and kitchen tools, and build every table yourself: CTR, CPC and cost per 1,000 views of recommendation-widget headlines, the gap between clicks and landing sessions, engaged-time thresholds and the cost per engaged visit, scroll-depth curves, publisher, device and position splits, flat-fee sponsored articles with guarantees and make-good credits, rate-card comparisons, orders, ROAS and conversion lag. The second half covers click-bait detection, bids and delivery, invalid-traffic credits, headline significance tests, creative fatigue, a disclosure-label audit, reading time against an editorial benchmark, a what-if budget grid and a final dashboard. Each task is checked the moment you type the formula. All companies, people, campaigns and numbers are fictional and benchmarks are illustrative.
Lessons
- Widget Campaign Scorecard: Views, CTR, CPC and Cost per 1,000 Views for Sponsored HeadlinesFree
- Click-to-Visit Gap: Reported Clicks vs Landing Sessions, Click Loss and Cost per Landed Visit Locked
- Engaged Time: Defining an Engaged Visit, Quick Exits, Engaged Rate and Average Engaged Seconds Locked
- Cost per Engaged Visit: CPC vs CPEV, Engaged Rate, Two Rankings and the Real Winner Locked
- Scroll Depth: Reach Curve, Share of Landed Visits, Step Retention and the Median Depth Locked
- Publisher Quality: Placement CPEV, SUMIFS by Site, Target Checks and Concentration Locked
- Device and Position Split: Engaged Visits, CPEV by Device and Click-Weighted Engaged Rates Locked
- Sponsored Article Packages: Delivery vs Guarantee, Make-Good Credit and CPEV on the Net Fee Locked
- Package Rate Cards: XLOOKUP Tiers, Add-On Fees, Estimated Engaged Visits and Quotes within the Target Locked
- From Engaged Visit to Order: Order Rate, Cost per Order, ROAS and Contribution after Ad Cost Locked
- Conversion Lag: Click-to-Order Days, Attribution Windows, Maturity Curve and a Projected Cost per Order Locked
- The Click-Bait Trap: CTR vs Engaged Rate, Medians, a Combined Rule and Heat Flags Locked
- Bids, Budgets and Delivery: Budget Limit vs Inventory Limit, Expected Clicks and Spend Locked
- Invalid-Traffic Checks: Suspect Share, Claimable Clicks, Credit Requests and Flags Locked
- Headline Fatigue: Daily Click Rate, Index vs Launch Level, SLOPE and FORECAST.LINEAR Locked
- Headline Tests: Pooled CTR, Standard Error, z Value, p-Value and a Verdict Locked
- Disclosure Audit: Label Wording Points, Checklist Score, Pass/Fix/Hold Status and Flags Locked
- Sponsored vs Editorial Reading: Expected Read Time, Attention Ratio, Index vs Benchmark and CORREL Locked
- Budget Scenarios: A What-If Grid of Budget and CPEV, Engaged Visits, Budget Needed and a Heat Map Locked
- Final Project: A Native Advertising Dashboard with CPC, Engaged Rate, CPEV, ROAS and a Combo Chart Locked
Learner reviews
Be the first to review this course.