Total number of forms per ad account

SQL query for linkedin

Get the total number of forms associated with each ad account.

SELECT adaccount_id, COUNT(DISTINCT form_id) AS total_forms FROM forms GROUP BY adaccount_id

linkedin data model

Table Adaccounts

Id: Integer
Name: String
Test: Boolean
ReferenceInfo_organization_id: Integer
ReferenceInfo_organization_vanityName: String
ReferenceInfo_organization_logo_cropped: String
ReferenceInfo_organization_localizedName: String
ReferenceInfo_organization_logo_original: String
ReferenceInfo_organization_logo_cropInfo_x: Integer
ReferenceInfo_organization_logo_cropInfo_y: Integer
ReferenceInfo_organization_logo_cropInfo_width: Integer
ReferenceInfo_organization_logo_cropInfo_height: Integer
ReferenceInfo_organization_name_localized_en_US: String
ReferenceInfo_organization_name_preferredLocale_country: String
ReferenceInfo_organization_name_preferredLocale_language: String

Table Forms

Id: Integer
Name: String
State: String
Created: Integer
VersionId: Integer
LastModified: Integer
Content_questions: String
Owner_organization: String
HiddenFields_0_name: String
HiddenFields_0_value: String
CreationLocale_country: String
CreationLocale_language: String
Content_questions_0_name: String
Content_legalInfo_legalInfoId: Integer
Content_questions_0_questionId: Integer
Content_legalInfo_consents_0_id: Integer
Content_headline_localized_en_US: String
Content_legalInfo_privacyPolicyUrl: String
Content_description_localized_en_US: String
Content_questions_0_responseEditable: Boolean
Content_questions_0_responseRequired: Boolean
Content_legalInfo_consents_0_checkRequired: Boolean
Content_legalInfo_legalDisclaimer_localized_en_US: String
Content_legalInfo_consents_0_consent_localized_en_US: String
Content_questions_0_question_localized_{country=US, language=en}: String
Content_questions_0_questionDetails_multipleChoiceQuestionDetails_options_0_id: Integer
Content_questions_0_questionDetails_multipleChoiceQuestionDetails_options_1_id: Integer
Content_questions_0_questionDetails_multipleChoiceQuestionDetails_options_0_text_localized_{country=US, language=en}: String
Content_questions_0_questionDetails_multipleChoiceQuestionDetails_options_1_text_localized_{country=US, language=en}: String

Table Responses

Id: String
Form_name: String
Question0_id: Integer
Question1_id: Integer
Question2_id: Integer
Question3_id: Integer
Question4_id: Integer
Question5_id: Integer
Question6_id: Integer
Question7_id: Integer
Question8_id: Integer
Question9_id: Integer
Question0_name: String
Question1_name: String
Question2_name: String
Question3_name: String
Question4_name: String
Question5_name: String
Question6_name: String
Question7_name: String
Question8_name: String
Question9_name: String
Question0_answer: String
Question1_answer: String
Question2_answer: String
Question3_answer: String
Question4_answer: String
Question5_answer: String
Question6_answer: String
Question7_answer: String
Question8_answer: String
Question9_answer: String

Magical SQL for linkedin with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.