Is it possible to snap shot salesforce data on a daily basis to run point in time reports?
Can Domo capture daily Salesforce snap shot data into the repostory to be used in reports, like opportunities, that can compare two specific dates? For example, we want to compare all the Oppty stages same time last week to see what changed.
Best Answers
-
Definitely. Domo has the ability to create append chains across DataSet runs in order to do snapshotting.
To set this up, simply change your update settings to 'Append' instead of 'Replace':
From their, you can use the _BATCH_LAST_RUN_ value (a column that Domo adds when the DataSet runs) as your snapshotting date.
Cody Irwin
Manager, Technical Solutions
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
Note that by taking the approach outline above, you need to be careful when using that DataSet for non-snapshotted use cases since it will automatically count all historical values instead of just the latest snapshot. Normally, we'll run this kind of DataSet through a Magic ETL or DataFlow to add a 'Latest' column that flags which records came in as part of the last run. We'll use that column as a filter for cards that satisfy a current and not a snapshotted use case.
Cody Irwin
Manager, Technical Solutions
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
Here's how I would approach this.
Ideally, you would have your Salesforce dataset configured to Append when it updates each week.
Use your Salesforce opportunity dataset as an input to a Magic ETL dataflow. Connect the input dataset to an 'Add Constants' widget, create a new constant column called ReportDate, select Date as the column type and then choose Current Date as the constant value for the new column.
Create an output dataset and name it something like 'Salesforce Oppty Weekly Snapshot.' This way, each week when the Salesforce dataset updates you'll get the entire dataset with a ReportDate field you can use to view opportunities at different points of time.
Let me know if you have other questions about this.
KurtF
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
Answers
-
Definitely. Domo has the ability to create append chains across DataSet runs in order to do snapshotting.
To set this up, simply change your update settings to 'Append' instead of 'Replace':
From their, you can use the _BATCH_LAST_RUN_ value (a column that Domo adds when the DataSet runs) as your snapshotting date.
Cody Irwin
Manager, Technical Solutions
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
Note that by taking the approach outline above, you need to be careful when using that DataSet for non-snapshotted use cases since it will automatically count all historical values instead of just the latest snapshot. Normally, we'll run this kind of DataSet through a Magic ETL or DataFlow to add a 'Latest' column that flags which records came in as part of the last run. We'll use that column as a filter for cards that satisfy a current and not a snapshotted use case.
Cody Irwin
Manager, Technical Solutions
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
Here's how I would approach this.
Ideally, you would have your Salesforce dataset configured to Append when it updates each week.
Use your Salesforce opportunity dataset as an input to a Magic ETL dataflow. Connect the input dataset to an 'Add Constants' widget, create a new constant column called ReportDate, select Date as the column type and then choose Current Date as the constant value for the new column.
Create an output dataset and name it something like 'Salesforce Oppty Weekly Snapshot.' This way, each week when the Salesforce dataset updates you'll get the entire dataset with a ReportDate field you can use to view opportunities at different points of time.
Let me know if you have other questions about this.
KurtF
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
Please click on "Accept as Solution" on any reply that may have solved your problem.
Thanks!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive