ChatGPT Ads
The Two Minute Reports ChatGPT Ads connector puts the data from your ChatGPT ad accounts into Google Sheets or Google Data Studio. You can make reports on campaigns, ad groups, ads, and products. You do not have to write code.
What you can report on
- Campaign, ad group, and ad performance: impressions, clicks, amount spent, CTR, CPC, and CPM
- Conversions, click-through conversions, view-through conversions, and cost per conversion
- Attributed order value and ROAS
- Performance by country, device, platform, and product
- Campaign, ad group, and ad settings: status, budget, bidding, and review status
- Product feed items: title, brand, price, and availability
Prerequisites
- An ad account in ChatGPT Ads Manager
- Access to Settings › General in Ads Manager for that ad account, to create an API key
How to get your credentials
The connector uses an API key from ChatGPT Ads Manager. One API key gives access to one ad account.
- Sign in to ChatGPT Ads Manager.
- If you have more than one ad account, select the ad account that you want to report on.
- In the left menu, go to Settings › General.
- In the API Keys section, select Create New Key.
- Enter a name that you can find again, for example
Two Minute Reports. Then create the key. - Copy the API key and keep it in a safe place. After you close the dialog, Ads Manager shows only the start and the end of the key.
How to create a connection
- Go to https://hub.twominutereports.com/connections
- Select New Connection
- Select ChatGPT Ads from the list of connectors, then select Next
- Name the connection and paste your API key in API Key. If you do not have an API key, see How to get your credentials. Then select Save.
- Enable the ad account you want to report on
How to get ChatGPT Ads data into your reports
To pull ChatGPT Ads data into Google Sheets:
- In the TMR sidebar, go to Data Queries and select Add
- Select the ad accounts you want to analyze. You can select more than one.
- Choose your metrics and dimensions from the available options
- Select the date range for your analysis
- To change the attribution window for conversions, open ChatGPT Ads Report Configuration. Then select one or more windows in Conversion/Attribution Window(s). See Attribution windows.
- Configure sorting and filtering options as needed
- Select Run Query to put the data into Google Sheets
To pull ChatGPT Ads data into Google Data Studio:
- Select Open in Google Data Studio, then select + Create Report.
- A query config panel opens. Do one of the following:
Creating a new query config: Enter a name and select the ad accounts you want to include. To change the attribution window, open ChatGPT Ads Report Configuration and select one or more windows in Conversion/Attribution Window(s). Then select Save.
- Select Create from scratch to build a custom report.
- In the Google Data Studio connector panel, select your team and choose the query config from the dropdown. Select Connect in the top-right corner.
- You land on the Google Data Studio dashboard. Drag the ChatGPT Ads metrics and dimensions onto your canvas to start analyzing your data.
Good to know
Attribution windows
Conversion metrics use an attribution window. The default window is 30 days after a click and 1 day after a view. You can also select 7, 14, or 30 days after a click, with or without 1 day after a view.
If you select more than one window, each conversion metric gets one column for each window. The column for the default window keeps the usual name, for example Conversions. The other columns show the window in the name, for example Conversions (7 d click).
Fields that you cannot use together
- You can use only one of Country, Device, Platform, and Product in a query.
- Conversion metrics are not available by Platform or Product. This includes conversions, cost per conversion, attributed order value, and ROAS.
- Attributed order value and ROAS are not available by Country, Device, Platform, or Product.
Data freshness
A query can show data that is up to 8 hours old.
Troubleshooting
- "Save" fails when you create the connection: make sure that you copied the full key from the API Keys section in ChatGPT Ads Manager. A conversion key or an API key from the OpenAI API platform does not work.
- "No ad account was found for this ChatGPT Ads API key": create the API key in Settings › General of your ad account in ChatGPT Ads Manager, then try again.
- "This ChatGPT Ads connection has an invalid API key": the API key was deleted or replaced in ChatGPT Ads Manager. Create a new API key for the same ad account. Then edit the connection and paste the new key.
If you need help, contact [email protected].