Docs

Quora Ads Performance Data Export

What is Quora Ads ?

Quora Ads is an online advertising platform developed by Quora, where businesses pay to reach millions of people who are already looking for answers to questions that relate to their business or industry.

Quora Ads performance report give you post-click performance metrics for users who clicked on your Quora Ads and then came to your website.

How to add a Quora Ads Source in Electrik.AI?

Follow these steps to connect your Quora Ads account to Electrik.AI

Step 1: Ensure you have following prerequisites to create a Quora Ads Connection in Electrik.AI

a. Quora Ads Account User Id.

b. And Password.

Step 2: Sign-in into your Electrik.AI account

Step 3: Select IO in Electrik.AI dashboard

Select IO in Electrik.AI dashboard

Step 4: Select the Connections tab in the left most navigation bar & click on “Add” action button.

Select-the-Connections-tab-in-the-left-most-navigation-bar-click-on-Add-action-

Step 5: The Source default tab is selected just click on “Quora Ads” connection.

Step 5 The Source default tab is selected just click on “Quora Ads” connection-ElectrikAI

Step 6: Enter your Quora Ads User Id and Password.

Step 6 Enter your Quora Ads User Id and Password-ElectrikAI

Step 7: Allow Electrik.AI to access your Quora Ads account.

Step 7 Allow Electrik.AI to access your Quora Ads account-ElectrikAI

Step 8: Select the Quora Ads Account from the dropdown whose data you wish to export.

Step 8 Select the Quora Ads Account from the dropdown whose data you wish to export-ElectrikAI

Step 9: Click on Save button on the top.

Step 9 Click on Save button on the top-ElectrikAI

Congratulations, you have now successfully created a Quora Ads Connection in Electrik.AI.

Congratulations, you have now successfully created a Quora Ads Connection in Electrik.AI

What are the supported Data Destinations?

Electrik.AI supports the following databases to export Quora Ads Data. It is important to note that Electrik.AI itself is not a destination. A destination is required to export data from various marketing data sources using Electrik.AI

PostgreSQL Data Destination-Eletrik.AI
MySQL Data Destination-Electrik.AI
AzureSQL Data Destination-Eletrik.AI
Google Big Query Data Destination-Elecrik.AI
Snowflake-Data-Destination-Electrik.AI

How to export Quora Ads Data?

Electrik.AI creates a data flow (or ETL process) that exports Facebook Ads data to a target database or data warehouse. This process runs daily at scheduled time and exports data for the previous day.

Follow these steps to create a Data Flow from Quora Ads to Database .

Step 1: Ensure you have the following prerequisites.
1. Access to Quora Ads.
2. Quora Ads Account User Id and Password.
3. Access to a Database of your choice (PostgreSQL, MySQL, Azure SQL, BigQuery.)
4. Database Connection Details such as Host, Port, DB Name, DB User, DB Password.
Step 2: Sign-in into your Electrik.AI account.
Step 3: Select IO in Electrik.AI dashboard.

Select IO in Electrik.AI dashboard-ElectrikAI

Step 4: Click on Add button to create a Quora Ads Performance Data Extractor Flow.

Step 5: Select Quora Ads Connection present in the list of available sources.

Step 5 Select Quora Ads  Connection present in the list of available sources-ElectrikAI

Step 6: Select your existing Quora Ads connection in Electrik.AI.
To Configure a new connection, refer to this link.

Select your existing Quora Ads connection in Electrik.AI

Step 7: Click on a database of your choice from list of available destinations.
In this example we are choosing My SQL.

Step 7 Click on a database of your choice from list of available destinations-ElectrikAI

Step 8: Select your existing MySQL connection in Electrik.AI.
To Configure a new connection, refer to this link.

Step 8  Select your existing MySQL connection in Electrik.AI

Step 9: a. Electrik.AI now supports 4 reports, choose the desired type to get the appropriate data. In this example we are choosing Campaign Performance. 

Electrik.AI now supports 4 reports, choose the desired type to get the appropriate data. In this example we are choosing Campaign Performance-ElectrikAI

