Counting specified conversions data from Google Ads

[lucky_luke]

Hello everyone,
I came across a problem that I can't seem to find a solution to. I want to count only specified conversions from Google Ads - for example I want only to count Purchases and Lead events in the same table but in different columns.

Tried using some conditions with Segment Conversion Type Name but it is a dimension. I want to count event Purchase as a metric that is assigned to specified campaigns. I did something like this in Google Ads using custom column: "All conversions: GA4: xyz.com (web) Purchase" and it works great but only in Google Ads. I cannot export this metric to the looker studio and can't recreate this either.

For visual explanation - I want my table to look like this :
Campaign; Impressions; Clicks; Conversions; Purchases; Leads;

Any ideas how to solve this problem?
Luke

[leticiath]

Did you find out? same problem here.

[lucky_luke]

I did find a possible solution, but still after a couple of months there are some data errors sometimes in counting them. First, i made a data connection with the same source of data (like one google ads account or mcc); I connected 4 same data sources and used the left outer connection. I made conditions of combinations which were date segments like for example day. In table 1 I added things I needed like clicks, impressions etc, in table 2 I added the metric "All conversion" and then I added a filter with Segment Conversion Type Name equals *Name of conversion from GADS*. If I remember right, you should be able to pick it from the list. For table 3 and 4 I made the same move but with different conversions. And that's it. You should be able to work with it. Let me know if you require help or if the solution worked.

[阿泰]

May I ask if what you mean is blending data from GA4 with Google Ads? And you want to create a table like this?
Campaign (Google Ads) | Impressions (Google Ads) | Clicks (Google Ads) | Purchases (GA4) | Leads (GA4).

If I misunderstood, please kindly let me know. Thanks!

[lucky_luke]

Not like this, I mean blending the same data from Google Ads a couple of times. I don't want data from GA4 because sometimes there are differences in counting events. What you would normally do in Google Ads is look at campaign results and add All conversions metric, then segment it by event causing conversion. Then you have look at what events were triggered by campaing. To make this easier I made a custom column with All conversion metric with added filter for event causing conversion. You cant import custom column from GAds to Looker studio so this is the solution I found out.

For your example it would use only one blended data source which will containt only one Google Ads Account. See screenshot below:

That "contact" and "purchase" in table 2 and 3 are just All conversions metric from Google Ads but I renamed it to make it easier to read directly in report.

Filter (don't look that the name contains GA4 - its just my team event naming convention as we are using conversions from GA4 events):

Join condition (I used Day and Custom formula from my looker, but it can be also campaign, ad group etc.)

Reach out if you need more help or something is still hard to understand 🙂