Python: proto.marshal.collections.repeated.Repeated type in the dataframe

33 views
Skip to first unread message

Daria

unread,
Jul 7, 2021, 12:58:26 PMJul 7
to Protocol Buffers
Hello everyone! 

Please explain  why I get in the column data type  proto.marshal.collections.repeated.Repeated    instead of list and how I can get list ?   I convert the upload via  new Google Ads API into the dataframe  - all  columns are ok but this one:

Marshal3.png

An example of a value in the  column : [https://site.com/page]

If it helps here is my script: 

/////////////////

import argparse
import sys
import pandas as pd

from google.ads.googleads.client import GoogleAdsClient
from google.ads.googleads.errors import GoogleAdsException



customer_id = '*****'

client = GoogleAdsClient.load_from_storage("ga.yaml")


ga_service = client.get_service("GoogleAdsService")
customer_service = client.get_service("CustomerService")
resource_name = customer_service.customer_path(customer_id)

customer = customer_service.get_customer(resource_name=resource_name)


ga_service = client.get_service("GoogleAdsService")

query = """
    SELECT
  customer.descriptive_name,
  campaign.status, 
  ad_group.status, 
  ad_group_ad.ad.final_urls
 
FROM ad_group_ad
WHERE segments.date DURING TODAY AND campaign.status = 'ENABLED' AND ad_group.status = 'ENABLED' """


search_request = client.get_type("SearchGoogleAdsRequest")
search_request.customer_id = customer_id
search_request.query = query


results = ga_service.search(request=search_request)

df1 = []

for row in results:
    
    campaign = row.campaign
    ad_group = row.ad_group
    ad_group_ad  = row.ad_group_ad

    df2 = pd.DataFrame({'account_name':[customer.descriptive_name], 'campaign.id': [campaign.id], 'campaign.name': [campaign.name],'ad_group.id':[ad_group.id], 'ad_group.name': [ad_group.name],'ad_group_ad.ad.id':[ad_group_ad.ad.id], 'ad_group_ad.ad.final_urls': [ad_group_ad.ad.final_urls]}) 
    print(              
                customer.descriptive_name,
                campaign.id,
                campaign.name,
                campaign.status,
                ad_group.id
                ad_group.name
                ad_group.status, 
                ad_group_ad.ad.id
                ad_group_ad.ad.final_urls, 
                ad_group_ad.ad.tracking_url_template
            )      
        
        
    df1.append(df2)
    df3 = pd.concat(df1, ignore_index=True) 

////// 

And here is the raw upload fragment (which I write to df):

SearchPager<results {
  customer {
    resource_name: "customers/2331356"
    descriptive_name: "Dive"
  }
  campaign {
    resource_name: "customers/23386756/campaigns/119453447"
    status: ENABLED
    name: "GA_Yaponskij_Poisk"
    id: 1194527344986
  }
  ad_group {
    resource_name: "customers/23386756/adGroups/1143496263"
    status: ENABLED
    id: 114349619263
    name: "\320\236\320\261\321\211\320\270\320\265_ \320\276\320\261\321\203\321\207\320\265\320\275\320\270\320\265 \321\217\320\277\320\276\320\275\321\201\320\272\320\276\320\274\321\203"
  }
  ad_group_ad {
    resource_name: "customers/2331386756/adGroupAds/1149619263~8861903960"
    ad {
      resource_name: "customers/277316756/ads/488776713960"
      id: 488861577960
      final_urls: "https://www.site.ru/language-jpn"
      
    }
  }
}

I will be grateful for any help
Reply all
Reply to author
Forward
0 new messages