limata3

from googleads import adwords
from googleads import oauth2


def connect_to_adwords_api():
    customer_id = 'xxx-xxx-xxxx' # This is client customer ID you see in the google ads UI
    oauth2_client = oauth2.GoogleRefreshTokenClient(
        client_id={GOOGLE_CLIENT_ID},
        client_secret={GOOGLE_CLIENT_SECRET},
        refresh_token={GOOGLE_REFRESH_TOKEN}

limata3

def create_and_assign_budget():
    adwords_client = connect_to_adwords_api()
    
    # This bit here creates the budget
    
    budget_service = adwords_client.GetService('BudgetService', version='v201809')
    budget = {
        'name': {an appropriate name},  # Doesn't need to be unique. Budget Id is what matters for uniqueness
        'amount': {
            'microAmount': int(round({budget_amount} * 1000000))

limata3

def create_draft():
    adwords_client = connect_to_adwords_api()
    draft_service = adwords_client.GetService('DraftService', version='v201809')
    draft = {
        'baseCampaignId': original_campaign_id,
        'draftName': {draft_name}
    }
    draft_operation = {'operator': 'ADD', 'operand': draft}
    draft = draft_service.mutate([draft_operation])['value'][0]
    draft_campaign_id = draft['draftCampaignId']

limata3

def change_draft_target_cpa(original_campaign_tcpa, original_campaign_name, draft_campaign_id):
    # Create Portfolio for new campaign
    draft_target_cpa = round(original_campaign_tcpa * (1-0.30), 2)
    draft_portfolio_name = '{0}-Test_XYZ_Draft_Portfolio'.format(original_campaign_name)
    adwords_client = connect_to_adwords_api()
    bidding_strategy_service = adwords_client.GetService('BiddingStrategyService', version='v201809')
    portfolio_config = {
        'name': draft_portfolio_name,
        'biddingScheme': {
            'xsi_type': 'TargetCpaBiddingScheme',

limata3

with control_campaigns as (
select
    'Control' as measurement_group
  , campaign_name as base_campaign
  , date
  , cost
  , conversions
  , conversion_value
from
  fivetran.adwords.google_campaign_performance

limata3

import pandas as pd


def get_all_ad_groups_from_campaign(campaign_id):
    adwords_client = connect_to_adwords_api()
    ad_group_service = adwords_client.GetService('AdGroupService', version='v201809')
    selector = {
        'fields': ['Id', 'Name', 'Status','TargetCpa'],
        'paging': {
            'startIndex': str(0),

limata3

def create_experiment(experiment_name, base_campaign_id, draft_id, split_percent=50, split_type='COOKIE'):
    adwords_client = connect_to_adwords_api()
    trial_service = adwords_client.GetService('TrialService', version='v201809')
    trial = {
        'draftId': draft_id,
        'baseCampaignId': base_campaign_id,
        'name': experiment_name,
        'trafficSplitPercent': split_percent,
        'trafficSplitType': split_type
    }

limata3

import pandas as pd
import numpy as np


raw_test_data = pd.read_csv('medium_ppc_inc_evaluate_dataset.csv')
# You can access the csv above in this link: https://drive.google.com/open?id=1IOuneJr-QFDYGsJPRjQ8ra-5C4VczeOW

raw_test_data['diff_conversions'] = raw_test_data['test_conversions'] - raw_test_data['ctl_conversions']

N = len(raw_test_data)

limata3

limata3