b. Review the Data Source, Data Destination, Database Schema, Report Name, Provide Success Notification Email, Failure Notification Email

Success Notification Email: Enter a valid Email ID to receive the Flow Success Email Notification.

Failure Notification Email: Enter a valid Email ID to receive the Flow Failure Email Notification.

Note: By Default, Electrik.AI uses the signed-in user’s Email Id.

c. Click “Save and Proceed” to continue.

Review the Data Source, Data Destination, Database Schema, Report Name, Provide Success Notification Email, Failure Notification Email -ElectrikAI

Note: By Default, Electrik.AI chooses an existing Database Schema to load your Quora Ads Report. You can create a new schema in your database by selecting the “Create New Schema” radio button.

Step 10: Please wait while you are redirected to Flow Details Screen.

Step 10 Please wait while you are redirected to Flow Details Screen-ElectrikAI

Congratulations, you have now successfully setup Quora Ads Performance Report to MySQL Database flow in Electrik.AI.

Congratulations, you have now successfully setup Quora Ads Performance Report to MySQL Database flow in ElectrikAI

Your Quora Ads data will start loading after 24 hours in your Database.

Your Quora Ads data will start loading after 24 hours in your Database-ElectrikAI

Quora Ads Target Schemas

The Ad Performance report includes all statistics aggregated at the ad level.

Index Category Electrik.AI Column Name Description Sample Value
1 Dimension accountcurrency The account currency type usd
2 Dimension accountid The Quora Advertising assigned identifier of an account 5.2777E+14
3 Dimension accountname The account name electrik.ai
4 Dimension adid The Quora Advertising assigned identifier of an ad 2.1111E+14
5 Dimension adname ga_image ad
6 Dimension adsetid 3.1666E+14
7 Dimension adsetname ga api topic
8 Metric bidamount The bid amount that Quora Advertising calculates for your ad to be placed on the first page in the search results 10000
9 Dimension campaignid The Quora Advertising assigned identifier of a campaign 4.2221E+14
10 Dimension campaignname The campaign name evergreen_traffic-ga api topics
11 Metric clicks Clicks are what you pay for. Clicks typically include a customer clicking an ad on a search results page or on a website on the search network. Clicks can also come from other sources (for example,spiders,robots, and test servers) 20
12 Metric conversionrate_ addpaymentinfo 0
13 Metric conversionrate_ addtocart 0
14 Metric conversionrate_ addtowishlist 0
15 Metric conversionrate_ appinstall 0
16 Metric conversionrate_ completeregistration 0
17 Metric conversionrate_ generatelead 0
18 Metric conversionrate_ generic 0
19 Metric conversionrate_ initiatecheckout 0
20 Metric conversionrate_ purchase 0
21 Metric conversionrate_ search 0
22 Metric conversions The conversion rate as a percentage.The formula for calculating the conversion rate is (Conversions/ Clicks)x 100
23 Metric conversions_ addpaymentinfo 0
24 Metric conversions_ addtocart 0
25 Metric conversions_ addtowishlist 0
26 Metric conversions_ appinstall 0
27 Metric conversions_ completeregistration 0
28 Metric conversions_ generatelead 0
29 Metric conversions_ generic 0
30 Metric conversions_ initiatecheckout 0
31 Metric conversions_ purchase 0
32 Metric conversions_ search 0
33 Metric cpc 7820.85
34 Metric ctr The click-through rate (CTR) is the number of times an ad was clicked, divided by the number of times the ad was shown (impressions). The formula for calculating CTR is (Clicks / Impressions) x 100 0.009
35 Metric impressions The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions. 2113
36 Dimension landingurl The landing URL https://electrik.ai/product /google-analytics-hit-data- extractor?utm_source =quora&utm_ medium=cpc& utm_campaign= evergreen_traffic -ga%20api%20topics &utm_term=google %20analytics%20api &utm_content =image_ad
37 Electrik.AI snapshot_dt Date on which the data is captured 6/22/2020
38 Metric spend The cost per click (CPC) summed for each click All monetary values are in local currency, in units of one ten-thousandth of the local base currency. For example, a spend value of 24500 with currency USD represents $2.45. 156417
39 Dimension status The account status running
40 Electrik.AI etl_org Organization Id ORG000858
41 Electrik.AI etl_project Project Id PR000333
42 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC ###########
43 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC ###########
44 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC ###########
45 Electrik.AI etl_flow_nm EAI Flow Code FL001412
46 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001412-202006 25041538167916

