When querying for RSA ad components using `ad_group_ad` and `ad_group_ad_asset_view`, results do not match. Extra headlines and descriptions are getting returned from `ad_group_ad_asset_view`. I only want data which is shown in the google ads UI.
I was querying some data from `ad_group_ad_asset_view` and noticed that data which was not visible in my google ads UI was being returned by the query. Upon investigation I found that there were some extra headlines and descriptions which were being returned from google ads. When I tried querying the same resource from `ad_group_ad`, it only returned the data which was being shown in the display.
After reading the API documentation for `ad_group_ad_asset_view` there was no relevant information regarding why this might be happening.
I am attaching the queries below,
SELECT
ad_group.id,
ad_group.name,
campaign.id,
campaign.name,
ad_group_ad_asset_view.ad_group_ad,
ad_group_ad_asset_view.asset,
ad_group_ad_asset_view.field_type,
ad_group_ad_asset_view.source,
ad_group_ad_asset_view.performance_label,
asset.id,
ad_group_ad_asset_view.enabled,
asset.policy_summary.approval_status,
asset.text_asset.text
FROM ad_group_ad_asset_view
SELECT
ad_group.id,
ad_group.name,
ad_group_ad.ad.id,
ad_group_ad.ad.responsive_search_ad.headlines,
ad_group_ad.ad.responsive_search_ad.descriptions,
ad_group_ad.status,
campaign.id,
campaign.name FROM
ad_group_ad WHERE
ad_group_ad.ad.type = 'RESPONSIVE_SEARCH_AD'
Both the queries ran successfully and returned data.
`asset.text_asset.text` from the first query returned the headline and descriptions which I was looking for, along with some extra rows which were not part of the UI. I was expecting it to only return the rows which were part of the active ad. And I want to know if I can modify my query to only include that.
As you can see in the first query, I tried to include fields like `ad_group_ad_asset_view.source`, `ad_group_ad_asset_view.enabled`, `asset.policy_summary.approval_status` and `ad_group_ad_asset_view.performance_label` to filter out all the rows were not part of the RSA ad shown in the UI, but this requirement was not satisfied by any subset of these fields or any combination of them.
Some things I found interesting about the rows that were returned but not present in the UI:
- the rows were both automatically generated and created by the user.
- the rows were both enabled and paused.
- Some of them had `unspecified` performance label and some had it had `pending`. This was the case even for the rows which were visible in the UI.
I am not sure whether any of these assets were created from the API or from the google ads UI.
I can share the actual data (e.g., ad IDs, asset IDs) through a private channel if needed.
Background about these queries:
- I tried them on
c# sdk for google ads- I am using the latest version of the API `v18`
Let me know if any additional details would help, happy to provide them.
Thanks so much for your time and support!