IMPORTANT #1: The Ordering of the Schema Headers should match the FB_FIELDS in step 3. Click on Get schema & paste it in the above spreadsheet we created.Click on Get Custom Data Source ID & copy-paste the ID in the above script as DATASET_ID value.In Analytics, Go To Data Import > Create Cost Data Import > Make sure to choose Overwrite data option.Step – 2: (Optional: Only For GA Upload Feature) You can find the google analytics account id & property id in the account settings & property settings respectively.Now create the cost data import as follows: Step – 1: (Optional: Only For GA Upload Feature) To upload the data to GA, simply set “ isGaUpload” to true & “useHeaders” to false. Select an account & try exporting the data. Now, paste the copied URL in the Valid oAuth Redirect URIs & save the settings.Īnd its DONE…!!!! Try Opening your spreadsheet & Authorizing your facebook account.Go To Facebook App > Click Add Product > Click Facebook Login Setup.In the Spreadsheet, click on Reports > OAuth Redirect URI & copy the URL.Create & Name your App (I named ‘Ads to Spreadsheet’) > Click Create App ID.Click on Google API console > Enable the Analytics API.Go To Resources > Advanced Google Services > Turn on Analytics API.If you want to import data to analytics, we’ll have to turn on the analytics API.(Optional: Only for Google Analytics Import Feature) Don’t forget to name your project & spreadsheet.Copy & Paste the codes to these files from Facebook Cost Data Upload Script.Now you should have 2 files – Code.gs & digiSideBar.html (Don’t change these names).Create another HTML file & name it as ‘digiSideBar.html’.After this step, you can directly move to step – 2.To get that we’ll need to create a Facebook app. You can now see the code where the CLIENT_ID & CLIENT_SECRET is blank. The next step is to go to “Tools” > “Script Editor” (in the sheet menu).Once copied, you can see now see the new menu named “Reports”.Copy the sheet (Click on File > Make a Copy).Facebook Cost Data Import in Google Analytics – Setup Process Step – 1 (New Library Version) More on this later…Īlso, I am assuming the Ad URLs in Facebook are properly tagged with UTMs. You can also use triggers in App Scripts to automate the facebook exporting & google analytics uploading process. #2 Uploading Facebook Data into Google Analytics Here’s what you’ll get in the spreadsheet. Currency Conversion: Convert Facebook Ads currency while export.UTM Feature: Export facebook UTM values in the spreadsheet.Unlimited Imports To GA: Import Facebook Ads Data in Google Analytics.Reporting Automation: Schedule Your Facebook Reports Hourly/Daily/Weekly/Monthly.Full Quota Usage: Export Unlimited rows of Facebook Ads data.
The process is simple & we’ll be using Facebook Marketing APIs & Google Analytics APIs to do the same. Here, we’ll be looking at an automated setup to export Facebook Ads Data in Google Sheet & then uploading it in google analytics.
0 kommentar(er)
