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!

Mzdravkov IMG42

About

Username
Mzdravkov
Location
Bulgaria
Joined
Visits
112
Last Active
Roles
SYS_ADMIN
Points
27
Badges
5

Comments

  • Hi @FacilitatorAU, Are any of the campaigns imported from other sources? There are a couple of fields like ga:adwordsCampaignID, ga:dcmClickCampaign, ga:dsCampaign that could help https://ga-dev-tools.web.app/dimensions-metrics-explorer/ Regards, Martin
  • Hi @fawzan123, The main use case for Data Fusion is to link Data Stream Types that have matching values in your data, but do not have any common entities in the data model (for example Ads and Generic) If all the streams you're linking have the Ads Data Stream Type (and therefore Media Buy Key) in common, there's no need…
  • Hi @RohitSaini, The least restrictive way of sharing is to set the page to 'Anyone' access. This only exposes Page content, and the access is through a temporary token. So whenever the Page's Sharing setting are changed, a new link is required.…
  • Hi Sarah, Normally it is not possible to base a Calculated Dimension on a Measurement result. This is because the Measurement itself has to execute on a defined set of Dimensions (and the metric's aggregation can vary based on them). The way to circumvent this is a Reimmersion setup. You would have build a Report…
  • Hi @Greg, In case of platform timeout issues, we recommend opening a ticket in the platform itself, so it can be investigated as soon as possible by the Support team. https://support.datorama.com/en/support/solutions/articles/4000130552-how-to-file-support-tickets Regards, Martin
  • Hi @Bruno, Confirming this is the standard format for credentials for this API. Make sure to enter the full username as they give it and the same password that you use in the provider's UI. If the issue persists, we would recommend logging a ticket (ideally with a screenshot of any message you get when trying to login).…
  • Hi @Liam, Sure, the following are the official resources that fit the bill: https://support.datorama.com/en/support/solutions/articles/4000139845-custom-widget-functionalities https://support.datorama.com/en/support/solutions/articles/4000138196-custom-widget-introduction-use-case- I think you may also find the below…
  • Hi @thanuja, You can find in the below KB a detail explanation on exactly what constitutes a row in Datorama https://support.datorama.com/en/support/solutions/articles/4000085228-row-usage-monitoring-and-calculation To put it simply, the Dimension granularity is the main driver of usage. The mapping you use also has an…
  • Hi @Sankalp, Glad to assist! You would need to first select Label CSS element. This is most easily done using F12 (Developer Console in Chrome) and then taking the 'Select an Element' tool. Once you have that, you can use the modifiers below to modify the position/color, so the CSS would be: .<element to modify> { bottom:…
  • Hi @Karthik_Naidu, Generally you would use one of two formulas (or a combination of them) - PARSEDATE() and FORMATDATE() If the input is a text string, you first have to turn it into a date object using PARSEDATE(), so: For input Dimension [Date_string]= '2014-02-25', if we have a…
  • Hi @IK0, Glad to help out - the DAYSBETWEEN() function can be used for this, so it would be: if(DAYSBETWEEN([Day],TODAY())>0){1;} else{0;} You can find more info on its syntax here: https://support.datorama.com/en/support/solutions/articles/4000139660-formulas-in-datorama#link3 And the below articles overview the supported…
  • Hi @rabipadhy, Currently there is no connector for this API provider. If you would like to see one in the future, you can submit a Feature Request for it to be added through a ticket. Some information like the Platform URL, API Documentation and a contact on the API provider's side will be needed. In the meantime, data…
  • Hi @Seb, I would suggest trying some of the following: actions{lead} actions{complete_registration} actions{onsite_conversion.lead_grouped} actions{offsite_conversions.fb_pixel_lead} You can find the syntax for this kind of metrics (Action Stats) here:…
  • Hi @Nassima, The Instagram connectors are Lifetime connectors, meaning the API provider themselves does not hold historical data - they only report the accumulated # of likes, comments etc. up to today. A historical log can be built up overtime by having the stream run daily (then Datorama will save a job for Aug 1, 2, 3…
  • Hi @JBell, Does it fit your use case to do this in the Data Stream mapping itself? Take for example the below: EXTRACT(csv['campaign_name']. '\\(DM', 0) This would only take the first part of the email without '(DMxxxx)', and then the email names will match from the outset. Or you can set up a Calculated Dimension with…
  • Hi @Juanesco22, The first order of business would be to check if the raw file pulled in the stream Log contains data. If it does, but you get 0 records uploaded - the issue could be in the Transformation/Mapping stage or later (Data Load Rules, etc). If the Stream Log file comes in empty - this could be a permission issue…
  • Hi Brittany, I don't think the described is supported - Calculated and Mapped Measurements have 1 specific Metric Type set (Percentage, Number or Currency), which determines their behavior in widgets and it is not dynamic. In case you are implementing this in a Rich Text/Custom widget, you could use a Calculated Dimension…
  • Hi @PriyankaThirugnanam, Something unique about this metric is it will only be pulled in when the data consists of Auction or Reach and Frequency campaigns, as per the below Facebook resource: https://www.facebook.com/business/help/2051461368219124 If they are of this type but it's not pulling. It would also be worthwhile…
  • Hi, I was able to get a Calculated Dimension with the following formula to validate and work as expected (1 in current month, 0 in other months): IF(FORMATDATE([Start_Date],'MM')==FORMATDATE(DATEADD('m',0,TODAY()),'MM'),1,0) Only thing I added was the conditions in the IF(). Otherwise your syntax seems correct. If you…