Rolling window data backup within Domo

Qualifications

Promoting is switching quick, and so is the knowledge that comes with it. Our company combines info from companies these types of as Fb Advertisements, Google’s Campaign Manager 360, Google Ads, Bing Advertisements, Snapchat, and other folks so we can observe and optimize promotion campaigns throughout channels collectively in Domo. 

On the other hand, some of the solutions outlined earlier mentioned delete knowledge from their technique right after 24 months. Additionally, due to the fact advertising and marketing facts can alter up to 90 days (or extended!) after an motion has transpired (as attribution modeling updates or fraudulent clicks are taken out), we are fascinated in a rolling window of data.

When pulling details, we can very easily alter date ranges in pre-built Domo connectors and use the append features to seize historical details. We can then produce a harmless haven inside Domo for our data and know that it will not get deleted. 

Nonetheless, when Domo has 99% of the connectors we want, from time to time we will need to perform with the Domo API to develop a custom resolution.

Trouble statement

Let’s say I have produced a resolution that pulls details from 91 times back right until yesterday into Domo. I want to preserve the historic knowledge after that 90-day rolling window (the 91st day) but I never want to commit time redeploying my solution with a diverse day array in the pull. 

Alternative statement

We can leverage the DataSet Copy Unload Connector to make a loop within just Domo that backs up info. This connector is straightforward to use. All you have to do is set up Domo API credentials, then specify the Dataset ID you want to copy and the Domo occasion you’re grabbing the facts from. 

Demo

First, we set up an ETL that works by using a filter-method to grab the facts from 91 days back from our tailor made link. Then, we use the DataSet Copy Unload Connector with the dataset ID from the dataset produced by the ETL, set the update mode to append, and set it to run on a program to update in advance of the authentic connection runs once again. 

Just like that, you have received your historical information from a rolling window of facts safe and sound in Domo. I hope this publish was practical and introduced you to something new in Domo.