Import Quora Ads Data to Google Sheets

Quora is a well-known Q&A platform. 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 OAuth2 integration for Quora Ads.

PART 1: 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

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

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

PART 2: PULL QUORA API DATA INTO SHEETS

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

  1. Open up Google Sheets and click Add-ons > API Connector > Create New API Request.
  2. In the Create Request interface, enter the Request URL we just created above.
    quora-ads-img6
  3. We don’t need any headers for this request, so just leave that section blank.
  4. Under Authentication, click Manage connections.
    oauth2-img1
  5. In the list of available connections, find Quora Ads and click Connect.
    quora-ads-img2
  6. 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
  7. 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
  8. Create a new tab. You can call it whatever you like, but here we’ll call it ‘Quora Ads’. While still in that tab, click ‘Set current’ to use that tab as your data destination.
  9. 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 3: 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-05-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?endDate=2020-05-03&fields=adSetName,ctr,impressions,status,bidAmount,landingURL&level=AD&startDate=2020-05-01
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

Leave a Comment