Setting Up a Social & Ad Risk Reviews Database

Modified on Thu, 5 Nov at 1:49 PM

This article is for IntelligenceBank administrators. It explains how to prepare the database that receives social posts and ads. IntelligenceBank then connects your site and sets up the collection of your accounts and pages.

Before you start

  • Marketing Compliance with Risk Reviews must be enabled on your site. Without it the Is Social Media setting is not available. Your IntelligenceBank contact can confirm this.
  • Only a main administrator or a Databases module administrator can turn on Is Social Media and change the database's settings afterwards.
  • Only one database per site can be the Social & Ad Risk Reviews database.

Step 1: Create the database

Create a new, empty database, for example "Social & Ad Risk Reviews". Use a database with a single submission form. A staged database cannot be used.

Step 2: Add the upload field

In the database form builder, add a multiple file upload field and set it as below.

SettingValueWhy
Multiple Files UploadOnA post or ad can have several images or videos.
Enable Risk ReviewOnRisk review is what finds risks in each file.
Risk Review Trigger ModeManualIntelligenceBank attaches the images, videos and details first and then starts the review. An automatic trigger would start the review before the record is complete.
Maximum File LimitAt least 10, up to 50A carousel can carry up to 10 images. A limit below 10 is refused when the collection is set up.

Step 3: Add the record fields

IntelligenceBank fills in the details of each post or ad by matching on the field label. Capitalisation and spacing do not matter, but the words must match: "Body copy" matches "Body Copy", but "Post Copy" does not. Add one field for each label below. A missing field is left blank on every record, but the details still appear in the Metadata panel.

Field labelWhat it holdsSuggested field type
AccountThe account the post or ad came fromText
Live Post LinkLink to the original post or adText or URL
Post IdThe platform's ID for the post or adText
Date PostedWhen it was publishedDate or text
Date ScrapedWhen IntelligenceBank collected itDate or text
Scrape IdThe collection that gathered itText
Body CopyThe text of the post or adText area

Some platforms add one label:

PlatformExtra label
Meta AdsPaid For Disclaimer
Facebook postsPaid Partnership
InstagramPaid Partnership
Google AdsNone. Google Ads has no Body Copy, so the platform name is written instead.
LinkedInNone

Rules for these fields:

  • Make them optional. Not every post or ad has every value.
  • Use text, text area, date or URL fields. Other field types, such as dropdowns and checkboxes, cannot be filled.
  • Do not add other required fields unless they are text fields. A required text field with nothing to fill it is filled with the record title. A required date, dropdown or checkbox cannot be filled and the record is rejected.
Record field label versus panel label
The record field is labelled Live Post Link in your form. In the Metadata panel the same value is shown as Link, because the post or ad may have been removed from the platform since it was collected.

Step 4: Turn on Is Social Media

  1. Open the database's Settings.
  2. Tick Is Social Media and save.

If another database on the site already has this setting turned on, the save is refused and the message names that database. Turn the setting off there first.

Step 5: Show Total Risk Count

To show each record's findings in the list, set the database's Featured Field to Total Risk Count. The column only appears when risk visibility is enabled for your site. Your IntelligenceBank contact can confirm this.

What happens next

Tell your IntelligenceBank contact the name of the database. IntelligenceBank connects it to the collection of your accounts and pages, and checks it every time a collection is saved. If something is missing, the collection is not saved until it is fixed, and you are told what to change.

What changes once it is on

  • The Add record button is hidden for every user, including administrators. Records only arrive through the collection.
  • Typing the add record address directly sends the user back to the database list.
  • The database is shown as a list only. Card, Calendar and Kanban layouts are not offered.
  • Only a main administrator or a Databases module administrator can open the database's settings.

Next: Reviewing social posts and ads. More about the feature: About Social & Ad Risk Reviews.

Need help?

If you have questions about Social & Ad Risk Reviews, contact your IntelligenceBank Customer Success Manager or the IntelligenceBank Support team.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article