Overview:

πŸ“Š Outcome: Integrated Google Ads and Facebook Data

πŸ•‘ Estimated Time: ~20min

πŸ—’ Structure:

  1. Facebook Integration
  2. Google Integration

 

Facebook Integration

πŸŽ₯ 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:

 

Google Integration

πŸŽ₯ 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:

 

➑️ Next Step:

Clean Google Data

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.