Advisor signup (Portland)

TLYCS ran a campaign in a single city involving 'donation advice'

See also

We recoded and augmented this analysis within the EAMT Analysis web-book here. More work could be done, if warranted.

In December 2021, TLYCS ran a YouTube advertising campaign in Portland Oregon, involving ‘donation advice’. The top 10% household-income households were targeted with (one of) three categories of videos. One of the ultimate goals was to get households to sign up for a 'concierge' personal donor advising service

Quick takeaways

  • There were very few signups for the concierge advising service. (About 16 in December 2021 , only 1 from Portland.)

  • We consider a 'difference in difference', to compare the year-on-year changes in visits to TLYCS during this period for Portland vs other comparison cities.

  • This comparison yields a 'middle estimate cost' of $37.7 per additional visitor to the site. This seems relatively expensive. We could look into this further to build a more careful model and consider statistical bounds, if such work was warranted.

General idea and main questions

Specific goal of TLYCS promotion: To get people to click on the ad and go to the 'landing page' of TLYCS. Here, they will fill out a form to request an appointment with a donation advisor. We will simultaneously be raising awareness for TLYCS.

General questions:

  1. Can we get people to sign up for donation advice using videos in YouTube Ads?

    • How many sign-up and what sorts of people?

  2. Do these ads boost engagement with TLYCS in net? (E.g. donations, website activity, book downloads)

    • "Lift test" on Portland market (analyze with difference-in-difference relative to other markets)

  3. Which ads are best at this? (These ads differ in substance as well as in style)

Background and context

Participant universe and sample size

Location: Portland, OR

Audience: Top 10% of household income

People living in Portland, Oregon in the top 10% of household income (approximated by Google) will get an in-stream ad (ad plays before video user intended to watch)

Key treatment(s)

Exposure to a sequence of nine versions of YouTube ad videos. Frequency cap: 6/weeks

Three main 'theme/header' variations (similar, slightly different phrasings)

these variations were crossed with...

Three categories of videos within each theme:

  1. "Bravery": Charlie Bresler explains how 'you can save lives without being brave' with small amounts of money for bednets, nutrient micro-doses, etc.

  2. $10: Man giving out money to poverty-stricken people in Capetown. Text narrative overlaid describes that $5 can buy a slice of pizza, or an interocular lens to treat cataracts, etc. Leans towards 'identified victims/recipients'.

  3. "I want to do good": Colorful puppets sing about giving and donating to save lives. Counters common arguments about 'breeding dependency', fear of administrative waste, etc.

These are organized and linked here.

Note/limitation: Unfortunately, we were not able to track 'which video got more clicks'.

Each video comes with a site-link extension with a Call to Action:

Treatment assignment procedure

We assigned the particular video treatments to audiences using a YouTube/Google optimization algorithm. This chose videos to maximize the probability that a user chose 'Speak to an Advisor' and filled out the linked form.

Outcome data

  • How long people watched the videos for

  • Whether they 'clicked through'

  • Whether they filled out the form for advising (Algorithm is serving to optimize this)

Results (simple analysis)

Note: we present some more in-depth analyses and graphs in the Quarto HERE, along with a code and data pipeline

Cost per user (first-pass)

A first pass and upper bound on impact and (lower bound on) cost/session

Assumptions/data interpretations

  1. The numbers used in our data come from meaningful sessions from unique users

  2. The 'date range' is the relevant one for being affected by the advertisements of interest

  3. The 'comparison cities' are approximately randomly selected

Most optimistic (unrealistic) bound

Guiding assumption: a counterfactual 0 visits from Portland in this season

  • 306 Portland Users (389 Portland site visits) in relevant 2021 period.

  • If these were all driven by the advertisement (and counterfactual was 0 visits), this is +306 Users and +389 visits

  • Cost $4k

  • -->Lower bound on cost of $13.07 per user ($10.28 per visit)

Year-on-Year (maybe reasonable) optimistic bound

Guiding assumption: a counterfactual 'sam as last year' in Portland

  • 306 Portland Users (389 Portland site visits) in relevant 2021 period.

  • 144 Portland Users (189 Portland site visits) in relevant 2020 period.

  • --> 306 - 144 =162 users uptick,

    • (389 - 189 = 200 visits uptick)

  • --> $4k/162 = $24.69 Lower bound on cost per user

    • ($4k/200 = $20 per visit)

Difference in Differences comparison to other cities

Guiding assumptions:

  • The cities used are fairly representative

  • 'Uptick as a percentage' is unrelated to city size/visits last year

  • All the cities in the comparison group are 'informative to the counterfactual' in proportion to their total number of sessions

This yields

  • 112.5% visits uptick (Year on Year) for Portland in 2020

For all North American cities other than Portland (with greater than 250 000 people):

The average is 46.5 users in the 2020 period and 64.5 users in the 2021 period, an uptick of about 38.8%. This is very similar to the result if we look at all cities which has an uptick of 43.1%.

  • 38.8% uptick multiplied by 144 users = 55.9 (‘counterfactual uptick’ in users for Portland)

  • 162 - 55.9 = 106 (uptick relative to counterfactual)

  • USD 4000 /106 = 37.7 USD cost per additional user through this ad

Note this is a midpoint estimate, we have not yet given statistical bounds.

In the graph below (pasted from the Quarto here), we show these year-on-year upticks in context.

Other outcomes

There were very few signups for the concierge advising service. Only about 16 in December 2021 globally, only 1 of which was from Portland.

Notes

Other detailed notes are in our private Gitbook. More formal and detailed analysis could be done if it seems merited.

Last updated