1104419 - F.M.O - Feedback for Donors by Country Graph

Status: RESOLVED FIXED

(Mozilla Foundation Communications :: Website, task)

Description

[Andrea Wood [:andreawood]]

Donors by country graph:

-- There still doesn't appear to be a way to "reveal" or "see" the "other" category. Right now you can primarily see the top 8 giving countries but you can't search or find data about the rest

-- Breaking the # of donors onto a second line seems like a waste of space, possible to use a slash or parentheses to keep the donor total next to the country name on the same line? That way we could have 16 visible countries instead of just 8 right?

-- The colors representing the top few countries that will always be visible should be very different (e.g. USA and Canada blues are too similar)

-- How can we bring in data from November 1 and add to recent data? We have over $170K now and we need to show what countries donated up to now.

Comment 1

[Mavis Ou [:mavis]]

(In reply to Andrea Wood [:andreawood] from comment #0)
> Donors by country graph:
> 
> -- There still doesn't appear to be a way to "reveal" or "see" the "other"
> category. Right now you can primarily see the top 8 giving countries but you
> can't search or find data about the rest

Gavin is on PTO tomorrow but he has implemented the collapsible list already (Bug 1104226O).  I can add grab the code and place it in our f.m.o.

> -- Breaking the # of donors onto a second line seems like a waste of space,
> possible to use a slash or parentheses to keep the donor total next to the
> country name on the same line? That way we could have 16 visible countries
> instead of just 8 right?

Yes, that can be tweaked. 


> -- The colors representing the top few countries that will always be visible
> should be very different (e.g. USA and Canada blues are too similar)

Can also be tweaked.

> -- How can we bring in data from November 1 and add to recent data? We have
> over $170K now and we need to show what countries donated up to now.

Andrea / Adam,
I know we had some issues about placing GA code to the thank you pages so I assume we missed the chance to capture some donation data?  If we were to show the donation / country breakdown on the chart the total might be a lot lower than what we show on the totalizer(total payment received on PayPal)?  That's my understanding but please correct me if I'm wrong.

Comment 2

[Andrea Wood [:andreawood]]

Hi Mavis your description of why the totalizer won't match the chart data is correct. Is there some hack we can do to get them to match? E.g. we can do a rough breakdown of the donations by country and by source for Nov 1 - 20 and hack it into the chart data somehow?

Comment 3

[Adam Lofting (:adamlofting)]

(In reply to Andrea Wood [:andreawood] from comment #2)
> Hi Mavis your description of why the totalizer won't match the chart data is
> correct. Is there some hack we can do to get them to match? E.g. we can do a
> rough breakdown of the donations by country and by source for Nov 1 - 20 and
> hack it into the chart data somehow?

If we have the numbers somewhere we can hack this into the totals, but I don't think the PayPal records include the country. We'll have some records for the credit card donations in BSD. But this is less than half of the donations.

The most hacky solution, but perhaps all we've got, would be to divide the total number of donations up to the 20th Nov, by the spread of visitor traffic by country to estimate where this came from. 

So if 10% of traffic came from France, we'd allocate them 10% of the total count, for example.

What do you think?

Comment 4

[Mavis Ou [:mavis]]

Updating the dependency here, this isn't a blocker of our v1 launch (graphs are excluded)

Comment 5

[Andrea Wood [:andreawood]]

Adam I think that works OK - esp. since we've been testing exclusively in US-EN there are relatively few other countries represented in the data at this stage.

Comment 6

[Adam Lofting (:adamlofting)]

Great. I'll take this as a task.

Comment 7

[Gavin Suntop [:gvn]]

(In reply to Andrea Wood [:andreawood] from comment #0)

> -- Breaking the # of donors onto a second line seems like a waste of space,
> possible to use a slash or parentheses to keep the donor total next to the
> country name on the same line? That way we could have 16 visible countries
> instead of just 8 right?

16 looks pretty bad. See: https://www.dropbox.com/s/zo3xttxrb188ruq/Screenshot%202014-11-26%2010.22.06.png?dl=0

8 felt good to me in terms of information density. Also, with the patch to show/hide additional non top donors you'll be able to access all the additional information.

Putting the number on a new line not only looks cleaner (IMO) but it's also better in a responsive context. It allows more room for the country names when the viewport gets smaller.

Recommend leaving this as is.
 
> -- The colors representing the top few countries that will always be visible
> should be very different (e.g. USA and Canada blues are too similar)

I agree with this point. I'll see how I can mix it up to make adjacent slices more distinct.


Andrea, can you let me know if this approach is acceptable?

Comment 8

[Andrea Wood [:andreawood]]

If you want to leave it at the top 8, that's fine, but the goal with this chart is to surface countries that aren't necessarily in the top 8 (the top 8 will basically always be the same 8 - US, CA, GB, DE, FR, IN, etc). How will I find how much Thailand has donated if I am Thai?

Comment 9

[Gavin Suntop [:gvn]]

That goal will be accomplished by the show/hide additional donors functionality implemented here:

https://bugzilla.mozilla.org/show_bug.cgi?id=1104226

Comment 10

[Gavin Suntop [:gvn]]

Attachment: https://github.com/gvn/eoy-charts/pull/3

Comment 11

[Gavin Suntop [:gvn]]

PR 3 is to mix up the color order.

Comment 12

[Gavin Suntop [:gvn]]

First 3 feedback items are resolved and committed.

Andrea, the fourth item is a backend/API fix. Either we can re-assign this ticket (assuming to Adam) or file a new ticket for it so we can resolve this one. Your call! :)

Comment 13

[Andrea Wood [:andreawood]]

Hi Gavin, let's file a new ticket (i'm not exactly sure which item is left, so probably a sign to give it it's own bug :)

Comment 14

[Gavin Suntop [:gvn]]

> -- How can we bring in data from November 1 and add to recent data? We have
> over $170K now and we need to show what countries donated up to now.

That's the remaining item.

Comment 15

[Adam Lofting (:adamlofting)]

(In reply to Gavin Suntop [:gvn] from comment #14)
> > -- How can we bring in data from November 1 and add to recent data? We have
> > over $170K now and we need to show what countries donated up to now.
> 
> That's the remaining item.

Solved here: https://bugzilla.mozilla.org/show_bug.cgi?id=1105536

I think this can be closed, but please re-open if I missed anything.