Is this article for you? It covers services only available to Give Lively member nonprofits.
Is this article for you? It covers Salesforce integration services only available to Give Lively member nonprofits.

Map downloadable CSV donor data columns to Line Items (All) report

Become familiar with the updated column headers and additional new data in the Line Items (All) on-screen report and downloadable CSV.

Before you get started

Video Overview

Walkthrough

Before you get started

Video Overview

Walkthrough

Before you get started

Video Overview

Walkthrough

No items found.

Before You Get Started

Learn more about our “Line Items (All)” donor data reporting tools, found in the Reports Portal via a “Data Reports” link in the Nonprofit Admin Portal.

Video Overview

Video Transcript

Walkthrough

This article is designed to help Give Lively member nonprofits become familiar with the updated column headers and additional new data in the “Line Items (All)” on-screen report and downloadable CSV now in beta in the Reports Portal. 

It maps the column headers from the until-now usual donor data CSV format (downloadable through the Nonprofit Admin Portal) to the column headers in a new, expanded, restructured, comprehensive CSV file that can be downloaded from the Reports Portal.

The goal is to help smooth the transition to the new “Line Items (All)” report, including making updates to third-party systems using this data, in advance of discontinuing the old by April 2024.

To learn more about the new donor data reporting tools and the transition to them, read about:

CSV column mapping chart

This chart only shows how column headers from the until-now usual donor data CSV map to the new "Line Items (All)" CSV. It does not include any of the new columns in the new expanded, restructured, comprehensive CSV.

Columns in "usual" CSV Columns in Line Items (All) CSV
donation_date Order Date
donor_first_name First Name
donor_last_name Last Name
donor_email_address Email
donation_amount Gross Amount
transaction_fee_covered_by_donor Covered Transaction Fee Amount
amount_refunded Total Refunded Amount
donor_frequency Frequency
private Anonymous to Public
dedication_name Dedication Name
dedication_type Dedication Type
status Payment Status
payment_method Payment Method

payment_platform_charge_id Payment Platform Charge Id
id Give Lively Charge Id
donor_mailing_address Donor Mailing Address
donor_mailing_street_1 Donor Mailing Street (line 1)
donor_mailing_street_2
Donor Mailing Street (line 2)
donor_mailing_city Donor Mailing City
donor_mailing_state Donor Mailing State
donor_mailing_zip_code Donor Mailing Zip Code
donor_billing_country Donor Billing Country
donor_phone_number Donor Phone Number
internal_name Internal Name
page_name Page Name
page_type Page Type
page_url Page URL
page_slug Page Slug
referrer_url Referrer URL
utm_source UTM Source
text_code_used Text Code Used
team_name Team Name
widget_type Widget Type
widget_url Widget URL
sf_opportunity_id Sf Opportunity Id
double_the_donation_submission Double the Donation Submission

Downloads

Get Inspired

No items found.