Where to Find Your Data

Here is where you can find your Facebook Ads data once the integration has been successfully implemented and data has been loaded.

In Your Data Warehouse

If you are an Enterprise merchant, you can analyze your Facebook Ads data directly in your data warehouse.

Raw Data

You can analyze your raw, extracted data using the tables in your Facebook Ads Schema.

Transformed Data

You can also view your Facebook Ads data in more analysis-friendly tables if you set up the proper transformation code and wait for the next workflow to run.

If you have set up Facebook Ads transformation configuration, then your Facebook Ads data will be transformed into the following tables:

• ums.facebook_spend

• ums.vendor_performance

If you have configured your Marketing Data Mart Code, you will also find Facebook Ads data in the following table:

• dm_mkt.fct_vendor_level_performance

In Looker

If you are using Daasity's Looker template, you can analyze your transformed Amazon Ads data alongside other marketing sources in the following explores & dashboards:

Explores

• Marketing Attribution

• Vendor-Reported Marketing Performance

Dashboards

• Marketing