How to import your data from Facebook Donate

Import donation data from Facebook using a Beacon standard import template

Updated over a week ago

You can easily import data from Facebook's donation platform into Beacon using our pre-built import library template.

Importing from Facebook

  1. Download your data from Facebook as a CSV file.

    Warning: Facebook payment 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. If you haven't already set up an import template for Facebook, have a read of this article, and then go to Import templates > Manage templates.

  3. Create a new template, and choose the Facebook - Donations template. Click Create.

  4. You'll see that all of the template settings have already been pre-set. Feel free to review them and make the appropriate changes - and then save the template.

  5. Go to Import data > Run import. Upload your CSV from Facebook, and start the import. Once the import is finished, you'll see this:

Screenshot 2019-04-11 at 15.27.42

Frequently Asked Questions

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?