Prompt Chain

Query Google Ads Performance Data with ChatGPT

Connect Google Ads to ChatGPT via Adzviser to query performance metrics using natural language, enabling quick analysis and optimization without leaving the

Works with google adsadzviser

91
Spark score
out of 100
Updated 3 months ago
Version 1.0.0

Add to Favorites

Why it matters

Leverage ChatGPT's natural language capabilities to query Google Ads performance metrics without navigating the Google Ads UI. Analyze campaign, ad group, or ad-level data for insights and optimization strategies.

Outcomes

What it gets done

01

Connect Google Ads account to Adzviser for data access.

02

Ask natural language questions about campaign performance (e.g., spend, clicks, impressions).

03

Receive structured CSV data of Google Ads metrics within ChatGPT.

04

Analyze performance data and brainstorm optimization strategies.

Install

Add it to your toolbox

Run in your project directory:

curl -fsSL https://spark.entire.vc/get/oai-gptactiongoogleadsadzviser | bash

Steps

Steps in the chain

01
Confirm Google Ads Account Access

Confirm that you have Read-only, Standard, or Admin access to a Google Ads account.

02
Sign Up for Adzviser

Sign up for an account on Adzviser and activate a subscription (starting at $0.99).

03
Connect Google Ads to Adzviser

Connect your Google Ads account to Adzviser by creating a workspace. See https://docs.adzviser.com/getStarted/workspace for instructions.

04
Add Custom GPT Instructions

Once you've created a Custom GPT, copy the provided text in the Instructions panel.

05
Add OpenAPI Schema

Once you've created a Custom GPT, copy the provided text in the Actions panel.

06
Configure OAuth Authentication

In ChatGPT, click on 'Authentication' and choose 'OAuth'. Enter: Authorization URL: https://adzviser.com/authorize-gpt, Token URL: https://adzviser.com/api/oauth-exchange-token-gpt, Token Exchange Method: Default (POST). Leave Client ID, Client Secret, and Scope blank.

Overview

GPT Action Library - Google Ads via Adzviser

What it does

This page provides an instruction & guide for developers building a GPT Action for a specific application. Before you proceed, make sure to first familiarize yourself with the following information: - [Introduction to GPT Actions](https://platform.openai.com/docs/actions) - [Introduction to GPT Actions Library](https://platform.openai.com/docs/actions/actions-library) - [Example of Building a GPT Action from Scratch](https://platform.openai.com/docs/actions/getting-started)

Source README

GPT Action Library - Google Ads via Adzviser

Introduction

This page provides an instruction & guide for developers building a GPT Action for a specific application. Before you proceed, make sure to first familiarize yourself with the following information:

This guide explains how to connect Google Ads reporting data to ChatGPT to retrieve key performance metrics like impressions, clicks and cost at campaign, ad group or ad level. To simplify this process, you will use Adzviser as middleware, which ensures that the data returned from the Google Ads API is properly formatted and ready for analysis in ChatGPT’s Data Analysis environment.

How Adzviser works: First, connect your Google Ads account to Adzviser via OAuth. When you ask questions like “How much did I spend per campaign last month?” in ChatGPT, Adzviser sends a Google Ads Query Language request and transforms the response into a CSV file (under 10MB). This file is then returned to ChatGPT for analysis. Adzviser enables you to easily review and analyze your campaign performance while brainstorming optimization strategies based on historical data insights.

Value + Example Business Use Cases

Value: Google Ads marketers can now leverage ChatGPT’s natural language capabilities to easily query performance metrics and account settings without navigating the Google Ads UI. No need to upload or download any files in the entire process.

Example Use Cases:

  • An eCommerce business owner wants to quickly check the Return on Ad Spend (ROAS) for their Google Ads campaigns from the previous month
  • A brand marketer aims to conduct keyword and search term analysis using reporting data from the past 3 months to identify which keywords to pause or scale, and which search terms to add as negative keywords.
  • An agency marketer needs to generate a monthly report featuring key metrics such as Cost-per-Click (CPC), Cost-per-Conversion (CPA), and Search Impression Share with month-over-month comparisons.
  • A freelance marketer needs to audit a new client’s Google Ads account to evaluate performance and find optimization opportunities during the onboarding process.

Demo/Example

Application Information

Application Key Links

Check out these links from the application before you get started:

Application Prerequisites

Before you get started, make sure you go through the following steps in your application environment:

  • Confirm that you have Read-only, Standard, or Admin access to a Google Ads account.
  • Sign up for an account on Adzviser and activate a subscription (starting at $0.99).
  • Connect your Google Ads account to Adzviser by creating a workspace

ChatGPT Steps

Custom GPT Instructions

Once you've created a Custom GPT, copy the text below in the Instructions panel. Have questions? Check out Getting Started Example to see how this step works in more detail.

OpenAPI Schema

Once you've created a Custom GPT, copy the text below in the Actions panel. Have questions? Check out Getting Started Example to see how this step works in more detail.

Authentication Instructions

Below are instructions on setting up authentication with this 3rd party application. Have questions? Check out Getting Started Example to see how this step works in more detail.

In ChatGPT

In ChatGPT, click on "Authentication" and choose "OAuth". Enter in the information below.

FAQ & Troubleshooting

  • Empty Google Ads account list: If you encounter an empty Google Ads accounts list when trying to connect your Google Ads account, it is likely that you have not yet named your Google Ads account yet. To solve it, go to ads.google.com and sign in. Then follow the instructions here to name your Google Ads account.

Are there integrations that you’d like us to prioritize? Are there errors in our integrations? File a PR or issue in our github, and we’ll take a look.

Step 1: Confirm Google Ads Account Access

Confirm that you have Read-only, Standard, or Admin access to a Google Ads account.

Step 2: Sign Up for Adzviser

Sign up for an account on Adzviser and activate a subscription (starting at $0.99).

Step 3: Connect Google Ads to Adzviser

Connect your Google Ads account to Adzviser by creating a workspace. See https://docs.adzviser.com/getStarted/workspace for instructions.

Step 4: Add Custom GPT Instructions

Once you've created a Custom GPT, copy the provided text in the Instructions panel.

Step 5: Add OpenAPI Schema

Once you've created a Custom GPT, copy the provided text in the Actions panel.

Step 6: Configure OAuth Authentication

In ChatGPT, click on 'Authentication' and choose 'OAuth'. Enter: Authorization URL: https://adzviser.com/authorize-gpt, Token URL: https://adzviser.com/api/oauth-exchange-token-gpt, Token Exchange Method: Default (POST). Leave Client ID, Client Secret, and Scope blank.

Discussion

Questions & comments · 0

Sign In Sign in to leave a comment.