Import Quora Ads Data to Google Sheets

In this guide, we’ll walk through how to pull Quora ad data data directly into Google Sheets, using the API Connector add-on for Sheets. Quora’s advertising API only supports authentication via OAuth2, so we’ll be connecting using API Connector’s built-in integration for Quora Ads.

CONTENTS

PART 1: CONNECT TO THE QUORA API

If you haven’t connected API Connector to Quora before, you’ll first need to initiate the connection as follows:

  1. Open up Google Sheets and click Add-ons > API Connector > Manage Connections.
  2. In the list of available connections, find Quora Ads and click Connect.
    quora-ads-img2
  3. You will be taken to Quora.com and asked to provide API Connector with read access to your Quora Ads Manager data. Click Accept.
    quora-ads-img3
  4. You will now be returned to your Google Sheet, and can verify that your Quora Ads connection is active in the Connections screen.
    quora-ads-img4

PART 2: CREATE YOUR QUORA API REQUEST URL

For our first request, we’ll follow the documentation to get some statistics about the performance of your Quora Ads data.

  • API root: https://api.quora.com/ads/v0/
  • Endpoint: /accounts/YOUR_ACCOUNT_ID

To get your account ID, log in to your account at https://www.quora.com/ads/account and check under your account name in the right-hand corner:
quora-ads-img8

Putting it all together, we get the full API Request URL:

https://api.quora.com/ads/v0/accounts/YOUR_ACCOUNT_ID

PART 3: PULL QUORA API DATA INTO SHEETS

We can now enter our values into API Connector and start importing Quora data into Google Sheets.

  1. Back in the Create Request interface, enter the Request URL we just created above.
    quora-ads-img6
  2. We don’t need any headers for this request, so just leave that section blank.
  3. Under Authentication, choose “Quora Ads” from the drop-down menu.
  4. Create a new tab and click ‘Set current’ to use that tab as your data destination.
  5. Name your request and click Run. A moment later you’ll see statistics about your Quora Ads populate your Google Sheets.quora-ads-img7

PART 4: MORE EXAMPLE API URLS

You can experiment with endpoints and query strings as described in the Quora API documentation to see other types of ad data, but if you just want to jump in, play around with the URLs you enter in the API URL path field. Try the following (one at a time), substituting in actual values where indicated.

  • Current User
https://api.quora.com/ads/v0/me
  • Account Data
https://api.quora.com/ads/v0/accounts/$YOUR_ACCOUNT_ID?fields=campaignId,conversions,conversionRate,clicks,spend,accountCurrency,dailyBudget,lifetimeBudget&level=CAMPAIGN&order=DESCENDING&presetTimeRange=YESTERDAY&sort=conversions&sortConversionType=Generic&summary
  • Campaign Data
https://api.quora.com/ads/v0/campaigns/$YOUR_CAMPAIGN_ID?attributionWindows=CLICK_28_DAY&endDate=2020-07-02&fields=conversions,clicks,cpc&granularity=DAY&sort=spend&sortConversionType=Generic&startDate=2020-05-01&summary
  • Ad Set Data
https://api.quora.com/ads/v0/ad-sets/$YOUR_ADSET_ID?startDate=2020-05-01&endDate=2020-07-31&fields=adSetName,ctr,impressions,status,bidAmount,landingURL&level=AD
  • Ad Data
https://api.quora.com/ads/v0/ads/$YOUR_AD_ID?endDate=2020-05-03&fields=clicks,spend&granularity=DAY&sort=spend&startDate=2020-05-02

Part 5: Handle Pagination

Note that Quora Ads limits the number of records returned in each request. By default, only 25 records will be returned unless you follow the paging links to subsequent records as described in their documentation.

To retrieve more than 25 records, you would run your second request using the next page link returned in the response under the field header paging » next. With API Connector, you can loop through these requests automatically with pagination handling, like this:

quora-ads-img10

Leave a Comment