The Ad Set Performance report includes all statistics aggregated by default at the ad group level.

Index Category Electrik.AI Column Name Description Sample Value
1 Dimension accountcurrency The account currency type usd
2 Dimension accountid The Quora Advertising assigned identifier of an account 5E+14
3 Dimension accountname The account name electrik.ai
4 Dimension adsetid 3E+14
5 Dimension adsetname ga api topic
6 Metric bidamount The bid amount that Quora Advertising calculates for your ad to be placed on the first page in the search results 10000
7 Dimension campaignid The Quora Advertising assigned identifier of a campaign 4E+14
8 Dimension campaignname The campaign name evergreen_traffic-ga api topics
9 Metric clicks Clicks are what you pay for. Clicks typically include a customer clicking an ad on a search results page or on a website on the search network.Clicks can also come from other sources (for example, spiders,robots, and test servers) 61
10 Metric conversionrate_addpaymentinfo 0
11 Metric conversionrate_addtocart 0
12 Metric conversionrate_addtowishlist 0
13 Metric conversionrate_appinstall 0
14 Metric conversionrate_ completeregistration 0
15 Metric conversionrate_generatelead 0
16 Metric conversionrate_generic 0
17 Metric conversionrate_initiatecheckout 0
18 Metric conversionrate_purchase 0
19 Metric conversionrate_search 0
20 Metric conversions The conversion rate as a percentage.The formula for calculating the conversion rate is (Conversions/ Clicks)x 100
21 Metric conversions_addpaymentinfo 0
22 Metric conversions_addtocart 0
23 Metric conversions_addtowishlist 0
24 Metric conversions_appinstall 0
25 Metric conversions_completeregistration 0
26 Metric conversions_generatelead 0
27 Metric conversions_generic 0
28 Metric conversions_initiatecheckout 0
29 Metric conversions_purchase 0
30 Metric conversions_search 0
31 Metric cpc 7205.2
32 Metric ctr The click-through rate (CTR) is the number of times an ad was clicked, divided by the number of times the ad was shown(impressions).The formula for calculating CTR is (Clicks / Impressions) x 100 0.014
33 Metric impressions The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions. 4482
34 Electrik.AI snapshot_dt Date on which the data is captured ######
35 Metric spend The cost per click (CPC) summed for each click 439516
36 Dimension status The account status running
37 Electrik.AI etl_org Organization Id ORG000864
38 Electrik.AI etl_project Project Id PR000260
39 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC ######
40 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC ######
41 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC ######
42 Electrik.AI etl_flow_nm EAI Flow Code FL001459
43 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001459-20200 707152207476710

The Campaigns Performance report includes all statistics aggregated by default at the campaign level.

