Adwords Report request api download not saving file

2. Get/Request a developer token

Go to your adwords account click ‘Tools’ icon on the right side of the corner and click ‘ API Center’. Then you will land on a similar page as P2 showing. Basic access level is enough for you to make API call. Copy and paste developer token info into your ‘diseinuak4web.net’ — where you store your credentials to access your adwords account.

3. Get your refreshed token and configure your adwords client

Add your Client ID and Client Secret that you get during the step 1 into the script below. Then run script below ‘Get_your_refreshed_diseinuak4web.net’ via your terminal (Mac user) or comment line (PC user). Since I am a Mac user, I will use terminal to address the rest of the steps.

You will see the screenshot below while running ‘Get_your_refreshed_diseinuak4web.net’

As the instruction puts in the pic-5, copy & paste the URL from the terminal into your browser. It might ask you to choose a gmail account. Remember to select your email which associated with your adwords account. Then you will see:

You might see different name in pic For example, my app name is ‘Adwords-test’. So you will see your app name diseinuak4web.net ‘Allow’, then land on:

Click ‘Allow’ again, then you will see:

As the instruction shown on the webpage, copy code back to your terminal and hit ‘enter’ or ‘return’ on your keyboard. Then the terminal will show:

Copy & paste the refreshed token and save it. So far so good? I know first time it might be still confusing but you already have the all parts to build the key to access adwords via API.

Let’s download “diseinuak4web.net” (which store your credentials to access account)from Google API Python Library.

In the “diseinuak4web.net”, there are two configurations. You only need one of them depending on your adwords account type. In my case, I am using AdWordsClient configurations. Now input those information that you’ve already got into the ‘diseinuak4web.net’ file:

developer_token (from step 2)

client_id & client_secret (from step 1)

refresh_token (from step 3)

Save ‘diseinuak4web.net’ file in a safe place on your local drive while completed those information below. Perfect! You completed setup the key to access the Adword!

4. Make your API call — run script ‘ get hourly ad spent’

run script “Get_ads_KPIs_diseinuak4web.net” — which generate the csv file for each adwords account including last 4 weeks data.

Notes:

1. When initialize client object. adwords_client = diseinuak4web.netomStorage(‘…/diseinuak4web.net’) Here the ‘diseinuak4web.net’ file including your credentials.
2. Be careful about the micro amount in API reporting. In order to get USD, monetary variables/ In my script, I did this for ‘cost’ variable. df[‘Cost’]=diseinuak4web.net
3. I put three adwords account information in the dictionary (Ad_acc)just as an example to run reporting for several accounts at the same time. If you only have one account, then just input one account into the dictionary (Ad_acc). Or you can just input your brand name as the ‘key’ and adwords account ID as ‘acc_id’ as input variables into the function (run_Hour0fDay_kip_report)
4. I used functions to generate start date and end date for last 28 days based on today’s date. But you don’t really need that part. Just input any start/end date format as yyymmdd.
5. In my function (run_Hour0fDay_kip_report), the report definitions are created in AWQL (the AdWords Query Language). Report definitions can also be created in XML. Check the reference here.

Last, there are many different types of reports which can be built via AdWords API. Kindly check the reference.