Data from different sources
I wish to pull in data from facebook ads, google adwords and google analytics to combine into a single dashboard.
I am using Supermtrics for Google sheets (paid version)
I have setup a new google sheet file and within that there are 4 tabbed google sheets one for each data source and one to neatly collate the results on a dashboard.
I have one data source per sheet - however when i come back into the file to edit and click between the sheets it says the data source for each sheet if Facebook ad data - it doesn't seem to refresh the different data sources on each sheet.
Any thoughts on how best to solve this problem? Should i put the different data sources into different google sheets files? Or can i have them in the same file but on different sheets?