Advanced Data Management tools allow you to bulk upload values (such as Events, Labels, and Internal Codes) directly to fundraiser records in GivePanel, making it easier to manage data for larger campaigns.
Step 1: Preparing Your File for Bulk Upload
Export a List of Fundraisers: We recommend starting by exporting a list of the fundraiser records you want to update in GivePanel, as this will provide you with a column for their campaign IDs.
Add Columns for Values: Once you have the list, create additional columns for each value you want to bulk upload. For example:
One column should contain the Campaign IDs (unique identifiers for each fundraiser record).
Other columns should be for the values you want to upload, such as Events, Labels or Internal Codes. Clearly title these columns (e.g., "Labels", "Internal Codes").
Ensure Values Are Set Up: Before uploading, make sure that the values (like events, labels or internal codes) you want to add have already been set up in your GivePanel account.
Excel Corruption Issue: If you encounter any problems with Excel corrupting Facebook Campaign IDs, refer to our help article here for guidance.
Save Your File: Once you've populated your file, save it in CSV format to ensure compatibility with the bulk upload tool.
Step 2: Accessing Advanced Data Management Tools
In the top right corner of your GivePanel account, click on your Account Name to open the dropdown menu.
Select Account Settings.
In the Account Settings page, click on the Advanced tab.
From here, select Bulk Upload.
Step 3: Uploading Your File
Drag and drop your prepared CSV file or click to upload the file that contains the values you want to bulk upload to fundraiser records.
You will then be invited to map the columns of data in your file with the correct values in GivePanel for example the column that contains the ''Campaign ID'' (fundraiser unique identifier) you select in the ''Fundraiser ID'' field.
The other fields will be labelled by your column titles, click into the drop down and select what you are bulk uploading. For example, if you're bulk adding labels, you would select ''Active Label'' from the drop down.
Step 4: Completing the Bulk Upload
After uploading, the system will process the file and apply the changes to the fundraiser records.
You will see a confirmation message once the upload is complete, this will let you know if there were any errors.
By following these steps, you can manage and update multiple fundraiser records at once using the Advanced Data Management tools.