Join our Community in its new Home - The Datorama Trailblazer Community Group!
It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.
We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.
We can’t wait to see you there!
It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.
We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.
We can’t wait to see you there!
Trying to bring in conversions from the Facebook API
jheilig
TorontoACCOUNT_ADMIN 
in Help Center
I am trying to bring in a conversion from the Facebook API. We have the data stream mapped out, but the only way I can figure out to do this is to filter out a certain value from the Facebook campaign name. From the data stream mapping level, there doesn't seem to be a way to do this using the contains function.
The formula I am looking to build is like this: IF(csv['fb.campaign_name'] contains 'Start Trial', {return csv['fb.conversions']},0)
If the Campaign Name contains "Start Trial", it should return the conversions value or appear as null.
From our data model, we're unable to filter this out from the widget level if we were to simply bring in the conversion mapped to a measurement.
Any assistance would be great!
The formula I am looking to build is like this: IF(csv['fb.campaign_name'] contains 'Start Trial', {return csv['fb.conversions']},0)
If the Campaign Name contains "Start Trial", it should return the conversions value or appear as null.
From our data model, we're unable to filter this out from the widget level if we were to simply bring in the conversion mapped to a measurement.
Any assistance would be great!
Comments
The syntax that you referenced should be slightly different to work:
IF(csv['fb.campaign_name'] contains 'Start Trial', csv['fb.conversions'],0)
The return syntax is used when writing in the javascript format, if.
Let me know if you need further assistance