1073118 - F.M.O - "Live Version" Visualizations - Country Breakdown Graph

Status: RESOLVED FIXED

(Mozilla Foundation Communications :: Website, task)

Description

[Mavis Ou [:mavis]]

Visualization design for country breakdown graph.

Note that we should take responsive design and localization limitation into consideration.

Comment 1

[Andrea Wood [:andreawood]]

I added Adam to this bug.

Adam offered the possibility that this visualization could use country data gathered by Google Analytics:

"If we don't have country info from PayPal, we can present the 'donations by country' data from GA as a fall-back plan." - Adam

Q for Adam: How accurate are the country data if we went this route? 

The other option is the PayPal API, but i'm not sure you can grab country data through the API. Needs to be checked out. Mavis you have access to the PayPal sandbox / API right? Is this something you can check?

Comment 2

[Adam Lofting (:adamlofting)]

(In reply to Andrea Wood from comment #1)
> Q for Adam: How accurate are the country data if we went this route? 

An interesting statistical feature of this is it will show the geolocation based on IP address of where the donations are made FROM (where in the world the donor is sitting at that point in time). Whereas the payment detail in PaylPal will show the BILLING ADDRESS of the donors. 

The geolocation data in GA is plenty good enough for this use case.

Comment 3

[Mavis Ou [:mavis]]

If we choose to use PayPal data does that mean all the BSD transactions will be excluded?

> The geolocation data in GA is plenty good enough for this use case.
Ditto.  What do you think, Andrea?

Comment 4

[Andrea Wood [:andreawood]]

yup, let's just use GA for sure. Hopefully that makes your life easier Mavis!

Comment 5

[Mavis Ou [:mavis]]

Hey Andrea and Adam,

Just wanna share my assumption with you in case I'm totally off the track.

So we will
1) add GA to the "thank you for donating" page 
2) use GA API to get the country breakdown info

Adam, do I need to have a API key in order to make the call?  If so, how should I obtain one?

Thanks!

Comment 6

[Andrea Wood [:andreawood]]

Adam has the answer to this (not me) so clearing my needinfo.

Comment 7

[Adam Lofting (:adamlofting)]

(In reply to Mavis Ou [:mavis] from comment #5)
> So we will
> 1) add GA to the "thank you for donating" page 
Correct :)

> 2) use GA API to get the country breakdown info
> 
> Adam, do I need to have a API key in order to make the call?  If so, how
> should I obtain one?

You don't need to write the API stuff from scratch, as we can add this data to an existing tool I have setup here: https://github.com/adamlofting/transformtogeckoboard

This tool is connected to the GA API via this code:
https://github.com/adamlofting/transformtogeckoboard/blob/master/lib/googleanalytics.js

And using code like this...
https://github.com/adamlofting/transformtogeckoboard/blob/master/lib/appmaker.js

...can query GA, and output the numbers we care about as an end point that you can call to get the data into FMO. Like this: http://transformtogeckoboard.herokuapp.com/appmaker/topremixes

Comment 8

[Matt Thompson (@OpenMatt :OpenMatt)]

* [oct31] is now past. Please update whiteboard to [nov14] or future train.

Comment 9

[Mavis Ou [:mavis]]

Adam, could you help verify that the GA code has been added to the thank you page?  I hope somewhere on the GA dashboard has this info. :)

Comment 10

[Mavis Ou [:mavis]]

If nothing shows up on GA yet could you paste the relevant code(if there's any) that needs to be added to the Thank You page?  Thanks!

Comment 11

[Andrea Wood [:andreawood]]

Interesting treatment by Wikipedia:
http://meta.wikimedia.org/wiki/Fundraising#mediaviewer/File:Donationmap.png

We should continue to break down by country on our chart (a more detailed view), but their breakdown by continent definitely simplifies things. Perhaps that could be the default view on our page, and then you can see detailed data by country on click or rollover? Not sure what exactly your design entails. Just sharing! Thought it was cool.

Comment 12

[Adam Lofting (:adamlofting)]

(In reply to Mavis Ou [:mavis] from comment #10)
> If nothing shows up on GA yet could you paste the relevant code(if there's
> any) that needs to be added to the Thank You page?  Thanks!

Aki has done some work on this, but the data isn't in GA yet so I think there's something we need to debug in the tracking script on the thank you page. I've re-opened the original bug for this: https://bugzilla.mozilla.org/show_bug.cgi?id=1013832

Also this is the link to the documentation for tagging donation pages:
https://wiki.mozilla.org/Foundation/Metrics/Landing_Page_Tracking#Donation_Pages_.28sendto.mozilla.org.29

Comment 13

[Adam Lofting (:adamlofting)]

(In reply to Adam Lofting (:adamlofting) from comment #12)
> Aki has done some work on this, but the data isn't in GA yet so I think
> there's something we need to debug in the tracking script on the thank you
> page. I've re-opened the original bug for this:
> https://bugzilla.mozilla.org/show_bug.cgi?id=1013832
> 
> Also this is the link to the documentation for tagging donation pages:
> https://wiki.mozilla.org/Foundation/Metrics/
> Landing_Page_Tracking#Donation_Pages_.28sendto.mozilla.org.29

I filed a more specific bug for this work: 
* Bug 1100306 - Donation amount conversion tracking (GA and Optimizely)

Comment 14

[Adam Lofting (:adamlofting)]

Once the thank you pages are tagged with the GA eCommerce tags, the data for the graph(s) can be accessed:

BY COUNTRY
http://transformtogeckoboard.herokuapp.com/eoy/donationsbycountry

BY CONTINENT
http://transformtogeckoboard.herokuapp.com/eoy/donationsbycontinent

Comment 15

[Matt Thompson (@OpenMatt :OpenMatt)]

* [nov14] is past -- please update to [nov28] train or later

Comment 16

[Mavis Ou [:mavis]]

Adam, 

Just to clarify the data we want to use to feed the graph is "number of donors" by country and not "donation".  Sorry about catching this late :( Could you please adjust the code for us?  I hope GA can tell us this info!  But let me know if we need to place new GA track code in the "thank you" page etc.

Thank you!
Mavis

Comment 17

[Andrea Wood [:andreawood]]

ah. i did not catch this either. i was thinking "donors" would read less "US-Centric" because all the amounts will be in USD and the US will account for 50% of all donations.

If it is hard to switch to # of donors, please continue with total donations. We'll adjust this next year.

Comment 18

[Adam Lofting (:adamlofting)]

No problem at all, I clearly missed that too!

Here are additional end-points:

http://transformtogeckoboard.herokuapp.com/eoy/transactionsbycountry

http://transformtogeckoboard.herokuapp.com/eoy/transactionsbycontinent

Comment 19

[Mavis Ou [:mavis]]

Attachment: GitHub PR - update endpoint url

Comment 20

[Gavin Suntop [:gvn]]

Comment on attachment 8527279 [details] [review]
GitHub PR - update endpoint url

Close, but needs a little tweaking. See GH! :)

Comment 21

[Gavin Suntop [:gvn]]

Merged.

Comment 22

[Mavis Ou [:mavis]]

Up on staging: fundraising2.mofostaging.net/

For any further issues, please file a separate bug.