Example #1
0
def g_organize():
    '''
	adSource.objects.all().delete()
	
	for goog_cam in GoogleCampaign.objects.all():
		goog_name = goog_cam.campaign_name
		category = adSource()
		category.provider = 'Google'
		category.name = goog_name
		
		for goog_key in GoogleKeyword.objects.all():
			if goog_key.adgroup.campaign.campaign_name == goog_name:
				category.impressions = category.impressions + goog_key.impressions
				category.cost = round(category.cost,2) + round(goog_key.cost,2)
				category.clicks = category.clicks + goog_key.clicks
				
		category.cost = round(category.cost,2)
		
		if not category.impressions == 0:
			category.CTR = round(category.clicks * 100/category.impressions,2)
			category.CPM = round(category.cost * 1000 / category.impressions,2)
		if not category.clicks == 0:
			category.CPC = round(category.cost/category.clicks,2)
		category.save() 
		'''
    for goog_cam in GoogleCampaign.objects.all():
        goog_name = goog_cam.campaign_name
        category = adSource()
        category.provider = 'Google'
        category.name = goog_name

        for goog_ad in goog_cam.googleadgroup_set.all():
            for goog_key in goog_ad.googlekeyword_set.all():

                #if goog_key.adgroup.campaign.campaign_name == goog_name:
                category.impressions = category.impressions + goog_key.impressions
                category.cost = round(category.cost, 2) + round(
                    goog_key.cost, 2)
                category.clicks = category.clicks + goog_key.clicks

        category.cost = round(category.cost, 2)

        if not category.impressions == 0:
            category.CTR = round(category.clicks * 100 / category.impressions,
                                 2)
            category.CPM = round(category.cost * 1000 / category.impressions,
                                 2)
        if not category.clicks == 0:
            category.CPC = round(category.cost / category.clicks, 2)

        category.save()
Example #2
0
def g_organize():
	'''
	adSource.objects.all().delete()
	
	for goog_cam in GoogleCampaign.objects.all():
		goog_name = goog_cam.campaign_name
		category = adSource()
		category.provider = 'Google'
		category.name = goog_name
		
		for goog_key in GoogleKeyword.objects.all():
			if goog_key.adgroup.campaign.campaign_name == goog_name:
				category.impressions = category.impressions + goog_key.impressions
				category.cost = round(category.cost,2) + round(goog_key.cost,2)
				category.clicks = category.clicks + goog_key.clicks
				
		category.cost = round(category.cost,2)
		
		if not category.impressions == 0:
			category.CTR = round(category.clicks * 100/category.impressions,2)
			category.CPM = round(category.cost * 1000 / category.impressions,2)
		if not category.clicks == 0:
			category.CPC = round(category.cost/category.clicks,2)
		category.save() 
		'''
	for goog_cam in GoogleCampaign.objects.all():
		goog_name = goog_cam.campaign_name
		category = adSource()
		category.provider = 'Google'
		category.name = goog_name
		
		for goog_ad in goog_cam.googleadgroup_set.all():
			for goog_key in goog_ad.googlekeyword_set.all():
			
				#if goog_key.adgroup.campaign.campaign_name == goog_name:
				category.impressions = category.impressions + goog_key.impressions
				category.cost = round(category.cost,2) + round(goog_key.cost,2)
				category.clicks = category.clicks + goog_key.clicks
				
		category.cost = round(category.cost,2)
		
		if not category.impressions == 0:
			category.CTR = round(category.clicks * 100/category.impressions,2)
			category.CPM = round(category.cost * 1000 / category.impressions,2)
		if not category.clicks == 0:
			category.CPC = round(category.cost/category.clicks,2)
		
		category.save() 
Example #3
0
def fb_organize():
	adSource.objects.all().delete()
	for fb_group in FacebookAccount.objects.all():
		fb_name = fb_group.account_name
		category = adSource()
		category.provider = 'Facebook'
		category.name = fb_name
		
		for fb_cam in FacebookCampaign.objects.all():
			if fb_cam.account.account_name == fb_name:
				category.impressions = category.impressions + fb_cam.impressions
				category.cost = category.cost + fb_cam.cost
				category.clicks = category.clicks + fb_cam.clicks
				
		category.cost = round(category.cost,2)
		
		if not category.impressions == 0:
			category.CTR = round(category.clicks * 100/category.impressions,2)
			category.CPM = round(category.cost * 1000 / category.impressions,2)
		if not category.clicks == 0:
			category.CPC = round(category.cost/category.clicks,2)
		category.save()
Example #4
0
def fb_organize():
    adSource.objects.all().delete()
    for fb_group in FacebookAccount.objects.all():
        fb_name = fb_group.account_name
        category = adSource()
        category.provider = 'Facebook'
        category.name = fb_name

        for fb_cam in FacebookCampaign.objects.all():
            if fb_cam.account.account_name == fb_name:
                category.impressions = category.impressions + fb_cam.impressions
                category.cost = category.cost + fb_cam.cost
                category.clicks = category.clicks + fb_cam.clicks

        category.cost = round(category.cost, 2)

        if not category.impressions == 0:
            category.CTR = round(category.clicks * 100 / category.impressions,
                                 2)
            category.CPM = round(category.cost * 1000 / category.impressions,
                                 2)
        if not category.clicks == 0:
            category.CPC = round(category.cost / category.clicks, 2)
        category.save()