Importing from Facebook

Import donation data from Facebook and Instagram using Beacon's library template

Updated over a week ago

You can easily import data from Facebook and Instagram's donation platform into Beacon using our pre-built import library template. We'll create all the appropriate donors, fundraisers, and their fundraising pages for you!

Initial setup

If you're wanting to import from Facebook for the first time, there's a few extra fields and options you'll want to add to your Beacon account before you create your template and run your import. These will help all of your data import into your account seamlessly, and ensure everything links together as it should.

Step one: Create a new field on People

Since you get very few email addresses from Facebook contacts, we're going to create a field to store Facebook's IDs instead. This will ensure that if folks are fundraising or donating multiple times they won't be duplicated.

  1. Open any Person record

  2. Create a new short text field called 'Facebook ID'

Step two: Add new drop-down options

To properly attribute incoming donations and fundraising pages to the correct platform, we're going to add options to some 'Source' drop-down lists.

  1. Open any Payment record

  2. Add 'Instagram' as an option

  3. Open any Fundraising page record

  4. Add 'Facebook' and 'Instagram' as options

  5. (optional) If you have the Finance element, open any Payout record

  6. Add 'PayPal Giving Fund' as an option

Step three: Create your template and adjust settings

Let's add the template, ready for final tweaks!

  1. Head to Import data > Manage templates

  2. Create a new template, choosing 'Facebook' from the template library drop-down

Our Facebook template has been pre-configured for most settings, but we'll want to map to your new field, and adjust our deduplication settings.

Map the following columns:

Note: You'll need to toggle on the 'Show additional field options' when mapping some of these columns.

Donor PSID
Map to → Payer (Person) > Facebook ID

Campaign Owner PSID

Map to → Fundraiser (Person) > Facebook ID

Fundraising page > Fundraiser > ID (Smart column)

Map to → Fundraising page > Fundraiser > Facebook ID

Fundraising page > Fundraiser > Name (Smart column)

Map to → Fundraising page > Fundraiser > Name > Full

Set deduplication as follows:

Payments: External ID (Create or update)

People (all): Facebook ID (Only create)

Fundraising pages: External ID (Create or update)

Payouts: External ID (Create or update)

Success: All done! You're ready to import your data.

Importing your data

  1. Warning: Facebook IDs are long numbers that can easily get accidentally changed with formatting when opened in Excel or Google Sheets. Upload directly after your initial download, or see the FAQ section for more info.

  2. Go to Import data > Run import

  3. Upload your CSV from Facebook, and start the import

Frequently Asked Questions

Is fee information available from the Facebook report?

Yes and no! Since fees are charged by the processor, PayPal Giving Fund, this information is not included in your Facebook report.

However, Facebook and PayPal Giving Fund do make public how fees are calculated, which we've added in Smart columns in the import template. These fees will be correct for donation in any currency donating to a UK charity. If your charity is based outside the UK, you may need to adjust the calculations for fees.

Is Gift Aid information available from the Facebook report?

No. Unfortunately, Facebook no longer include information on whether someone gave a Gift Aid declaration as part of their donation, so donations will not be marked as 'Gift Aid claimed'. As a precaution, we won't add any donations from Facebook to Gift Aid claims in Beacon.

Your Gift Aid will still be collected and paid to you, but it is now processed by PayPal Giving Fund. Additionally, the data from PayPal Giving Fund is not able to link back to the specific Facebook donations, so it's not possible to reconcile the two data sets.

Why have my payment IDs changed / How do I safely edit the CSV?

Because Facebook payment IDs are very long numbers, Excel (and often Google Sheets) automatically display them in a rounded up/down 'scientific' number format, instead of their full format.

Facebook payment ID scientific

- VS -

If you then save this file, the displayed values (e.g. 2.36198E+15) get saved instead of the correct value (e.g. 2361983273916210). When the scientific number is imported into Beacon it gets converted back to a full number, but since it's been rounded up or down by Excel it will be incorrect (e.g. 2361980000000000). This can lead to unrelated payments being merged into one.

To avoid this issue, there are two different solutions:

  1. Import the file directly after download from Facebook, without opening it in Excel or Google Sheets. Beacon will then be able to import the full, correct ID.

  2. Or, if you need to edit the spreadsheet before uploading, format the Payment ID column to display the values correctly before saving.

How to format the Payment ID column in Excel:

  1. Select the column

    Select column

  2. Right click on the selection and click 'Format cells...'

    Format cells

  3. Choose Category: 'Custom' and then Type: '0'

    Number format

  4. Click 'OK'

Note: For Google Sheets; highlight the column, then go to Format > Number > 0

You should now see the full number in the Payment ID column, and can safely save as a CSV file for import. If you open the file again later, you will likely need to repeat these steps.

How do I download my Facebook report?

You can download your donations report from within your Facebook page.

  1. Click 'Settings' at the top of your page

  2. Click 'Donations' in the side menu​

  3. Click the 'Donation Donation Reports' button

  4. Choose 'Multi-day Transaction Report', enter the date range you'd like, and fill in your email address

  5. Click 'Export Reports'

Did this answer your question?