Rolling window data backup within Domo

Qualifications

Advertising and marketing is transforming speedy, and so is the details that arrives with it. Our company combines information from providers these as Facebook Ads, Google’s Marketing campaign Manager 360, Google Advertisements, Bing Ads, Snapchat, and other people so we can observe and improve advertising and marketing campaigns throughout channels with each other in Domo. 

Nevertheless, some of the solutions shown earlier mentioned delete info from their process following 24 months. Additionally, because advertising and marketing facts can change up to 90 days (or longer!) after an action has transpired (as attribution modeling updates or fraudulent clicks are taken off), we are interested in a rolling window of details.

When pulling data, we can simply alter day ranges in pre-crafted Domo connectors and use the append features to seize historic info. We can then create a safe and sound haven inside Domo for our knowledge and know that it will not get deleted. 

Even so, while Domo has 99% of the connectors we have to have, occasionally we have to have to do the job with the Domo API to generate a tailor made alternative.

Issue statement

Let’s say I have produced a answer that pulls info from 91 times in the past until eventually yesterday into Domo. I want to preserve the historic facts just after that 90-day rolling window (the 91st day) but I really don’t want to commit time redeploying my solution with a various date array in the pull. 

Option statement

We can leverage the DataSet Duplicate Unload Connector to create a loop inside of Domo that backs up data. This connector is easy to use. All you have to do is set up Domo API qualifications, then specify the Dataset ID you want to copy and the Domo occasion you’re grabbing the info from. 

Demo

Very first, we established up an ETL that employs a filter-components to grab the information from 91 days ago from our customized connection. Then, we use the DataSet Duplicate Unload Connector with the dataset ID from the dataset produced by the ETL, established the update method to append, and established it to operate on a plan to update just before the initial connection operates once again. 

Just like that, you’ve bought your historic details from a rolling window of facts risk-free in Domo. I hope this article was helpful and introduced you to a little something new in Domo.