Open navigation

How to enroll a connector in a BigQuery project

With the Google APIs Explorer, you can enroll any Supermetrics early access or custom-built connector in BigQuery even if it's not available in the BigQuery marketplace.


Before you begin

The Supermetrics team will need to help you at a few points in this process. If you’re not a customer, or if you’re not sure who to talk with about this, get in touch with us first.


Before you can enroll a connector in BigQuery, you’ll need permission to update your project. Ask your admin to grant you the Project Mover role — or add it yourself — for the project you want to enroll the connector in.


Learn about predefined roles in Google’s documentation.


Instructions

Step 1: Find your project number

You’ll need your project number to enroll the connector.


To find it:

  1. Log in to Google Cloud Platform.
  2. In the left-side menu, click BigQuery → SQL workspace.
  3. Select the project you’d like to enroll the connector in.
  4. Click Home → Dashboard.
  5. In the Dashboard tab’s Project info pane, you’ll find your project number.


Step 2: Get the connector ID

This is the identifier that you’ll add to your project in the Google APIs Explorer. If the connector ID for your data source isn't publicly available, we'll send it to you. 


Publicly available connector IDs
Data sourceCodeConnector ID
Active Campaign
ACT625565fe-0000-27d5-84a4-089e08287d94
AdformADF5f2be496-0000-2839-b7eb-94eb2c1b843a
Adjust
ADJ6234bd5c-0000-27b7-aa63-14c14ee6ff14
AdnuntiusADNUN6234bd5c-0000-27b7-aa63-14c14ee6ff14
Adobe AnalyticsASC5beea00c-0000-2788-9dbe-089e0825df7c
Adobe Analytics 2.0ADA5f2be496-0000-2839-b7eb-94eb2c1b843a
AdRollADR5c19c754-0000-2b91-8a34-94eb2c098aa8
AdtractionADTRA6261a06a-0000-2d1e-bd8f-94eb2c19941e
AffluentAFF6235a174-0000-2d1a-826f-883d24f7e250
AhrefsAHRF5f890bb1-0000-2ef8-a38b-f4f5e8087e78
Amazon DSPADSP624094a8-0000-25fc-aabf-94eb2c185b14
Apple Public DataAPPD616dc02d-0000-2a0a-ad56-f4030436250e
Apple Search AdsASA60bb5d2d-0000-21d5-8b1c-089e0826323c
AppsflyerAPPS62398a5c-0000-2d5b-becc-14c14ef31064
AwinAWIN6175ce3c-0000-2b48-9fc3-240588852818
Bing Webmaster ToolsBW5c6fc1ff-0000-28bb-8852-089e0825d01c
CallRailCLR608aca37-0000-2579-9f9a-f403043ae070
Campaign MonitorCM
62610b16-0000-29b3-8eaa-f403045c59c0
Capterra PPCCAP62610b16-0000-29b3-8eaa-f403045c59c0
Capterra ReviewsWCAPT61a50f1e-0000-2a7e-8cc4-001a114fe186
ClockifyCLKFY6259596c-0000-2353-aa9c-14c14eea3400
CriteoCRI5c88cbc6-0000-23f6-b0e3-001a114f24d8
Facebook AdsFA5bbe8038-0000-2f6e-860e-883d24faaee4
Facebook Audience NetworkFAN5e4c210c-0000-2185-8fdf-001a1143bcec
Facebook InsightsFB5bbcf00d-0000-2a80-ba79-089e082617a0
Facebook Political Ads
FBAL619738bc-0000-2f5e-89dc-001a114534ee
Facebook Public DataFBPD5c8887f5-0000-26e4-9099-089e0825fea4
Google AdsAW5bbcef97-0000-2a80-ba79-089e082617a0
Google AdSenseADM5c6467a0-0000-2e17-ac8d-089e0825fab4
Google Ad ManagerDFP5c664aeb-0000-27fa-9a5f-089e0825e63c
Google AnalyticsGA5bbcea7f-0000-2aeb-a306-089e082624ec
Google Analytics 4GAWA608e9840-0000-2307-95dd-d4f547e65340
Google Campaign Manager 360DFA5c705c93-0000-29e7-a84d-089e082612e0
Google Display & Video 360DBM5c62f111-0000-27fa-9a5f-089e0825e63c
Google My BusinessGMB5c88f286-0000-243c-8f82-089e082e9944
Google Play ReviewsWGPR6184dc40-0000-2d1a-ae29-3c286d3b26ee
Google Search Ads 360DFS5c6db7e7-0000-2156-b91a-089e0825fab4
Google Search ConsoleGW5c701e55-0000-2030-80c5-089e08267568
Google TrendsGT619c4c1d-0000-2b35-a331-24058872a5f8
HubSpotHS5c879094-0000-29ed-a177-089e0820fe38
Instagram InsightsIGI5c5f25d7-0000-2fb7-b1ca-089e0831d2dc
Instagram Public DataIGPD25c88d2e7-0000-23f6-b0e3-001a114f24d8
KlaviyoKLA60b7e857-0000-2981-b93c-14c14ef1f00c
LinkedIn AdsLIA5bbd2d3d-0000-2e36-ae73-089e08285a74
LinkedIn Company PagesLIP5c6fdb94-0000-2f72-9cee-883d24fedd8c
LiveIntentLIVI6270b841-0000-2a61-bca7-f40304365b5c
MagentoMGO60b2485d-0000-2300-a981-089e0825ecb0
MailchimpMC5c6fdc38-0000-2f72-9cee-883d24fedd8c
MarketoMARK61916762-0000-2e84-bf0e-883d24f58238
MatomoMAT626dea84-0000-29b3-8eaa-f403045c59c0
MediaMathMM61be851f-0000-2f06-b6ee-94eb2c1b877a
Microsoft AdvertisingAC5bbce602-0000-26b3-9299-089e082b752c
MozMZ5c5e31ed-0000-2f7e-9e9d-089e083264c4
Newsletter2GoN2GO6261d6dc-0000-28b4-b9eb-f403045eee68
OmnisendOMNSD623a37bb-0000-2f32-8af9-089e083246c0
OptimizelyOPT6184da39-0000-2d1a-ae29-3c286d3b26ee
OutbrainOBA5e475afa-0000-2843-bade-089e0831b710
PardotSFP619dece2-0000-2e0e-ba37-94eb2c097114
Pinterest AdsPIA5de74e27-0000-2e3f-9dc0-089e08229e8c
Pinterest OrganicPIO5e4b0e51-0000-2163-a9cb-f4f5e80c662c
Pinterest Public DataPIPD5c8839cf-0000-2629-891b-883d24fe8a68
Quora Ads
QA5c5dc1b1-0000-2482-be53-089e08266748
Reddit AdsRED6187b94f-0000-2747-a7a3-94eb2c1bf27a
Reddit Public DataRDPD5c883ab1-0000-2629-891b-883d24fe8a68
SalesforceSF5c9badac-0000-2f2e-a2ed-94eb2c09835a
Salesforce Marketing CloudSFMC619c4283-0000-231d-8757-001a114498b4
SearchmetricsSME60b7d4d1-0000-2981-b93c-14c14ef1f00c
Semrush AnalyticsSR5c7060dc-0000-2e95-b86c-089e08262ab4
Semrush ProjectsSRP5c879d9a-0000-279d-996f-089e08282bb4
SendinblueSIB6231a638-0000-27c0-8243-f403045e6872
ShopifySHP5e4c1d70-0000-28a8-9ee0-240588732ffc
SimplesatSMPS6237b25d-0000-2295-a9e9-d4f547e6ade4
SizmekSIZ
62519a92-0000-2a83-8ce1-d4f547ef4924
SmarpSMARP61a2f301-0000-2fdf-90c1-001a11432826
Snapchat MarketingSCM5c8726af-0000-2eb4-acd0-f403043e5bec
Spotify AdsSPA61be84a3-0000-2f06-b6ee-94eb2c1b877a
StackAdaptSTAC61943cf9-0000-2507-8d6f-2405886cc818
StripeST5c6f466a-0000-2ddc-8d0f-30fd380fda28
TaboolaTBL5c879e5d-0000-279d-996f-089e08282bb4
TikTok
TIK60b248f1-0000-2300-a981-089e0825ecb0
The Trade DeskTTD5e4c1d81-0000-28a8-9ee0-240588732ffc
TripAdvisor ReviewsWTRIP62595a71-0000-2353-aa9c-14c14eea3400
Tumblr Public DataTBPD5c872851-0000-2eb4-acd0-f403043e5bec
Twitter AdsTA5bbcf068-0000-2a80-ba79-089e082617a0
Twitter Public DataTWPD5c87a03b-0000-279d-996f-089e08282bb4
Unity AdsUNA625f80e1-0000-2a25-aa3e-f403045ec55c
Vimeo Public DataVMPD5c88dbba-0000-23f6-b0e3-001a114f24d8
VKontake Public DataVKPD5c885316-0000-28f6-a206-883d24fe9628
WooCommerceWOO6260004b-0000-2016-98be-94eb2c1b654a
XandrXAN618a52e3-0000-2e24-bc9c-883d24fc57b8
Yahoo DSPVDSP61a62b66-0000-2049-b74d-94eb2c0a6a56
Yahoo Native AdsYG5c68f936-0000-21f9-ae5b-089e08286ed0
Yandex.Direct
YAD5c6aa71f-0000-29e7-a84d-089e082612e0
Yandex.MetricaYAM5c68f7f5-0000-21f9-ae5b-089e08286ed0
Yelp ReviewsWYELP62458010-0000-2008-b5bd-883d24fb25f4
YextYEXT622c3340-0000-2579-ac23-001a114dfa88
YouTubeYT5de2bf05-0000-2e56-adb1-089e08259b1c


Step 3: Enroll the connector in your project

When you’re ready, use the Google APIs Explorer to enroll the connector.

  1. Open the BigQuery Data Transfer Service.
  2. A dialog titled “Try this method” will open at the right-hand side of the screen.
  3. Fill in the “name” field with projects/yourProjectNumber.
  4. In the “Request body” field, click the plus icon and select dataSourceIds. 
  5. This will add a section where you’ll add the connector ID. Make sure to add double quotation marks around the ID.

    With your connector ID in the highlighted row, an example would read:

    {
    “dataSourceIds”: [
    yourconnectorID
    ]
            }


  6. Double-check your work, and click Execute when you’re ready.
  7. Authenticate your connection.

If everything’s working as it should, you’ll see a green response message reading 200.



Step 4: Verify enrollment

To make sure that your connector is properly enrolled:

  1. Open the Google Cloud Platform.
  2. In the left-side menu, click BigQuery → Data transfers.
  3. Click + CREATE TRANSFER.
  4. Under Source type, search for the connector you enrolled in the project. If the connector’s ready to use, it should appear there.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.