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-ElectrikAI

Step 4: Select the Connections Icon in the left most panel and Click on “Add” button the top.

Step 4 Select the Connections Icon in the left most panel-ElectrikAI

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

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 4 Flow Add Button-ElectrikAI

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.

IndexCategoryElectrik.AI Column Name Description Sample Value
1DimensionaccountcurrencyThe account currency typeusd
2DimensionaccountidThe Quora Advertising assigned identifier of an account5.2777E+14
3DimensionaccountnameThe account nameelectrik.ai
4DimensionadidThe Quora Advertising assigned identifier of an ad2.1111E+14
5Dimensionadnamega_image ad
6Dimensionadsetid3.1666E+14
7Dimensionadsetnamega api topic
8MetricbidamountThe bid amount that Quora Advertising calculates for your ad to be placed on the first page in the search results10000
9DimensioncampaignidThe Quora Advertising assigned identifier of a campaign4.2221E+14
10DimensioncampaignnameThe campaign nameevergreen_traffic-ga api topics
11MetricclicksClicks 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
12Metricconversionrate_ addpaymentinfo0
13Metricconversionrate_ addtocart0
14Metricconversionrate_ addtowishlist0
15Metricconversionrate_ appinstall0
16Metricconversionrate_ completeregistration0
17Metricconversionrate_ generatelead0
18Metricconversionrate_ generic0
19Metricconversionrate_ initiatecheckout0
20Metricconversionrate_ purchase0
21Metricconversionrate_ search0
22MetricconversionsThe conversion rate as a percentage.The formula for calculating the conversion rate is (Conversions/ Clicks)x 100
23Metricconversions_ addpaymentinfo0
24Metricconversions_ addtocart0
25Metricconversions_ addtowishlist0
26Metricconversions_ appinstall0
27Metricconversions_ completeregistration0
28Metricconversions_ generatelead0
29Metricconversions_ generic0
30Metricconversions_ initiatecheckout0
31Metricconversions_ purchase0
32Metricconversions_ search0
33Metriccpc7820.85
34MetricctrThe 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 1000.009
35MetricimpressionsThe number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.2113
36DimensionlandingurlThe landing URLhttps://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
37Electrik.AIsnapshot_dtDate on which the data is captured6/22/2020
38MetricspendThe cost per click (CPC) summed for each click156417
39DimensionstatusThe account statusrunning
40Electrik.AIetl_orgOrganization IdORG000858
41Electrik.AIetl_projectProject IdPR000333
42Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC###########
43Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC###########
44Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC###########
45Electrik.AIetl_flow_nmEAI Flow CodeFL001412
46Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL001412-202006 25041538167916

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

IndexCategoryElectrik.AI Column Name Description Sample Value
1DimensionaccountcurrencyThe account currency typeusd
2DimensionaccountidThe Quora Advertising assigned identifier of an account5E+14
3DimensionaccountnameThe account nameelectrik.ai
4Dimensionadsetid3E+14
5Dimensionadsetnamega api topic
6MetricbidamountThe bid amount that Quora Advertising calculates for your ad to be placed on the first page in the search results10000
7DimensioncampaignidThe Quora Advertising assigned identifier of a campaign4E+14
8DimensioncampaignnameThe campaign nameevergreen_traffic-ga api topics
9MetricclicksClicks 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
10Metricconversionrate_addpaymentinfo0
11Metricconversionrate_addtocart0
12Metricconversionrate_addtowishlist0
13Metricconversionrate_appinstall0
14Metricconversionrate_ completeregistration0
15Metricconversionrate_generatelead0
16Metricconversionrate_generic0
17Metricconversionrate_initiatecheckout0
18Metricconversionrate_purchase0
19Metricconversionrate_search0
20MetricconversionsThe conversion rate as a percentage.The formula for calculating the conversion rate is (Conversions/ Clicks)x 100
21Metricconversions_addpaymentinfo0
22Metricconversions_addtocart0
23Metricconversions_addtowishlist0
24Metricconversions_appinstall0
25Metricconversions_completeregistration0
26Metricconversions_generatelead0
27Metricconversions_generic0
28Metricconversions_initiatecheckout0
29Metricconversions_purchase0
30Metricconversions_search0
31Metriccpc7205.2
32MetricctrThe 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 1000.014
33MetricimpressionsThe number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.4482
34Electrik.AIsnapshot_dtDate on which the data is captured######
35MetricspendThe cost per click (CPC) summed for each click439516
36DimensionstatusThe account statusrunning
37Electrik.AIetl_orgOrganization IdORG000864
38Electrik.AIetl_projectProject IdPR000260
39Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC######
40Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC######
41Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC######
42Electrik.AIetl_flow_nmEAI Flow CodeFL001459
43Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL001459-20200 707152207476710

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

