Skip to main content

Hey guys,

 

first question in the community, so I hope I'm putting it in the right place. 👀

 

We are trying to display a product-specific conversion value and the corresponding conversion number from a META ad campaign in Looker Studio. We are able to do this for the overall conversion value and the total number of conversions for the campaign. However, we are advertising product A, for example, and only want to receive the conversion value and the number of conversions from the sales of product A. The values are displayed in the META ad manager with the help of the corresponding custom conversion.

 

Which parameter/filter can we use to display these values in Looker Studio? The product we use is Supermetrics for Looker Studio, so we don’t use Google Sheets in between.

 

Many thanks in advance for any tips, tricks or anything else that could help us. 😀

 

Cheers,
Lukas

​@Lukas Hi there!

I worked with the Supermetrics Looker Studio product a few years ago, so someone on the Supermetrics team might be able to chime in with a little more intimate knowledge, but I remember running into a similar issue when it came to the ‘Results’ metric. When you hover over ‘Results’ in Meta’s platform, which might list ‘Multiple Conversions’, Meta will give you a breakdown of those conversions… I think this is similar to what you’re saying. Unfortunately this breakdown doesn’t translate over to anything in the API, so when we pull it into Looker Studio, we just get a flat number and can’t break it out by any field. 

When it comes to pulling product-specific data into Looker Studio from Meta’s API, there’s a ‘product_ID’ dimension available to the API, but I’m not positive if it will work with all queries to that data. For example, I can pull impressions by Age and Gender, but I can’t look at Age and Gender in combination with Country and DMA. While I can see impressions by Country and DMA, I might not be able to see 50% video plays or 100% video plays. The API is brutal, so test out ‘product_ID’ first (if it’s available), to see if conversions will breakdown further for you in the Action/Action Type reports.

My direct solution in the past (when there weren’t a ton of products to work with) was to come up with custom conversions for each product, that way when I loaded the data into Looker Studio, I could break out all of the custom conversions, and have the ‘overall conversions’ metric be my rollup. It’s a bit tedious, and doesn’t backfill your data, but might help solve this.

My indirect solution is to reconcile everything in GA4 with custom timestamp dimensions, and then work to attribute conversions every week side-by-side within hour-level windows of time. For example, if Meta logs 3 conversions between 8a-9a, and I see 3 conversions in GA4 between 8a-9a, I can have some level of confidence that the reporting matches. It’s a less ideal solution (since GA4 has its own attribution difficulties), but could alleviate the manual work involved in pulling in those extra custom conversions directly on Meta.

Hope this helps!

Reply


Terms & ConditionsCookie settings