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

Ad Performance

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 account
5.2777E+14
3DimensionaccountnameThe account nameelectrik.ai
4DimensionadidThe Quora Advertising
assigned identifier of an ad
2.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 results
10000
9DimensioncampaignidThe Quora Advertising
assigned identifier of
a campaign
4.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_
addpaymentinfo
0
13Metricconversionrate_
addtocart
0
14Metricconversionrate_
addtowishlist
0
15Metricconversionrate_
appinstall
0
16Metricconversionrate_
completeregistration
0
17Metricconversionrate_
generatelead
0
18Metricconversionrate_
generic
0
19Metricconversionrate_
initiatecheckout
0
20Metricconversionrate_
purchase
0
21Metricconversionrate_
search
0
22MetricconversionsThe conversion rate
as a percentage.The
formula for calculating
the conversion rate is
(Conversions/ Clicks)x 100
23Metricconversions_
addpaymentinfo
0
24Metricconversions_
addtocart
0
25Metricconversions_
addtowishlist
0
26Metricconversions_
appinstall
0
27Metricconversions_
completeregistration
0
28Metricconversions_
generatelead
0
29Metricconversions_
generic
0
30Metricconversions_
initiatecheckout
0
31Metricconversions_
purchase
0
32Metricconversions_
search
0
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 100
0.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
captured
6/22/2020
38MetricspendThe cost per click (CPC)
summed for each click
156417
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 Id
FL001412-202006
25041538167916

Ad Set Performance

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 account
5E+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 results
10000
7DimensioncampaignidThe Quora Advertising
assigned identifier of
a campaign
4E+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_
completeregistration
0
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 100
0.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 click
439516
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 Id
FL001459-20200
707152207476710

Campaign Performance

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
account
5.27766E+14
3DimensionaccountnameThe account nameelectrik.ai
4DimensioncampaignidThe Quora Advertising
assigned identifier of a
campaign
4.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_
addpaymentinfo
0
8Metricconversionrate_
addtocart
0
9Metricconversionrate_
addtowishlist
0
10Metricconversionrate_
appinstall
0
11Metricconversionrate_
completeregistration
0
12Metricconversionrate_
generatelead
0
13Metricconversionrate_
generic
0
14Metricconversionrate_
initiatecheckout
0
15Metricconversionrate_
purchase
0
16Metricconversionrate_
search
0
17MetricconversionsThe conversion rate
as a percentage.The
formula for calculating
the conversion rate is
(Conversions/ Clicks)x 100
18Metricconversions_
addpaymentinfo
0
19Metricconversions_
addtocart
0
20Metricconversions_
addtowishlist
0
21Metricconversions_
appinstall
0
22Metricconversions_
completeregistration
0
23Metricconversions_
generatelead
0
24Metricconversions_
generic
0
25Metricconversions_
initiatecheckout
0
26Metricconversions_
purchase
0
27Metricconversions_
search
0
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 100
0.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 captured
6/19/2020
34MetricspendThe cost per click
(CPC) summed for each
click
434400
35DimensionstatusThe account
status
running
36Electrik.AIetl_orgOrganization IdORG000863
37Electrik.AIetl_projectProject IdPR000257
38Electrik.AIetl_create_utc_dttmRecord loaded/created
Timestamp in UTC
6/24/2020 15:32
39Electrik.AIetl_update_utc_dttmRecord Update
Timestamp in UTC
6/24/2020 15:32
40Electrik.AIetl_start_utc_dttmEAI Flow Start
Timestamp in UTC
6/24/2020 15:30
41Electrik.AIetl_flow_nmEAI Flow CodeFL001423
42Electrik.AIetl_flow_instance_idEAI Flow Execution
Instance Id
FL001423-
20200624153031956004

Account Performance

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

IndexCategoryElectrik.AI Column Name Description        Sample Value
1DimensionaccountcurrencyThe account
currency type
usd
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_
addpaymentinfo
0
6Metricconversionrate_
addtocart
0
7Metricconversionrate_
addtowishlist
0
8Metricconversionrate_
appinstall
0
9Metricconversionrate_
completeregistration
0
10Metricconversionrate_
generatelead
0
11Metricconversionrate_
generic
0
12Metricconversionrate_
initiatecheckout
0
13Metricconversionrate_
purchase
0
14Metricconversionrate_
search
0
15MetricconversionsThe conversion rate
as a percentage.The
formula for calculating
the conversion rate is
(Conversions/ Clicks)x 100
16Metricconversions_
addpaymentinfo
0
17Metricconversions_
addtocart
0
18Metricconversions_
addtowishlist
0
19Metricconversions_
appinstall
0
20Metricconversions_
completeregistration
0
21Metricconversions_
generatelead
0
22Metricconversions_
generic
0
23Metricconversions_
initiatecheckout
0
24Metricconversions_
purchase
0
25Metricconversions_
search
0
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 100
0.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 captured
6/20/2020
30MetricspendThe cost per click
(CPC) summed for each click
274600
31Electrik.AIetl_orgOrganization IdORG000858
32Electrik.AIetl_projectProject IdPR000333
33Electrik.AIetl_create_utc_dttmRecord loaded/created
Timestamp in UTC
6/22/2020 20:45
34Electrik.AIetl_update_utc_dttmRecord Update Timestamp
in UTC
6/23/2020 2:02
35Electrik.AIetl_start_utc_dttmEAI Flow Start
Timestamp in UTC
6/23/2020 2:00
36Electrik.AIetl_flow_nmEAI Flow CodeFL001395
37Electrik.AIetl_flow_
instance_id
EAI Flow Execution
Instance Id
FL001395-
20200623020024489710