In Yahoo Native Ads, the Conversion value metric is only in one reporting cube. This means that it can’t be pulled with certain other values, including Campaign name. Read more about this in Yahoo’s documentation.
You can fetch these values together in Supermetrics with Google Sheets and Data Studio, with a few extra steps.
Google Sheets
In Google Sheets, create 2 separate queries, and use a lookup or reference to create a single combined table.
In the first query, include these fields:
- Metrics: Conversion Value
- Dimensions: Campaign ID, Month
In the second query, include these fields:
- Metrics: Clicks, impressions, conversions
- Dimensions: Campaign ID, Campaign Name, Month
Use vlookup to check the first query’s results for the right month and campaign ID, and return the conversion value as a new column next to the second query.
Data Studio
To fetch these values together in Data Studio, follow the steps above for fetching from with Google Sheets. Use Google’s data blending feature, with Campaign ID as a join key. Learn more about data blending in Google’s documentation.