How to create custom fields in Looker Studio

Follow the steps below to create custom fields in Looker Studio

---

Part 1: Create a custom field

Part 2: Field names, formulas and formats

---

Part 1: Create a custom fields for

1. Click "Resources" > "Manage added data sources"
   
2. Click "Edit" in the data source for Google Ads
   
3. Click "ADD A FIELD"
   
4. Click "Add calculated field"
   
5. Type the name in the Field Name. In this example we use "PM Conversions"
   
   
   
6. Copy the formula from Part 2 in this guide and paste it in the Formula field. In this example, we use "All conv."
   
7. Click "SAVE"
   
8. Click back to "All fields"
   
   
   
9. Search for the newly created field in the list of fields and ensure the format is set to either a number or a Currency. In this example, we set it to a Currency.
   
   
10. Repeat steps 3-8 for each of the following fields as defined in Part 2

 

Part 2: Field names, formulas, and formats

 

Field Name: PM Conversions
Type: Number
Formula:

All conv.

Field Name: PM Revenue
Type: Currency
Formula:

All conv. value

Field Name: PM ROAS
Type: Number
Formula:

All conv. value / cost

Field Name: PM Gross Profit
Type: Currency
Formula:

All conv. value

Field Name: PM Gross Profit After Ad Spend
Type: Currency
Formula:

All conv. value - cost

Field Name: PM POAS
Type: Number
Formula:

All conv. value / cost

---

Continue:

How to create charts and apply filters in Looker Studio