Salsa Scoop

Clay Shirky at the Nonprofit Technology Conference

Read more...

10:20 AM Jun 11, 2009 - 0 comments permalink

The Beeb does Madoff and the JEHT Foundation

This one slipped past my podcast net when it was fresh a couple of weeks ago, but the BBC World Service documentary series produced a compelling program scrutinizing Bernie Madoff's trail of dirty money from gated Florida enclaves to wrongfully convicted prisoners ... and the uncertain liability of charitable foundations and the nonprofits they funded in the wreckage of Madoff's stunning scam.

Give it a listen.

Read more...

01:25 AM Jun 08, 2009 - 0 comments permalink

4 Sneaky Ways to Get the Most From Salsa Reports

Custom report builders are not the easiest things to engineer: you're trying to present to the user an interface that's both intuitive and incredibly expansive, and effects a smooth transition from the nearly limitless arrangements of data that might be present in a user's mind to the very specific (and tedious) job of instructing a big dumb database exactly which data to find and exactly what to do with it.

Those that I've had to wrestle with in other databases in my nonprofit career have generally had me pinned within two rounds.

Which brings us to Salsa. The custom report builder in Salsa is incredibly powerful, but like many such, it can be a challenge if you're looking at it for the very first time. The fact that it's built to render a standard SQL query will be helpful to a minority of users, and utterly useless to most.

With that in mind, reports guru (and all-around support guru) Chelsea Bassett is leading a webinar trilogy this month on different ways to use the reports tool. The first one was yesterday, but there are still two more on the way.

June 11: Email Reports
June 25: Donation Reports

(See the month's full roster of Salsa webinars here)

Should be a fabulous opportunity to mine the capacious brain of our beloved client support paladin.

Regardless of whether your reporting needs run to supporter data, email, donations, all of the above, or other things entirely, there are several underappreciated features in the report builder worth outlining, that may help you get the most from all that precious data.

1. You Can Copy a System Report

See a report in the standard Salsa library that's almost exactly what you want? You can get a local copy of any system report in your custom reports library and tweak to your heart's content.

To copy a system report,

Place the system report on one of your dashboard pages.
Hit "Full Report" to run it.
Click "Clone and edit this report" in the upper left-hand corner of the report results page.

Just navigate to your custom report list, and the copied report should be there for you to edit.

2. Reports Can Give Totals and Subtotals

In SQL land, this feature is called "rollup" -- and that's what it's named in the custom report builder. You can find rollup, perhaps unintuitively, under the "Filter" tab.

To get a subtotal,

Click on the "Group By?" box for at least one field under Columns.
Select a "function" (such as "Sum") for at least one field you're not grouping by.
Select "Rollup" under the "Filter" tab

You may be thinking here, "I want to see individual gifts add up to a sum, not a sum for every line."

Perfectly possible! Try grouping by the Donation_KEY field (or for other kinds of reports, the _KEY field on the table you're reporting). Since KEY numbers are completely unique, their "sum" will always be only a sum of one value ... while the "rollup" will give you the total of all those individual gifts.

3. Reports Can Request Variable User Fields

So you've got a report that's just the right framework of columns and rows, and you're thinking ... dang, I have to rebuild this any time I want to see an updated set of numbers?

In fact, you do not have to rebuild it.

Reports can be built to request user input of variables every time they are run -- for instance, a date, or a date range. To do this,

Under the "Conditions" tab, select the field you'll want to vary each time you run the report
Select an operator -- "Equals" is the default, but you might want "Less Than," "Greater Than," or others.
Leave the "Value" field empty.
Change the "Value type" field to "User Variable."
In "Variable Label", enter human-readable text that will prompt the person running report on what kind of information to enter. For instance, if the condition is built on the Transaction_Date field, the Variable label might be "Enter the date here".
Use the (+) button and "Add OR condition" buttons to add as many different user-submitted condition entries as you like. These can be freely combined with fixed conditions.

4. Reports Can Be Set to Run on a Schedule

No matter how polished and buffed your report, it still needs a human being to run it ... and in any given busy week (to say nothing of those spent on the beach), that step can easily slip the mind.

No problem.

Salsa reports can not only be run by hand, but can be set to run automatically and email the results on a scheduled basis. To set one up,

Place the system report on one of your dashboard pages.
Hit "Full Report" to run it.
Click "Export" in the lower right-hand corner of the report results page.
Under "export to a file, or schedule an export," click "Export Options".
Set the "run and export this report" field to "on a schedule".
Select a start time for the first report to run.
Select the run frequency from the "Run the report" menu.
Select one or more (comma-delimited) email addresses to receive the reports.

The other fields on this page -- a custom header, optional include fields, compressed files -- are strictly optional.

Read more...

02:30 PM Jun 05, 2009 - 1 comments permalink

Green Grants popularity delaying awards announcement

"All human wisdom is summed up in two words -- wait and hope"
-Alexandre Dumas

There was an overwhelming response in the environmental community for DemocracyInAction's recent Green Grants application window. And really (but we're biased) who wouldn't want free Salsa for a year?

We're amazed, as we always are when we have an opportunity to take stock, of the amazing work being done out there. Fortunately for the earth and a few billion of its inhabitants, there are so many of you out there doing so much amazing work that the applications far outran our projections.

So, while we intended to announce Green Grant winners this past Monday, June 1, we're still evaluating submissions -- as quick as we can, honest! -- and hope to have the awards announcement out next week.

Thanks for your patience. We're so sorry about the delay.

Read more...

05:20 PM Jun 03, 2009 - 0 comments permalink

Styles of Effective Presentations

The inimitable Beth Kanter cues to this outstanding roundup of TED presentations with wildly different approaches that each work in different ways.

We were lucky enough to enjoy the Lessig style at our user conference last year. But it has to be said that several other speakers -- and non-presenting participants -- made a similar spark with much less polish and visual whizbangery.

The more of these I see -- conferences, webinars, podcasts, and the wonders of Flash embeds -- the more it strikes me that every presentation I see violates someone's bullet-point list of presentation best practices. The common thread for all these wonderful presenters is commitment to the personal connection -- the entertainment, if you want to put it that way.

For an approach almost 180 degrees from Lessig's slideshow pyrotechnics that also works marvelously -- Elizabeth Gilbert on genius:

Read more...

11:20 AM Jun 01, 2009 - 0 comments permalink

Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190