Custom Metric Collaboration Between Snowflake and Adobe Analytics

[suchindra]

Hi,

We are in the process of creating a custom metric in Snowflake that will enable us to combine Adobe data with other data sources. Is it possible to import a metric definition or rule from Snowflake into Adobe Analytics? Our goal is to create the metrics in Snowflake and then import them into Adobe Analytics.

[Jennifer_Dungan]

Hi @suchindra,

Do you mean you want to export your calculated metric definitions? Or do you just mean your custom metrics (event1, event2, .... )?

If calculated metrics, I don't think there is any way to export these, and besides, I think it would be really hard to convert these to map to your Snowflake data model...

However, if you are actually referring to your custom events (and standard events), then yes, this is possible.

Your actual metrics are all available in the Raw Data exports (https://experienceleague.adobe.com/en/docs/analytics/export/analytics-data-feed/data-feed-contents/d...) in the events_list field (I would use post_events_list in case anything is being set by processing rules)

This field is a comma separated list of the standard events on each hit... however, you will not see "event1,event2..." the way you do on the front end, instead you will get the backend "metric id", so you will see "200,201..." for instance.

A full event id mapping file is provided with the Raw Data feed (event.tsv), it will include ALL default and standard events.

Now, if you are using merchandising events, then you won't see the event in the event_list field, but instead it will be part of the product_list and post_product_lists fields (the same as your merchandising eVars) since each metric has to correlate to the specific product.

One final note, "Page Views" is one "standard" metric that is not available in the events_list... this is a strange one, but Adobe actually calculates this by looking at hits that have pageName or pageURL (actions, even if the data is sent on the call, has these two values removed in the final data)

[Vinay_Chauhan]

Adobe Analytics doesn’t support importing metric definitions or rules directly from Snowflake. Calculated metrics are created and maintained within Adobe Analytics itself, and there’s no way to transfer a definition in from an external system.

What you can do is use Data Feeds or CJA to export Adobe event-level data, combine it with your Snowflake data, and then apply your custom metric logic there. If you want those same metrics reflected inside Adobe Analytics, they would need to be rebuilt as calculated metrics natively within the tool.

We can say that, metrics can be joined and modeled outside of Adobe, but there’s no “import” function to pull Snowflake-defined rules back into Adobe Analytics.