Index Category Electrik.AI Column Name Description Sample Value
1 Dimension accountcurrency The account currency type usd
2 Dimension accountid The Quora Advertising assigned identifier of an account 5.27766E+14
3 Dimension accountname The account name electrik.ai
4 Dimension campaignid The Quora Advertising assigned identifier of a campaign 4.22212E+14
5 Dimension campaignname The campaign name evergreen_traffic-ga api topics
6 Metric clicks Clicks are what you pay for. Clicks typically include a customer clicking an ad on a search results page or on a website on the search network. Clicks can also come from other sources (for example, spiders,robots, and test servers) 61
7 Metric conversionrate_ addpaymentinfo 0
8 Metric conversionrate_ addtocart 0
9 Metric conversionrate_ addtowishlist 0
10 Metric conversionrate_ appinstall 0
11 Metric conversionrate_ completeregistration 0
12 Metric conversionrate_ generatelead 0
13 Metric conversionrate_ generic 0
14 Metric conversionrate_ initiatecheckout 0
15 Metric conversionrate_ purchase 0
16 Metric conversionrate_ search 0
17 Metric conversions The conversion rate as a percentage.The formula for calculating the conversion rate is (Conversions/ Clicks)x 100
18 Metric conversions_ addpaymentinfo 0
19 Metric conversions_ addtocart 0
20 Metric conversions_ addtowishlist 0
21 Metric conversions_ appinstall 0
22 Metric conversions_ completeregistration 0
23 Metric conversions_ generatelead 0
24 Metric conversions_ generic 0
25 Metric conversions_ initiatecheckout 0
26 Metric conversions_ purchase 0
27 Metric conversions_ search 0
28 Metric cpc 7121.31
29 Metric ctr The click-through rate (CTR) is the number of times an ad was clicked, divided by the number of times the ad was shown (impressions).The formula for calculating CTR is (Clicks / Impressions) x 100 0.011
30 Metric dailybudget 100000
31 Metric impressions The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions. 5752
32 Metric lifetimebudget
33 Electrik.AI snapshot_dt Date on which the data is captured 6/19/2020
34 Metric spend The cost per click (CPC) summed for each click 434400
35 Dimension status The account status running
36 Electrik.AI etl_org Organization Id ORG000863
37 Electrik.AI etl_project Project Id PR000257
38 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 6/24/2020 15:32
39 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 6/24/2020 15:32
40 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 6/24/2020 15:30
41 Electrik.AI etl_flow_nm EAI Flow Code FL001423
42 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001423- 20200624153031956004

The Account Performance report includes all statistics aggregated at the keyword level.

Index Category Electrik.AI Column Name Description Sample Value
1 Dimension accountcurrency The account currency type usd
2 Dimension accountid The Quora Advertising assigned identifier of an account ##############
3 Dimension accountname The account name electrik.ai
4 Metric clicks Clicks are what you pay for. Clicks typically include a customer clicking an ad on a search results page or on a website on the search network.Clicks can also come from other sources (for example,spiders,robots, and test servers) 39
5 Metric conversionrate_ addpaymentinfo 0
6 Metric conversionrate_ addtocart 0
7 Metric conversionrate_ addtowishlist 0
8 Metric conversionrate_ appinstall 0
9 Metric conversionrate_ completeregistration 0
10 Metric conversionrate_ generatelead 0
11 Metric conversionrate_ generic 0
12 Metric conversionrate_ initiatecheckout 0
13 Metric conversionrate_ purchase 0
14 Metric conversionrate_ search 0
15 Metric conversions The conversion rate as a percentage.The formula for calculating the conversion rate is (Conversions/ Clicks)x 100
16 Metric conversions_ addpaymentinfo 0
17 Metric conversions_ addtocart 0
18 Metric conversions_ addtowishlist 0
19 Metric conversions_ appinstall 0
20 Metric conversions_ completeregistration 0
21 Metric conversions_ generatelead 0
22 Metric conversions_ generic 0
23 Metric conversions_ initiatecheckout 0
24 Metric conversions_ purchase 0
25 Metric conversions_ search 0
26 Metric cpc 7041.03
27 Metric ctr The click-through rate (CTR) is the number of times an ad was clicked, divided by the number of times the ad was shown(impressions). The formula for calculating CTR is (Clicks / Impressions) x 100 0.013
28 Metric impressions The number of times an ad has been displayed on search results pages.Without impressions there are no clicks or conversions. 2935
29 Electrik.AI snapshot_dt Date on which the data is captured 6/20/2020
30 Metric spend The cost per click (CPC) summed for each click 274600
31 Electrik.AI etl_org Organization Id ORG000858
32 Electrik.AI etl_project Project Id PR000333
33 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 6/22/2020 20:45
34 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 6/23/2020 2:02
35 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 6/23/2020 2:00
36 Electrik.AI etl_flow_nm EAI Flow Code FL001395
37 Electrik.AI etl_flow_ instance_id EAI Flow Execution Instance Id FL001395- 20200623020024489710