IndexCategoryElectrik.AI Column Name Description Sample Value
1DimensionaccountcurrencyThe account currency typeusd
2DimensionaccountidThe Quora Advertising assigned identifier of an account5.27766E+14
3DimensionaccountnameThe account nameelectrik.ai
4DimensioncampaignidThe Quora Advertising assigned identifier of a campaign4.22212E+14
5DimensioncampaignnameThe campaign nameevergreen_traffic-ga api topics
6MetricclicksClicks 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
7Metricconversionrate_ addpaymentinfo0
8Metricconversionrate_ addtocart0
9Metricconversionrate_ addtowishlist0
10Metricconversionrate_ appinstall0
11Metricconversionrate_ completeregistration0
12Metricconversionrate_ generatelead0
13Metricconversionrate_ generic0
14Metricconversionrate_ initiatecheckout0
15Metricconversionrate_ purchase0
16Metricconversionrate_ search0
17MetricconversionsThe conversion rate as a percentage.The formula for calculating the conversion rate is (Conversions/ Clicks)x 100
18Metricconversions_ addpaymentinfo0
19Metricconversions_ addtocart0
20Metricconversions_ addtowishlist0
21Metricconversions_ appinstall0
22Metricconversions_ completeregistration0
23Metricconversions_ generatelead0
24Metricconversions_ generic0
25Metricconversions_ initiatecheckout0
26Metricconversions_ purchase0
27Metricconversions_ search0
28Metriccpc7121.31
29MetricctrThe 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 1000.011
30Metricdailybudget100000
31MetricimpressionsThe number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.5752
32Metriclifetimebudget
33Electrik.AIsnapshot_dtDate on which the data is captured6/19/2020
34MetricspendThe cost per click (CPC) summed for each click434400
35DimensionstatusThe account statusrunning
36Electrik.AIetl_orgOrganization IdORG000863
37Electrik.AIetl_projectProject IdPR000257
38Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC6/24/2020 15:32
39Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC6/24/2020 15:32
40Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC6/24/2020 15:30
41Electrik.AIetl_flow_nmEAI Flow CodeFL001423
42Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL001423- 20200624153031956004

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

IndexCategoryElectrik.AI Column Name Description        Sample Value
1DimensionaccountcurrencyThe account currency typeusd
2DimensionaccountidThe Quora Advertising assigned identifier of an account##############
3DimensionaccountnameThe account nameelectrik.ai
4MetricclicksClicks 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
5Metricconversionrate_ addpaymentinfo0
6Metricconversionrate_ addtocart0
7Metricconversionrate_ addtowishlist0
8Metricconversionrate_ appinstall0
9Metricconversionrate_ completeregistration0
10Metricconversionrate_ generatelead0
11Metricconversionrate_ generic0
12Metricconversionrate_ initiatecheckout0
13Metricconversionrate_ purchase0
14Metricconversionrate_ search0
15MetricconversionsThe conversion rate as a percentage.The formula for calculating the conversion rate is (Conversions/ Clicks)x 100
16Metricconversions_ addpaymentinfo0
17Metricconversions_ addtocart0
18Metricconversions_ addtowishlist0
19Metricconversions_ appinstall0
20Metricconversions_ completeregistration0
21Metricconversions_ generatelead0
22Metricconversions_ generic0
23Metricconversions_ initiatecheckout0
24Metricconversions_ purchase0
25Metricconversions_ search0
26Metriccpc7041.03
27MetricctrThe 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 1000.013
28MetricimpressionsThe number of times an ad has been displayed on search results pages.Without impressions there are no clicks or conversions.2935
29Electrik.AIsnapshot_dtDate on which the data is captured6/20/2020
30MetricspendThe cost per click (CPC) summed for each click274600
31Electrik.AIetl_orgOrganization IdORG000858
32Electrik.AIetl_projectProject IdPR000333
33Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC6/22/2020 20:45
34Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC6/23/2020 2:02
35Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC6/23/2020 2:00
36Electrik.AIetl_flow_nmEAI Flow CodeFL001395
37Electrik.AIetl_flow_ instance_idEAI Flow Execution Instance IdFL001395- 20200623020024489710