Displaying a Goal Column for Specific KPI Metrics in Looker Studio

[pb8020]

My team and I are trying to create a looker studio table that has all the normal KPIs that one would find in Google Ads, but we are wanting to add a column that has a goal for impressions. This particular client would like to see how many impressions they have in each campaign, with a column to the right of the impressions that shows the impressions goal.

My first thought was to try to create a spreadsheet and blend the data. Then, I took a look at adding my own field, but realized it would just be the same for every campaign and row of the table, so that wasn't an option. I am wondering if anyone has stumbled across this sort of issue before?

Let me know if anyone has any thoughts.

Thanks!

[marcwo]

Hi @pb8020

I am not sure if I understand correctly: you have a table in looker studio with several rows, every row contains current impressions and you want to add the target impressions on a campaign level?

If you want to do so using a calculated field, you can use a CASE WHEN statement to create a target column - keep in mind though, that the case when statement might become quite big and difficult to maintain, depending on the number of distinct campaigns.

Thanks

Marc