🎥 Video Explanation:

👞 Step by Step:

1. Open Integrate

2. Click Add and select 'Facebook Ads'

3. Name your connection: "Facebook Ads"

4. Connect your Facebook Account with Y42

   🕑 wait for import settings to load

5. Once the Import Settings are loaded, select a historical start date and which account you want to connect

   ℹ️ historical start date: this date determines from which date on the Facebook data are getting loaded, please note: for Facebook this data must be in the last 37 months

   🕑 wait for the tables and columns to load

6. Now you can select the tables, that you want to import; for our use case we need 'ads_insights'

7. Once you click 'Import' the table is getting loaded

📚 Additional Ressources:

• Facebook Ads Integration
• Facebook Ads Raw Data Guide

🎥 Video Explanation:

👞 Step by Step:

1. Open Integrate

2. Click Add and select 'Google Ads'

3. Connect your Google Account with Y42

   🕑 wait for import settings to load

4. Once the Import Settings are loaded, select a historical start date and which account you want to connect

   ℹ️ historical start date: this date determines from which date on the Google data are getting loaded

   🕑 wait for the tables and columns to load

5. Now you can select the tables, that you want to import; for our use case we need 'AD_PERFORMANCE_REPORT'

   ℹ️ Info that not all combinations are possible + why + Guidance on columns to select

   Columns for AD_PERFORMANCE_REPORT
   - day
   - adID
   - cost
   - views
   - adType
   - clicks
   - device
   - account
   - adGroup
   - allConv
   - network
   - campaign
   - currency
   - adGroupID
   - conversions
   - engagements
   - impressions
   - interactions
   

6. Once you click 'Import' the table is getting loaded

📚 Additional Ressources:

• Google Ads Integration
• Google Ads Raw Data Guide