![]() 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. You can also specify the number of Decimal Places and a currency symbol.Here, we’ll be looking at an automated setup to export Facebook Ads Data in Google Sheet & then uploading it in google analytics. ![]() You need to have at least a paragraph of text to see the effect of “Justify” visually.įormat can be set to “None”, “Number”, “Percent”, “Currency”, or “Change Indicator”. ![]() “Justify” is like a newspaper column where the spaces between words are adjusted so all the words start and end on the same vertical lines. “Auto” aligns text to the left and numbers to the right. By default the alignment is “Auto”, but if you switch it to “Right”, the numbers will be right-justified.Īs you can see, the options for Text Alignment are “Auto”, “Right”, “Left”, “Center”, and “Justify”. You can fix this issue by clicking on the column in the widget editor to open up the formatting tool. The happens because the CSV widget interprets the numbers with commas (“,”) as strings which get left justified by default, and the numbers without commas as numbers which get right justified by default. For example, if you have a column, like “Widgets Sold” that has some numbers with commas “,” and some without, you may see an alignment issue like the one below. Sometimes, when you import data from a CSV file, you will want to adjust the formatting in the CSV widget table. Here is what the widget looks like, with and without column headers. If data in any cell contains a comma, it must be enclosed in quotes. The CSV widget treats data in all cells as being in string format. To see a sample of the required CSV format without headers, click here. Optionally, you can omit the column headers, but you must indicate that your file has no headers in the dialog box that appears when you upload your file. To see a sample of the required CSV format with headers, click here. In addition, the first line of the CSV file must contain the column headers. Data must be uploaded in CSV format (the delimiter must be the comma character ‘,’). You can upload CSV data directly in to Megalytic, or host the CSV files on your server, Dropbox, Google Sheets, etc. Megalytic provides a CSV widget to handle situations where you want to import data and display it in a report.
0 Comments
Leave a Reply. |