Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
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