If you want to track conversions metrics that you would from outside platforms but in Bright Analytics, you can by finding the correct ids for your conversion and adding it to the metric definition.
Within Facebook Business Manager UI:
Navigate to FB Business Manager > Event Manager > Custom Conversions.
Find the conversion id next to the conversion name.
3. Copy the ids into the metric definition window in the report engine as instructed below.
Within the Bright Report Engine
In the report engine, first create a SUM IF metric
Add the column action_type from the datasource for facebook.
type 'offsite_custom.conversion.(your_conversion_id)' > insert your conversion id here. Don't forget the quote marks.
Add the actions_count column
Add the final if else, 0 and close the brackets. Follow the example below.
(Note - check all syntax - commas and brackets)
Repeat for all appropriate tables - demopraphic, geo, device, and click Commit Changes.
Any problems, please contact firstname.lastname@example.org