Rolling window data backup within Domo
[ad_1]
Background
Advertising is altering speedy, and so is the facts that arrives with it. Our agency brings together info from companies these as Fb Advertisements, Google’s Campaign Manager 360, Google Advertisements, Bing Adverts, Snapchat, and other individuals so we can track and enhance advertising campaigns throughout channels together in Domo.
On the other hand, some of the services listed earlier mentioned delete data from their method soon after 24 months. Additionally, since advertising facts can alter up to 90 days (or longer!) immediately after an motion has transpired (as attribution modeling updates or fraudulent clicks are taken off), we are fascinated in a rolling window of knowledge.
When pulling data, we can very easily modify date ranges in pre-created Domo connectors and use the append features to capture historic information. We can then generate a secure haven within just Domo for our facts and know that it will not get deleted.
On the other hand, even though Domo has 99% of the connectors we need to have, occasionally we have to have to work with the Domo API to make a tailor made remedy.
Challenge assertion
Let us say I have formulated a remedy that pulls data from 91 times back till yesterday into Domo. I want to help you save the historic facts after that 90-working day rolling window (the 91st working day) but I really do not want to shell out time redeploying my remedy with a various date variety in the pull.
Option statement
We can leverage the DataSet Copy Unload Connector to create a loop inside of Domo that backs up facts. This connector is effortless to use. All you have to do is established up Domo API qualifications, then specify the Dataset ID you want to copy and the Domo occasion you’re grabbing the details from.
Demo
First, we set up an ETL that uses a filter-formula to seize the facts from 91 times ago from our custom made connection. Then, we use the DataSet Duplicate Unload Connector with the dataset ID from the dataset developed by the ETL, set the update method to append, and set it to operate on a plan to update prior to the authentic relationship runs yet again.
Just like that, you’ve got your historic data from a rolling window of details safe and sound in Domo. I hope this write-up was helpful and introduced you to one thing new in Domo.
[ad_2]
Resource url