Beacon

How to import your data from Facebook Donate into Beacon

Updated 5 months ago

facebook

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

link Importing from Facebook

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

error_outline 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.

  1. 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.

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

Screenshot 2019-04-11 at 16.07.09

  1. 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.

  2. 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


link Frequently Asked Questions

link 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 -
Facebook payment ID full

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 columnSelect 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'

help_outline 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.

close

Contact Us

It'd be great to hear from you! To reach out, fill in your details below and we'll get back to you.

close

Register for webinar

To join this webinar, please enter your details below and we'll send you details on how to join.



close