Total spend by ad account
SQL query for Linkedin Ads
Calculate the total spend for each ad account.
SELECT adaccount_id, SUM(spend) AS total_spend FROM adaccounts GROUP BY adaccount_id
Linkedin Ads data model
Adaccounts
View 15 columns
IdInteger
NameString
TestBoolean
ReferenceInfo_organization_idInteger
ReferenceInfo_organization_vanityNameString
ReferenceInfo_organization_logo_croppedString
ReferenceInfo_organization_localizedNameString
ReferenceInfo_organization_logo_originalString
ReferenceInfo_organization_logo_cropInfo_xInteger
ReferenceInfo_organization_logo_cropInfo_yInteger
ReferenceInfo_organization_logo_cropInfo_widthInteger
ReferenceInfo_organization_logo_cropInfo_heightInteger
ReferenceInfo_organization_name_localized_en_USString
ReferenceInfo_organization_name_preferredLocale_countryString
ReferenceInfo_organization_name_preferredLocale_languageString
Forms
View 29 columns
IdInteger
NameString
StateString
CreatedInteger
VersionIdInteger
LastModifiedInteger
Content_questionsString
Owner_organizationString
HiddenFields_0_nameString
HiddenFields_0_valueString
CreationLocale_countryString
CreationLocale_languageString
Content_questions_0_nameString
Content_legalInfo_legalInfoIdInteger
Content_questions_0_questionIdInteger
Content_legalInfo_consents_0_idInteger
Content_headline_localized_en_USString
Content_legalInfo_privacyPolicyUrlString
Content_description_localized_en_USString
Content_questions_0_responseEditableBoolean
Content_questions_0_responseRequiredBoolean
Content_legalInfo_consents_0_checkRequiredBoolean
Content_legalInfo_legalDisclaimer_localized_en_USString
Content_legalInfo_consents_0_consent_localized_en_USString
Content_questions_0_question_localized_{country=US, language=en}String
Content_questions_0_questionDetails_multipleChoiceQuestionDetails_options_0_idInteger
Content_questions_0_questionDetails_multipleChoiceQuestionDetails_options_1_idInteger
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
Responses
View 32 columns
IdString
Form_nameString
Question0_idInteger
Question1_idInteger
Question2_idInteger
Question3_idInteger
Question4_idInteger
Question5_idInteger
Question6_idInteger
Question7_idInteger
Question8_idInteger
Question9_idInteger
Question0_nameString
Question1_nameString
Question2_nameString
Question3_nameString
Question4_nameString
Question5_nameString
Question6_nameString
Question7_nameString
Question8_nameString
Question9_nameString
Question0_answerString
Question1_answerString
Question2_answerString
Question3_answerString
Question4_answerString
Question5_answerString
Question6_answerString
Question7_answerString
Question8_answerString
Question9_answerString
Campaigns
Creatives
Campaign Analytics
Campaign Groups
Creative Analytics
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed