Expand my Community achievements bar.

Join us for our next community Coffee Break on February 28th! Four of our Analytics Champions will be joining us to discuss Summit tips, best practices, and any of your Analytics questions!
SOLVED

Import and include budget data in Adobe Analytics

Avatar

Level 3

We would like to see budget numbers for things like revenue that are forecasted by our financial team in Adobe to see how well we are doing YoY and against budget. These budget items are only specific to a monthly total and broken out by customer types. I would think there would be a way to import an excel sheet with a month/year column and a revenue column to map to a "Budget Revenue" metric?

1 Accepted Solution

Avatar

Correct answer by
Level 4

You can use the Data Sources functionality to import budget totals into an event metric. It requires a date and key value so you will need to allocate the budget across each day of the month. It's a bit finicky, but I've been using it for offline spend and channels data for a couple years and it's great. 

https://docs.adobe.com/content/help/en/analytics/import/data-sources/datasrc-home.html

View solution in original post

1 Reply

Avatar

Correct answer by
Level 4

You can use the Data Sources functionality to import budget totals into an event metric. It requires a date and key value so you will need to allocate the budget across each day of the month. It's a bit finicky, but I've been using it for offline spend and channels data for a couple years and it's great. 

https://docs.adobe.com/content/help/en/analytics/import/data-sources/datasrc-home.html