3. Facebook

Use the SQL code below and change {{projectId}} and {{datasetName}} to your own.

WITH
  dates AS
    (
      SELECT
        '{{start_suffix}}' AS s,
        '{{end_suffix}}' AS e,
        '{{main_currency}}' AS cur
    ),
  AdCostData AS
    (
      SELECT
        --UTM
          IFNULL(NULLIF(TRIM(c.utm.utm_source), ''), 'facebook.com') AS source,
          IFNULL(NULLIF(TRIM(c.utm.utm_medium), ''), 'referral') AS medium,
          IFNULL(NULLIF(TRIM(c.utm.utm_campaign), ''), '(not set)') AS campaign,
          IFNULL(NULLIF(TRIM(c.utm.utm_term), ''), '(not set)') AS keyword,
          IFNULL(NULLIF(TRIM(c.utm.utm_content), ''), '(not set)') AS adContent,
        CONCAT('facebook via OWOX (', c.ad_account, ')') AS adGroup,
        c.date AS date,
        --Metrics
          SUM(c.spend) AS adCost,
          c.account_currency AS currency,
          SUM(c.impressions) AS impressions,
          SUM(c.clicks) AS adClicks,
        c.ad_account AS adAccount,
        'A01' AS dataSource,
        --Campaign
          IF(c.campaign.objective = 'APP_INSTALLS' OR c.creative.applink_treatment = 'deeplink_with_appstore_fallback', 'APP', 'WEB') AS campaignType,
          CAST(c.campaign.id AS STRING) AS campaignId,
          c.campaign.name AS campaignName,
        --AdGroup
          CAST(c.adset.id AS STRING) AS adGroupId,
          c.adset.name AS adGroupName,
        'Facebook Ads' AS adSource,
        c.debug_info.pipeline_id AS pipelineId
      FROM
        dates AS d, `{{projectId}}.{{datasetName}}.facebook_AdCostData` AS c
      WHERE
        c.date BETWEEN PARSE_DATE('%Y%m%d', d.s) AND PARSE_DATE('%Y%m%d', d.e)
      GROUP BY
        source, medium, campaign, keyword, adContent,
        adGroup, date, currency, adAccount, dataSource,
        campaignType, campaignId, campaignName,
        adGroupId, adGroupName, adSource, pipelineId
    ),
  Currencies AS
    (
      SELECT
        c.date,
        c.currency,
        c.rate,
        MAX(IF(c.currency=d.cur, c.rate, null)) OVER (PARTITION BY c.date) AS localRate
      FROM
        dates AS d, `{{projectId}}.{{datasetName}}.Currencies` AS c
      WHERE
        c.date BETWEEN PARSE_DATE('%Y%m%d', d.s) AND PARSE_DATE('%Y%m%d', d.e)
        AND
        currency IN ('UAH','EUR','RUB')
    ),
  CurrencyConversion AS
    (
      SELECT
        --UTM
          a.source,
          a.medium,
          a.campaign,
          a.keyword,
          a.adContent,
        a.adGroup,
        a.date,
        --Metrics
          IF(c.rate IS null OR c.localRate IS null, null, a.adCost/c.rate*c.localRate) AS adCost,
          a.impressions,
          a.adClicks,
        a.adAccount,
        a.dataSource,
        --Campaign
          a.campaignType,
          a.campaignId,
          a.campaignName,
        --AdGroup
          a.adGroupId,
          a.adGroupName,
        a.adSource,
        STRUCT(a.pipelineId) AS debugInfo
      FROM
        AdCostData AS a
        LEFT JOIN
        Currencies AS c
        ON a.date=c.date AND a.currency=c.currency
    )
SELECT
  *
FROM
  CurrencyConversion

You will get the data in the table 'CostData' with the schema below: