1073119 - F.M.O - "Live Version" Visualizations - # of Donors by Source Graph

Status: RESOLVED FIXED

(Mozilla Foundation Communications :: Website, task)

Description

[Mavis Ou [:mavis]]

Visualization design for # of donors by source.

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

Comment 1

[Mavis Ou [:mavis]]

Some notes from Andrea and Adam:

[ Andrea ] =====
Total number of donors by source. Adam is tracking conversion by adding a Google Analytics code to the “thank you” confirmation page donors see after donation. We’ll have a GA tracking code for every source (twitter, Facebook, homepage, snippet; etc etc). The same sources could be used by studiomofo to build the chart showing “donors by source”. E.g. could we count the number of times a confirmation page is shown by source using the GA tracking codes and pull the totals into the FMO chart showing totals by source category?

[ Adam ] =====
The GA tracking code will include donation amounts (using the ecommerce tracking functionality). Don't worry about writing any new code to connect to the GA API. I've solved this for an existing dashboard so it's relatively simple now to expose a new custom report as a public JSON file you can consume in FMO (https://github.com/adamlofting/transformtogeckoboard). E.g. Total Donations by Source between October and January.

Comment 2

[Matt Thompson (@OpenMatt :OpenMatt)]

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

Comment 3

[Gavin Suntop [:gvn]]

Hey, Adam. Is your transformtogeckoboard service running somewhere that I can query it?

Comment 4

[Mavis Ou [:mavis]]

(In reply to Gavin Suntop [:gvn] from comment #3)
> Hey, Adam. Is your transformtogeckoboard service running somewhere that I
> can query it?

From your other post, Adam, I'm assuming http://transformtogeckoboard.herokuapp.com/eoy/donationsbysource  ?

Comment 5

[Adam Lofting (:adamlofting)]

(In reply to Mavis Ou [:mavis] from comment #4)
> (In reply to Gavin Suntop [:gvn] from comment #3)
> > Hey, Adam. Is your transformtogeckoboard service running somewhere that I
> > can query it?
> 
> From your other post, Adam, I'm assuming
> http://transformtogeckoboard.herokuapp.com/eoy/donationsbysource  ?

Yes, that's right. Sorry I added it in the bug for data part of this task (Bug 1073126) but didn't add it here.

Comment 6

[Gavin Suntop [:gvn]]

No worries. One more question, is this a complete list or is it paginated somehow? I'm seeing a lot of sources starting with numbers, A, or B, so wondering if there's more?

Comment 7

[Adam Lofting (:adamlofting)]

(In reply to Gavin Suntop [:gvn] from comment #6)
> No worries. One more question, is this a complete list or is it paginated
> somehow? I'm seeing a lot of sources starting with numbers, A, or B, so
> wondering if there's more?

It's the top 50 results in DESC order by total donation value. Once there is real donation data in there we'll probably only want to graph the top 20 or so depending on what looks good in the graph. 

If you need more results at that time though I can expand the query.

Comment 8

[Gavin Suntop [:gvn]]

Gotcha. I'm guessing 50 will be more than enough! :)

Comment 9

[Gavin Suntop [:gvn]]

Hi Adam,

I'm still seeing $2 from the UK and that's it. I've been able to continue development by faking the data, but was wondering when we can expect real amounts. We're hoping to launch Monday.

Also, locally I've disabled CORS to pull the data while I'm developing, but you'll need to allow "fundraising.mozilla.org" access at a minimum (if this isn't already done) for us to go live.

Comment 10

[Mavis Ou [:mavis]]

Adam, 
Hey Adam,

Same as Bug 1073118

Sorry for flagging this late - for this bug we would like to have "number of donors" by source instead of donation.  Also I checked in with Andrea, she said "donors by source should match our google analytics sources. (mozilla.org, snippet desktop, snippet android, bitcoin etc)"

Could you please make this data available for us to query?
Mavis


Thank you!
Mavis

Comment 11

[Mavis Ou [:mavis]]

obviously some failed copy/paste happened in my comment above, haha :)

Comment 12

[Andrea Wood [:andreawood]]

if this is hard, just keep total donations by source. "source" is the actual GA source code which will be the channel where the donations originate (not a website). So, snippet; homepage; social; etc.

Comment 13

[Adam Lofting (:adamlofting)]

(In reply to Gavin Suntop [:gvn] from comment #9)
> I'm still seeing $2 from the UK and that's it. I've been able to continue
> development by faking the data, but was wondering when we can expect real
> amounts. We're hoping to launch Monday.

We're getting data now for credit card transactions, but not PayPal - see Bug 1100306

> Also, locally I've disabled CORS to pull the data while I'm developing, but
> you'll need to allow "fundraising.mozilla.org" access at a minimum (if this
> isn't already done) for us to go live.

Good spot. I've enabled CORs now (for any domain).

(In reply to Mavis Ou [:mavis] from comment #10)
> Sorry for flagging this late - for this bug we would like to have "number of
> donors" by source instead of donation.  Also I checked in with Andrea, she
> said "donors by source should match our google analytics sources.
> (mozilla.org, snippet desktop, snippet android, bitcoin etc)"
> 
> Could you please make this data available for us to query?

Done :)

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

(In reply to Andrea Wood [:andreawood] from comment #12)
> if this is hard, just keep total donations by source. "source" is the actual
> GA source code which will be the channel where the donations originate (not
> a website). So, snippet; homepage; social; etc.

Websites are also a 'source' in GA. With the medium of referral. So long as we're only graphing the sources who are actually generating donations, it's fine for a referring site to be a source of donations in the list (especially if it's a promotion by a contributor for example).

Comment 14

[Mavis Ou [:mavis]]

Up on staging: fundraising2.mofostaging.net/

For any further issues, please file a separate bug.