September 14, 2021 20:28
Integrate Google Ads and Facebook Data
Overview:
π Outcome: Integrated Google Ads and Facebook Data
π Estimated Time: ~20min
π Structure:
Facebook Integration
Google Integration
Facebook Integration
π₯ Video Explanation:
π Step by Step:
Open Integrate
Click Add and select 'Facebook Ads'
Name your connection: "Facebook Ads"
Connect your Facebook Account with Y42
π wait for import settings to load
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
Now you can select the tables, that you want to import; for our use case we need 'ads_insights'
Once you click 'Import' the table is getting loaded
π Additional Ressources:
Google Integration
π₯ Video Explanation:
π Step by Step:
Open Integrate
Click Add and select 'Google Ads'
Connect your Google Account with Y42
π wait for import settings to load
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
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
Once you click 'Import' the table is getting loaded
π Additional Ressources:
β‘οΈ Next Step:
Clean Google Data
Was this article helpful?
Yes
No
0 out of 0 found this helpful