Consolidating Common Metrics from Multiple Data Sources into a Single Table

Hi all,

I've been asked to create a sort of marketing campaign template, where the idea is that for each campaign a user will add a bunch of formatted Excel spreadsheets into a SharePoint folder which contains all the data we need. Each spreadsheet represents a marketing channel (such as Google Analytics, Google Ad Words, Display Ads, Facebook, etc), and in some cases we have multiple spreadsheets related to one channel containing different data.

A lot (but not all) of the marketing channels have the same types of data - for example, the number of impressions and the number of clicks. I'm trying to come up with a way to end up with a table that has a set (manually defined) list of Channels and then I map in that channel's total impressions and total clicks so I end up with a list of channels and how many impressions and clicks they have.

Here's a sort of example of my data sources...

1. Display Ads Spreadsheet, with a DATE column, an IMPRESSIONS column and a CLICKS column
2. Facebook Spreadsheet, with a DATE column, an IMPRESSIONS column and a CLICKS column
3. Snapchat Spreadsheet, and this spreadsheet only has a single row where it gives the TOTAL IMPRESSIONS and TOTAL CLICKS for the campaign (unlike the others, where it's split across dates).

I've already created a custom "Data Over Dates" query that has a common Date column, followed by columns for Display Impressions, Display Clicks, Facebook Impressions, Facebook Clicks so I can show data where I have a data on a common timeline... but I'm now looking for a way here I remove the date element, and end up with a table like... Channel Name | Impressions | Clicks ... 

Is someone able to help me with this, please? I'm not even sure if this is a transformation done at the query-level or something to do in DAX!

Thanks in advance,

Dion