AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
2.5K members online now
2.5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Counting number of transaction IDs

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi, 

 

I am guessing this is fairly straightforward. I want to create a new calculated field from Number of #Transaction IDs to be used as a Scorecard. I can't use Ecommerce > Transactions, because I'm dealing with a duplicate TransactionIDs-issue. 

 

Until that is solved, I want to show the correct number of transactions, which I will get from counting transaction IDs in GA. I haven't really succeeded with creating the calulated field myself. Any ideas?

Counting number of transaction IDs

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

I think you can do a DISTINCT COUNT on that field. It should remove the duplicate transaction IDs.