Powerful Query
v3.66
Perform
Performance
Dash
Dashboard
Loading…
Add Data Source
Save Data Source
Settings
Data Source Setup
Conversion Mapping Setup
Budget Setup
Daily Budget Setup
Result & Efficiency Setup
Google Sheet URL (Conversion Data)
Connect
Open
Refetch Latest Data
Tab
Data Source
Conversion Source
Date Column
Ad ID Column
Metric Columns (select and name as needed)
Data Sources
Sort
Folder
Import
Add Data Source
Custom Dimensions
Update Hierarchy
Cancel
Save
Sources
Presets
Advanced Filter
Clear Filters
Filter by Selection
Copy
D
W
M
Q
Y
T
Auto
Manual
—
Run
Save
Save as new preset
Save as default
Rename
Refetch Data
Reset & Refresh
Download CSV (Pivot Table)
Export Config
Import Config
Budget Column:
On
⌥B
Data Labels:
On
Keyboard Shortcuts
Filters
Clear all
+ Add
METRICS
Custom Metric
Confirm Analysis Fields
Powerful Query detected these fields automatically — confirm or adjust before running
Date Field
Column containing report date
auto
Amount Spent Field
Column containing spend (used to calculate Cost per X)
auto
Dimension Hierarchy
Set drill-down order
1st
›
2nd
›
3rd
Rename
Display column name
Original Name
Display Name
Keyboard Shortcuts
Create a custom metric
Name *
0
/ 40
Description (optional)
0
/ 180
Data format
Number (123)
Number (123)
Percent (%)
Value (฿)
Cost per result (฿)
Value per Cost (x)
Decimals
0
1
2
3
4
5
Color scale
↑ Good
↓ Good
Formula
Column
(
)
+
−
×
÷
Visual
Text
Type metric name or click Column to add...
Cancel edit
Add
Saved custom metrics
+ New
Custom Dimension
Update Hierarchy
Paste a Google Sheet URL above, then click
Link
→
Run