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 to keep the conversation going.

We can’t wait to see you there!

How to combine Google Analytics dimension values with excel file dimension values as the same one


  • VenusVenus SingaporeSYS_ADMIN IMG42
    Hi Admin from Nestle Taiwan

    This can be addressed by using the formula in the mapping process, for both TotalConnect or API Connector Data Streams.

    Please see this article in our knowledge base for your reference.

    For API Connector Data Stream, you may find the mapping editing under Data Stream Advanced Setting > scroll to the bottom and find something like below > click into Mapping for the relevant data model:

    Then apply the aggregation formula in one of the custom metrics to group the values accordingly. Suggested formula as highlighted.

    If you have further questions about this, please contact [email protected] or reach out to your Success Architect and they can troubleshoot in your workspace.

    Thank you.


Sign In or Register to comment.