I have a Google Sheet that pulls in the last 7 days of Adwords data.

gbennett

I have a Google Sheet that pulls in the last 7 days of Adwords data. I am attempting to create a dataset that appends this data without creating duplicates.  I would love it if someone can provide feedback on how to accomplish this. Thanks.  

AS

You'd probably want to look into using a recursive dataflow:

https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/How-can-I-add-only-unique-values-from-one-dataset-to-another/td-p/16549

 

The dataflow feeds into itself and builds up over time.  It's a really nice trick to have in your Domo quiver.

gbennett

I was not able to recreate a recursive data flow using this technique.  Not sure what I did wrong, but I will get support at Domopalooza.