def _download_mobile_os():
dfp_report_downloader = get_downloader()
output_file = tempfile.NamedTemporaryFile(
prefix="os_targets_", suffix=".csv", mode="w", delete=False)
pql_query = "SELECT Id, OperatingSystemName FROM Operating_System"
dfp_report_downloader.DownloadPqlResultToCsv(
pql_query, output_file)
output_file.close()
print ("Saved mobile os targets to... %s" % output_file.name)
return output_file
def _download_mobile_os():
dfp_report_downloader = get_downloader()
output_file = tempfile.NamedTemporaryFile(prefix="os_targets_",
suffix=".csv",
mode="w",
delete=False)
pql_query = "SELECT Id, OperatingSystemName FROM Operating_System"
dfp_report_downloader.DownloadPqlResultToCsv(pql_query, output_file)
output_file.close()
print("Saved mobile os targets to... %s" % output_file.name)
return output_file
def _download_geos():
dfp_report_downloader = get_downloader()
tmp_geos = tempfile.NamedTemporaryFile(
prefix="geo_targets_", suffix=".csv", mode="w", delete=False)
pql_query = ("SELECT Id, Name, CanonicalParentId, CountryCode, Type "
"FROM Geo_Target "
"WHERE targetable = true AND "
"type = 'Country' OR "
"(CountryCode = 'US' AND type IN ('State', 'DMA_Region'))")
dfp_report_downloader.DownloadPqlResultToCsv(
pql_query, output_file)
output_file.close()
print ("Saved geo targets to... %s" % output_file.name)
return output_file
def _download_geos():
dfp_report_downloader = get_downloader()
tmp_geos = tempfile.NamedTemporaryFile(prefix="geo_targets_",
suffix=".csv",
mode="w",
delete=False)
pql_query = ("SELECT Id, Name, CanonicalParentId, CountryCode, Type "
"FROM Geo_Target "
"WHERE targetable = true AND "
"type = 'Country' OR "
"(CountryCode = 'US' AND type IN ('State', 'DMA_Region'))")
dfp_report_downloader.DownloadPqlResultToCsv(pql_query, output_file)
output_file.close()
print("Saved geo targets to... %s" % output_file.name)
return output_file
